The Book of Redgate: We Value Teams
This value is something that I still hear today: our best work is done in teams. On the facing page, there is a short description of what this means....
2025-10-10 (first published: 2025-09-19)
184 reads
Troubleshooting TempDB Log Full Errors When SSMS Won’t Connect
Have you ever received the dreaded error from SQL Server that the TempDB log file is full? Only to open SSMS and be greeted with a message that prevents...
2025-10-13 (first published: 2025-09-18)
734 reads
Accelerating AI with Confidence: Why Microsoft Purview is Key to Responsible Innovation
Artificial intelligence is no longer a distant concept. It is here, embedded in the way we work, create, and make decisions. From generative assistants to predictive analytics, AI is...
2025-10-13 (first published: 2025-09-18)
374 reads
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail of clues. With SQL Server 2025 now reaching its first Release Candidate (RC0), it feels...
2025-10-10 (first published: 2025-09-17)
394 reads
A Prompt AI Experiment
Prompt AI released recently and I decided to try a few things with the tool that might help me in database work. I’ve had to do this task, but...
2025-09-17
113 reads
SQL Server Is Slow (part 1 of 4)
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at you that SQL Server is slow? Stop. Don’t Open SSMS Yet. You’ve heard it...
2025-10-08 (first published: 2025-09-17)
442 reads
Secure Logic Apps with OAuth Authorization
I’ve used Logic Apps a couple of times over the past years for simple workflows, like sending an email (still not supported in ADF, booooo), reading a SharePoint List...
2025-09-17
223 reads
Scaling PowerShell – Lessons from a Technical Interview
Recently, I was in a technical interview where the topic of running PowerShell at scale came up. Although I’ve worked with PowerShell for quite some time, I realized I’d...
2025-09-16
171 reads
Installing Old Versions of PowerShell Modules with Their Dependencies
I don’t recall where this came up (probably in SQLSlack), but I had a need to install an older version of dbatools to test something related to loading the...
2025-10-06 (first published: 2025-09-16)
175 reads
In Memory of Andrew Clarke, AKA Phil Factor
One of the parts of getting older that really sucks is I seem to attend more funerals than weddings. It’s a sad fact of file, and this was one...
2025-09-15
577 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers