SQLBits 2015

Metadata Driven Automation: A Primer

Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved.
Need to automate a process in your database? Create audit tables, generate stored procedures, or any other type of manually repeatable process? In this session we'll look at how to start and the thought processes and design considerations involved. From initial idea to fully-functional solution, metadata can be used to drive processes and object creation and maintenance in your database. It does however need to be designed right to avoid pain in the future.

Whether you want to create simple audit tables or build a whole ETL solution is immaterial, you need to start the project right and make it bulletproof. This is more a session on the thought process involved in designing such a solution but will have an example we will work through during the session. A small amount of work and planning at the start will save you days in the future, so let’s get on with it!