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

Nine chapters of my data architecture book are available

As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...

A Decade of Dedication – Celebrating 10 Years in Business

I am overjoyed to announce a momentous occasion – we have officially reached the remarkable milestone of being in business for 10 years! This incredible journey began with a...