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

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

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

Error handling protip: @@Error resets after the next command

The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run ... Continue reading

Azure Analysis Services – Processing Hot & Cold Data using Tabular model partitions

Introduction Recently have been working on a “Proof of Concept” task where I wanted to test the capabilities of Azure Analysis Services Tabular model when loading data from different...

Extracting data from Common Data Services (Microsoft Dynamics 365) using Azure Data Factory

(2020-Mar-30) Little did I know that I can use Azure Data Factory (ADF) to extract data from the Common Data Services (CDS). This data platform enables you to securely store...

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

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