Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.

Adelaide SQL Server User Group

 

Welcome to the Adelaide SQLPASS chapter. You can find us on the 3rd Wednesday of the month, at the Microsoft offices, Level 12, 147 Pirie St.

There's a link below to get on the mailing list.

We use EventBrite for meeting registrations - please look at adssug.eventbrite.com for a list of our meetings.

Previously, we used sqlserver.org.au, and you can see an archive of events on that site - but the Adelaide mailing list from there hasn't been used for some time.

--Rob

Get on our mailing list by clicking here!

Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201501.eventbrite.com.

Our next meeting is: Wed, Jan 21 2015 12:00 to 14:00 in Adelaide.

Stored Procedures vs. Ad-Hoc SQL: Performance Showdown!
Still not sure of which is faster? Let us put this matter to rest once and for all. We will measure every single aspect of the execution of a stored procedure vs. its Ad-Hoc query counterpart, and only one will prevail! We will look at raw performance, memory consumption, plan cache usage, and network bandwidth utilization. We will also discuss options for environments on which the code cannot be modified.

Speaker: Argenis Fernandez
Argenis Fernandez works in the Database Engineering team at SurveyMonkey, and is based in Redmond, WA. He has worked with SQL Server for over 15 years and enjoys heavy OLTP workloads and performance tuning. Formerly a Senior Consultant for Microsoft, Argenis is also a Microsoft Certified Master in SQL Server 2008, and founder of the Security Virtual Chapter for PASS.

There is always stuff going on in the PASS community. For more information about these events, please contact the group leader, Rob Farley (try emailing through lobsterpot.com.au).