Speed T-SQL with Macro Scripting, Templates, and More

Speaker: Eric Freeman of Esurance

Do you ever find yourself frustrated writing numerous queries? In this session you'll learn fairly simple methods for writing fast, reliable, and reusable T-SQL cohttp://photos4.meetupstatic.com/photos/event/d/0/2/c/event_190613292.jpegde. Find out how you can spend a little bit of time today and how it can save you a lot of time in the future. Eric will also go over methods that can be used to write faster T-SQL including macros, SQL Server templates, dynamic SQL, Excel, and even Notepad. This session is targeted for people who write a lot of T-SQL.

This presentation is demo heavy!

You'll learn:http://photos1.meetupstatic.com/photos/event/c/f/1/e/event_190613022.jpeg

How to write faster T-SQL What macro scripting is all about How simple SQL Server templates are to use How to leverage tools already available to you Eric Freeman works as a Senior Business Intelligence Analyst at Esurance, an Allstate Company. He has 10+ years of experience working on Microsoft SQL Server with an emphasis on Performance Tuning, ETL and Data Warehousing. He is President of the Sacramento SQL Server User Group, and holds an MCTS in Business Intelligence.