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

Gavin Draper's SQL Server Blog

Software Dev/DBA living the dream in sunny Brighton, UK. I've been playing with SQL Server about nearly 20 years now and still feel just as clueless as I did back then. I love writing about things I find as I go along.

Archives: March 2014

Rails Continuous Testing

Coming from the .Net world where continuous testing is expensive on both the wallet and processing power seeing what Ruby has to offer in this area is pretty incredible.

You can pretty much bring in a few gems and have continuous testing with awesome notifications out of the box. For… Read more

0 comments, 26 reads

Posted in Gavin Draper's SQL Server Blog on 11 March 2014

Browser Based Web Notifications

3 of the 4 major browsers now support web notifications (Safari, Firefox, Chrome) and no where near enough sites are making use of this killer feature. One web app that does make good use of this is Gmail, if you’ve enabled it then it will show notifications when you get… Read more

0 comments, 26 reads

Posted in Gavin Draper's SQL Server Blog on 1 March 2014

Cloning a SQL Server Database

The following script will backup and restore a database to the same server with a different name. Tested on SQL 2012/2008. You just need to set the 4 variables at the top of the script to specify source and destination along with directories to store the backup and restored database… Read more

0 comments, 26 reads

Posted in Gavin Draper's SQL Server Blog on 1 March 2014