Tip: RECOVERY_PENDING is not the same as RECOVERING
I’ve seen this mistake more than once, from DBAs with a middling to fair amount of experience. So it bears repeating....
2014-09-08
919 reads
Blog Posts
Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information
A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...
2014-09-07
524 reads
24 Horas de PASS em Português – Edição 2014
Este ano (2014) a 3ª edição do “24 Horas de PASS” em Português será realizada nos dias 7 e 8...
2014-09-05
99 reads
4 Attitudes I Wish I Had Earlier as a DBA
I was tagged by Mike Walsh (blog | twitter) in his post 4 Attitudes I Wish I Had Earlier As a...
2014-09-05 (first published: 2014-08-28)
8,123 reads
Analysis Services Partitions
Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files....
2014-09-05
639 reads
Database Free Space Monitoring – The right way
Lately I spent some time evaluating some monitoring tools for SQL Server and one thing that struck me very negatively...
2014-09-05
457 reads
Four things I wish I’d known back then
In the blogging meme of the day, I was tagged by my friend Tim Costello to share four things I...
2014-09-05 (first published: 2014-08-28)
8,203 reads
Friday Followup For September 5, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-09-05
336 reads
Reblog: August 29 to September 4
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-09-05
734 reads
Silicon Valley is a different world
I spent the last couple days at Flowcon 2014, a conference that is bringing people together to talk about growing...
2014-09-05
783 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
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...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers