Expanding Northwind with Prompt+

I was trying to do a little testing of our subsetter and needed a larger database. So I decided to ask Prompt + to help me with a little...

Speaking at SQL Saturday Syracuse 2024

I’m happy to announce that I will be speaking at the first-ever SQL Saturday Syracuse on September 7th, 2024. I will be presenting Answering the Auditor’s Call with Automation

Move to WordPress.com, and We’ll Handle the Migration for Free

For a limited time, we’ll move your existing WordPress site from any host to WordPress.com for free. 

Building a Cost-Effective SQL Server Failover Cluster in Google Cloud Platform

Building a SQL Server Failover Cluster in Google Cloud Platform (GCP) is a powerful way to ensure your databases remain highly available, even in the face of unexpected failures....

Database CI/CD Basics (T-SQL Tuesday #177)

This month’s invitation is from Mala Mahadevan (b) asking us how we manage the database code. Since this is my passion project, I have a few basic tips to...

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