Saving My Garmin Data

With the Garmin outage, I was a little worried about my data. As a result, I wanted to ensure I could get information off of my device and at...

Calculating Application Availability in the Cloud

When deploying business critical applications in the cloud you want to make sure they are highly available. The good news is that if you plan properly, you can achieve...

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

Probing Columnstore Indexes

This article was first published on: 2020-03-14.

This article will probe the performance benefits of columnstore indexes, on a transactional (OLTP) workload for real-time analytics.

We'll cover examples...

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

Tonight is the PASS Marathon on SQL Server Performance

The event is tonight, and it’s my first time helping out as a moderator. I got a call for volunteers, and I added my name. The event starts at...

The What, Why, When, and How of Incremental Loads

When moving data in an extraction, transformation, and loading (ETL) process, the most efficient design pattern is to touch only the data you must, copying just the data that...

Color Coding a Database on All Servers with SQL Prompt

SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...

These are the extensions I have installed on Azure Data Studio

At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked...