Next Meeting

Next Meeting: Tue, Jan 12 2016

Toronto SQL Server / Data Platform User Group January Meeting

Please register (RSVP http://www.meetup.com/Toronto-SQL-Server-User-Group/) if you will be attending and let us know if you have registered but cannot join.  While we won't turn you away if you show up with out registering, we need this information to determine room set up and food orders. Help us by registering.

Something Stinks: Avoiding Parameter Sniffing Issues & Writing Consistently Fast SQL 
Michael Swart

Some of the most painful database problems involve queries that have inconsistent performance. These queries can run fast on your dev box, but not in QA. These queries can be fast in the morning, but not in the afternoon. I take an in-depth look at the causes of this variable performance. How to recognize such queries at development time and what you can do about it. When we're done, developers who write SQL will have a solid set of tools to help write consistent, predictably fast SQL.

Bio

Michael J Swart is a passionate database professional and blogger. Specializing in SQL Server he has been awarded Microsoft's MVP for the past four years. He enjoys working for a private company in Kitchener, Ontario. 

Sponsor (NEW!)

Dudas BI logo
We have a NEW sponsor for our meeting, Dundas Data Visualization (Dundas.com).  John Wood will be starting our meeting just after the networking and pizza, with a presentation about their BI solutions.  Please take 30 seconds to fill out this audience survey https://www.surveymonkey.com/r/WXGNJG7 so that he make the best use of your time.  Also, he will be bringing prizes to do a draw, so bring your business cards for that draw.

Agenda

5:30-6:00 PM Pizza and Networking

6:00 PM -7:45 PM Presentation

8:00 PM - ??? Option to head to local pub for more discussions

Important Info

Registration for our meeting is used as the skills testing question for our prize draws.  It's also important for our getting food and drink orders correct.  Please register and also let us know if you can't make it.  

Parking is available across the street from the meeting location

Next Meeting

We are finalizing the date, which will likely be in February.  The topic will be career/professional development in the SQL / Data Platform specialization.

When

iCal
UTC : Tue, Jan 12 2016 22:30 - 01:00
Event Time : Tue, Jan 12 2016 17:30 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Tue, Jan 12 2016 22:30 - 01:00

Featured Presentation

Something Stinks: Avoiding Parameter Sniffing Issues & Writing Consistently Fast SQL

Speaker: Michael Swart

Summary: Some of the most painful database problems involve queries that have inconsistent performance. These queries can run fast on your dev box, but not in QA. These queries can be fast in the morning, but not in the afternoon. I take an in-depth look at the causes of this variable performance. How to recognize such queries at development time and what you can do about it. When we're done, developers who write SQL will have a solid set of tools to help write consistent, predictably fast SQL.

About Michael: Michael J Swart is an active blogger and SQL Server MVP since 2012. He works as a database developer in Kitchener, Ontario, Canada.

Please ensure you pre-register for our meetings. Registration allows you to participate in our awesome drawings and helps us plan for the meetings.
cage-aids
cage-aids
cage-aids
cage-aids