Wisconsin SQL Server User Group

Welcome to the Wisconsin SQL Server Users Group

Next Meeting

Tuesday,

February

13

WISSUG February 2018 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 Feb 2018 Meeting Announcement

February 2018 WISSUG Meeting

Date:  13 Feb 2018

Time: 4:30 PM

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

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!

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.

SQL Saturday 2018 (Madison, WI) 07 April, 2018

SQL Saturday is returning to the Pyle Center in downtown Madison in April of 2018.

Registration is working, but the speaker list/agenda is not yet available.  Free training, but no free lunch.

Don’t be surprised if there are pre-cons (which are not free) on Friday, the 6th.

Check out the GroupBy site.

This is a free community-based training event with the next sessions scheduled for March, 2018. 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, 2017) available for free.

You need to join (for free) the Visual Studio Dev Essentials program then you can download SQL 2017.

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.

Not just SQL Server.  PowerShell, Windows Server, Networking, and more.  Have a look. 

Feb 2018 WISSUG meeting

Deadlocking for Mere Mortals  Presented by: Jonathan Kehayias (SQLSkills.com)

While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBAs  in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.

Jonathan Kehayias (SQLSkills.com)    

Jonathan is a SQL Server MVP and Microsoft Certified Master. He has presented at multiple conferences including PASS, SQLIntersection, SQLRally, SQLBits, and VMware Open Forum. In addition Jonathan teaches part of the SQLskills Immersion Events on Performance Tuning and on High Availability, and used to teach the SQL Server portion of the Microsoft Certified Master – SharePoint certification for Microsoft. Jonathan is also a Drill Sergeant in the U.S. Army Reserves, and did a tour of duty in Iraq in 2004. He’s married with two young children who he can often be found goofing off with.

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

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

16 Mar 2018 – GroupBy  sessions

07 Apr 2018 - SQL Saturday

10 Apr 2018 -  Index Fragmentation: Internals, Analysis, and Solutions – Paul Randal

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:

Deadlocking for Mere Mortals

Jonathan Kehayias, Principal Consultant SQLskills.com

While troubleshooting deadlocking in SQL Server has gotten easier in SQL Server, it continues to be a constant source of questions in the forums online. This session will look at the most common deadlocks asked about on the forums, and how to troubleshoot them using the various methods available to DBAs in SQL Server; including Trace Flags, SQL Trace, Event Notifications, and Extended Events.

About Jonathan:
Jonathan Kehayias is a Microsoft Certified Master of SQL Server 2008 and a SQL Server MVP. A senior consultant at SQLskills.com, he started with SQL Server in 2004 as a database developer and report writer. After spending 2 1/2 years working in T-SQL, in late 2006, he transitioned to the role of DBA. In early 2011, he joined SQLskills.com full time, focusing on his primary passion of performance tuning. He frequently rewrites queries for better performance.

 

 

 

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