www.sqlpass.org    Professional Association for SQL Server

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 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 event

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

Our next meeting is: Wed, Oct 09 2013 12:00 to 14:00 in Adelaide.

Table Expressions: So Much More Than CTEs
You use table expressions a lot but may not have given them much thought as a tool for query tuning. Whether to use simplifiable table expressions or materialized tables can be a significant consideration for large queries, and one that shouldn't be ignored. This session will teach you how SQL Server handles table expressions and how they impact important performance features such as joins and the shapes of execution plans. Understanding where, when, and why you should and shouldn't use them can improve your T-SQL in all kinds of ways.

Speaker: Rob Farley
Rob Farley runs LobsterPot Solutions. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses up to large PDW implementations. His presentation style and his insight into the complex made simple and profound make him unique in the SQL community, with or without his guitar. He blogs at http://sqlblog.com/blogs/rob_farley and is on Twitter at @rob_farley.

 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

PASSChapterLogo100.jpg 

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. 

sql_micro_sm.gif 

Microsoft provides the Adelaide SQL Server User Group with a venue in which to meet!

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.