Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting




July 2016 WISSUG meeting

  • In-Person & Online @ 833 E Michigan St Milwaukee, Wisconsin, United States (map)
  • 16:30 - 18:00 Central Daylight Time
  • Language: English

WISSUG Feb 2015 Meeting Announcement

July 2016 WISSUG Meeting


Date: 12 July 2016

Time: 4:30 PM

Location: Microsoft Office in Waukesha   (N19W24133 Riverwood Drive, Waukesha, WI  53188)


Driving directions: Take I-94 to County J/Waukesha (Exit 294). Take County J north for  about 1/4 mile. Go past the stone entrance to Riverwood office park (on your left), and proceed to the next entrance, which is Riverwood Drive, marked by a street sign.  Go to the building designated Riverwood 2, which will be on your left.


We need presenters.  Really.  Check out Kendra Little’s post on Speaking.

Bonus: here’s a video of Kendra with her Top 5 Tips For Your First Presentation video.


Newsworthy items:

SQL Server 2016 released 01 June 2016 

Read about the new version of SQL Server here: https://blogs.technet.microsoft.com/dataplatforminsider/2016/05/02/get-ready-sql-server-2016-coming-on-june-1st/


PASS Summit 2016  (October 26-28, Seattle, WA)

The 2016 PASS SQL Server Summit is returning to Seattle in October.

Planning to go?  Great!  Thinking of going?  Great idea!

Here’s some help.  Use this super secret code (LC15HFK3) when you register and save $150 off the registration fee. But don’t wait too long; the fee goes up after 17 July.      

SQL Server Developer Edition is now free!

Microsoft has decided to make Developer Edition freely available.  No, it’s not time-bombed.

All you have to do is join (for free) the Visual Studio Dev Essentials program then download the software.    

PASS Virtual Chapters: Over two dozen virtual chapters, each focusing on a different area of SQL Server.  Go to http://www.sqlpass.org/ and click on the Join a Virtual Chapter button to view the list and just click to the chapters that interest you.

Have you checked out Microsoft Virtual Academy?  There’s a ton of free training just waiting for you. 

July 2016 WISSUG meeting

Every DBA knows the positive impact indexes can have on the performance of a database.  But you can always have too much of a good thing; duplicate indexes, or too many indexes can be worse than none at all. And are you really sure that spiffy new index is a good idea?  Join us this month as Any Yun helps explain how to get indexes done right.


Presentation Preview

Uncovering Duplicate, Redundant, and Missing Indexes   Presented by Andy Yunz.         

Do you know if your database's indexes are really being used to their fullest potential? And do you know if SQL Server needs other indexes to improve performance? 

Attend this session and learn how SQL Server tracks actual index usage, and how you can make use of that information to improve the state of indexes in your database. We will use this data to identify wasteful, unused, & redundant indexes, and explore performance penalties you pay for not addressing these inefficient indexes. Finally, we will dive into the Missing Index DMV and explore the art of evaluating its recommendations to make proper indexing decisions.


Andy Yun is a Database Developer & Administrator with Ensono, LLC, an IT Managed Services firm. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, Andy strives to make T-SQL leaner and meaner.  Passionate about passing his knowledge onto others, Andy actively participates in the SQL Server community, as co-Chapter Leader of the Chicago Suburban User Group, and by speaking at regional User Groups & SQL Saturdays.

WISSUG Chapter – Stay Informed

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.  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".


1. Go to www.sqlpass.org

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 checkbox is checked.


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) with chapter members, suggest a topic for a presentation.  The more people participate, the better the group becomes.

* Presentation by Gary Schultz


Join the Meeting!

Copy this address and paste it into your web browser:        


Please register (you can do this at any time before the meeting) for WISSUG Monthly User Group Meeting at:

After registering, you will receive a confirmation email containing information about joining the webinar.

Phone-in audio is not supported; you must use your computer connection for audio.       

Brought to you by GoToWebinar®

Webinars Made Easy®  


Upcoming WISSUG Meetings

09 August 2016 – Tim Mitchell (tyleris.com) – SSIS

13 September 2016 – Jes Borland (Concurrency.com) – Wait Stats

11 October 2016 – TBD


Special Offer from Manning Press:


We are pleased to welcome Manning Press as a continuing WISSUG sponsor.

Manning has generously offered all WISSUG members a 36% discount on all their titles.

Simply enter UG367 in the Promotional Code box when checking out.


Special thanks to our sponsors:

WiSSUG sponsors are the best - Please support our sponsors with your patronage.







Powered by Office 365



Back to Top