PASS AppDev, Virtualization, and DBA VCs February Presentations

PASS AppDev Presents: SQL Server Indexing

 Event Description:
While indexing traditionally has been the concern of the DBA, it's important for developers to understand both the usefulness and the impact of indexes in your relational database.  With the right indexes your application will perform like a Formula One racer, without them performance will better resemble a Model T.  This presentation will explain how indexes work, what options are available to you in SQL Server 2008, and how to tune your application and your database for the best performance.

Allen White:

Allen is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He's spent over 35 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT.  Allen has been awarded Microsoft’s MVP Award for the last three years. He's active in the Ohio North SQL Server User's Group and contributes in the MSDN Forums, answering questions about SMO and PowerShell, and maintains a blog athttp://sqlblog.com/blogs/allen_white/default.aspx.

­­

PASS Virtualization Presents: SQL Meets Virtual CPUs, Memory, and Storage

Event Description:
SQL Server can run great in virtual environments like Microsoft Hyper-V and VMware vSphere, but you can dramatically increase the odds of success if you know which knobs to tweak.  Just like SQL Server, virtualization software doesn't always work best with the default settings, and knowing which settings change SQL Server performance is key.  In this session, Brent will explain:

·      Why virtual CPUs, memory, and storage are different

·      Hidden gotchas that often cause virtual performance

·      How to stress test your virtual server to find limits

Brent Ozar:

Brent Ozar is a SQL Server Expert for Quest Software, a systems management company.  Up until a year ago, Brent managed the VMware, storage area networks (SANs) and SQL Servers for a $7b company.  He's used virtualization on the desktop and in the datacenter, and he can explain the options with real-world experience.  He coauthored the book Professional SQL Server 2008 Internals and Troubleshooting.

The Where and When
To get the attendee links, go to Virtualization.SQLPass.org, and click on Register at the top right of the page to sign up.  We'll email all members before the webcast.

PASS DBA VC Presents: SQL Server Locking & Blocking Made Simple

Event Description:
A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application's performance. In this session, we will explore SQL Server's locking methodology and discover techniques for enhancing query response times.

Joe Webb:

Joe Webb, a Microsoft SQL Server MVP, serves as Chief Operating Manager for WebbTech Solutions, a Nashville-based consulting company. He has over 14 years of industry experience and has consulted extensively with companies in the areas of software development, database design, and technical training.