We are please to announce that INETA Speaker, Kathleen Dollard will be joining us for the February meeting. Join us and explore different ways to create stored procedures for general/complex SQL scripting tasks.
Have you ever wanted to generate stored procedures on the fly using the underlying metadata/catalog vews? How about a simple insert, update, delete stored procedure for every fact table in a Data Warehouse? Well, you are closer than you think to finding a solution!!! Code Generation….
Date: Tuesday, February 19th
Time: 6pm(Networking/Refreshments), 6:30pm-8:30pm(Presentation)
Topic: SQL Server Stored Procedure Code Generation in 2008
Presenter: Kathleen Dollard
Kathleen Dollard is a consultant, author, trainer, and speaker. She’s been a Microsoft MVP since 1998, wrote “Code Generation in Microsoft .NET” (Apress) and is a regular contributor to Visual Studio Magazine. She speaks at industry conferences such as VSLive, DevConnections, and Microsoft DevDays as well as local user groups. She’s the founder and principal of GenDotNet. Her passion is helping programmers be smarter in how they develop by learning to use Visual Studio, XML related technologies, .NET languages, code generation, unit testing, and other tools to their full capacity. She’s currently working on full life cycle improvements, such as better debugging and capturing business intent in metadata and test definitions. When not working, she enjoys woodworking, snowshoeing, and kayaking depending on the outdoor temperature.
Code generation allows you to output any code – including TSQL. You’ll see how generation combines metadata with templates to produce the code you need. Metadata comes primarily from the database structure, but you can also enrich it with more detail such as the mapping to business objects. You’ll see how a harness can coordinate generation activities extracting metadata, building scripts, and loading scripts with a single button click. While code generation has been around for decades, .NET 3.0 and 3.5 offer significant new opportunities in terms of templates and the code generation the harness process. You’ll see new approaches to templates that work well when creating complex templates and leave ready to incorporate code generation into your own development when and where it’s appropriate.