(Pinal Dave) This was an interesting error which I received while trying to uninstall SQL Server. In this blog, we would learn how to fix error Index was outside the bounds of the array, which might come during uninstallation of SQL Server.

(Melissa Coates) Recently I used Azure Cloud Shell for the first time. This is a quick post to show how I referenced the file share in Azure Storage to communicate with Cloud Shell.

(Chris Webb) While Power BI has a lot of great functionality for filtering the data that appears in a visual using visual-level filters there are going to be situations where you need more control over how filtering works, and in this blog post I’m going to show you how you can use visual-level filt

(Grant Fritchey) It is entirely possible to try to JOIN two tables on almost any field, as long as the two data types can, in some way, be made to reconcile to each other, you can try to join the tables.

(Pinal Dave) Learning never stops when you are a consultant. While doing my recent Comprehensive Database Performance Health Check my client asked an interesting question.

(James Serra) Azure Data Factory v2 (ADF) has a new feature in public preview called Data Flow. I have usually described ADF as an orchestration tool instead of an Extract-Transform-Load (ETL) tool since it has the “E” and “L” in ETL but not the “T”.

(Jason Brimhall) Yes Virginia, there are ghosts in your database. More specifically, there are ghosts in your SQL Server database.

(Denny Cherry) Azure is a great platform to use, and the new Managed Disks are fantastic as you just need to set it and forget it.

(Robert Dorr) I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article.

(Pinal Dave) Every consulting engagement is different and I get to learn new things. In this blog post, I will share what I learned during my recent Comprehensive Database Performance Health Check.