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

COVID-19, a wake-up call

COVID-19 is the only pandemic I’ve seen in my whole life. It gave me a whole new percepective of the life. Kaal (Time) is mightiest of everyone and everything....

ASF 030: Benni De Jagere interview

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus on the Microsoft (BI) Stack. On a daily basis, he turns (large amounts) of coffee...

ASF 030: Benni De Jagere interview

Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus on the Microsoft (BI) Stack. On a daily basis, he turns (large amounts) of coffee...

Azure SQL Database: Great Choice for Modern Cloud Applications

Microsoft offers several options for moving your SQL Server workloads to Azure. If you’re looking to host modern cloud applications, your best option is Azure SQL Database Service. For...

Containers and DevOps

Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change...

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

Figuring Out How To Hide Production Data

There’s a really simple conundrum that we go through all the time. The best data for development is production You can’t have production data for development You have to...