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

Recover database encrypted modules code with dbatools

This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments I read about it, mainly why people still use WITH ENCRYPTION when it's simple to...

Better Productivity: Cycling the Windows Clipboard in Windows 10

A quick tip I learned, that has become handy for me. Tl;dr: Try Win+V Often I am moving lots of information between different applications. I might do some editing,...

Daily Coping 21 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...

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

Daily Coping 18 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...

Failing SQL Agent Jobs – Part 2

Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed...

Workload Replay for Azure SQL Database and Amazon RDS

Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon...

Configure HyperV on windows 10 - Part 5