Excellence in SQL Server

Steve Jones from SQLServerCentral.com http://www.sqlservercentral.com/ asked in his editorial from the 5th of July to write 4 posts about...

Steve Jones from SQLServerCentral.com http://www.sqlservercentral.com/ asked in his editorial from the 5th of July to write 4 posts about...

Steve Jones from SQLServerCentral.com http://www.sqlservercentral.com/ asked in his editorial from the 5th of July to write 4 posts about...

What do you check after you have successfully restored a database. Here is my quick checklist: - database is online - you can see the...

What do you check if you only have a limited amount of time to review a SQL Server. You can''t run your usual set of scripts. All you...

I am currently involved with performance tuning on a large database, almost a terabyte of data. One of the things that we found was that...

In April this year I sat the Microsoft Exam 70-761 and after that I decided to start studying for Exam 70-762 Developing SQL Databases....

Whilst installing SSMS 17.6 recently I needed to find out how to do a silent install. The following image shows you the available...

Whilst building a new SQL Server I wanted to make sure that the database mail settings where the same as the previous servers. Even if I...

Whilst doing a pre-production health check on a SQL Server 2016 Standard Edition server I noticed that some cpu schedulers were offline....

I was asked the other day, is it possible to have multiple SSRS instances on the same server? The answer is yes, you can install another...

A great script to add to your toolkit. sp_whoisactive by Adam Machanic. It is a comprehensive activity monitoring stored procedure that...

I was asked to investigate an issue with the upgrade of a legacy application from SQL Server 2005 to SQL Server 2012. After running...

This is the last of a series on installing SQL Server. This is based on an a standalone installation of SQL Server 2017. This blog...

This is the fourth part of a series on installing SQL Server. This is based on an a standalone installation of SQL Server 2017. This blog...

This is the third part of a series on installing SQL Server. This is based on an a standalone installation of SQL Server 2017. This blog...

This is the second part of a series on installing SQL Server. This is based on an a standalone installation of SQL Server 2017. This blog...

Well it has been a very long time since I have done a Microsoft certification exam (I think the year was 2000). Well a lot has changed in...

This is the first part of a series on installing SQL Server. You could use these blogs as the skeleton for an automated build This is...

As part of an application upgrade at a client. I was asked did I see any issues in disabling the following TCP settings on the SQL Server...