Friday, May 20, 2011

VOTE FOR MY PASS SESSIONS!

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.
Thanks,

Brad

Tuesday, May 17, 2011

TO THE ORGANIZERS OF SQL RALLY THANK YOU!


SQL Rally is over, and before we get too far away from it, I just wanted to say a quick Thank You.  

There was a lot of work done to pull off the SQL Rally.  It was over 1 year in the planning, and it showed.  I’m still relatively new to Florida, I moved here not even a year ago.  And when I did, I had no idea what a rich SQL Community it had as a state.  There are over 12 PASS Chapters in the state of Florida, an average of at 5 SQL Saturday’s a year, and this year the Inaugural SQL Rally.

Going to these events you see a lot of the same people time and time again.  Kendal Van Dyke (@SQLDBA|blog), Gareth Swanepoel (@GarethSwan|blog), Pam Shaw (@PamShaw), Jack Corbett (@UncleBigUns|blog), Karla Landrum (@KarlaKay22|blog), Rodney Landrum (@SQLBeat|blog), Jorge Segarra (@SQLChicken|Blog), Adam Jorgensen (@adam_jorgensen|blog), Andy Warren (@SQLAndy|blog), and this is the second time in less than a year I’ve seen Louis Davidson (@DrSQL|Blog) down in Florida volunteering his time, VA Beach or Tennessee, either way that’s a long way to travel!


If we could group all of these folks in a room, and I’m sure there are even more that I’ve left out, and give them a standing ovation it wouldn’t be enough.  When you take the time to speak, it takes a lot of preparation, planning Demo’s, Slide Decks, and learning, time that it takes outside of work and from your family. 

When you are planning an event like this, coordinating the speakers, finding the venue, getting sponsors, working on Logo’s, Websites, brochures, marketing, meetings, planning nightly activities, pre-con’s, the list goes on and on, you do a lot more.  It takes a lot more, and that is a lot less time you have with your family.



When you see the pictures that Kendal Van Dyke posted on his flickr account, the first couple pictures you see show the work being done while you are on the verge of the event.  Jack, Andy, and Kendal all had really great blogs leading up to the Rally, but nobody is there taking pictures when you have a planning meeting, nobody is handing out swag for time spent weeding out the venues, when you negotiate a deal for rooms, or get funding there is no crowd to break out in applause.

We attend these events because we are passionate about SQL, we are all striving to share with one another to better ourselves and each other.  The people that put on these events, they love this at a whole different level.  I don’t think they get to hear “Thank You”, nearly enough.  Maybe I'm wrong, I hope they do.

So this is the only way I can think to do it.  If you had a hand in Volunteering Thank You, If you had a hand in putting together a Session or a Pre-Con Thank You, and for all the people that put in their time, were away from their families, and made the big picture come together Thank You.

Send them a message on Twitter, go to their blog, or shoot them an email and just say Thank You. I had a blast, I can’t wait to do it again, and I really appreciate all the hard work.  So one more time, because I could never say it enough, Thank You for all you do so that we can learn.

Thanks Again,

Brad

SQL RALLY SLIDE’S & DEMO’S


Hello Dear Reader, I’ve posted the Slides & Demo’s from my SQL Rally Presentation over on my Resources Page.  You can Click Here to download them, as well.  SQL Rally had a lot of great learning and a lot of great presentations.  Head over to the SQL Rally website and view a list of Blogs and Pictures from attendees of the Event!


Thanks,

Brad