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

Last Week Reading (2020-08-02)

Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from ADF Team. Working with Git repositories in Azure Pipelines Multi-repository access and more. DevOps for...

Online certification exams are definitely different

As you can tell from previous posts, I’ve taken a few Microsoft Certification exams here in 2020. As you may have also heard, there’s been this Coronavirus pandemic happening...