Category Archives: SQLServerPedia Syndication

  1. Intro to Auditing in SQL Server on SQL Shack

    Leave a comment

    October 1, 2014 by Kenneth Fisher

    I had an article published yesterday on http://www.SQLShack.com. Intro to Auditing in SQL Server. It’s worth reading if I do …
    Continue reading

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

  3. Changing configuration settings with sp_configure

    2

    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!

    8

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

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

  7. Pausing an MSSQL Instance

    9

    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

  8. Two simple commands that can be a big help in performance tuning.

    5

    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

  9. Finding a job!

    2

    August 27, 2014 by Kenneth Fisher

    I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years …
    Continue reading

  10. The amazing never shrinking heap

    Leave a comment

    August 25, 2014 by Kenneth Fisher

    This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 401 other followers