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

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

Don’t forget to drop your views

I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created...

SSIS Package Execution in Azure is Out Now

It’s been a long time coming, but now SQL Server Integration Services is in Public Preview on Azure!
I’ve written about...

Adding a Replica back into a SQL Server Availability Group

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Oct 2, 2017 is the GA date for SQL Server 2017

Announced today at Microsoft Ignite, the general availability date is Oct 2, for Windows, Linux, and Docker. Time to get...