Monthly Archives: July 2013

  1. Using DTEXECUI to generate a DTEXEC command line statement the easy way

    8

    July 31, 2013 by Kenneth Fisher

    SSIS is one of those tools that I love and hate at the same time. It’s a great ETL tool …
    Continue reading

  2. Notes on debugging Database Mail problems

    6

    July 29, 2013 by Kenneth Fisher

    I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
    Continue reading

  3. I’m going to my first SQL Saturday!

    Leave a comment

    July 24, 2013 by Kenneth Fisher

    I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused …
    Continue reading

  4. Generic Dynamic SQL Stored Procedure

    4

    July 22, 2013 by Kenneth Fisher

    Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
    Continue reading

  5. Amusing SQL Trick – Hide yourself from SQL Server

    1

    July 17, 2013 by Kenneth Fisher

    I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead …
    Continue reading

  6. Scripting a partitioned table or index, a caution.

    14

    July 15, 2013 by Kenneth Fisher

    I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
    Continue reading

  7. Ordering steps in a SQL Agent job

    2

    July 8, 2013 by Kenneth Fisher

    Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is …
    Continue reading

  8. Writing Dynamic SQL (A how to)

    3

    July 1, 2013 by Kenneth Fisher

    A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
    Continue reading

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

Join 1,627 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013