Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

October

09

WISSUG October 2018 meeting

  • Online @ 833 E Michigan St Milwaukee, Wisconsin, United States (map)
  • 11:30 - 13:00 Central Daylight Time
  • Language: English

WISSUG Oct 2018 Meeting Announcement

October 2018 WISSUG Meeting  - NEW MEETING TIME!

Date:  09 Oct 2018

Time: 11:30 AM     ß NEW MEETING TIME!

Location: Microsoft office (833 E Michigan St, Milwaukee, WI  53202)  8th floor.

ATTENTION:  New meeting time!  See below for details.

We need presenters!  Thinking about being 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 TIME for WISSUG meeting!

WISSUG meets in Microsoft’s new office in downtown Milwaukee.

The address is: 833 E Michigan Street on the 8th floor. 

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

In an effort to make the Group meetings accessible to more people, our meeting time has changed to start at 11:30 am Central Time. 

Our meeting date remains the second Tuesday of each month.

SQL PASS Summit 2018 – 05-09 November 2018 in Seattle

The Summit is returning to Seattle for 2018.  The pre-conference sessions are set and registration is open. These usually fill-up quickly, so act soon to avoid disappointment.  Most of the regular conference sessions have been selected and more are on the way.  Check back to see new sessions as they are added.

You can save $150 off the registration fee by using this code: LSDISC9YE

Tip: If you get the All-in-one-bundle, you’ll not only get both pre-cons, but also get a (nice) PASS  backpack and a rockin’ PASS Summit water bottle.

Check out the GroupBy site.

This is a free community-based training site organized by Brent Ozar. The SQL Server community (you) determines the content – thanks, Brent!  Submit, review, rate an abstract at the GroupBy site.     

PASS Virtual Groups: Over two dozen (free) virtual groups, focusing on different areas of SQL Server, PowerShell, PowerBI and more.  Go to http://www.pass.org/ and click on the Community tab where you’ll find the Virtual Groups link.

Don’t forget about Microsoft Virtual Academy.  Lots of free training on SQL Server, PowerShell, Azure – you name it, it’s probably there.

October 2018 WISSUG meeting

Getting Started with Query Performance

Presented by: Rich Benner (Deltek.com)

You've been writing queries for a while but you find yourself needing them to run faster, how do you measure them and increase performance?

In this session we'll go through some techniques to give you an idea what's happening inside the SQL Server engine and improve your queries.

We'll be going a few topics to give you a understanding on how you can increase performance:

- Execution Plan basics and how to read them

- SET Statistics options and tools

- Some common mistakes to avoid (cursors, scalar functions, etc.)

- Indexing and how it affects your queries

- SARGability - what it means and why it can make a massive difference

You should leave this session with the ability to analyze your own (and other's) queries and see where  you might have performance bottlenecks and fix them!.

Rich Benner, Senior Database Performance Specialist  (Deltek.com)    

I'm a performance tuning DBA that loves optimizing SQL Servers. I've had enough poorly servers thrown at me that I've gathered a lot of tools that allow me to locate and fix issues quickly and efficiently.

I work for a product vendor as the SQL expert and do everything from fixing up servers to reviewing code pushes by developers as well as performance enhancements for queries.

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

 

Keep 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 and events

Nov 2018 – No meeting.  See you at the PASS Summit in Seattle!

11 Dec 2018 – Frank Gill – The SQL Server Transaction Log for Developers

08 Jan 2019 – TBD

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.

 

 

 

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