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

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

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

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

Azure SQL Data Warehouse and Backups

Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...

Considerations for Using Layout Images in Power BI

Using layout images in Power BI has become a popular design trend. When I say layout images, I’m referring to...

Displaying Long Values in SSMS

Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...

Displaying Long Values in SSMS

Click here to watch this week’s video on YouTube.
I write a lot of dynamic SQL and frequently encounter variables that...

Displaying Long Values in SSMS

Watch this week's video on YouTube
I write a lot of dynamic SQL and frequently encounter variables that contain many characters:
DECLARE @LongValue NVARCHAR(MAX) = CAST('' AS NVARCHAR(MAX)) +
N'SELECT
...