Monthly Archives: September 2014

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

  2. What I know about batch files

    23

    September 24, 2014 by Kenneth Fisher

    For a SQL Server guy it sometimes amazes me how often I’m in and out of batch files and how …
    Continue reading

  3. Changing configuration settings with sp_configure

    5

    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

  4. Triggers are not toys!

    9

    September 17, 2014 by Kenneth Fisher

    For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL …
    Continue reading

  5. I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

    1

    September 15, 2014 by Kenneth Fisher

    Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this …
    Continue reading

  6. What are trace flags?

    1

    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

  7. T-SQL Tuesday #58: Passwords

    2

    September 9, 2014 by Kenneth Fisher

    It’s that time again. The second Tuesday of each month we have a blog party called T-SQL Tuesday. The host …
    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. Two simple commands that can be a big help in performance tuning.

    6

    September 2, 2014 by Kenneth Fisher

    The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013