Determine SQL Server Network Protocol Information using T-SQL and DMVs

I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...

SQL Server Encryption, What’s The Key Hierarchy All About?

 
I’m sure that we all know that SQL Server includes all sorts of interesting functionality to allow us to encrypt...

NTFS Compression and SQL Server Do Not Play Well Together

Wanted to be proactive and move a database that was in the default path on C: to a secondary drive as it was growing pretty heavily.

What I didn’t realize...

Flipping Sides in SQL Operations Studio

I’ve been starting to use SQL Operations Studio (SOS) a bit more. This is a small, lightweight editor that is...

Exporting Extended Events Session Data to a Table

If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...

Tracking Down tempdb usage

Determining what is causing your tempdb to grow can be difficult at times and troublesome during production issues.  Luckily SQL...

Why you should not use SELECT *

A shorter post this week, but an important one. Last week, Erik Darling commented on my post saying that we...

Putting Object Explorer etc on the right side of SSMS rather than the left.

A while back I was given the advice Move your tabs (Object Explorer etc) to the right side of SSMS....

MVP for Another Year

I am a little late in posting this, but I still wanted to share. It is a huge honor to...

Azure Training in London

I am very excited about my upcoming IEAzure class being held in London, September 10th and 11th at the Marriott in Kensington (London).
This...