Does a missing data file send a database suspect?
Short answer: No
I keep seeing this come up on various forums when people ask what makes a database go suspect...
2010-06-29
2,035 reads
Blog Posts
Getting Drive Info Part 1, sp_OA
This blog series will cover several different methods to collect drive information from a Windows server that is running SQL...
2010-06-29
2,641 reads
Manage Reporting Services using SSMS
Sometimes you’ll want to manage reporting services functionality through SQL Server Management Studio (SSMS). This would be the case if...
2010-06-29
2,330 reads
Partition Alignment and Late Night Infomericals
Late night infomercials make some amazing claims. “If you order now you too can cut through a cinderblock wall and...
2010-06-29
1,507 reads
SQL Saturday #28 (Baton Rouge) – All about User Groups
This year at SQL Saturday #28 we will be featuring a User Group Booth alongside the Sponsor booths. The User Group...
2010-06-29
1,566 reads
SQL Server Instance Checklist
This is my third in a series of checklists that I am putting together for a new book designed for...
2010-06-29
2,958 reads
The Breakfast Plan Goes Awry
Here’s the editorial for SSC today and while it’s a humorous story about asking for donuts and getting a free...
2010-06-29
1,424 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,137 reads
AWOL: DBA Turned Gardener Temporarily, but Still Obsessed with Transaction Log Files
After 10 Years, a Move Closer to School and Work
Wow, how moving house interrupts life. I can appreciate we have...
2010-06-28
512 reads
2010-06-28
676 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers