Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

February

14

February 2017 WISSUG 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 February 2017 Meeting Announcement

WISSUG

Wisconsin SQL Server User’s Group

February 2017 WISSUG Meeting

Date:  14 February 2017

Time: 4:30 PM

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

ATTENTION: This is the last WISSUG meeting at this 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 beginning with March meeting!

After many years in the Waukesha location, Microsoft is moving to a new office in downtown Milwaukee.

833 E Michigan Ave to be precise.  The move will take place in March and April of this year, so the Waukesha location will be unavailable after this month’s meeting.  The new office will not be available to us until our May 2017 meeting. 

Thus, we will meet in March (14th) and April (11th) at the US Bank building at Foley & Lardner LLP, located on the 40th floor.  Parking is available (limited) on the south side (Clybourn Street) of the building, as well as in the US Bank parking structure.

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

WISSUG Meeting calendar & location:

Feb 14th – Microsoft office in Waukesha

Mar 14th, Apr 11th – Foley & Lardner (40th floor) at the US Bank Building

May 9th (and after) – Microsoft office – 833 E. Michigan Ave (next to US Bank building)

Have you seen the GroupBy site?

This is a free community-based training event with the sessions taking place Friday, 21 April and Friday 28 April 2017.  Best part: We (SQL Server community determine the content).  Review, rate, submit an abstract.  Nice idea – thanks, Brent!

SQL Saturday is returning to the Pyle Center in downtown Madison on 08 April 2017.  Mark your calendars for this outstanding free training event.

The PASS Business Analytics Day will be held on 11 January 2017 in Chicago.  There are full-day tracks on using R with SQL 2016 and on Power BI.

SQL Server Developer Edition (including SQL 2016) is available for 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, focusing on different areas 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. 

February 2017 WISSUG meeting

"Help! I need to get this replication Re-replicating"  Presented by Dr. Tom Lane 

The audience will be presented with a number of broken-down replication scenarios and they will hunt down the cause of each failure and find ways to correct the problem and/or prevent it from happening again. Throughout the adventure, the various replication types will be discussed and pro-active methods of monitoring and fault tolerances will be discussed.

Dr. Tom Lane   

Thomas is currently a BI/DW Consultant at Solve (www.Solve100.com).   He received his Ph.D. in Chemistry, did his post-doctoral study at Marquette University, taught programming and database classes at Marquette University, worked as an instructor for a private teaching firm, worked as a developer, and for the past fourteen years worked with SQL server as DBA, ETL specialist, and Data Architect at various Midwestern companies.

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 Dr. Tom Lane

Join the Meeting!  Now using GoToWebinar

We are now using GoToWebinar for a better remote attendee experience.

Please be aware of the following: 

1.    You must register (any time before the meeting) here: WISSUG Chapter 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

14 Feb 2017 – Dr. Tom Lane - SSAS 2016 Tabular model development.

14 Mar 2017 – Glenn Berry - Analyzing I/O Subsystem Performance.

11 Apr 2017 – Frank Gill – The Anatomy of a Transaction.

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.

______________________________________________________________________

<v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <v:fill o:detectmouseclick="t"> <v:imagedata o:title="image003" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image001.jpg">                      <v:fill o:detectmouseclick="t"> <v:imagedata o:title="image003" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image002.jpg">        <v:fill o:detectmouseclick="t"> <v:imagedata o:title="image004" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image003.jpg">                       <v:fill o:detectmouseclick="t"> <v:imagedata o:title="Idera" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image004.jpg">      

<v:imagedata o:href="cid:image007.png@01CEC346.A43A3C10" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image005.png">             <v:imagedata o:href="cid:image009.png@01CEC346.A43A3C10" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image006.png">                    <v:imagedata o:title="Brent Ozar horizontal with text 600 x 171" src="WISSUG%20February%202017%20Meeting%20Invitation_files/image007.jpg">

       

 

Featured Presentation:

"Help! I need to get this replication Re-replicating"

Thomas Lane, DW/BI Consultant Talavant

The audience will be presented with a number of broken-down replication scenarios and they will hunt down the cause of each failure and find ways to correct the problem and/or prevent it from happening again. Throughout the adventure, the various replication types will be discussed and pro-active methods of monitoring and fault tolerances will be discussed.

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