SQL Server Schema Compare

A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...

Azure SQL Database Resumable Online Index Rebuild

If you know me by now I like rebuilding indexes and that is no different in Azure. Now we have...

[Video] SQL Server Deadlocks

SQL Server Deadlocks – Also known as “The deadly Embrace” occurs when there are 2 processes and neither can advance and...

DBCC CHECKDB Azure SQL Database

Who should be running DBCC CHECKDB for Azure SQL Database? Should it be Microsoft or should customers be scheduling it?...

Azure SQL Database – Scaling up

Scaling up and down your SQL Database is something that is quite common to do. I want to discuss the...

SSMS and MFA support for Azure SQL DB

Quite a mouth full for a title but never the less very exciting. With the new version of SQL Server...

Azure Cloud “Fear” Busting #4 – Losing Control?

So the decision to move to the cloud has been made but there is a fear from people that once...

Azure Automation and SQL Index Maintenance

Azure does a lot for your SQL Database, from backups to automatic tuning but it still doesn’t have an index...

SQL Server – So you like to shrink do you?

If you do – shame on you and shame on me because I do.

Moving on, I found strange behaviour within SQL...

Interviews and Oranges

What a great topic for this month’s T-SQL Tuesday hosted by Kendra Little https://littlekendra.com/2017/08/01/tsql-tuesday-93-interviewing-patterns-anti-patterns/

The topic being: Interviewing Patterns and Anti-Patterns....