Search results matching tags 'SQL Server 2008' and 'User Groups'

Did You Know? I gave two presentations last week

Kalen Delaney — Mon, 14 Jun 2010 15:05:00 GMT

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: Merrill Aldrich and the infamous Buck Woody.

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 exactly my session would cover. 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 Internals of Compression"… like he was surprised. I guess I'll have to send him a copy of my latest book… SQL Server 2008 Internals. 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. The details are in my book, if you're interested.

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). I'm just passing on this comment, I haven't done enough testing of my own to make a personal recommendation.

The demos have been posted for both the Denver PASS and the SQL Saturday sessions at:
www.sqlserverinternals.com/conferences

~Kalen

Presenting at New England SQL Server User Group!

andyleonard — Thu, 29 Jan 2009 03:35:00 GMT

I am getting psyched about presenting to the New England SQL Server User Group in a couple weeks! On 12 Feb I'll be talking about Incremental Loads, Change Data Capture, and SSIS 2008.

The bonus is I get to hang out with my friend Adam Machanic!

If you read this blog and will be in the area, stop by and say Hi.

:{> Andy

Did You Know? My First Talk on SQL 2008

Kalen Delaney — Thu, 03 Apr 2008 00:13:00 GMT

I gave my first SQL Server 2008 presentation yesterday, and also spoke at a Launch Event for the first time. It was a terrific experience, primarily because it forced me to really start digging into SQL Server 2008. I had been doing so much 2005 training recently, I just really hadn't had a chance to really USE 2008, although I have dutifully installed all the CTPs.

My one-hour talk covered 3 main areas:

Policy-based Management
Performance Studio
Multi-server Management

In my prep the evening before, I had been able to go through the whole thing in about 55 minutes, and I usually end up talking faster when in front of an audience. So figured I had time to show a few extra things in the demos, as well as show off the new ZoomIt presentation tool that I talked about in my previous post.

I have no idea what happened, but I was just barely finished with the first demo, and I looked at the clock and realized 45 minutes had gone by! I have absolutely no idea how that happened, and I would really like to apologize to all the people in the audience for having to deal with me rushing through the Performance Studio demo and not being able to say much at all about Multi-server management. I must have just been having too much fun with policies, but that is really no excuse.

I will be giving the same talk at our local (Puget Sound) .NET Developers Association Meeting on April 21, so if you want to hear the rest of the story, and see the rest of my demos, come on by!

Thanks!

~Kalen