Friday, 9 January 2009

How Quantix deliver their SQL Server Managed Service

Quantix, a leading managed service provider and a tier 1 Microsoft Gold Partner in the UK, has over 20 years experience in delivering Managed Services to organisations across all vertical markets.

Database support services are at the core of Quantix’s services and over the years, Quantix has been able to use a wide range of technologies to deliver an award winning Managed Services to their client base.

SQL Server Managed Services deliver a variety of services that can be handpicked by the business and organisation of varying size, with services ranging from:

· SQL Server Support
· Telephone support
· On-site/remote consultancy
· SQL Server health checks
· SQL Migrations and clustering solutions
· 24x7 support
· SQL Server monitoring solutions and much more.

The SQL server managed service can also be tailored to meet the requirements of your business.

Our Database and Applications Management Centre is typically connected to your systems via site-to-site VPN, so we have effective and secure communications. Quantix have blended together specific management tools & unparalleled DBA experience to create a comprehensive monitoring and alerting solution for SQL Server environments. Through this solution our substantial team of certified consultants can react 24x7 to resolve problems.

Quantix offer various service levels to suit specific business needs and also have different pricing structures which are dependent on your individual business needs.

If you would like to know more about our SQL Server Managed Services, please visit www.quantix-uk.com or contact Quantix on 0115 983 6200

Monday, 10 November 2008

SQL Server 2008 - Update on features

I wanted to give you a brief update/outline on a few new features relating to the newest version of SQL Server (2008).

The latest version has had some major changes and will improve the overall productivity of the IT infrastructure where it is implemented. SQL Server 2008’s main goal is to become more reliable, secure and scalable across business critical applications.

The Business Continuity element has had some new changes including an enhanced database mirroring feature which can build on SQL server 2005 and includes automatic page repair and enhanced supportability.

It has new capabilities, which allows it to store new date and time data, Hierarchy ID, Filestream ID, Sparse Columns and Large user-defined types (Eliminates the 8-KB limit for user defined types).

Integrating data has become a lot easier with advanced backup compression, so less storage is required to keep back-ups online and back-ups can run faster since less I/O is required. SQL Server Integration Services (SSIS) pipeline improvements means data integration packages can be scaled more effectively and frees up resources to manage the large enterprise-scale workloads.

Quantix also offer a range of SSRS Support Services enabling our clients to focus on their core business activities while we manage and maintain their Business Intelligence (BI) software and tools. The service involves extensive proactive monitoring to keep your BI Applications functional and optimised. All of this work is performed remotely and does not interfere with other applications or services

These are just a few new additions to latest SQL Server. If you would like to know more about the new features please visit the Quantix website or if you would like to speak to one of our SQL Server consultants please do not hesitate to contact us on: 0115 983 6200

Monday, 27 October 2008

SSRS Managed Services

A couple months back, we wrote a blog about ‘Which is better the SQL Server Reporting service or Crystal reports?’ Both have their benefits, as well as disadvantages. Today, I would like to go into more detail about the SQL Server 2005 Reporting Services that are offered by Quantix.

As a Microsoft Gold Partner, Quantix provide Microsoft SQL Server 2005 Reporting Service (SSRS) managed services. SSRS is a comprehensive server based solution which enables the creation and delivery of reports tailored to the customers exact needs.

Being part of the Microsoft Business Intelligence suite, SSRS can be integrated with other Microsoft applications, making it easier to report on the overall Microsoft infrastructure. Quantix have taken the SQL Server Reporting Service and started to offer it as a managed service solution enabling clients to get the most out their Microsoft investments.

Quantix SSRS Managed Service

Quantix, a leading IT managed service provider, has been able to develop a service using the SSRS business intelligence tool. The managed service is focused around giving the end user/client the ability to completely focus on their core business activities, whilst Quantix and its team of fully qualified Microsoft consultants, maintain their business intelligence tools.

The key benefits of the SSRS Managed services include reduced operational costs, utilising Quantix’s specialist SSRS skills, improved flexibility in timely reporting, delivery of services via a dedicated SLA and the option to have on demand report creations.

As with other managed services offered by Quantix (SQL Server Support, SQL Server Managed Services), the client can expect to benefit from a high R.O.I, increased productivity and business/staff efficiency, on demand access to a pool of SQL Server skills and methods of delivery which suit the client.

To learn more about the SQL Server Reporting Services or other Business Intelligence tools, please visit the Quantix website or please do not hesitate to contact one of our SQL Server consultants on: 0115 983 6200

Monday, 20 October 2008

SQL Server Database Solutions from Quantix

Microsoft SQL server is one of the most operated databases in the world, allowing organisations to get a far better insight into their business information, run mission-critical applications and is designed to provide businesses with that extra cutting edge to succeed in a competitive environment. Over the years SQL server databases have evolved and become even more business orientated with new features like the business intelligence tools which allow organisations to integrate data from a wide range of sources and then report and analyse it, giving a more 3 dimensional insight into core business functions.

Because SQL Server databases are so important to a business’s core functionality, it is very important that your business has a sufficient and effective support practice in place, to ensure you capitalise on your database investments.

