Get the month end dates of last N months

Here is a simple T-SQL script that may come handy if you need the month end dates of last N months. N is the number of months. The output...

How I carved up 18TB of Storage

In a previous post I told you about how I got a Synology DS920+ on loan to play around with.  The device comes with 4 drive bays so there...

Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

New blog post - Seamlessly migrate large SQL databases using AWS Snowball and AWS DataSync.

In this blog post, I covered how to simplify large SQL Server database migrations...

Azure SQL Managed Instances

After many years working with different “flavours” of SQL server in Azure from its true PaaS form to SQL server in AKS (Azure Kubernetes Service) it’s time to look...

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

Azure Kubernetes Service – Handy Commands

Just some handy commands to use via kubectl. I found these useful for various reasons so hopefully you will too. Overview of our nodes. Pod information, remember from my...

Connecting to Azure Blobs in Power BI

The step-by-step process below walks through connecting to data housed in Azure Blob Storage from Power BI using a SAS token. There are many ways to grab your data...

Daily Coping 11 Aug 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...

Join me on 13 August 2021 for Dativerse

This coming Friday the 13th (August 2021) is the first ever Dativerse virtual conference, hosted by our DataGrillen friends William and Benjamin. According to their site: We try to...

Last Non-NULL Date in SQL Server

The simplest of requests are often the most difficult to execute. For example, a finance team needs to know every time a customer did not invoice for 90 days...