Be in the SQL Yearbook
I’ve been thinking about this for years, and I’m finally doing it. I’m making a SQL Yearbook, and I want you to be...
2018-09-06
265 reads
Jen McCown
T-SQL: How many bananas tall are you?
So today, this happened: Now I suddenly want to know how many bananas tall I am… https://t.co/7geupBzXDj — MidnightDBA (@MidnightDBA) September...
2018-09-06
314 reads
Fix: When an Availability Group listener’s IP is stolen
When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener,...
2018-09-05
882 reads
Learn PowerShell in Oklahoma, August 24!
SQL Saturday Oklahoma City is coming up RIGHT SOON, on August 25. The day before SQL Saturday OKC - August 24...
2018-08-14
701 reads
Vote for a new SSMS feature: Pin files in SQL Server Management Studio
So, this just happened: That's a p good idea. I'll upvote it if you put it in User Voice. Or...
2018-08-03
411 reads
Minion Backup: Restore to another server
Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look...
2018-06-28
450 reads
The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’
Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let's take...
2018-06-14
356 reads
Generate RESTORE LOG statements
Today, we're going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files,...
2018-06-06
808 reads
Tea with Kalen! An interview with Kalen Delaney (#DBAsAtMidnight)
We had an AMAZING talk with Kalen Delaney – wait, you do know who Kalen is, don’t you? Rightfully, @SQLQueen on Twitter. Over 30 years...
2018-05-16
351 reads
SQL Saturday Dallas half-day precon: “Beginning Programming with Powershell”
On May 18 we will be presenting a half-day of PowerShell learnin', right before SQL Saturday Dallas! Read up and...
2018-04-24
349 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers