Saturday, April 28, 2012

SQL Saturday 130 Deck & Scripts Live

Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville.  This is just a quick post to say that the slide Deck & Scripts are now up and on the Resource Page, I'll follow this up next week with a longer post reviewing the event.  Click Here for the Resource Page, click here for the Slide Deck, click here for the demos, and click here for the Monday Morning Check List.



Thursday, April 26, 2012

See you at SQL Saturday 130 Jacksonville!

Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL!  The good people from the Jacksonville SQL Server User Group have put together an excellent event.  If you are in the Jacksonville area, (or in FL or GA for that matter) and would like to make it to the event, go register here because we would love to see you!

On Friday the festivities kick off with a great Pre-Con Kevin Kline (Blog|@KEKline)  a full day on Troubleshooting & Performance Tuning for Microsoft SQL Server 2008 R2.  Kevin is one of the top guys in the SQL Server world, he is a Founding member of PASS and a former PASS President, he’s a SQL MVP, an author, and an all around great guy.  This is a full day of training that normally goes for hundreds of dollars, and right now it is only $120 for the full day.  Click on the link above to get more details.

“So Balls,” you say, “What will you be doing at SQL Saturday 130?”

We will get to that in a moment Dear Reader but first let’s go to the line up.


When you go to a SQL Saturday you expect a great line up, and SQL Saturday 130 in Jacksonville is no exception.  Six different SQL Server MVP’s, Six different tracks, two SSAS Maestro’s, all in all over 36 Sessions of pure SQL fun.   As if this wasn’t enough it is free.  That is right Dear Reader, if you have not been to a SQL Saturday in the past you may not know this but they are completely free to attend.  For the full schedule click here.

“So Balls”, you say, “What will you be attending?”

With all of these great speakers it will be tough to choose where to go, but I’m going to do my best!

If you’re new to the blog you may not know this, but I LOVE Compression! 

 One of the most interesting stories on Compression in SQL 2012, in my humble opinion, is ColumnStore Indexes.  So I’m going to start out the day with my friend Gareth Swanepoel (Blog|@GarethSwan) to learn more about them as he presents The Fangorn Forest – ColumnStore Indexes.  Then I’m off to present on Page & Row Compression in SQL 2012 (FYI 99.99% of what I cover works in 2008 R2 as well).  Next I’m off to watch Tom Brenneman (@TomBrenneman)  present on, Job Common Sense 101- Don’t be that Guy!!.  Tom does a lot of work with the Pragmatic Works foundation, runs the Jacksonville SQL Server User Group, and whenever I’ve spoken with him is a very engaging man.  I’m sure his presentation should be very interesting!  

After that I’m off to see Pam Shaw (Blog|@PamShaw)  presenting Taking the Scary out of Monster Reports.  Pam is a flat out expert at SSRS, she recently presented at MagicPASS, my SSUG home away from home, and she is great.  If you work with SSRS I would recommend you stop by and watch her present.  Next up I’m going to attend Chad Churchwell’s (Blog|@ChadChurchwell) session on SQL Server 2012 AlwaysOn for HA and DR.  I’ve had the pleasure of working with Chad since I hopped over to Pragmatic Works, and he is absolutely brilliant, Availability groups are one of the best things to come out of SQL 2012 and I’m really looking forward to seeing Chad’s take on them.  

Finally I’m going to finish off the day watching my friend Rob Volk(Blog|@SQL_R) present on Lego Sets: Relational Building Blocks.  I first watched Rob present at SQL Saturday 85 in Orlando last year, he is funny, engaging, and presenting on a topic I think EVERY DBA should learn about, Set Based Logic.  This is the mathematical foundation of how data set’s inside of SQL server work, and are the most efficient way to move and alter data vs. the Row By Agonizing Row approach (RBAR).  This should be a great way to end the day.


