Tag Archives: microsoft sql server

  1. Playing with the log – Before the first full backup

    Leave a comment

    October 29, 2014 by Kenneth Fisher

    The log file tends to fascinate me. In fact one of my favorite posts is where I looked into the …
    Continue reading

  2. A script to list the DTS connection information for every package on the instance.

    Leave a comment

    October 27, 2014 by Kenneth Fisher

    For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the …
    Continue reading

  3. Force only certain values to be unique

    1

    October 22, 2014 by Kenneth Fisher

    I thought of something rather interesting the other day while answering a question asking for help with some table structures. …
    Continue reading

  4. Update to “The clustered index columns are in all of the non clustered indexes.”

    2

    October 20, 2014 by Kenneth Fisher

    I certainly hadn’t planned on creating a part two of my post on clustered index columns but in the comments …
    Continue reading

  5. Required reading before upgrading SQL Server.

    3

    October 8, 2014 by Kenneth Fisher

    I was watching a great presentation by Brent Ozar(b/t) on why to move to SQL 2014 and in the Q …
    Continue reading

  6. You can’t use aggregate/windowing functions with CROSS APPLY

    7

    October 6, 2014 by Kenneth Fisher

    One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well …
    Continue reading

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

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

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

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

Follow

Get every new post delivered to your Inbox.

Join 428 other followers