Table-Based Database Object Factories

Ever had to write a large number of similar or standardized stored procedures, audit triggers, archive tables, etc.? Let SQL Server do the work for you! With some custom functions, stored procedures and extended properties, this is no longer a chore. In this session we will see how to create table-based object factories that are capable of producing well-formatted stored procedures, triggers, audit tables or whatever you need them to produce. Whether initial creates or alters post schema changes, the manual drudgery can be removed!

During the session I will explain what automation is possible and demonstrate this working in practice. I will also show how this can be used in conjunction with DDL Triggers and SQL Server Database Tools to seamlessly fit into the development process.

I heard a phrase from Jen Stirrup recently, "If you have to do it twice, automate it.". Damn straight, I'm down with that and you should be too.
Presented by James Skipwith at SQLBits XI
Tags (no tags)
  • Downloads
  • SpeakerBIO
    James_Skipwith.jpg

    A former programmer, James to the dark side over thirteen years ago as he thought SQL Server would offer more of a challenge - and it did not disappoint! Through versions 7 to 2012 - with a side order of SQL Azure - he ave worked solidly with SQL Server. He also adores C# and BI but always find himself coming back to his first love, the database engine. Automation makes him smile and he is happiest when deep in the mire, under pressure, and with numerous seemingly impossible tasks to do in a hurry.

    He is currently juggling moving a major client’s in-house system over to an SaaS model utilising SQL Azure, EF5+, and MVC, as well as more traditional DBA, SSIS, and SSAS work. MCM. SSDT junkie.
    http://sqlpimp.com/
  • Video