Skip to main content

SQL Server Consulting

SQL SERVER CONSULTING


Get your free 30 minutes SQL Server consultation with one of our expert technology consultants today.
Here at gethynellis.com we offer a range of SQL Server consulting services to help you manage and maintain your SQL Server environment. 

If you are interested in our services please contact us 

Call:  01212 889670  

(or 0044 121 2889670 from outside the UK) 


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? Is your data being backed up? Can it be restored? Do you  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  list of recommendations and 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 Tuning

So you have a problem with your SQL Server. It randomly goes slow for no apparent reason. Something that normally completes quickly is not taking seconds or minutes to complete. We can help you identify your performance bottlenecks – the root cause of the performance problem and from there 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 and the Cloud 

You have no doubt heard about cloud computing and you may have come across running SQL Server in the cloud. We have experience of deploying SQL Server Infrastructure as a Service (SQL 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 on Azure. Just remember Running SQL Server in the cloud = running your SQL Server on someone else’s computer.

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 Virtualization 

If you haven’t looked at cloud computing for SQL Server yet I think there is a good chance that you have looked at virtualization. Lots of companies and organizations are adopting a virtualisation first approach to the installation of new servers in their data centres. This can and will include SQL Server. Historically many  DBAs perceive SQL Server virtualisation as a bad thing for their database Servers fearing that performance and reliability will suffer. 

We can help and assist you with SQL Server virtualization.
We can ensure that the virtual environment is setup and configured so that SQL Server performance will not suffer and your SQL Servers will run happily on a virtual environment. 
We can also help you convert (migrate) your existing physical servers to virtual machines. 

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 Version 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 services.
Having undertaken many SQL Server version upgrades (2000 to 2005, 2005 to 2008 and 2008 to 2012/2014) we have a wealth of knowledge that can help you upgrade the to the latest and greatest version of SQL Server 

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


High Availability/Disaster Recovery Strategy

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


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 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 gethynellis.com

Call:  01212 889670 




Popular posts from this blog

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…

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…

How to Setup Kerberos Correctly

David was in Copenhagen this weekend delivering his Kerberos talk Taming the Beast: Kerberos for the SQL DBA to SQL Saturday Denmark. I have had a quick chat with him via email since he got back and he said he had a great time. The event was very well attended with 280+ attendees and his talk was well attended.

I think David is planning submitting a few sessions to SQL Saturday events in Europe in the next few months so look out for him there and we'll keep you posted as to his whereabouts when schedules get finalised later in the year.

David has pre-recorded his Kerberos talk. You can watch on you tube and I have also embedded it in this post if you want to see what his kerberos talk  covers...



If we can help you with a SQL Sever problem visit our SQL Server Consulting page or contact us