SQL Saturday 108 (Redmond, WA) Session Files Session files are now available for download. The zip file contains the PowerPoint slide deck and demo code. Zip file: ReplicationMagic.zip (5.2 KB) Included files: Demo: Initializing replication from a log backup InitializeFromLogPub.sql InitializeFromLogSub.sql Demo: Initializing replication from a filegroup backup using named filegroups FGByNameBackup.sql FGByNameRestore.sql Demo: Initializing…
| News From the Frontlines |  |
Tag Archive: Replication
Undocumented Gotchas of Transactional Replication
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…
(2 votes, average: 4.00 out of 5)
Loading ...SQL PASS Summit 2011: Session Files
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…
(1 votes, average: 5.00 out of 5) Loading ...Session Files for Replication Magic Presentation to WSSUG
Session Files for Replication Magic Presentation to WSSUG I presented my session on Replication Magic: Initializing from Backup to the Wichita SQL Server User Group last night. I took a little longer to post my session files so I could add comments to the SQL scripts. Session files are below. Powerpoint silde deck: ReplicationMagic.pptx (1.27…
(2 votes, average: 5.00 out of 5) Loading ...3 Log Shipping Techniques
3 Log Shipping Techniques My new article for SQL Server Magazine titled 3 Log Shipping Techniques has been posted online and will appear in an upcoming print issue. This article is a look at some very interesting techniques that use log shipping in interesting ways. Mastering these tehcniques can save you a great deal of…
(1 votes, average: 5.00 out of 5) Loading ...Counting Unreplicated Commands and Transactions
Counting Unreplicated Commands and Transactions Someone asked me a question via Twitter today that I couldn’t possible answer 40 characters at a time. The question was about how to get the count of unreplicated transactions and commands from teh distribution server without using system views. Well, I do use one system view, but only because…
(3 votes, average: 5.00 out of 5) Loading ...SQL Server 2008 SP1 Too Old for Replication?
SQL Server 2008 SP1 To Old for Replication? We are in the middle of a platform upgrade project at work, and I was setting up replication on a newly flattened and rebuilt server with Windows Server 2008 R2 and SQL Server 2008 SP1. I remoted into the publisher server to set up replication. When I…
(1 votes, average: 5.00 out of 5) Loading ...Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you’ve ever had to deal with errors in Replication Monitor, your first experiences with it probably involved confusion. Sometimes the error messages are too generic and do not help you find a resolution. Replication Monitor also tells you the command that failed. This clears up everything,…
(No Ratings Yet) Loading ...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…
(No Ratings Yet) Loading ...-
My SQL Server Magazine Articles
- Database Mirroring for Disaster Recovery September 16, 2011
- Comparative Review: Database Schema Comparison Tools August 24, 2011
- 3 Log Shipping Techniques June 22, 2011
- Hardening SQL Server June 20, 2011
- Review: ScriptLogic Security Explorer for SQL Server February 8, 2011
-
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS