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 finally reached the final post, day 31. My final topic for the series is born out of a conversation I had today with my good friend and fellow DBA, Ed Watson (blog|@SQLGator). today, I want to talk about backing up and restoring the resource database. The resource database stores critical system objects safely separated away from the master database. It
read more

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 I’ve been working feverishly to finish today’s post before the calendar flips over to tomorrow. This started out as sharing a simple script I use for running DBCC CHECKDB against all databases on a server, and like I tend to do, I thought of lots of things I wanted to add to it. I spent a several hours customizing my
read more

Day 13 of 31 Days of Disaster Recovery: Standard Backup Scripts

Today’s post took longer to prepare than I had anticipated which is why day 13 is being published on day 14. This won’t derail the 31 Days of Disaster Recovery series, even if it runs over into February. Day 13’s topic is standard backup scripts. I’ve said on numerous occasions that the first thing a DBA should do when they inherit a new server is to make sure it has sufficient backups on it. Then later once everything is under
read more

T-SQL Tuesday #15: Database Mirroring Automation

T-SQL Tuesday #15: Database Mirroring Automation This blog entry is participating in T-SQL Tuesday #15, hosted this month by Pat Wright (Blog|@SqlAsylum). You are invited to visit his blog to join the blog party. You are welcome to write your own participating blog post for the party or just to read more blogs participating in this month’s theme: Automation. Automation is one of my favorite topics. For my part in this month’s T-SQL Tuesday, I am going to combine it
read more

Come See Me at the SQL PASS Summit

Come See Me at the SQL PASS Summit Notifications went out today for the SQL PASS Summit (Nov. 8 – 11, 2010) regular session abstracts. After many hours spent deliberating and reviewing abstracts, they sent out notifications to everyone letting us know if our abstracts were selected or not. I submitted 2 abstracts and 1 was selected. I will be presenting on Automating SQL Buildouts with Hyper-V and SQL Server R2. If you attend this session, I highly recommend reading
read more

Measuring Transactional Replication Latency Without Tracer Tokens

Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for programmatically measuring replication latency in transactional replication. To measure latency with a tracer token, you simply insert a tracer token at the publisher. The replication process will trace the token as it moves through the steps of the process and report back how long it took for the token to reach the distributor and the subscriber. Sounds great,
read more

SQLSaturday 26 Session Files

SQLSaturday 26 Session Files: 10/3/2009 in Redmond, WA Thanks to everyone that attended my sessions at SQLSaturday 26 in Redmond, WA on 10/3!! This was my first SQLSaturday event. I was granted the opportunity to be a last minute replacement speaker and gave two presentations. This was my first time speaking in front of a large audience at an event. It was a thoroughly enjoyable experience, and I hope to speak at future events as well. As promised in my
read more