Category Archives: Settings

  1. Multiple Windows Groups with different default databases

    Leave a comment

    May 28, 2015 by Kenneth Fisher

    A question came up at work the other day, mostly as a mind game, but you never know it might …
    Continue reading

  2. Default database

    Leave a comment

    May 26, 2015 by Kenneth Fisher

    What? The default database is one of the options when creating a login in SQL Server. This is the initial …
    Continue reading

  3. Port numbers and SQL Server

    Leave a comment

    March 30, 2015 by Kenneth Fisher

    I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are …
    Continue reading

  4. Why not NOLOCK?

    4

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  5. Database default locations

    4

    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

  6. Changing configuration settings with sp_configure

    3

    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

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

  8. Pausing an MSSQL Instance

    10

    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

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

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

Follow

Get every new post delivered to your Inbox.

Join 768 other followers