SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Tech Review

I got asked by someone to technically review their SQL Server 2005 book, so I'm betting that there will be lots of opportunties to learn a few things as I test code and work with the June CTP in the near future.

I also learned a few things with the September magazine, which focuses on High Availability in SQL Server. Database snapshots, which are incredibly easy to use to recover your db to a point in time, are one article. There's also mirroring, clustering, and partitioning in there.

The snapshot thing is interesting. It makes a copy of changed pages only, so queries against tables that haven't changed since the snapshot was created run against the original database. Not such a good idea for large tables to use this as a development environment. James Lukehoelter wrote the article and one of his suggestions was to combine mirroring on another server and then running a snapshot off of that. An interesting unique solution.

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest


No comments.

Leave a Comment

Please register or log in to leave a comment.