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
920 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
525 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
640 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,204 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
337 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
784 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers