Category Archives: Settings

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

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

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

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

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

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

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

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

  9. At Startup SSMS setting

    1

    August 26, 2012 by Kenneth Fisher

    I came across this handy dandy little setting earlier this year.  It was well hidden from me, by which I …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 173 other followers