Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

December

12

December 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 Dec 2017 Meeting Announcement

December 2017 WISSUG Meeting

Date:  12 Dec 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.

Have you seen the GroupBy site?

This is a free community-based training event with the next sessions scheduled for December 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. 

Dec 2017 WISSUG meeting

Execution Plan Essentials

Presented by: Eugene Meidinger

Do you have a query that you want to tune, but don't know where to start?

Execution plans can be a great starting point for understanding what your query is doing under the hood.

By learning how to read execution plans, you will have a greater confidence and understanding when writing T-SQL.

In this session, we will show you how to access execution plans and read them.

Then we will dive into real examples and explain what each of them means and how it impacts performance.

We will cover all of the most common operators in execution plans. These examples apply to any version of SQL. By the end of this talk, you'll feel comfortable getting started with execution plans.

Eugene Meidinger   

Eugene Meidinger has been working as a BI consultant at All Lines Technology for the past 6 years.

He speaks at the Pittsburgh SQL User Group and local SQL Saturdays. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server 2012.

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

09 Jan 2018 – TBD

13 Feb 2018 - Deadlocking for Mere Mortals - Jonathan Kehayias

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

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:

Execution Plan Essentials

Eugene Meidinger, BI Consultant Lantek

Do you have a query that you want to tune, but don't know where to start? Execution plans can be a great starting point for understanding what your query is doing under the hood. By learning how to read execution plans, you will have a greater confidence and understanding when writing T-SQL.

About Eugene:
Eugene Meidinger has been working as a BI consultant at All Lines Technology for the past 6 years. He speaks SQL Saturdays and PASS Summit. He also leads the Pittsburgh Power BI User Group. He is certified in querying and administering SQL Server 2012.

 

 

 

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