T-SQL Tuesday #177–Keeping track of database code

This month’s invitation is from Mala Mahadevan, who has hosted 5 times. This latest one is one that is near and dear to my heart as I use source...

State of the Database Landscape Survey 2024

Hello all! This post is nothing but a simple request. Please, if you have a few spare minutes, meander on over to this link and fill out the State...

Backup SQL Server to AWS S3 Bucket (2022 Update)

Way back in the mists of time I wrote a post on how to backup SQL server to an S3 bucket using TNTDrive, https://sqlundercover.com/2018/06/18/backup-your-on-premise-sql-server-directly-to-an-aws-s3-bucket/. Back then, if we wanted...

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