Subscribe to this blog
Day 17 of 31 Days of Disaster Recovery: When are Checksums Written to a Page
2 comments, 1,193 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 21 January 2013
Day 16 of 31 Days of Disaster Recovery: Disaster Recovery Gems From Around The Net
7 comments, 423 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 18 January 2013
Day 15 of 31 Days of Disaster Recovery: Running DBCC CheckTable in Parallel Jobs
3 comments, 495 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 17 January 2013
Day 14 of 31 Days of Disaster Recovery: Fixing a Corrupt Tempdb
5 comments, 562 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 16 January 2013
Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts
11 comments, 409 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 15 January 2013
Day 12 of 31 Days of Disaster Recovery: Extreme Disaster Recovery Training
7 comments, 419 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 January 2013
Day 11 of 31 Days of Disaster: Converting LSN Formats
5 comments, 464 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 12 January 2013
Day 10 of 31 Days of Disaster Recovery: Monitoring for Corruption Errors
7 comments, 445 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 11 January 2013
Day 9 of 31 Days of Disaster Recovery: Use All the Checksums
20 comments, 839 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 9 January 2013
Day 8 of 31 Days of Disaster Recovery (T-SQL Tuesday #38): Resolutions for All DBAs
7 comments, 486 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 8 January 2013
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recover
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recovery
Today is day 7 in my series on disaster recovery. I thought I would switch gears for today and write about disaster recovery Service-Level Agreements (SLAs). Specifically, I’m talking about Recovery Point… Read more13 comments, 612 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 8 January 2013
Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in Allocation Pages
Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in Allocation Pages
Yesterday, I covered corruption in nonclustered indexes, the easiest type of corruption to handle. Today, I’m going to move on to something slightly more complex, yet still really simple to… Read more14 comments, 530 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 6 January 2013
Day 5 of 31 Days of Disaster Recovery: Dealing With Corruption in a Nonclustered Index
The generic steps we will go through for any corruption scenario are… Read more
11 comments, 1,407 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 6 January 2013
Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
Here we are at day 4 in my series focusing on disaster recovery. It’s Friday, so this will be a quick one for today. I want to talk about the importance backing up… Read more
11 comments, 525 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 4 January 2013
Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database
Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database
Welcome back for day 3 of my month-long series on Disaster Recovery. For today’s post, I want to address something that, in my experience, has really flummoxed a lot of people who… Read more20 comments, 526 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 4 January 2013
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
Welcome to day 2 of my month-long series on Disaster Recovery. For today’s post, I want to talk a little bit about restoring backups of contained databases. In… Read more14 comments, 520 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 2 January 2013
SQLBits XI: Need Your Vote
SQLBits XI: Need Your Vote
SQLBits XI is in Nottingham, U.K., May 2 – 4, 2013, and I am attending. Hopefully, I will be presenting a regular session as well. To do that, I need your vote. The sessions are now open for public voting. Please go… Read more4 comments, 524 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 2 January 2013
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
Welcome to my series on Disaster Recovery. I will spend the entire month of January focusing on all things related to disaster recovery including topics like corruption, data integrity, data loss,… Read more20 comments, 1,256 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 1 January 2013
Tempdb Contention That Can’t be Soothed
Tempdb Contention That Can’t be Soothed By Adding Files
I’ve talked a lot in the past about tempdb contention and how to monitor for and identify it in blog posts, a whitepaper, webcasts, and live presentations. Okay, so I tend to… Read more
3 comments, 472 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 21 December 2012
Cross-database Queries by Contained Users
Cross-database Queries by Contained Users
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on the subject of contained databases. The slide deck and demo code from my presentation, Implementing Contained Databases, can be downloaded below or will be uploaded to the… Read more
0 comments, 491 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 14 December 2012