Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: February 2012

Why We Follow Best Practices

Why We Follow Best Practices

Best Practices


There are many reasons why we follow best practices. My own reasons have changed over the course of my career. Early in my career as a database developer and then later as a new DBA, I followed best practices because people who claimed… Read more

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 (Redmond, WA) Session Files

SQL Saturday 108 Replication Magic

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…

Read more

[Shameless Plug] Can We Have Your Vote?

[Shameless Plug] Can We Have Your Vote?

SQL PASS SQLRally

Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL Rally 2012 in Dallas, TX called “Demystifying Database Administration Best Practices”. We think it’s going to be an epic session with just loads and loads… Read more