Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email helpdesk@pass.org. Thank you for your patience.

Fox Valley Microsoft Data Platform

Next Meeting

Wednesday,

November

06

FoxPASS November 2013 Meeting

  • In-Person @ 100 W Lawrence St, Suite 100 Appleton Center Appleton, Wisconsin, United States (map)
  • 17:30 - 19:30 (UTC-06:00) Central Time (US & Canada)
  • Language: English
  • RSVP URL: None

We have a guest speaker coming to us from Florida! Gareth Swanepoel of Pragmatic Works is going to be talking to us about Extended Events!

Featured Presentation:

SQL Server 2012 Extended Events - Lightning sand, Flame spurts & R.O.U.S.’s

Gareth Swanepoel, Premier Field Engineer Microsoft

As a lone DBA in the scary world of the SQL Server 2012 Fire Swamp, you may be wary of the multiple threats of Lightning sand, Flame spurts & Rodents of Unusual Size. In this session, come and learn how to map your way through these threats using the new and improved DMV's and Extended Events that are found in SQL Server 2012.

In this session, you will learn about a few of the new DMV's available in SQL 2012. You will also learn about the improved XEvents interfaces and how to use XEvents to monitor your server and track issues in a similar manner to how SQL Profiler is used.

Prerequisites:
The target of this session is production SQL Server DBA’s or developers who have average T-SQL skills already. This session assumes that you have a basic understanding of SQL Server fundamentals. For example, you should be familiar with the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this session.

Goals:
- Understanding of the new DMV's available in SQL server 2012
- Knowledge of how XEvents are able to be used to monitor SQL Server
- Knowledge of the improvements that SQL Server 2012 has brought to XEvents (New XEvents UI, Tools, etc.)

About Gareth:
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQL Saturdays, the PASS Summit and other technical conferences.

Bronze Sponsors

 

Hosts

 

Other Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids