Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

July

11

WISSUG July 2017 meeting

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

WISSUG July 2017 Meeting Announcement

W  I  S  S  U  G

July 2017 WISSUG Meeting

Date:  11 July 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.

24 Hours of PASS

Here’s another free training/learning opportunity to take advantage of.  24 one-hour presentations running consecutively beginning at 07:00 (CDT) on 19 July.  Many of these presentations are a ‘sneak-preview’ of the full-length sessions that will take place at the PASS Summit this fall.

More details and registration: http://www.pass.org/AttendanEvent/OnlineEvents/24HoursofPASS.aspx

 

SQL PASS Summit 2017

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

Psssttt..  Here’s a $150 discount code, just for you: LC15HFK3.

Note: The registration will increase on 23 July, so sign up soon if you can.

Have you seen the GroupBy site?

This is a free community-based training event with the next sessions scheduled for September 2017. Organized by Brent Ozar, the SQL Server community 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.  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.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. 

July 2017 WISSUG meeting

Answering the Question, "What Happened?" with Query Store   Presented by Erin Stellato (SQLSkills.com) 

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. 

It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. 

If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature.

In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once

you’ve upgraded to SQL Server 2016.  We'll review the different options for Query Store, look at examples of what gets collected,

dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use

the specified plan.  Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

Erin Stellato  (SQLSkills.com)   

Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003.

Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. 

Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences

like SQLintersection and the PASS Summit.  Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

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

08 Aug 2017 – Ben Miller – Data Collection with PowerShell

12 Sep 2017 - Jason Granat – SSIS: Can’t We Just Get Along?

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

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:

Answering the Question, "What Happened?" with Query Store

Erin Stellato, Principal Consultant SQLskills

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan. Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

About Erin:
Erin Stellato is a Principal Consultant with SQLskills and lives in Cleveland, OH. She has over 17 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

 

 

 

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