Search
Saturday, August 23, 2014 ..:: Home ::.. Register  Login
Site Navigation
  Home

Useful Links
    

WiSSUG Wisconsin SQL Server User’s Group

Next Meeting
August 2014 WISSUG Meeting
 
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
Attention WISSUG members!
 
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…
 
 
Presentation Preview
 
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!
 
Copy this address and paste it into your web browser:
https://meet.lync.com/wissug/pgdba/G2411L6H

Audio Information - Computer Audio
To use computer audio, you need speakers and microphone, or a headset.

Lync 2013 downloads: 64-bit   32-bit  Other Lync downloads
 
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?)
 
 
PASS Summit 2014 
 
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:
    
Sponsors

PASSChapterLogo100.jpg

 Powered by Office 365

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

  

 

 

 

 

 

    
Copyright 2009 by PASS Chapters Portal   Terms Of Use  Privacy Statement
DotNetNuke® is copyright 2002-2014 by DotNetNuke Corporation