SQL Puzzle – Prime Numbers

My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...

Concatenation Truncation – Are your strings being truncated?

It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...

Auditing Data Access in SQL Server for GDPR Compliance

In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...

SQL Clone, Redgate Licensing, and Cookies

SQL Clone is amazing, and it can really save time and disk space for many organizations. I’ve got a series...

Clustered vs Nonclustered: Index Fundamentals You Need To Know

Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...

DELETE data on SQL Server HEAP table – Did you know…

Before I complete my question let me provide context. I've received an alert saying that a specific database could not...

Clustered vs Nonclustered: Index Fundamentals You Need To Know

Photo by Patrick Tomasso on Unsplash
How many times have you known that adding an index would improve query performance but you weren't exactly sure which type of index to add?
This happened to me all the time...

Deploy Dacpacs With PowerShell

Final Addendum – use dbatools!
Addendum – There is a repo on GitHub which I wrote and recommend using for build/deployment of DACPACs....

Policy Based Management and Powershell

Introduction

Policy Based Management (PBM) can be used to inform DBAs when an incorrect setting is being used on a SQL...

DELETE data on SQL Server HEAP table - Did you know...

Before I complete my question let me provide context.
I’ve received an alert saying that a specific database could not allocate a new page (disk was full)
The message that you...