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

Archives: April 2013

Dedicated Admin Connections (DAC) and SQL SERVER 2012 SSMS

G’day,

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, 2,095 reads

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

Multiple ALTER DATABASE SET options

G’day,

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, 926 reads

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