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,145 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,201 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,198 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,861 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
922 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,430 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,246 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,468 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,349 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
4,041 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers