Date: 12 Aug 2014
Time: 4:30 PM
Location: Microsoft Office in Waukesha (N19 W24133 Riverwood Drive, Waukesha, WI 53188)
We need presenters. This is your user group, have you presented lately?
If not, what’s holding you back? Check out Kendra Little’s post on speaking
Take a deep breath, and make the commitment. It won’t hurt. Promise.
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.
August 2014 WISSUG meeting
Pop quiz: How many DMVs are there in SQL Server 2012 R2? Right, a bunch.
Okay, smarty pants, which one(s) would a highly-skilled DBA use to find a problem query? A missing index?
If you’re not sure (like me), don’t worry – the Doctor is in…
Dr. DMV's Troubleshooting Toolkit – Presented by Glenn Berry
Dynamic Management Views and functions allow you to easily see exactly what is happening
inside your SQL Server instances and databases with a high level of detail. You can discover
your top wait types, most CPU intensive stored procedures, find missing indexes, and identify
unused indexes, to name just a few examples.
This session presents, demonstrates and explains numerous DMV queries that you can quickly
and easily use to detect and diagnose configuration and performance issues in your
SQL Server instances and databases.
Glenn works as a Principal Consultant at SQLskills in Parker, CO. He has been a SQL Server MVP
since 2007, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA,
MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes
DMVs, high availability, hardware selection, full text search, and SQL Azure. He is also
an Adjunct Faculty member at University College - University of Denver, where has been teaching
since 2000. He has completed the Master Teacher Program at Denver University - University College.
He is heavily involved in the SQL Server community, and is a frequent speaker at user groups,
SQL Saturdays, and the PASS Community Summit. He is the author of the book SQL Server Hardware,
and he wrote chapters for SQL Server MVP Deep Dives and SQL Server MVP Deep Dives Volume 2 books.
Glenn blogs regularly at http://sqlserverperformance.wordpress.com. He is active on Twitter as @GlennAlanBerry
and will be presenting the session “Analyzing I/O Subsystem Performance” at the PASS Summit in Seattle this November.
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 (or your painful learning experience)!
* Presentation by Glenn Berry
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!
Join the Meeting!
Audio Information - Computer Audio
To use computer audio, you need speakers and microphone, or a headset.
Lync 2010 downloads:
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
09 Sep 2014 Dr. Tom Lane – Transactional Replication
14 Oct 2014 TBD (isn’t it your turn?)