July 2014 WISSUG Meeting
Date: 08 July 2014
Time: 4:30 PM
Location: Microsoft Office in Waukesha (N19 W24133 Riverwood Drive, Waukesha, WI 53188)
We need presenters! What interests you about SQL Server? Why not share your experience with the group? It doesn’t have to be a PASS Summit-level presentation. Besides, you’re among friends here.
Not convinced? Check out Kendra Little’s post on speaking.
WISSUG Newsletter Changes
If you would like to continue to receive information about upcoming meetings and events for both WISSUG & PASS, please make sure you get registered with an account on SQLPASS
. Starting in April 2014, all communications about WISSUG will be sent via a mailing list to users registered as WISSUG members with sqlpass.org.
Here's how to make sure you can stay "in the know"!
2. If you've never registered with this site before, use the Register link in the upper right-hand corner to create your account.
3. If you already receive messages from PASS, login with your account information.
4. Once you're logged in, go to MyChapters and make sure to join WISSUG as a Local Chapter.
5. Make sure the Subscribe to Email Newsletter is checked.
LiveMeeting is being replaced with Lync
Microsoft is replacing LiveMeeting with Lync, so we will be using Lync for remote access to the presentations beginning with the April 8th 2014 meeting. Please see the links below if you need the (free) Lync client software.
July 2014 WISSUG meeting
Each query has one and only one way it can be processed, right? Right. Well… sort of. One of the tasks the query optimizer performs is determining the best possible plan for our painstakingly-crafted SQL statements. But it doesn’t work in a vacuum and we can help it come up with a better (or sometimes worse) plan. Interested in learning how? Me too. The better part, that is.
Inside the Query Optimizer - presented by Bradley Ball
The Query Optimizer is a black box. It can be intimidating until you understand it. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get.
In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works. This is the first step in learning how to use the Optimizer's rules to make your queries faster!
Bradley Ball is a MCITP 2005 & 2008 DBA with over a decade of experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army, The Executive Office Of the President of the United States, and Publix Supermarkets. Currently the Data Platform Management Lead for Pragmatic Works and Microsoft VTSP. He has presented at many SQL Saturdays, for PASS SSUGs, SQL Rally, DevConnections, SQL Live 360, & the PASS Summit 2011, 2012, 2013 and will be presenting at the 2014 PASS Summit. He can be found blogging on http://www.sqlballs.com about SQL Server or anything else that interests him.
WISSUG Meeting Agenda
* Networking with your peers: Got a problem? Got an answer? Share it!
* WiSSUG Business: Don’t just sit there – participate! Volunteer, present a topic, share your expertise!
* Presentation by Bradley Ball
Lync Meeting Information
IMPORTANT: Lync requires an audio device to be connected on your computer to function properly. This is a known (and frustrating) issue with Lync. Some users have reported plugging in even a non-functional microphone has allowed Lync to work. Some users have reported better results using Lync 2010. Let’s hope Microsoft addresses this issue soon!
Obligatory Legal Notice:
Microsoft Office Lync can be used to record meetings. By participating in this meeting, you agree that your communications may be monitored or recorded at any time during the meeting.
Upcoming WISSUG Meetings
12 Aug 2014 Glenn Berry (SQLSkills.com) – TBD
09 Sep 2014 Dr. Tom Lane – Transactional Replication
You ARE planning to attend the SQL Server 2014 PASS Summit in Seattle, right?
As long as you’re going, why not use this discount code and save a cool $150 off the registration fee? Enter this top-secret code when you register.
Discount code: USMIS36
Fine print: The Chapter discount code cannot be combined with any other PASS Summit 2014 discount and cannot be applied to an existing registration.
Special thanks to our sponsors: