T-SQL Tuesday #45 – Who’s Auditing My SSIS Packages?
It’s time once again for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday #45 is...
2013-08-13
867 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
DBCC CHECKDB … Terminated Abnormally Due to Error State 6
I recently encountered a DBCC CHECKDB failure with a fairly non-specific failure message. The error message said it terminated abnormally...
2013-07-24
7,228 reads
Looking for Buried Treasure in the Transaction Log
Lately, I’ve been finding more and more reasons to look in the transaction log for investigative purposes. Questions come up...
2013-05-27
1,202 reads
Bug: sys.dm_db_session_space_usage Reporting Extremely High Tempdb Allocations
A little more than a year ago while working at Idera, I was consulted on reports from a few clients...
2013-05-21
1,222 reads
T-SQL Tuesday #41 – Presenting Comes Full Circle and I Love It!
It’s time for that monthly geek party again we like to call T-SQL Tuesday. T-SQL Tuesday is one of the...
2013-04-09
1,152 reads
Day 31 of 31 Days of Disaster Recovery: Backup and Restore of the Resource Database
It has been a long journey to the final day my 31 Days of Disaster Recovery series, but we have...
2013-03-28 (first published: 2013-03-25)
2,426 reads
Network Packet Size: to Fiddle With or Not to Fiddle With
A network pipeline isn’t nearly as pleasant to look at as the oil pipeline (or anything) in Alaska, but it’s...
2013-03-27
3,271 reads
Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database
It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with...
2013-03-12
1,342 reads
The Saddest Thing I Ever Heard a Manager Say
I am currently going through the process of looking for a new opportunity for my career. I’m going through the...
2013-03-08 (first published: 2013-03-01)
6,043 reads
Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test
For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from...
2013-02-25
1,344 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers