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
61 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)
577 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
34 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)
549 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)
537 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)
678 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)
518 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)
484 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)
493 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)
654 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Checking the Error Log III
Comments posted to this topic are about the item Checking the Error Log III
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers