Monthly Archives: November 2013

  1. Finding active DTS packages


    November 27, 2013 by Kenneth Fisher

    DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS …
    Continue reading

  2. Finding the metadata for a query


    November 25, 2013 by Kenneth Fisher

    You know I occasionally find it interesting how I learn new things. I was running through a practice test for …
    Continue reading

  3. A pattern to do beginning of period calculations.

    Leave a comment

    November 20, 2013 by Kenneth Fisher

    Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning …
    Continue reading

  4. Connection options in SSMS


    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

  5. Who’s on call


    November 13, 2013 by Kenneth Fisher

    Every morning we have a daily meeting and my manager asks who’s on call. And every morning some form of …
    Continue reading

  6. A better way to find missing indexes


    November 11, 2013 by Kenneth Fisher

    I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
    Continue reading

  7. Physical Join Operators by Ami Levin

    Leave a comment

    November 6, 2013 by Kenneth Fisher

    For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these …
    Continue reading

  8. sp_SrvPermissions & sp_DBPermissions V3.0

    Leave a comment

    November 4, 2013 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

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

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013