Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

November

14

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

November 2017 WISSUG Meeting

Date:  14 Nov 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 November 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. 

Nov 2017 WISSUG meeting

Statement Execution and the Plan Cache 

Presented by: Kimberly Tripp (SQLSkills.com)

Kimberly will discuss the impact on caching / performance of different methods of statement execution.

Briefly, she will also compare / contrast this with stored procedures. In the end, you’ll know the

best way to request data so that stable requests are cached and unstable requests are

not (giving you the most optimal performance).

Kimberly Tripp (SQLSkills.com)   

In addition to being the founder and president of SQLSkills.com,  Kimberly’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world; she’s also been a Microsoft SQL Server MVP for over 10 years.

She has over 25 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she's not tuning SQL servers, she's diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.

Email: Kimberly@SQLskills.com

Website: http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/

Blog: http://www.SQLskills.com/blogs/Kimberly

Twitter: http://twitter.com/KimberlyLTripp

SQL Server MVP since 2002

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

12 Dec 2017 – Jes Borland  - TBA

09 Jan 2018 – TBA

13 Feb 2018 - TBA

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:

Statement Execution and the Plan Cache

Kimberly Tripp, Founder/President/Owner SQLskills.com

Statement Execution and the Plan Cache

About Kimberly:
Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

Supplementary Materials

The following event attachments are available to you:

 

 

 

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