Tag Archives: Undocumented Stuff

Undocumented stored procedures, functions, etc.

Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database

March 11, 2013 11:18 pm / 2 Comments /

It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with quality topic ideas for the series as we near the end. For day 30 of the series, I am combining a post on performing piecemeal restores with a post on filegroups for T-SQL Tuesday #40 … Read More →

Posted in: SQL Server / Tagged: , , , , ,

Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC

January 27, 2013 4:29 pm / 3 Comments /
31 Days of Disaster Recovery

The end of the day is quickly approaching as I finish this blog post. This is day 22 in my series 31 Days of Disaster Recovery, and I want to examine which DBCC CHECK commands update the last known good DBCC check that is tracked in the header of the database. To check this value, … Read More →

Posted in: SQL Server / Tagged: , , ,

Day 21 of 31 Days of Disaster Recovery: Who Deleted That Data?

January 25, 2013 9:08 pm / 1 Comment /
31 Days of Disaster Recovery

Welcome back for day 21 of my 31 Days of Disaster Recovery series. Today I want to talk about trying to track down who deleted data from a table. This little investigation started out as a question on the #sqlhelp hash tag on Twitter from Wayne Sheffield (blog|@DBAWayne) whom I first met on SQLCruise Alaska … Read More →

Posted in: SQL Server / Tagged: , ,

Day 19 of 31 Days of Disaster Recovery: How Much Log Can a Backup Log

January 23, 2013 10:01 pm / 5 Comments /
31 Days of Disaster Recovery

It’s day 19 of my 31 Days of Disaster Recovery series, and today I want to talk about how much log is in a backup file. A common misconception is that when you restore a backup, you get an exact copy of the database as it was when it was backed up. That’s mostly true, … Read More →

Posted in: SQL Server / Tagged: , , ,

Undocumented Gotchas of Transactional Replication

December 17, 2011 3:06 pm / 5 Comments /

Undocumented Gotchas of Transactional Replication This discussion started on Twitter via the #sqlhelp hash tag. The question that was asked is, “What are the undocumented gotchas of Transactional Replication? #SQLHelp”. I responded with several things that came to mind. I thought these would be good to capture in a blog post and hopefully others would … Read More →

Posted in: SQL Server / Tagged: , ,

SQL PASS Summit 2011: Session Files

October 17, 2011 7:06 am / Leave a Comment /

SQL PASS Summit 2011: Session Files This past week was the SQL PASS Summit 2011 in Seattle, WA. I presented three sessions (regular session, lightning talk, panel discussion) plus ran a focus group on advanced certification and hosted a Birds of a Feather lunch table on disaster recovery. It was a busy, busy week. Below … Read More →

Posted in: SQL Server / Tagged: , , , , , , , ,