How SQL Server stores data types: DATETIMEOFFSET

If you’d like to check out the previous instalment in this series on storing dates and times, click here. I avoided mentioning this data type because I didn’t think...

How to create a DataKeeper Replicated Volume that has Multiple Targets via CLI

I often help people automate the configuration of their infrastructure so they can build 3-node clusters that span Availability Zones and Regions. The CLI for creating a DataKeeper Job...

Moving Synapse Databases Between Subscriptions – Practical Guidance

One of the tasks, we often do with migration projects is move large volumes of data. Depending on how you are configured, you may need to do the migration...

WordPress.com Welcomes the Award-Winning Atavist Magazine to the Platform

The Atavist Magazine, known for its in-depth journalism and creative, elegant design, joins sister site Longreads, making WordPress.com a home for the web’s best longform storytelling.

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

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