Category Archives: Settings
-
Changing configuration settings with sp_configure
5September 22, 2014 by Kenneth Fisher
I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
Continue reading -
What are trace flags?
3September 11, 2014 by Kenneth Fisher
Trace flags are one of those things that I’ve heard about more and more over the last five or six …
Continue reading -
Pausing an MSSQL Instance
10September 4, 2014 by Kenneth Fisher
I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop …
Continue reading -
Default nullability of a new column
Leave a commentMarch 31, 2014 by Kenneth Fisher
Ever assume that when you don’t specify NULL or NOT NULL on a new column it’s going to allow NULLs? …
Continue reading -
Connection options in SSMS
2November 18, 2013 by Kenneth Fisher
When connecting to a SQL Server instance in SSMS there are a fair number of options. Most DBAs I know …
Continue reading -
Amusing SQL Trick – Hide yourself from SQL Server
1July 17, 2013 by Kenneth Fisher
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
Continue reading -
What port is my instance listening on?
8January 8, 2013 by Kenneth Fisher
I just had the interesting task of finding the port number that one of the instances I deal with is …
Continue reading -
I can connect to my instance locally but not remotely
4October 23, 2012 by Kenneth Fisher
Every now and again (today for example) I’ll get a call that one of our SQL Server instances is down. …
Continue reading -
DBMail on a cluster
Leave a commentSeptember 26, 2012 by Kenneth Fisher
I’ve always found clusters a pain in the neck. For my latest pain I just spent the last 2 days …
Continue reading
SQL Studies 