Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

September

12

WISSUG September 2017 Meeting

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

WISSUG September 2017 Meeting Announcement

September 2017 WISSUG Meeting

Date:  12 Sep 2017

Time: 4:30 PM

Location: Microsoft office (833 E Michigan St, Milwaukee, WI  53202)

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:

NEW MEETING LOCATION for WISSUG meetings!

Microsoft has completed the process of moving to their new office in downtown Milwaukee.

833 E Michigan Street (8th floor) to be precise. 

This will be our meeting location beginning with the June 2017 meeting. 

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

SQL Saturday – Wausau:  16 Sep 2017

Looking for some free high-quality training on SQL Server?  You’re in luck.

More details and registration here: http://www.sqlsaturday.com/631/eventhome.aspx

SQL PASS Summit 2017

The SQL PASS Summit is returning to Seattle this year and runs from 30 October – 03 November.  

You can save $150 off the registration fee by using this code: LC15HFK3.

Have you seen the GroupBy site?

This is a free community-based training event with the next sessions scheduled for September 1st & 8th, 2017. 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) is available for free.

Microsoft has decided to make Developer Edition freely available.  Yes, really.

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

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. 

Sep 2017 WISSUG meeting

SSIS Incremental Loading: The Tortoise and The Hare

Presented by: Jeremy Frye (RDX.com)

Extracting, transforming and loading data can be a major component in building a data oriented solution that satisfies business requirements and needs. Depending on the size of the data you are working with, your SSIS design patterns can have an impact on performance and run times.

In this session, we will cover a variety of SSIS incremental design approaches involving large data sets. We will look at the architecture of each ETL strategy to determine the pros and cons and generate specific use cases to decide which strategy yields optimal results.

Jeremy Fry (RDX.com)   

Jeremy Frye is the manager of the Business Intelligence and Data Warehousing team at RDX.

He is a Business Intelligence Architect and Developer with a background in database administration as well.  Jeremy has over 9 years of experience in the SQL space. He has spoken on BI topics at many SQL Saturdays throughout the country as well as the Pittsburgh Pennsylvania local SQL user group.

In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.

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

October – no meeting – see you at the PASS Summit in Seattle!

14 Nov 2017 – Kimberly Tripp - Statement Execution and the Plan Cache

12 Dec 2017 – Jes Borland  - TBA

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:

SSIS Incremental Loading: The Tortoise and The Hare

Jeremy Frye, Manager of BI and Data Warehousing RDX

Extracting, transforming and loading data can be a major component in building a data oriented solution that satisfies business requirements and needs. Depending on the size of the data you are working with, your SSIS design patterns can have an impact on performance and run times. In this session, we will cover a variety of SSIS incremental design approaches involving large data sets. We will look at the architecture of each ETL strategy to determine the pros and cons and generate specific use cases to decide which strategy yields optimal results.

About Jeremy:
Jeremy Frye is the manager of the Business Intelligence and Data Warehousing Team at RDX. He is a Business Intelligence Architect and Developer with a background in database administration as well. Jeremy has over 9 years of experience in SQL Server. He has spoken on BI topics at many SQL Saturday's throughout the country, webinars, and local and remote SQL user groups. In his spare time, Jeremy often spends time trying to bridge the gap between keyboard strokes and workout reps.

 

 

 

PASSChapterLogo.jpg

sql_micro_sm.gif

PASSChapterLogo100.jpg

Powered by Office 365

sql_micro_sm.gif

sql_ca_sm.gif

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids