SQL Homework – August 2020 – More DML Triggers

Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading

Unboxing SQL Clone 2020 for a PoC

When I got a new machine, I had SQL Clone on my old machine, in a few VMWare VMs. I decided to move this to my new machine, so...

What Agent Jobs are Running??

Do you run SQL Agent Jobs in your environment?  Do you know what is running at any given time?  Most people do not know what is currently running if...

Caution When Dropping Unused Indexes on an Azure SQL Database

Index Maintenance is an important aspect of database health. Above and beyond regular index rebuilds and reorganizations it is important to understand the usage of the indexes on your...

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

Data Platform MVP 2020

I am humbled to be among so many great professionals and honored at the same time for having been chosen.
Related Posts:

It's an Honor: Microsoft MVP July 1, 2019

How...

Fun and profit with UTF-8

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available in Azure SQL Database, UTF-8 is exciting if you have a legacy database and application...

Online certification exams are definitely different

As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...

The EU New Stars of Data Come Tomorrow

One of the things I’ve tried to do when SQL Saturdays is ensure there are lots of local speakers, and new speakers. I’ve argued for more new speakers at...

Understanding how to enable SQL Server Optimizer Hotfixes

There are a number of knobs and switches that are available to database administrators that can be used to enable better performance.  There are three options in particular that...