I’m presenting on my favorite topic, data compression.  And I hope you will stop by and join me if you are at SQL Saturday.  Here’s my abstract.

 “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. In SQL 2012 we add Spatial Data Types. 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.

This presentation is always a lot of fun, small crowd or big.  AS what our companies want to track continues to grow, our data volume will only continue to grow, and Compression will be a major component of how to handle that.  Come and learn how you should do it, and I’m not just talking turning it on and off, but really learn what are the internals of compression.  Learn how to decide what you should and should not compress, and walk away with a Monday Morning Checklist that will aid you if you are looking to apply this soon at your job.


As always Thanks for stopping by Dear Reader, I hope to see you at SQL Saturday and if you cannot make it to my session, I hope to see you at the event!



Wednesday, March 21, 2012

Spring DevConnections 2012

Hello Dear Reader, this week finds me in beautiful Miami FL.  Next week I’ll be in Vegas, for one night only.  Next week the SQL Server Conference schedule for 2012 kicks off, and how better to do it than in Las Vegas with DevConnections.  Connections could not come at a better time, with SQL 2012 RTM being available for MSDN download and available everywhere else April 1st, (yes I know April Fool’s day you can’t make this stuff up).

Joining the long list of experts speaking at DevConnections is ME!  I’m thrilled to be participating in the Launch Party for SQL Server 2012.  I was honored to be invited to present at SQL DevConnections.  For those of you not familiar with DevConnections it is a twice yearly conference that cover’s Visual Studio, ASP.NET, Sharepoint, SQL Server, Silverlight, HTML 5, Cloud, Exchange, and Windows technologies.

And it doesn’t just cover them, each technology stack is its own conference.  So literally there are 9 conferences for Microsoft Related technologies all happening in one place!   Under one roof!   Technogeeks of the World UNITE, I have found your mecca and it is called Vegas.

“So Balls,” you say “What will you be presenting on? When will it be?”

Excellent question Dear Reader and away we go.


Since joining Pragmatic Works, see Pragmatic Works has Balls….SQLBalls, I have been very busy with client work, and this will mark my first presentation of the new year!  My subject will be Transparent Data Encryption in SQL 2012!  The When Dear Reader is next Thursday 3/29, 9:45 am.

I will be presenting on Transparent Data Encryption Inside and Out in SQL 2012.  Here is the abstract.

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 and What it doesn’t do, How it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), What the X.509 Encryption Standard is and Why you should be careful of what you store and where, and other Advance Features as well as some tips on how to manage it.

This is a great subject and I’m kicking off the new year by walking through the process, talking about what TDE impacts and changes (not just in your database but in your Disaster Recovery Planning), and taking a quick peak at the internals of an MDF file.


DevConnections units so many technologies in the Windows stack, it brings out some of the best in the business on all fronts, and the people presenting are amazing.   Paul Randal (Blog|@PaulRandal) and Kimberly Tripp (Blog|@KimberlyLTripp) co-chair the conference, with the level of quality that Paul & Kimberly put into everything you know that this is going to be good.

The people presenting back that up you have Aarron Bertrand (Blog|@AaronBertrand), Steve Jones (Blog|@Way0utwest), Jonathan Kehayias (Blog|@SQLPoolboy), Brent Ozar (Blog|@BrentO), Mike Walsh (Blog|@mike_walsh), Glenn Berry(Blog|@GlennAlanBerry), Grant Fritchey(Blog|@GFritchey), and many many more, to see the full list click here.  When you get speakers this good you know that the content will be amazing and it is,click here for a list of sessions.

And as if that isn’t enough it’s VEGAS!


My time in Vegas will be brief, I’m a one night only, kind of show.  Right now I’m booked to the gills with client commitments so I will be flying in Wednesday night, and back out Thursday after the presentation.

So if you get a chance in passing feel free to yell out “HI Balls”, you’ll turn a few heads but hey it is Vegas, and I’ll make sure to come over and say Hi right back.

See you there!