The Curiously Large CASE Statement

 
A powerful little expression in SQL Server is the CASE statement. The CASE statement has the ability to “transform” data...

Filelistonly and headeronly – Find SQL server version from backup and use of header only version, ldf mdf size and LSN restore and file list only logical name.

Problem: SQL server database refresh / restore...

[[ This is a content summary only. Visit my website for full links, other content,...

Writing a presentation 4: Practice and improvement

My presentation so far is really rough. I need to improve a lot before SQL Saturday Chicago! For now, the...

PASS turns 20

Its really hard to believe that its been 20 years since the start of the PASS organization – the volunteer run...

Monitoring Your Databases and Servers and…

You absolutely need to know about the servers you have under management in your estate. You need to know about...

4 Reasons To Avoid VARCHAR(8000)

Watch this week’s episode on YouTubeWhen first learning SQL Server, I had the brilliant idea of defining every column on...

Weekly reading #7

It is MVP Summit time! I have not made it this year unfortunately. I hope all MVPs have a greate...

dbatools for the accidental DBA

dbatools is a very well known tool within the SQL Server community, and probably most of the production DBA’s are...

Compliance Ain’t Easy

I’m sure by now you’ve heard of the GDPR and some of the large scale data breaches that have occurred...

A Week of SQL Server 2019

I’m in Redmond, or Bellevue, or somewhere nearby. Not completely sure where the Microsoft MVP Summit is this week (as...