Speed T-SQL with Macro Scripting, Templates, and More
- January 9 · 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 co
de. 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.
-
Ron
Save an Extra 20% with Discount Code MEETUP: Jan 28 Global Big Data Conference Santa Clara Convention Center
35+ Speakers, 20+ very high quality SessionsRegister: http://globalbigdataconference....
Agenda: http://globalbigdataconference....
January 25
-
@KennethFax
Mark, Special thanks for organizing the event and inviting Eric of Esurance to speak. I apologize for leaving early, I was required to rush back to campus office to meet with visit scholars last night.
So, I am still awake. :)!It would be great, if I could get a copy of Eric's presentation. I was already familiar with the first tools used, based on my experience. Ideally, I would like to see the coverage on SQL Templates. - Email is [masked]
Thanks again.
Sincere regards,
Kenneth FaxJanuary 10
-
-
Eric Freeman
Hi Kenneth, I'll do better than that. I'll get you the slides and template examples from the keynote specifically on templates that I referenced durring my session.
January 11
-
-
Joel Saldana
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
People in thisMeetup are also in:
-
-
San Francisco Bay Area Azure Developers
600 Azure Developers
-
-
Mobile Internet Forum - Cloud HTML5 Android iOS WP
1,203 Mobile Developers
Next Meetup:
Wednesday, Jun 05 -
-
Join or login to comment.