addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

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

  • Jan 9, 2013 · 6:30 PM
  • Microsoft Office

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 code. 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:

  • 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.

Join or login to comment.

  • Joel S.

    I am working on leveraging the Microsoft BI SQL stack on SharePoint 2013. I think SQL 2012 Reporting servers (SharePoint 2013 PowerView) is a good alternative to Tableau. I think this will be a great data visualization tool that is entirely intergrated with Microsoft Office 2013. I am looking to see who is working with this technology and what challenges each person has faced respectively.

    November 26, 2012

Our Sponsors

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy