Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

June

11

WISSUG June 2019 meeting

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

 

Jun 2019 WISSUG Meeting

Date:   11 Jun 2019

Time: 11:30 AM  (Central Time)

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

 

IMPORTANT!

The Microsoft office building now requires that *everyone* be on a visitor list in order to be admitted to the office.  You must register (see below) for the meeting no later than noon of the Monday before the meeting date.  Thus, for the June meeting, please register by noon on Monday, June 10th.

 

Are you attending in-person?  You must register by noon on Monday, June 10th on the EventBrite site:

Register to attend WISSUG meeting in-person

 

Noteworthy items:

WISSUG meets in Microsoft’s office in downtown Milwaukee at 11:30 am on the 2nd Tuesday of the month.   The address is: 833 E Michigan Street on the 8th floor. 

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

 

Upcoming events:

 

PASS Summit 2019 04-08 Nov 2019 in Seattle, WA.

Pre-conference sessions have been announced – these tend to fill up quickly.  Many of the regular sessions have been announced as well.  

 

PASS Virtual Groups: Over two dozen (free) virtual groups, focusing on different areas of SQL Server, PowerShell, PowerBI and more.  Go to http://www.pass.org/ and click on the Community tab where you’ll find the Virtual Groups link.

 

Check out the GroupBy site.

This is a free community-based training site organized by Brent Ozar. The SQL Server community (you) determines the content – thanks, Brent!  Submit, review, rate an abstract at the GroupBy site.

 

Microsoft is retiring Microsoft Virtual Academy effective 10 June 2019.  It is being replaced with Microsoft Learn.  Checkout the new site.  It’s still free.

 

 

 

June 2019 WISSUG meeting

Tracking Data Transformations Using Temporal Tables

Presented by: Dr. Thomas Lane, Ph.D.

Along with change tracking and change data capture Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables.  Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature.  A temporal table truly introduces two tables into the mix: one for current data and another for historical data.

 

This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing.

 

 

Dr. Thomas Lane, Ph.D.

Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies.

 

 

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

 

Keep 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 and events

09 Jul 2019 - Deadlocking for Mere Mortals - Jonathan Kehayias  (SQLSkills.com)

August 2019 – No meeting – summer vacation!

10 Sep 2019 – SSMS Tips & Tricks - Gary Schultz

 

 

We need presenters!  Thinking about being 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.

 

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:

Tracking Data Transformations Using Temporal Tables

Thomas Lane, DW/BI Consultant Talavant

Along with change tracking and change data capture Microsoft has introduced a new method for tracking data changes within its databases called Temporal tables. Microsoft introduced temporal, or system-versioned, tables in SQL Server 2016 as a new database feature. A temporal table truly introduces two tables into the mix: one for current data and another for historical data. This talk will show how the feature is implemented and used along with a discussion on the common usage for temporal tables. Scripts will be explored for the automation of the creation of temporal tables along with its use in data warehousing.

About Thomas:
Thomas has been living and breathing Microsoft databases for over twenty years and is now relishing his position as a DW Consultant at Talavant (www.Talavant.com). After receiving his Ph.D. in Chemistry and following three years as a post-doc at Marquette University, Thomas left the world of science for a career in IT. He has worked as a programming and database instructor, a VB and C# developer, and for the past fourteen years worked with SQL server as a DBA, ETL specialist, and Data Architect at various Midwestern companies. Thomas recently received his MSCE in Data Management and Analytics.

 

 

 

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