Azure SQL Database SLA

Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...

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

Daily Coping 4 Aug 2020

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

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

Speaking at DataMinds Connect 2020

I’m delighted to announce I’ll be speaking again at DataMinds Connect this year, one of the greatest and best Microsoft Data Platform conferences on the European mainland. Due to...

Business Continuity in SQL Database

I have wrote a number of blogs on the topic of business continuity in SQL Database before (HA/DR for Azure SQL Database, Azure SQL Database high availability, Azure SQL...

Daily Coping 3 Aug 2020

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

Data Cleanup for WordPress Tags without a Plugin

Over the years I’ve had this blog, I’ve added lots of tags. In 15 years and 4,600+ posts, you can guess that I’ve made some typos and mistakes. I’ve...

Moving 1/3 of a heap

Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...

SQLSaturday Auckland: Certification Exams Inside Out this Weekend!

Looking forward to virtually presenting at SQLSaturday Auckland 2020 this weekend! I'll be presenting at 10:45AM Auckland time on Saturday, but that's 5:45pm Friday evening where I am in Central...