Backups for Azure SQL Virtual Machines

When it comes to database backups for IaaS based Azure SQL Servers you have 3 options. Automated Backups, both V1 and V2 depending on the SQL Server version. Azure...

Azure DevOps at the Data Platform Summit 2020

I was lucky enough to go to the Data Platform Summit in 2017. I still have one of my favorite speaking pictures from the event: I took my whole...

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