Facility9

I finally put together my abstracts and submitted them to PASS for the 2009 Summit. If you want to speak, but haven’t submitted abstracts yet, you better hop to it.

I figured that I would go ahead and list my abstracts here so you can copy them, fix the typos, and submit them as your own.

A Dynamic World Demands Dynamic SQL

Dynamic SQL is a misunderstood and much maligned part of a DBA’s tool kit – it can be used to solve difficult business problems, respond to diverse data needs, and alleviate performance problems. Many DBAs reject dynamic SQL outright as a potential source of SQL injections, being poorly performing, or just for being a hacky solution in general. Not so!

Jeremiah Peschka has been making extensive use of dynamic SQL throughout his career to solve a variety of problems. He’ll set about dispelling these misconceptions and demonstrate how dynamic SQL can become a part of every DBA’s tool kit.

Session Goals

• Learn how to work effectively with diverse inputs.
• Learn how to avoid common pitfalls of dynamic SQL.
• Develop an understanding of real world uses for dynamic SQL.

Digits, Dates, and Databases

Calendar and number tables migh not help you get a date, but they can help you accomplish difficult tasks in the database while sticking true to your set-based roots. Nobody wants to admit that they’ve used a while loop in their SQL code, but there are ways to avoid looping constructs and use a set-based solution using a numbers table for loop control. Date manipulation can be cumbersome to peform, can create unwieldy and unreadable code, and can even create performance bottlenecks. Using a calendar table can alleviate these performance bottlenecks and make many calculations easy.

Session Goals

• Learn what number and calendar tables are.
• Learn how to effectively use a numbers table in set-based SQL.
• Learn how to work with a calendar table to remove the need for complex date manipulation.

What are you waiting for? Submit your sessions today!