St. Louis SQL Server User Group Meeting
September 13, 1:00 pm- 4:00 pm cdt
The next St. Louis SQL Server User Group meeting will be on September 13th from 1:00 pm – 4:00 pm.
Please RSVP, so that we can have a count for a lunch order,
Also, please feel free to forward this meeting announcement to anyone who may be interested in attending.
This will also be a broadcasted meeting. Link will soon be provided
Location: Microsoft St. Louis Office, Three City Place Drive, Suite 1100, St. Louis, MO 63141. Parking is in the garage behind / next to the building. There is an entrance to the building from the 2nd floor in the garage.
12:30 – 1:00 Registration - Lunch Provided by The Timberline Group www.timberlinegrp.com
1:00 Erin Stellato, SQL Skills – Kicking and Screaming: Replacing Profiler with Extended Events www.sqlskills.com
2:30 Dan Guzman, Service Broker Applied
4:00 Raffle Drawing – Apress, Wrox, McGraw-Hill, Murach, Wiley, O'Reilly, MS Publishing Books and more!
Erin Stellato, SQLskills Principal Consultant
Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.
Full Bio: http://www.sqlskills.com/about/erin-stellato/
SQL Server MVP since 2012
Abstract: – Kicking and Screaming: Replacing Profiler with Extended Events
There have been three new releases of SQL Server since the introduction of Extended Events in SQL Server 2008, and DBAs and developers alike *still* prefer Profiler. Friends, it's time to move on. If you've tried Extended Events and struggled, or if you've been thinking about it but just aren't sure where to begin, then come to this session. Using your existing knowledge and experience, we bridge the gap between Profiler and Extended Events through a series of demos, starting with the Profiler UI you know and love, and ending with an understanding of how to leverage functionality in the Extended Events UI for data analysis. By the end of this session, you’ll know how to use Extended Events in place of Profiler to continue the tasks you've been doing for years--and more. Whether you attend kicking and screaming, with resignation because you’ve finally given up, or with boundless enthusiasm for Extended Events, you'll learn practical techniques you can put to use immediately..
Dan Guzman is a IT professional with over 30 years of database administration and development experience, specializing in SQL Server since version 4.21 was introduced on the Windows platform. Dan is an active SQL Server community member, an officer in the St. Louis area SQL Server User Group, and has been a Microsoft SQL Server MVP since 2001
Abstract: Service Broker Applied
Service Broker provides messaging and queuing infrastructure to support Database Mail, Query Notifications, and custom applications leveraging Service Broker features. This session will review Service Broker architecture, objects and design patterns for developing robust Service Broker applications, including live demos implemented in both application code and T-SQL.