Category Archives: Settings

  1. 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

  2. Pausing an MSSQL Instance

    7

    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

  3. 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

  4. 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

  5. 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

  6. 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

  7. What port is my instance listening on?

    6

    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

  8. 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

  9. DBMail on a cluster

    Leave a comment

    September 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

  10. Funny results from OPTIMIZE FOR AD HOC WORKLOADS

    2

    September 18, 2012 by Kenneth Fisher

    I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers.  When I …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 372 other followers