Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting




August 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

August 2016 WISSUG Meeting


Date: 09 August 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 Cumulative Update 01 was released 26 July 2016 

More details here: https://support.microsoft.com/en-us/kb/3164674


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 18 September.      

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. 

August 2016 WISSUG meeting

SQL Server Integration Services (SSIS) is a powerful and capable tool for ETL processing as well as for other data moving and processing tasks.  Join us this month as Andy Leonard helps explain how to leverage Biml and manage SSIS execution frameworks metadata.


Presentation Preview

Biml and SSIS Frameworks   Presented by Andy Leonard.         

You’ve probably heard that it’s a data integration best practice to build small, unit-of-work SSIS packages. 

You’ve heard that with Biml you can create a lot of SSIS packages in very little time.

You follow this advice and end up with dozens of SSIS packages.   Now what?

A metadata-driven SSIS Execution Framework will simplify the execution of several SSIS packages down to a simple, one-line stored procedure call.

But then, how does one manage all the metadata required to populate the SSIS Execution Framework?

Biml to the rescue!


Andy Leonard is a Data Philosopher at Enterprise Data & Analytics, an SSIS Trainer, Consultant, and developer; a Business Intelligence Markup Language (Biml) developer and BimlHero; SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of SQL Server Integration Services Design Patterns, and author of Managing Geeks - A Journey of Leading by Doing, and the Stairway to Integration Services.

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 Andy Leonard


Join the Meeting!

Click on the URL below or copy and paste it into your web browser:        

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

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

11 October 2016 – Dave Levy (Microsoft) – SQL Server 2016 – Always Encrypted

08 November 2016 – No meeting – see you at the PASS Summit!


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