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

Archives: April 2013

Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS


As part of any SQL SERVER install that I do, I turn on Remote admin connections (using sp_configure) and open the relevant firewall port – normally 1433 for a default instance – Although this can be altered

As we know, you can open a dedicated administrated connection using… Read more

0 comments, 5,065 reads

Posted in measure twice, cut once. on 7 April 2013

Multiple ALTER DATABASE SET options


Did you know that you can actually combine multiple SET operations into a single ALTER DATABASE statement.

It’s true, you can!

Mostly I never see this done.

Maybe it doesn’t make sense! maybe it’s just more readable if a single ALTER DATABASE statement contains a single SET operation!… Read more

0 comments, 3,345 reads

Posted in measure twice, cut once. on 6 April 2013