Monthly Archives: July 2013
-
Using DTEXECUI to generate a DTEXEC command line statement the easy way
6July 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 -
Notes on debugging Database Mail problems
4July 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 -
I’m going to my first SQL Saturday!
Leave a commentJuly 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 -
Generic Dynamic SQL Stored Procedure
4July 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 -
Amusing SQL Trick – Hide yourself from SQL Server
Leave a commentJuly 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 -
Scripting a partitioned table or index, a caution.
13July 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 -
Ordering steps in a SQL Agent job
2July 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 -
Writing Dynamic SQL (A how to)
2July 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
