Suppressing the FOMO

I saw a post recently on Twitter/X/whatever we call it. It was for a DevOps in a Day from Redgate taking place in Jacksonville. I’ve been a part of...

Handling physical deletes from the source and continue populating your analytical data store

(2023-Oct-15) When something important disappears, it's natural to start asking questions and looking for answers, especially when that missing piece has had a significant impact on your life.Similarly, when data...

The Evolution of Database Administration: From Administration to Database Reliability Engineering

In the fast-paced world of IT, where trends like DevOps and Infrastructure as Code (IaC) dominate the landscape, the concepts of Reliability and Observability have seamlessly woven themselves into...

T-SQL Tuesday #167 – Encryption and Data Protection

I missed September since I was gone half the month in Europe and busy with a roadshow. And, I missed October, since I was busy this month and lost...

Common Mistakes in SQL Server – Part 4

Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...

Common Mistakes in SQL Server – Part 6

In SQL Server, there are various scenarios in which you may want to consider recompiling a query or a stored procedure to ensure optimal query performance. Recompilation generates a...

Speaking at #DataWeekender 6.5

Super excited to share that I have been selected to speak at Data Weekender 6.5 on Saturday, November 4, 2023. I will be presenting my session, Can Microsoft Purview...

Using the Pure Storage PowerShellSDK2 - Part 2 - Working With Data

Welcome back to the second installment of our series using the Pure Storage PowerShell SDK2. In this post, we’ll dive into working with object data using Pure Storage PowerShell...

A New Word: Gobo

gobo – n.  the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...

How to Downgrade Or Recover a SQL Server Database To A Previous Version Using SqlPackage.exe?

How to Downgrade a SQL Server Database To A Previous Version?

Upgrading a SQL Server database to a newer version is one of the core duties...