James Skipwith
James is a Microsoft Certified Master of SQL Server, developer, and automation junkie He loves nothing more than making things that are large, fast, and low maintenance.
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!
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!