Indexes

Hello folks.  Even more free training is coming your way in February from the PASS Virtual Chapters.  At least 3 of our chapters have scheduled training sessions I want to let you know about.  More press on these should be available  in the next week.  I can’t speak for the other VCs but I know those of us at the AppDev chapter are very open to doing sessions at time slots other than noon eastern (if fact you’ll see that later this month) but we need feed back as to what time you would like to have us bring you a session.  (and by feedback I don’t mean flame-mail!)
 
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 at http://sqlblog.com/blogs/allen_white/default.aspx. 

How do I view the presentation?
Attendee URL:  Live Meeting link
_____________________________________________________________________

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. 

Even though this is a SQLPass.org web site, they don’t share the same username/passwords.  You’ll need to register again with a new login to attend the meeting.  Thanks for your understanding! 

______________________________________________________________

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. 

Live Meeting Information:
Attendee URL: Live Meeting Link