Skip to main content

SQL Server Consulting

Here at we are a Microsoft Partner and we offer a range of SQL Server consulting services to help you design, manage and maintain your SQL Server environment. 

If you would like to discuss a SQL Server Consulting Requirement get in touch and arrange for a free 30 minute consultation

If you are interested in our services please contact us or start a chat!

Call:  01212 889670  

SQL Server Health Check

You have SQL Servers supporting  your mission critical business applications. You might not have a full time DBA taking care of and managing your environment for you. You are wondering if all is well with your SQL Servers? Is there anything that could be changed so they run better, faster, more securely? Is your data being backed up? Can it be restored? Do you  have any security concerns you need to address? Is your SQL Server performing as well as it can? 

We can help you answer these questions with a full and comprehensive SQL Server health check. We use our custom scripts to retrieve a whole bunch of information on your SQL Server Estate. We’ll then compile a report and presentation and a list of recommendations. We’ll spend some time going through and discussing these with and how to implement. We can even help you implement the recommendations if that is your preference.

For a free 30 minute consultation with one of our SQL Server consultants call 0121 2889670 (0044 121 2889670 from outside the UK) or use the email form in the contact us page

SQL Server Performance Tune-up

You have a problem with your SQL Server. It randomly goes slow for no apparent reason. Something that normally completes quickly is now taking seconds or minutes to complete. 

We can help!

We can help you identify your performance bottlenecks – the root cause of the performance problem. From there we will work with you eradicate the problem. Whether it’s a code change, creating indexes or something else. We can help.

For a free 30 minute consultation with one of our SQL Server consultants call 0121 2889670 (0044 121 2889670 from outside the UK) or use the email form in the contact us page

SQL Server Cloud 

You have no doubt heard about cloud computing, whether it be Microsoft's Azure platform or Amazon's AWS. You may have come across running SQL Server on one of these cloud platforms. 

We have experience of deploying SQL Server Infrastructure as a Service or IaaS  where you run your SQL Server on a virtual machine on the cloud platformSQL Server Virtual Machines) in both AWS (Amazon’s Cloud) and Azure (Microsoft’s cloud). 

We have also deployed databases to Azure SQL database – The platform as a Service (PaaS) on Azure. 

Just remember Running SQL Server in the cloud = running your SQL Server on someone else’s computer.

Do you have a private cloud or an on premises virtual environment? If you have a private cloud or an on premises virtual environment, maybe running your SQL Server estate on VMware or Hyper-V we can help with that too. 

For a free 30 minute consultation with one of our SQL Server consultants to discuss your SQL Server cloud requirements call 0121 2889670 (0044 121 2889670 from outside the UK) or use the email form in the contact us page

SQL Server Upgrade

You have SQL Server running nicely with no issues or problems. Its been running that way for years! The trouble is its SQL Server 2005 and you know you need to consider migrating or upgrading to a later version of SQL Server but you don’t know where to begin? 

We can help with our SQL Server version upgrade service.
Having undertaken many SQL Server version upgrades (2000 to 2005, 2005 to 2008 and 2008 to SQL Server 2012/2014/2016) we have a wealth of knowledge that can help you upgrade the to the latest and greatest version of SQL Server. Ensuring that process runs smoothly.

we can help you design the new SQL Server Architecture, plan the migration process and the tasks involved  and be on hand to actually carry out the migration for you. Its completely tailored to your needs 

For a free 30 minute consultation with one of our SQL Server consultants call 0121 2889670 (0044 121 2889670 from outside the UK) or use the email form in the contact us page

SQL Server Architecture

The design and architecture of your SQL Server infrastructure is key to the performance, reliability and scalability of the applications and services that it supports. We can help you design a suitable infrastructure for all the SQL Server components that you intend to utilize in your business.
contact us  for more information on our infrastructure design and implementation services

For example:
If you have SQL Server running your mission critical business databases ensuring that your data is protected and available will be important to you. We can help you develop a High Availability/Disaster Recovery Strategy.  Protecting your company’s most valuable asset and keeping that asset available is a very important task for most businesses. We can help you put in place a solid reliable backup strategy and implement SQL Server High Availability Features to protect your data and make it available when you need it the most. 

We will help you identify 
  • How much data can you afford to lose?
  • How frequently do you backup your databases?
  • Do you keep copies of you backup’s offsite?
  • Do you make use of any of the SQL Server HA FEATURES?
  • Clustering 
  • AlwaysOn Availability Groups
  • Log Shipping

The design will be fully documented with a high level design identifying business drives and why we are deploying this solutions. We will provide a detailed design showing how to implement the solution and we help you build the solution too. Again you have full flexibility in how we are engaged. 

For a free 30 minute consultation with one of our SQL Server consultants call 0121 2889670 (0044 121 2889670 from outside the UK) or use the email form in the contact us page

Feel free to contact us  about any SQL Server consulting services offered by

Call:  01212 889670 

Popular posts from this blog

Always Encrypted

By David Postlethwaite

Always Encrypted is new features in SQL Server 2016 and it is also available in Azure SQL Database. Here you can encrypt columns in a table with a master key and a certificate so that they will appear as encrypted strings to those who don’t have the required certificate installed on their pc.
Once the certificate is installed on the computer then the unencrypted data can then be seen as normal.

The data passes from database to your application as the encrypted value, only the application with the correct certificate can unencrypt the data so it is secure across the wire. This will go some way to resolving the concern of people worried about putting their sensitive data on a shared server in the cloud such as Microsoft Azure and accessing the data across the Internet.

At the time of writing Always Encrypted is only supported with ADO.NET 4.6, JDBC 6.0 and ODBC 13.1 but expect other driver to become available.

The calling application (including SSMS) must also hav…

SQL Server 2012 and Virtual Service Accounts

This post is written by David Postlethwaite
If you are using SQL Server 2012 you will probably have noticed that the default account for the SQL services has changed from that used in previous versions. With SQL 2005 and 2008 the default account for SQL service and SQL Agent service was “NT Authority\System”. This is one the built in accounts on a Windows machine, managed by the machine and selectable from a dedicated dropdown list

The Network Service account was introduced in Windows 2003 as an alternative to using the LocalSystem account, which has full local system privileges on the local machine, a major security concern.
The Network Service has limited local privileges easing these security concerns but when many services on a machine use the Network Service account it becomes harder to track which service is actually accessing resources and performing actions, because all the services are using the one Network Service account.
Also, this account, by default, has sysadmin per…

SQL Server Express v SQL Server Developer Edition

SQL Server Express v  SQL Server Developer Edition
Over the weekend I received the following in an email from Ali Ahmad who asked me some questions about learning SQL Server. We exchanged a couple of emails so I have boiled this down to the most salient points.

Goal: I want to learn SQL Server inside out… for career progression as DBA/BI/data mining. I'm a data analyst and want to learn inside out about data warehousing.
•I understand relational database concepts...
•I have SQL Server 2014 express installed…
•I need to download the adventure works sample in order to play with it.
•So much knowledge on Microsoft website it's easy to get lost… where do I begin?

SQL Server Express v SQL Server Developer
This is interesting. If you want to learn SQL Server inside out including the Business Intelligence suite of applications I would suggest downloading the developer edition of SQL Server which since 2016 has been made available free of charge. Prior to that there was a f…