Building an Azure Architecture Diagram

One of the challenges I have at times is illustrating how I’d set up a particular system. Not the technical details, the visual ones. I can use boxes and...

Daily Coping 27 Jul 2020

I’ve 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...

Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.

In this episode I share...

SQL Server and Docker Compose

I used to think that Docker Compose was used solely to spin up multiple containers, in fact I blogged about doing just that here. That opinion changed when I...

SQL Server Stretch DB to Azure

Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...

Recapping SQL Saturday Albany 2020 (virtual)

This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed...

Getting Started with Stream Analytics

Resources

Resources

If you want a schema reference for the json Application Insights produces // [Azure Application Insights Data Model // Microsoft Docs

](http://bit.ly/2S3kFlD)

If you want to visualize last 90 days of...

Daily Coping 24 Jul 2020

I’ve 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...

Giving Back to Speakers

It might be hard to think back to 2007, but at that time, there were only a few SQL Server events taking place in the world. SQL Bits held...

How to Spell and Capitalize tempdb for SQL Server

No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...