Featured Presentation

Page And Row Compression How, When, and Why

Speaker: Bradley Ball

Summary: Page and Row Compression are powerful new tools. Vardecimal shipped with SQL 2005 SP2, Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2. Get an overview into how each version of compression works internally. Learn how your Allocation Units will determine if your data is a candidate for compression. Understand how your tables Update and Scan patterns affect the compression types you should consider. And what you should you take into consideration for additional overhead.

About Bradley: Bradley Ball is a MCITP SQL 2005 & MCTS 2008 Database Administrator with over 10 years of IT experience. Bradley spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office Of the President of the United States. He is currently a Sr. SQL Database Administrator for Publix Supermarkets. Bradley can be found blogging on http://sqlballs.blogspot.com

 

Pre-Meeting Presentation

Basics of Performance Tuning - Part 1

Speaker: Andy Warren

Summary: In part one of our three part class on performance tuning you'll learn how to use Profiler, the tool that ships with SQL Server that is used to monitor SQL statements sent to the server. We'll show you how to start a Profiler session, set up the most common events, columns, and filters, and how to create a template so you can easily use the same settings each time. We'll explain how to assess the cost of a query by looking at reads, writes, cpu time, and duration. We'll finish up by showing you how to set up a server side trace - think of it as Profiler without the UI. Knowing how to use Profiler is critical for a DBA, and incredibly useful for a developer.

About Andy: Andy Warren is a SQL trainer focusing on basic administration and performance tuning, he runs the free SQLShare.com training site, is currently a SQL Server MVP, blogs daily at SQLAndy.com, started the SQLSaturday franchise, serves as a member of the Board of Directors of PASS, and was a founding partner in SQLServerCentral.com. In his remaining free time he's working on a book for first time managers

cage-aids
cage-aids
cage-aids
cage-aids