New blog post - Monitor deadlocks in Amazon RDS for SQL Server and set notifications using Amazon CloudWatch

Checkout my blog post on Monitor deadlocks in Amazon RDS for SQL Server and...

Daily Coping 15 Jun 2021

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

Launching the Microsoft Data Platform Continuity Virtual Group

Disasters big and small happen, and as data professionals, you should be prepared for the worst! I’m thrilled to announce that we’re launching the Microsoft Data Platform Continuity Virtual...

Blog post about Copying Azure files to SharePoint, comparing Logic App and Power Automate Flow for this, and Trust No One

(2021-May-31) Recently, I created a prototype solution for one of the projects, that would copy data files from Azure to SharePoint location. The task is trivial, doesn't require a lot...

Cleaning Up Stats Data for Volleyball

One of the things I’ve done the last few years is collect statistics as a coach for the kids I work with. Helping them understand how they are performing...

Daily Coping 14 Jun 2021

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

Day One, the Journaling App, Joins Automattic

We’re excited to welcome Day One to the Automattic team. Day One is a private journaling app that makes writing for yourself a simple pleasure. A beautifully designed user...

Find Queries Using a Key Lookup Operator

While teaching about Extended Events and Execution Plans last week, Jason, one of the people in the class, asked: Is there a way in Extended Events to find queries...

SQL Homework – June 2021 – SQL Audits

Last month I had you work on Extended Events, so hopefully now you are a bit more comfortable with them. ... Continue reading

Azure SQL Database – Secondary Database and Tiers

On the theme of failover groups let’s do a quick recap on my environment. As shown below you can see the secondary database server called spacesql in West Europe....