Migrate Your Azure Data Studio Connection List

I wanted to migrate some connections without recreating them and wondered how to do that in Azure Data Studio. It turns out to be easy. I post about whatever...

T-SQL Tuesday 177 - Managing Database Code

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Mala Mahadevan
(blog) asks how we manage our database-related code.

Where do you keep...

Observing Extended Events

Sure, you can right click on a running session for Extended Events and open the Live Data window, but are there other ways of observing what Extended Events is...

Microsoft Fabric reference architecture

Microsoft Fabric uses a data lakehouse architecture, which means it does not use a relational data warehouse (with its relational engine and relational storage) and instead uses only a...

Grouping by Object Type in SQL Compare

A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...

Your SQL Server is Slow, What To Look At

As a data professional, you’ll often get a phone call, email, or trouble ticket that says “SQL Server is slow, my query is slow, or things are slow”. This...

Boost Your SQL Skills: A Fun, Hands-on Challenge Awaits!

Are you ready to take your SQL skills for a spin? The August 2024 SQL Practice is here to offer you a fun, hands-on learning experience. Designed with real-world...

The Fediverse Files: ActivityPub Interview with Evan Prodromou

Doc Pop and Evan Prodromou discuss the past, present, and future of ActivityPub and the fediverse.

Don’t run CHKDSK while SQL Server is running

On behalf of every database administrator everywhere, I implore you not to run CHKDSK on a system that has a live database installed and running. This includes, but is...

Reducing Meetings and Making Them More Productive

I’m sick of meetings and I know many other folks are, too. Every time a knowledge worker (such as IT or cybersecurity but also business) has to go to...