Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting




WISSUG January 2018 meeting

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

WISSUG Jan 2018 Meeting Announcement

January 2018 WISSUG Meeting

Date:  09 Jan 2018

Time: 4:30 PM

Location: Microsoft office (833 E Michigan St, Milwaukee, WI  53202)  8th floor.

ATTENTION:  New meeting location!  See below for details.

Why not be a presenter?   Check out Kendra Little’s post on speaking.

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

Noteworthy items:


WISSUG meets in Microsoft’s new office in downtown Milwaukee.

The address is: 833 E Michigan Street on the 8th floor. 

Milwaukee County Transit System (MCTS) details are available here.

SQL Saturday 2018 (Madison, WI) 07 April, 2018

SQL Saturday is returning to the Pyle Center in downtown Madison in April of 2018.

Registration is working, but the speaker list/agenda is not yet available.  Free training, but no free lunch.

Don’t be surprised if there are pre-cons (which are not free) on Friday, the 6th.

Check out the GroupBy site.

This is a free community-based training event with the next sessions scheduled for March, 2018. Organized by Brent Ozar, the SQL Server community (you) determines the content – thanks, Brent!  Review, rate, submit an abstract at the GroupBy site.     

SQL Server Developer Edition (including SQL 2016, 2017) available for free.

You need to join (for free) the Visual Studio Dev Essentials program then you can download SQL 2017.

PASS Virtual Groups: Over two dozen virtual groups, focusing on different areas of SQL Server. 

Go to http://www.pass.org/ and click on the Community tab where you’ll find the Virtual Groups link.  There are over a dozen virtual groups from Data Architecture to PowerShell and more.  For free.

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

Not just SQL Server.  PowerShell, Windows Server, Networking, and more.  Have a look. 

Jan 2018 WISSUG meeting

Loading a Dimension Table using SSIS

Presented by: Manuel Quintana (Pragmaticworks.com)

In this session, we will dive into SSIS and look at the different design options that are available for maintaining dimensions in a traditional data warehouse.

Manuel Quintana (Pragmaticworks.com)    

Manuel Quintana has worked with Pragmatic Works just under 4 years.

Prior to this he had an 8-year career in hospitality working for Hyatt Hotels (lots of interesting stories!).

He began his career in BI as a technical support agent for the software side of Pragmatic Works, then moved to being a sales engineer where he would demo the products for potential clients. Manuel is now part of the training team and gets to travel around teaching many different BI topics like SSIS, SSAS and Power BI to name a few.

WISSUG Group – 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 up to date.


1. Go to www.pass.org

2. If you've never registered with this site before, use the Sign Up For Free 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, click the Community tab and choose Local Groups.  Enter Wisconsin in the Filter by Keyword box and click the Search button. Be sure to join WISSUG as a Local Group.

5. Make sure the Subscribe to Email Newsletter checkbox is checked.

Join the Meeting!   Powered by GoToWebinar

We are using GoToWebinar for remote attendees.

Please be aware of the following: 

1.    You must register (any time before the meeting) here: WISSUG Group Meeting Link   

2.    Choose the appropriate meeting date from the presented list.

3.    After registering, you will receive a confirmation email to join the webinar.

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

Upcoming WISSUG Meetings

13 Feb 2018 - Deadlocking for Mere Mortals - Jonathan Kehayias

13 Mar 2018 - SQL Server and PowerShell: Let's Get Serious – Drew Furgiuele

10 Apr 2018 -  Index Fragmentation: Internals, Analysis, and Solutions – Paul Randal

We are pleased to have 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.

Featured Presentation:

Loading a Dimension Table Using SSIS

Manuel Quintana, Training Content Manager Pragmatic Works

In this session, we will dive into SSIS and look at the different design options that are available for maintaining dimensions in a traditional data warehouse.

About Manuel:
Greetings. I have been an employee with Pragmatic Works for the past 4 years. I have supported our software products and now have joined our training team. Teaching topics such as Power BI, T-SQL, SSIS and the other main items for the microsoft BI stack. Business Intelligence is a passion of mine and I always love learning new things. My strongest areas of knowledge lay in SSIS as well as Power BI.







Powered by Office 365



Back to Top