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.