Day 20 of 31 Days of Disaster Recovery: The Case of the Backups That Wouldn’t Restore
I have decided to spend day 20 of my 31 Days of Disaster Recovery series by relating a true tale...
2013-01-25
1,140 reads
SQL Server Soldier :: News from the frontlines of the database wars
Day 19 of 31 Days of Disaster Recovery: How Much Log Can a Backup Log
It’s day 19 of my 31 Days of Disaster Recovery series, and today I want to talk about how much...
2013-01-24
1,196 reads
Day 18 of 31 Days of Disaster Recovery: How to CHECKDB Like a Boss
Day 18 of my 31 Days of Disaster Recovery series is drawing to a close. It’s 11:22 PM here, and...
2013-01-23
1,193 reads
Day 17 of 31 Days of Disaster Recovery: When are Checksums Written to a Page
Today is day 17 of 31 Days of Disaster Recovery. The series has skipped a couple of days due to...
2013-01-24 (first published: 2013-01-21)
1,855 reads
Day 16 of 31 Days of Disaster Recovery: Disaster Recovery Gems From Around The Net
It’s day 16 of my series 31 Days of Disaster Recovery. I’ve seen a lot of great DR related posts...
2013-01-18
916 reads
Day 15 of 31 Days of Disaster Recovery: Running DBCC CheckTable in Parallel Jobs
Welcome back to my 31 Days of Disaster Recovery series. Today is day 15, and I want to answer a...
2013-01-17
1,421 reads
Day 14 of 31 Days of Disaster Recovery: Fixing a Corrupt Tempdb
Welcome to day 14 of my 31 Days of Disaster Recovery series. I’ve previously discussed handling corruption for nonclustered indexes...
2013-01-16
2,238 reads
Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts
31 Days of Disaster Recovery
Today’s post took longer to prepare than I had anticipated which is why day 13...
2013-01-15
1,458 reads
Day 12 of 31 Days of Disaster Recovery: Extreme Disaster Recovery Training
31 Days of Disaster Recovery
Fittingly, today’s focus on disaster recovery as part of my 31 Days of Disaster Recovery...
2013-01-12
1,342 reads
Day 11 of 31 Days of Disaster: Converting LSN Formats
31 Days of Disaster Recovery
Welcome back to my series 31 Days of Disaster Recovery. Today is day 11, and...
2013-01-12
3,983 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