Temporal Table Data Fixes

I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...

SQL Server is not a Car

Lets compare them anyway, just for fun. Both have an engine Both have a monitoring device (Dashboard/Activity Monitor) Both need power (Gas/Electricity) Both need to be told what do...

SQL Homework – September 2023 – Time for temporal tables.

Recently I needed to use temporal tables. And not just for the job history table in a managed instance. In ... Continue reading

Connecting to SQL Server Database Engine, simplified

One of the advantages of being on the Database Docs team at Microsoft is that I get to work with amazing people, which means we can respond quickly to...

BotChat BiWeekly 1.00.00

Hey there, I’m Mala. I’ve been in the data game for a good 25 years, first as a DBA and then as a Data Engineer, mainly working with Microsoft...

The PASS Data Community Summit On Guy in a Cube

I’ve known Adam and Patrick for a long time and I’m thrilled with the content they produce on their Guy in a Cube show. It’s a great resource for...

Mastering Data Engineering with Databricks: Your Path to Becoming a Data Engineer Associate

Introduction
In today’s data-driven landscape, skilled data engineers are the backbone of organizations, driving insights from vast data streams. If you’re aspiring to become a Data Engineer Associate and harness...

How to Secure SQL Server

Security! This is the word that comes to mind of every concerned person when it comes to storing, accessing, and sharing the data and database or database server. At times when applications are run in geographically restricted areas, there...

Yet another kind of orphan users in SQL Server

Yet another kind of orphan users in SQL Server

Or YAOU for short. (This silly acronym, I just made it up so don’t try...

Friday Flyway Tips: Visualizing Undo Scripts

One nice thing with Flyway Enterprise is that it will automatically generate the undo scripts for migration scripts. However, it used to be that finding these and seeing the...