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

Query Azure CosmosDB from a SQL Server Linked Server

[read this post on Mr. Fox SQL blog] Recently I had a requirement to combine data that I already had in SQL Server (2016) with JSON document data already stored in...