Adelaide SQL Server Users Group

Adelaide SQL Server User Group

		Welcome
Welcome to the Adelaide SQLPASS chapter. You can find us on the 3rd Wednesday of the month, at the Edge Building on Hindley 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 event
Our next meeting will be on the third Wednesday of the month. We use EventBrite for registrations, so please register at http://adssug201302.eventbrite.com. Our next meeting is: Wed, Feb 20 2013 12:00 to 14:00 in Adelaide. Why Scans are better than Seeks Most DBAs design indexes and queries to avoid Scans and Lookups, and get adequate performance without knowing much more than that. In this talk, Rob Farley will demonstrate some of the differences between Scans and Seeks, breaking some of the preconceptions that people have about them, and investigating some of the impact they have around Joins, Parallelism and more. You'll see lots of queries and query plans, and leave with a much better understanding about what to look for in plans. Speaker: Rob Farley Rob Farley from LobsterPot Solutions recently became a Microsoft Certified Master in SQL Server. He's also an MCT, an MVP (since 2006) and is a PASS Board member. He blogs at <a href="http://sqlblog.com/blogs/rob_farley">http://sqlblog.com/blogs/rob_farley</a>, tweets as <a href="https://twitter.com/rob_farley">@rob_farley</a>, and you can reach LobsterPot via <a href="http://lobsterpot.com.au">http://lobsterpot.com.au</a> Download material about this presentation: seeks_scans.zip

		Announcements
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).

The Professional Association for SQL Server (PASS) is an independent, not-for-profit association, dedicated to supporting, educating, and promoting the Microsoft SQL Server community. From local user groups and special interest groups (SIGs) to webcasts and the annual PASS Community Summit � the largest gathering of SQL Server professionals in the world � PASS enables knowledge sharing, in-depth learning, access to the Microsoft SQL Server team, and the ability to influence the direction of SQL Server technologies. PASS was founded in 1999 by Microsoft and CA and continues to enjoy executive level endorsement from both organizations. As the number one user community for Microsoft SQL Server, Microsoft looks to the PASS community for valued feedback, input, and inspiration. PASS Mission Empower the global Microsoft SQL Server community to connect, share, learn and be inspired through networking, knowledge sharing, peer-based learning, and the ability to influence the direction of Microsoft SQL Server products and services.

		Sponsors
PASS provides the Adelaide SQL Server User Group with this website and other miscellaneous resources. The Adelaide SQL Server User Group is an official PASS Chapter. Microsoft has traditionally provided the Adelaide SQL Server User Group with a venue in which to meet, but now just creates SQL Server, which we love to use. LobsterPot Solutions provides the Adelaide SQL Server User Group with the services of Rob Farley and others, and all the necessary administration services to run the group. Chamonix IT Consulting provides the Adelaide SQL Server User Group with funding for catering. Red Gate provide swag! If you come along to one of our meetings, we might be giving away stuff from Red Gate.