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

SQLSailor.com

Anup SivaDas handles the Database Engineering initiatives for Expedia, Inc. (http://www.expedia.com/), having IT experience of more than 9 years. Anup is an active blogger with SQLSailor.com, and can also be found on MSDN SQLServer forums and BeyondRelational.com. He has handled multiple SQLServer projects for various fortune 500 companies, and gained enrich proficiency within Database Administration, Database Architecture for Cloud, Consulting, Virtualization, Build, and Production Support activities. Blog | Twitter | LinkedIn

Archives: October 2012

PASS Summit 2012 Countdown Begins !!!

All roads lead to Seattle!

If you are a SQLServer professional, then you don’t want to miss this event.

Over 190 technical sessions, 2 days of pre-conf sessions with in-depth learning opportunities, networking with MVPs/Microsoft CSS/SQLCAT members! This is what PASS Summit is all about, and the great news is… Read more

3 comments, 499 reads

Posted in SQLSailor.com on 23 October 2012

Tale of detaching a database which was enabled for replication!

In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.

Almost all the time when I detached a database earlier the feeling was like something which I mentioned before “Simple, fast and easy”, however today it was more sort of a… Read more

0 comments, 807 reads

Posted in SQLSailor.com on 4 October 2012

Backing up the “log” of a database which is in Simple recovery model ! – Watch out for this!

In theory we cannot backup the log of a database which is in Simple recovery model, however there is a small bug in SQL 2012 which allows you to do this, and you need to be very careful about this.

Below is the detailed repro steps for this issue and… Read more

2 comments, 522 reads

Posted in SQLSailor.com on 1 October 2012