Search results matching tags 'User Groups' and 'compression'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=User+Groups,compression&orTags=0Search results matching tags 'User Groups' and 'compression'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Did You Know? I gave two presentations last weekhttp://sqlblog.com/blogs/kalen_delaney/archive/2010/06/14/-two-presentations-last-week.aspxMon, 14 Jun 2010 15:05:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:26183Kalen Delaney<P>Even though I didn't make it to TechEd this year, it didn't mean I was quiet last week. On Wednesday, I was in Colorado, giving a talk for the new Colorado PASS User Group, which is a joint venture between 3 different existing groups from Colorado Springs, Denver and Boulder. On Saturday, I spoke at SQL Saturday #43, in Redmond on the Microsoft campus. My presence there has already been mentioned on two other blogs here at SQLBlog: <A href="http://sqlblog.com/blogs/merrill_aldrich/archive/2010/06/12/outstanding-sql-saturday.aspx">Merrill Aldrich</A> and the infamous <A href="http://blogs.msdn.com/b/buckwoody/archive/2010/06/14/sql-saturday-43-redmond-wa-review.aspx">Buck Woody</A>. </P>
<P>As Merrill mentioned, my session was on compression ("The Compression Session", isn't that catchy?). Right before lunch, I ran into an old friend, who asked what <STRONG><EM>exactly</EM></STRONG> my session would cover.&nbsp; I explained I would talk about the compression algorithms, and how exactly the data in your data files was compressed. He said… "Oh, you're going to talk about the <EM>Internals</EM> of Compression"… like he was surprised. I guess I'll have to send him a copy of my latest book… SQL Server 2008 <EM>Internals.&nbsp; </EM>I actually didn't cover the deepest internals that I could have; I did have some extra slides showing the details of the new row formats used if you choose to compress your data, but we didn't have any extra time.&nbsp; The details are in my book, if you're interested. </P>
<P>As mentioned, I discussed primarily the compression algorithms. I think my friend was asking what my specific topic was because he wanted to know if I was going to discuss performance and best practices at all. He then shared a tidbit that he had just heard from inside Microsoft (he used to work for Microsoft, for many long years) and that is that the consulting teams have pretty much discovered that the benefit of compression almost always outweighs the cost, and for most large systems they are recommending turning on page compression right out of the box. Remember that compression is a Enterprise Edition feature (and it's mainly the larger systems that are using Enterprise Edition).&nbsp; I'm just passing on this comment, I haven't done enough testing of my own to make a personal recommendation. </P>
<P>The demos have been posted for both the Denver PASS and the SQL Saturday sessions at: <BR><A href="http://www.sqlserverinternals.com/conferences">www.sqlserverinternals.com/conferences</A></P>
<P><FONT color=#ff00ff size=4>~Kalen</FONT></P>Did You Know: My Next Public Event at SQL Saturday in REDMONDhttp://sqlblog.com/blogs/kalen_delaney/archive/2009/09/20/sql-saturday-in-redmond.aspxMon, 21 Sep 2009 02:59:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:16908Kalen Delaney<P><A href="http://sqlblog.com/blogs/kalen_delaney/archive/2009/09/15/seats-left-in-my-boston-class.aspx" target=_blank>My Boston</A> class is SOLD OUT, but those of you in the Beautiful Pacific Northwest have an opportunity to come hear me at SQL Saturday in Redmond WA on Oct 3.&nbsp; I'll be speaking about compression in SQL Server 2008.</P>
<P>Check out the schedule of 3 concurrent tracks of great sessions, and it's all free!</P>
<P><A title=http://www.sqlsaturday.com/schedule.aspx href="http://www.sqlsaturday.com/schedule.aspx">http://www.sqlsaturday.com/schedule.aspx</A>&nbsp;</P>
<P>I hope to see many of you there!</P>
<P><FONT color=#ff00ff size=4>~Kalen</FONT></P>