Browse by Tags

• backup
• disaster recovery
• errors
• flow control
• log
• T-SQL Tuesday

• T-SQL Tuesday #31: Paradox of the Sawtooth Log

  Today’s T-SQL Tuesday, hosted by Aaron Nelson ( @sqlvariant | sqlvariant.com ) has the theme Logging . I was a little pressed for time today to pull this post together, so this will be short and sweet. For a long time, I wondered why and how a database Read More... Posted Tuesday, June 12, 2012 1:10 AM by merrillaldrich | 0 Comments Filed under: log, transactions, T-SQL Tuesday

• Pop Quiz: Restore a Database to the Point in Time when a Full Backup Started?

  Recently we've had to interview some SQL Server DBA candidates for our team, and we were looking for the type of open-ended technical questions that would draw out interviewees and let us get a sense of their thought process. A surprisingly simple question Read More... Posted Monday, November 01, 2010 12:26 PM by merrillaldrich | 6 Comments Filed under: backup, disaster recovery, transactions

• Flow control in T-SQL Scripts

  When many people, including me, began their early T-SQL efforts, the magic two letter GO statement was a bit mysterious. What was that for? Was it just decoration sprinkled through your scripts? What’s the difference when two SQL statements are separated Read More... Posted Friday, July 24, 2009 9:17 AM by merrillaldrich | 15 Comments Filed under: errors, flow control, transactions