Toronto PASS

EventDisplay

Next Meeting

Tuesday,

January

12

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.

Featured Presentation:

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.

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.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids