PSSUG Meeting November 11, 2009 Code Samples

Thanks to Vince Napoli and the folks of the Philadelphia SQL Server User group for inviting me to present the Advanced Workflow Processes in T-SQL session.  There was a good turnout including a few friends and colleagues who came out in support, which was appreciated.

This post contains links to the sample code and previous posts on the techniques of dynamic SQL execution as promised.

Exec vs sp_execute SQL {Journal Entry}

http://www.pocketjoshua.com/sql-journal/2009/10/18/exec-vs-sp_execute-sql.html
An exploration of the syntax and capabilities of dynamic T-SQL execution.
Source code as file

The Life & Times of a SQL Temp Table {Journal Entry}

http://www.pocketjoshua.com/sql-journal/2009/10/18/the-life-amp-times-of-a-sql-temp-table.html
This one is not very interesting but does show what can be done with the scope of temp tables and dynamic execution.

 

Simple Workflow Sample code {File}

Unzip the file and follow the files in numerical order. Read the comments to find out what's interesting about each file.
Source code as file

DQSM – Data Quality Status Monitoring {File}

The zip file contains the source code and sample files for demonstration.  Inside the main directory there are files with numbers leading the file name.  Execute these in order.  Some of them you just need to execute and move on.  The others you should spend some time in and look at the code and the output.  If you dig into the code, provided in the subdirectories, you will be able to explore the solution.

Most of the code can be used on any db.  Only the specific UDF and test Sprocs designed for AdventureWorks tables are not generic.  They serve as an example of what to do in you environment.

There are a few other little goodies in there to explore and play with but they are not critical to the presentation.
Source code as file

Comments

[Douglas Osborne]

Joshua,

Great presentation - I learned a lot.

When is your next one?

Carpe Datum,
Doug

[Bob Blackburn]

Thank you for the presentation. I will review the code and give it a try.

Bob