Bradley Ball is a MCITP SQL 2005 & MCTS 2008 DBA 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. Consultant for Pragmatic Works. He has presented at SQL Saturdays 62, 74, 79, 85, 86, 131, for the MAGICPASS & OPASS SSUG’s, SQL Rally 2011 & 2012, SQL Dev Connections 2012, the PASS Summit in 2011, and is scheduled for the PASS Summit 2012 and SQL Live 360 later this year. He recently finished Chapter 14 of Expert SQL Server Practices on Page & Row Compression and can be found blogging on http://www.sqlballs.com.
Hello Dear Reader! Last year I tossed my hat in the ring on the world of Presenting. This was a tremendous experience for me. Presenting is a whole other skill set, one that I had not exercised very often. The more I presented the more I learned. I received wonderful questions and feedback that helped me grow from SQL Rally 2011, presenting Page & Row Compression How, When, and Why to the PASS Summit 2011 where I presented Page & Row Compression: Deep Dive. All of this and there is still more to go into.
"So Balls,"you say, "What are we voting for again?"
Great Question Dear Reader! While I've presented loads on Page & Row Compression, in 2012 we are adding Spatial Compression to the mix and Vertipaq Compression that gives us Columnstore Indexes. Not to mention we still have Backup Compression as well. Put all that together and I've got enough information to fill a whole day, and that is just what I'd like to do!
I've submitted a Full Day Pre-Con on Compression to SQL Rally 2012. I am honored to say that I'm up for vote along with some other really great sessions. And you Dear Reader get to vote and decide on who the final two are that make it.
THERE'S ALWAYS ROOM FOR COMPRESSION
The title of my Pre-Con is "There's Always Room for Compression" and here is a copy of my abstract.
Come on There’s Always Room for Compression! In SQL 2012 Compression hits with a Bang. We should all be taking backups, and Compressing our backups as well. But what advanced feature can cost Compression performance and how can you re-claim it? SQL 2008 we got Backup and Page & Row Compression, SQL 2008 R2 gave us Unicode Compression to add to the mix, and SQL 2012 give’s us Page & Row Compression for Spatial Data. On top of that we get VertiPaq Compression for Columnstore Indexes. If you are running an OLTP shop, working heavily with BI, or a mix of the two Compression in SQL Server 2012 is something you should learn about. There are 3 bottleneck’s in any Database, find out how Page & Row Compression can help you offload I/Op’s for CPU. BI heavy shop? Understand What Columnstore Indexes are, how they work, and how you can use them.
If you are interested in Compression, looking at using this at work, or trying to figure out best practices for Compressing Data vote for me! We will Deep Dive Page & Row Compression and look at the internal components, how it works, how you monitor it, and that will lead to a greater understanding in how to apply it. The internals of Columnstore indexes using Vertipaq Compression, we will be spelunking on those internals as well! Come on spelunking on internals, that just sounds fun! *I first heard that phrase from Paul Randal(@PaulRandal | Blog), it is his but I'm borrowing it J!
Not only will we be Deep Diving a couple different area's but I want this to be an interactive day. I will be putting together a Sample Database that we will use so we can work together and by the end of the day you will have hands on experience with Determining what Tables are good candidates from Compression, Compressing them, taking baselines Before and After in order to see what benefits that we have achieved.
Compression can help you if you an OLTP shop or if you are a DBA who works primarily with BI. There is something for everyone.
Even if you do not vote for me there are a lot of really great Pre-Con's that you can vote for, (Like my friend & Co-Worker Bradley Schacht(@BradleySchacht | Blog) "The 3 P's of Presentation (PerformancePoint, PowerPivot, Power View)". All you need is an active login for PASS and you can vote. Please Go cast yours today Click Here!