A New Chapter: Why I Made the Move from Dayforce to ESO
A New Chapter: Why I Made the Move from Dayforce to ESO Over the past several weeks, many of you have probably noticed subtle hints throughout my blog. A...
2026-07-14
51 reads
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
One of the first things I review when I inherit a new SQL Server environment is the SQL Agent jobs. I can learn a tremendous amount about an organization...
2026-07-01 (first published: 2026-06-16)
557 reads
Mystery Backups: Estimating Disk Space When All You Have Are .BAK Files
How Do You Determine How Much Disk Space You Need If You’re Handed 18 SQL Server Backups and No History? Happy last day of June, dear reader. Today’s post...
2026-06-30
23 reads
PowerShell Strikes Back: A New Script
This is it. The final chapter of PowerShell Strikes Back. Over the past four weeks, you’ve built a real foundation. You know that single quotes are literal and double...
2026-06-15 (first published: 2026-05-26)
532 reads
PowerShell Strikes Back: Return of the Loop
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is paying off. In Week 1, we learned that quotes are not interchangeable. In Week 2,...
2026-06-03 (first published: 2026-05-18)
523 reads
PowerShell Newbie – Variables
This is Week 2 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the...
2026-05-27 (first published: 2026-05-11)
669 reads
PowerShell Strikes Back: Know Your Quotes, Young Padawan
This is Week 1 of PowerShell Strikes Back – a four-week May series for SQL Server DBAs who have dabbled in PowerShell but never stopped to nail down the...
2026-05-20 (first published: 2026-05-04)
504 reads
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
If you’ve been here before, you know this blog is usually about SQL Server, PowerShell, and the day-to-day work of being a DBA. Execution plans, availability groups, dbatools scripts...
2026-05-13 (first published: 2026-04-28)
473 reads
How to Connect to SQL Server When Nothing Else Works – DAC
It's 2 AM. Your phone is going off. Users can't connect to the application, and when you open SSMS to investigate, the connection spinner just keeps spinning. SQL Server...
2026-05-04 (first published: 2026-04-22)
476 reads
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
Hello, dear blog reader. Today’s post is coming to you straight from the home office, ready to talk about a topic that comes up more than you’d think: storing...
2026-04-22 (first published: 2026-04-14)
639 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers