Location: 8000 Norman Center Drive, Bloomington, MN  55437 – We will be meeting in the 8000 building this month. 

Sponsor:  Benchmark Learning 

Agenda:

• 4:30-5:00 : Registration / hospitality / networking
• 5:00-5:15 : Announcements etc.
• 5:15-6:00 : Jason Strate:  Error Logs and Deadlocks, Oh My!
• 6:00-7:00 : Kalen Delaney:  Seeking SQL Server Secrets

Presentation:

Error Logs and Deadlocks, Oh My!

Jason Strate, Digineer

Tired of turning to the SQL Server error log to find out what’s happened?  Would you rather just know about a deadlock when it’s occurred rather than later in the day when the manager as you why HRs bonus distribution application failed?  Find out how to get this information and more delivered to your inbox so that you can head off issues instead of drowning in them.  In this session we’ll look at Event Notifications and find out how to stop having to monitor SQL Server error logs today.

Jason Strate, SQL Server MVP, is a DBA with over twelve years of experience. His experience includes delivering both OLTP and OLAP solutions as well as assessment and implementation of SQL Server environments for best practices, performance, and HADR solutions. He is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008. Jason has presented at the SSWUG Virtual Conferences, TechFuse, SQL Saturday events, and at PASSMN user group meetings.

Presentation:

Seeking SQL Server Secrets

Kalen Delaney, SQLearning

Many experienced DBAs are aware that there are many undocumented commands and traceflags in SQL Server, and some DBAs may even keep track of all references to such options whenever they read about them in an article or blog posts, or hear about them at a conference. In this session, I’ll not only tell you about some of my favorite undocumented features, I’ll also tell you some of my tricks for discovering more undocumented secrets.

Kalen Delaney has been working with SQL Server for 23 years, and provides advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long. Kalen has spoken at dozens of technical conferences, including every PASS conference in the US, since the organization’s founding in 1999. Kalen is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, the most recent being SQL Server 2008 Internals, from Microsoft Press. Kalen blogs at www.sqlblog.com and her personal website and schedule can be found at www.SQLServerInternals.com.