Unit Testing & Intelligent Query Processing

Actually, these two topics don’t have anything to do with one another. I just ran out of days to promote everyone individually who was taking part in putting on...

Administration Basics: Point in time recovery

Nowadays, data is a precious asset for companies today. If you are a database administrator (by decision or by mistake) or simply you are the "IT guy," you have...

Daily Coping 30 Mar 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...

Extended Events: Queries and Waits

Wouldn’t it be great to be able to put together queries and waits at the same time? You all capture query metrics using some method. Most of us query...

It’s Not April Fools – Redgate Streamed is Coming

Next week is April 1, typically April Fools Day, where we have jokes, pranks, and false stories. I’ve done my share of them, but this isn’t one. With the...

Living with Bipolar During a Pandemic

Introduction Today is World Bipolar Day.  I wanted to write a blog about my experience with bipolar to help others that have mental health challenges know that aren’t alone...

T-SQL Tuesday Live–31 Mar 2020

I’m hosting another live T-SQL Tuesday event tomorrow, which is really just a casual video meeting for anyone that wants to join and take a break from work, life,...

Why you should never use default string lengths.

TL;DR; You probably don’t know what you’re going to get. Even if you do know the person maintaining your code ... Continue reading

Probing Columnstore Indexes

In this article, our focus will be to test, the performance benefits of columnstore indexes, on a transactional (OLTP) workload, for real-time analytics.

We'll cover examples from each of...

Understanding Disk Performance and IOPS in cloud platform

In the past many years, apart from working as DBA, I was working with multiple cloud technologies and actively involved in the migration process to cloud infrastructure. In between,...