Quantix, a Microsoft Gold Partner and a SQL Server Managed Service specialist, has developed a range of SQL Server services to provide the most comprehensive range of support options to suit all vertical market.

Quantix provide high end SQL server support service, which includes SQL Server Migration Solutions, SQL Server Upgrade and installation solutions, SQL Server Clustering solutions, Licensing models to name a few but also offer a 24/7 SQL Server Managed Service support package to manage and maintain any SQL Server environment.

Many of our clients benefit from our Managed Service package due to its flexibility in delivery, our substantial skills in Microsoft SQL Server, reduced costs and ability to increase staff productivity and efficiency by allowing them to concentrate on their core business tasks while we manage your SQL Server environment.

If you have any questions regarding your SQL Server environment or would like to discuss our SQL server support options, please do not hesitate to visit the Quantix website or contact us on 0115 983 6200.

Tuesday, 16 September 2008

Sql Server 2008 Readiness Review

Quick Update

With the recent release of Microsoft Sql server 2008, Quantix have launched a Sql Server 2008 Readiness Review, which aims to ensure that business are ready to upgrade or migrate to Sql Server 2008.

The review covers the 3 primary concerns when migrating/upgrading to Sql Server 2008:
  • Review of all database components
  • Analysis of existing applications
  • Discusions with the users to see if there has been any underlying performance problems.

The Sql Server 2008 Readiness Review also covers Security and Licensing issues.

To learn more about the Sql Server 2008 Readiness Review from Quantix, please visit the Quantix website or call one of our Sql Server Consultants on 0115 983 6247

Wednesday, 23 July 2008

Microsoft discontinue SQL Server 2000 Support

As Microsoft discontinue their support services and service packs for SQL Server 2000, businesses are now left with the daunting prospect of having no assistance or support directly from Microsoft when it comes to breaks/fix cases.

Although Microsoft will continue to provide security updates until 2012, SQL Server 2000 users may start to feel vulnerable to increased server downtime and other risks. Quantix, one of 20 Strategic Microsoft Partners for BI & Database, has developed a variety of tailored support solutions to help alleviate any concerns over de-support.

For organisations that are looking to upgrade an existing SQL Server database, Quantix can provide full migration support, regardless of whether the next step is SQL Server 2005 or SQL Server 2008. If your business uses in-house DBA’s, then you can utilise our specialist SQL Server consultants to plug ‘Skills-gaps’ via mentoring programmes or to deliver SQL Server DBA expertise on demand. In addition we can provide a migration planning service that allows you to plan and drive best practice for your SQL Server infrastructure.

In addition to performance monitoring, one of the key building blocks of our support portfolio involves onsite or remote SQL Server health check services. These systematically analyse all areas of your SQL Server environment to ensure systems are secure, optimised and working to best practice. In our view, prevention is certainly better than cure.

Quantix is also an Oracle Certified Advantage Partner, so we have all the skills required to migrate your database from SQL to Oracle should that be an option. Through our Oracle consultancy practice our team of qualified and experienced Oracle specialists can assess your needs and help you make the most out of your Oracle investments.

About Quantix:

Quantix, an Oracle Certified Advantage Partner and Microsoft Gold Partner, specialise in the provision of enterprise applications support and managed services to the Mid Market. Incorporated in 2002, Quantix has seen consistently strong growth in its range of support services and can now lay claim to a managed services contract base of over 4 million. Quantix has a turnover of circa £8m and currently works with over 400 clients across numerous vertical markets, including Finance & Banking, Transport, Public Services, Business Services, Retail, Manufacturing and Telecoms.

Monday, 14 July 2008

SQL Server 2005 Reporting Services or Crystal Report?

SQL Server Reporting Services competes with Crystal Reports and other business intelligence tools, and is included free in Express, Workgroup, Standard, and Enterprise editions of Microsoft SQL Server as an install option.

Over the last 12 months SQL Server Reporting Services has started to make its mark in the Business Intelligence market place. Not only does SQL Server Reporting Services deliver a new reporting tool, but it’s free as well. Suddenly everyone’s looking to ditch Crystal Reports - the report designer which comes bundled with VB and has been since VB 3 and integrated into Visual Studio .Net, but is SQL Server Reporting Service better?

What are the key differences between SQL Server Reporting Services and Crystal Reports, (Crystal Reports version 11). They both have strengths and weaknesses and these are the ones I’ve found, after working with both products, I compared them on what they say they can do and what I found on day one...

So Far...


  1. Although Microssoft say it’s free, they don’t recommend the "free" configuration and you will need additional SQL Server licensing before you get started.

  2. SQL Server Reporting Service handles less that 80% of the most common reporting scenarios I could come up with and some obvious features expected from a reporting tool are missing and some still have bugs in (these need to be fixed).

  3. SQL 2005 reporting services does support ad hoc reports (the designer develops a report schema and deploys it on the reporting server).

I'll keep updating as I complete my testing on SQL Server Reporting Services and Crystal Reports.

In the mean time, if you wish to learn more on SQL Server Reporting Services and how it can benefit your organisation, please visit the Quantix website.