Welcome to the St. Louis SQL Server User Group (STLSSUG)   

Join Our Group Online!
http://groups.yahoo.com/group/stlssug

PASS Summit 2016 Seattle, WA  October 24-28

Pass Conference Discount Code!

Use the Discount Code: LC15MTQ9  when you register for the PASS Conference and receive $150 off the conference fee!   This is a unique code which will give the STLSSUG & BI User Groups credit for your attendance.

 

Next Meeting

Tuesday,

September

13

STLSSUG September 13, 2016 Meeting

  • In-Person @ Three City Place Drive, Suite 1100 St. Louis, Missouri, United States (map)
  • 13:00 - 16:00 Central Daylight Time
  • Language: English

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, 
https://www.eventbrite.com/e/stlssug-september-13th-meeting-tickets-27095662857

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

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.


Email: Erin@SQLskills.com  
Website: http://www.SQLskills.com  
Full Bio: http://www.sqlskills.com/about/erin-stellato/  
Blog: http://www.SQLskills.com/blogs/Erin  
Twitter: http://twitter.com/ErinStellato  
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.