Testing for End of Month in PowerShell

This is one of those blog posts you write so that 2 years later, you can look it up to remind yourself how to do something.
I found myself needing...

T-SQL Tuesday #186 Invitation - Managing Agent Jobs

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party originally created by Adam Machanic in 2009 and currently curated...

T-SQL Tuesday 185 - Produce a Video!

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Erik Darling
(blog) asks us to produce a video

You can talk about whatever...

On the Internet, the Walls Have Ears

I received a sobering reminder this week of a lesson we all have learned or should have learned long ago. Something I said online came back around months later...

T-SQL Tuesday 184 - Mentorship

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Deborah Melkin
(blog) asks us to talk about our relationship with mentoring and...

The Mysterious Empty Table

It seems like no matter how long you work with a system beyond a trivial size, you’ll find something new every so often. A little while ago, I found...

Posting to Bluesky via PowerShell on macOS

The week of PASS Data Community Summit 2024 (November 4-8), Bluesky seemed to reach critical mass with the data community as well as the tech community writ large. Over...

SQL Query Stats via Powershell

Sometimes, work tasks and questions that come up in the SQL Server Community Slack coincide.
A couple weeks ago, DrData asked
With SET STATISTICS IO ON, is there really no way...

SQL Saturday Syracuse 2024 Recap

First Things First Thanks to every who came to my session, Asnwering the Auditor’s Call with Automation. Slides and scripts are posted to my Github.
The Event! This was Syracuse’s...

dbatools Required Filesystem Access for Database Restores

The Problem While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](https://dbatools.io/). It should have been a simple backup/restore copy of the databases,...