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
869 reads
SQL Server Soldier :: News from the frontlines of the database wars
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,235 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,207 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,225 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,153 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,275 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,430 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,347 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,047 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,365 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers