Friday, May 20, 2011


Hello Dear Reader, this is a quick post to ask for your vote, or just for you to vote in general.  Today is the last day of voting for sessions for the 2011 PASS SUMIT.
Here is the link to follow CLICK HERE TO VOTE. (You will need a PASS account to vote, but they are FREE!)
And here is a list of the Sessions I have submitted.  I’ve presented on Compression at SQL Saturday 62, SQL Saturday 74, SQL Rally, for the MAGICPASS SSUG, and for the Virtual DBA Chapter of PASS.  If you’ve viewed the presentation and can spare the time I’d appreciate it.

Page and Row Compression How, When, and Why

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 pattern’s affect the compression types you should consider. And what you should you take into consideration for additional overhead.

Page & Row Compression Deep Dive

Page and Row Compression are powerful new tools. Page & Row with SQL 2008 RTM, and Page & Row with Unicode Compression with SQL 2008 R2.  We can turn it on, we can turn it off, but we want more!  What are Access Methods and how in the SQL Engine do they affect Compression?  What are the “Gotchas” of Page Compression?  How does Compression differ in the way it treats Non-Leaf & Leaf Level pages?  What additional functionality did we get in DBCC Page, DMV’s, Perfmon Counters, and Extended Events to support our usage of Compression?  How do complex query plans affect Compression?  Come find out!

Transparent Data Encryption Inside and Out

Security is a very important part of your job and in how data is utilized.  We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list.  Find out What it does, What it doesn’t do, how it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), and other Advance Features as well as some tips on how to manage it.


No comments:

Post a Comment