Failing SQL Agent Jobs – Part 3

It is Tuesday!!  Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators...

Daily Coping 15 Aug 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Prepping the local SSD D: in an Azure VM for SQL Server TempDB

One of the few good, safe uses for the local SSD D: volume of an Azure VM is for SQL Server TempDB data and log files. There's a gotcha....

Adding ApplicationIntent=readonly to SQL Data Compare

Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection? If you are using Data Compare, and you are reading from...

Daily Coping 14 Sep 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Passing array of arrays as a parameter in Azure Data Factory and the role of an @item element in this

(2020-Sep-13) Array of arrays, in a JSON world, it’s a very common concept to have a set of sets of other elements in a dataset. Despite how strange it may...

Setup Laptop to boot with Windows 10 VHD - Part 4

Setup Laptop to boot with Windows 10 VHD - Part 4

Setup Laptop to boot with Windows 10 VHD - Part 4

All-Day at Virtual Houston Tech Fest 2020

It's a full day at Houston Tech Fest 2020 for us. Speaking at Houston TechFest is an decade-long annual tradition interrupted only by a hurricane and one year where I...