Category Archives: Settings

  1. Database default locations


    September 29, 2014 by Kenneth Fisher

    One of the options you had when installing your instance was setting some default file locations. Defaut data file location …
    Continue reading

  2. Changing configuration settings with sp_configure


    September 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

  3. What are trace flags?

    Leave a comment

    September 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

  4. Pausing an MSSQL Instance


    September 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

  5. Default nullability of a new column

    Leave a comment

    March 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

  6. Connection options in SSMS

    Leave a comment

    November 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

  7. How do the fixed Database and Server roles map to more specific permissions?

    Leave a comment

    September 9, 2013 by Kenneth Fisher

    I recently asked what the difference is between granting SELECT to a user (at a database level) and adding the …
    Continue reading

  8. Amusing SQL Trick – Hide yourself from SQL Server

    Leave a comment

    July 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

  9. What port is my instance listening on?


    January 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

  10. I can connect to my instance locally but not remotely

    Leave a comment

    October 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


Get every new post delivered to your Inbox.

Join 651 other followers