San Francisco, California
London, United Kingdom
Midlands SQL Server User Group - 10th March 2016, 6.30pm
Session 1: Paul Randal (SQLSkills.com) - Performance Troubleshooting Using Wait Statistics
Session 2: Mark Elleray - Microsoft Certification
6.15pm – 6:30pm Meet & Greet
6:30pm - 8:00pm Paul Randal (SQLSkills.com) - Performance Troubleshooting Using Wait Statistics [extended remote session]
One of the first things you should check when investigating performance issues are wait statistics - as these can often point you in the direction for further analysis. Unfortunately many people misinterpret what SQL Server is telling them and jump to conclusions about how to solve the problem - what is often called 'knee-jerk performance tuning'. In this session, you will learn what waits are, how to analyze them, and potential solutions to common problem patterns.
8:00pm - 8:30pm Break & Food
8:30pm – 9:00pm Mark Elleray - Microsoft Certification
Mark will guide us through the details of Microsoft certifications, everything and anything you ever needed to know about getting certified
We'll be at the Midlands Art Centre (MAC Birmingham), B12 9QH.
It's directly opposite Edgebaston Cricket Ground in Birmingham
Parking: Lots or free parking, entrance is via Queens Ride, opposite the cricket ground
Public Transport: It's about 2 miles from New Street Station. Short taxi ride, or buses 1, 35, 45, 47, 62 & 63.
The 45 & 47 are the best options, which depart from outside Boots in the Bullring, opposite where the main entrance to New Street station was, on Smallbrook Queensway.
Room: When you get there, we're in the 'Pincent Masons 1' room. On the 1st floor, above the main entrance.
We'll be putting on food for the event, so please do register so we know numbers. If you then can't make it we'd really appreciate it if you'd unregister and/or let us know.
Dress code: relaxed
If you need any further details or have any requests for this or future Midlands SSUG events, please let me (Alex Whittles) know, either on Twitter (@PurpleFrogSys or @SQLMidlands) or email Alex@SQLMidlands.com
CEO / Owner, SQLSkills.com
Paul is a Microsoft SQL Server MVP and a Microsoft Regional Director. He spent 9 years working on the SQL Server team, writing DBCC CHECKDB, and ultimately responsible for the entire Storage Engine. In 2007 Paul left Microsoft to co-own and run SQLskills.com, and is a world-renowned author, consultant, and top-rated speaker on SQL Server performance tuning, administration, internals, and HA/DR. When he's not tweeting, blogging, or helping someone recover from a disaster, he's likely to be underwater somewhere in the world with his wife, Kimberly L. Tripp.
Mark is a freelance BI consultant who has worked with SQL Server BI tools for fourteen years. His work centres around SQL Server Data Warehouse design and build. His particular passions within SQL Server are SSAS and SSIS.
When & Where
SQLMidlands - Bringing the West Midlands SQL Server community together
We normally hold meetings every other month, usually on a Thursday after work at in the centre of Birmingham. It's an informal gathering of like minded people, with a couple of speakers presenting tips, techniques and information on old, new and upcoming technology. We like to get a mixture of world leading speakers as well as providing an opportunity for our members to present.
We tailor the speakers and sessions to your requests so if you have any specific topics that you want to go through, then come along and let us know.
If you've registered for an event and can no longer make it, please do unregister so that we don't over order the food! To unregister just view your tickets in your EventBrite account, and then cancel the relevant ticket. Thanks!
This event is kindly sponsored by Purple Frog Systems, if you need any Microsoft Business Intelligence help (Data Warehouses, ETL, Cubes, Azure, IoT, etc.), give them a call!