The PASS AppDev and DBA Virtual Chapters have even more free training lined up for you:
Index Statistics
March 23rd at 12:00 PM Eastern (GMT -4)
Presenter: Josef Richberg
Add to Calendar
A semi-technical guide to understanding and using non-clustered indexes in your databases. Learn the benefits of covered indexes and their differences between SQL 2000 and SQL 2005+.
Josef Richberg
Josef Richberg is a DBA for HarperCollins Publishers working with SQL Server and SSIS. He has over 17 years experience designing, building, and tuning SQL Server. He is the recipient of the ‘2009 Exceptional DBA’ award and actively blogs at http://josef-richberg.squarespace.com
How do I view the presentation?
Attendee URL: Live Meeting link
_____________________________________________________________________
Topic: SQL Server Internals and Architecture
Date: March 24, Noon EasternTime (GMT -4)
Abstract:
Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:
– What’s different about 32- and 64-bit systems?
– What are the various areas of memory inside of SQL Server?
– How are queries handled behind the scenes?
– What does SQL Server do with procedural code, like functions, procedures, and triggers?
– What happens during checkpoints? Lazywrites?
– How are IOs handled with regards to transaction logs and database?
– What happens when transaction logs and databases grow or shrinks?
This fast paced session will take you through many aspects of the internal operations of SQL Server and, for those topics we don’t cover, will point you to resources where you can get more information. So strap on your silly, as we cover all these topics and more at speed with tongue planted firmly in cheek!
Prerequisites: Basic understanding of SQL Server operations and activities – such as transactions, queries, and preventative maintenance tasks like backup and recovery.
Speaker: Kevin Kline is the Technical Strategy Manager for SQL Server Solutions at Quest Software. A Microsoft SQL Server MVP, Kevin is a founding board member of PASS and the author of popular IT books like “SQL in a Nutshell” (O’Reilly & Associates). Kevin is a top-rated speaker at industry trade shows and has been active in the IT industry for over 20 years.
Door Prize:
Kevin will have two copies of his “In a nutshell” book that will be raffled off to attendees. You must register no later than 5:00 PM Eastern on March 23rd to be included in the raffle.
Registration: You can attend the meeting without registering but if you want to be entered in the drawing, you must register at
https://www.livemeeting.com/lrs/8000181573/Registration.aspx?pageName=pzjr7664vdwssm3t
Live Meeting Link (just paste into your browser):
https://www.livemeeting.com/cc/8000181573/join?id=344ND5&role=attend
