Archives: April 2013
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
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