Well the PASS 2008 summit must be official over as I’m sitting at the airport waiting for my plane. I was expecting a very long security line here at SeaTac but I was through security within maybe 10 minutes. While means that the two hours I was planning on standing in line I instead get to sit at Terminal D3 (after just moving from N11 on the far side of the airport) and wait for my flight to Ontario. I guess the upside is that I got to get some lunch before my flight.
Overall I would have to say that the PASS 2008 summit was a success. I got some good info about SQL Server, and met a lot of people that I either know from forums or who’s writings I’ve been reading for quite a while now. Overall the sessions were very informative, and I know that I got something out of just about every session I attended.
Last night a group of MVPs got together for dinner with our MVP lead. The dinner was a blast with about 30 people attending the dinner. It was on Friday night so a lot of people had already gone home. It was great to be able to sit and chat and relax with other people after the rush of PASS being over.
It was great to meet everyone, as well as say high again to people that I met at PASS 2007, SQL 2008 Launch and other conferences.
There were a couple of people that I didn’t have a chance to run across that I wish I did. Hopefully next year.
See you at PASS 2009 back here in Seattle, Washington.
Today was a pretty slow day. I spent most of the day kicking back in the MVP room talking to the MVPs and the Microsoft folks. I did make it to a couple of sessions however.
Today was another excellent day here at PASS 2008 in rainy Seattle, WA.
The sessions from the first day of PASS were great.
Read on for info about a couple of the sessions.
For those of you lucky enough to make it to PASS, I’ll be seeing you at the Kick Off party tonight at the Welcome Reception in Room 6ABC at the event.
For those who aren’t able to make it, I’ll do my best to keep you up to date on the goings on at the event. There was decent coverage for WiFi last year, I’m assuming that there will be good WiFi coverage this year as well.
For those that weren’t aware, tonight is the Welcome receiption for the PASS Summit in Seattle Washington (the summit actually started on Monday for those who attended the Pre Summit Sessions).
I’ll post as often as I can during the summit.
The nice folks at the Inland Empire .NET User Group have invited me to come and speak to them. This is a great speaking opportunity for me as they are about 20 minutes from my house.
I won’t be speaking there until December 9, 2008 (it’s amazing just how far in advance some of this stuff gets scheduled).
I’ll be giving two presentations at the meeting. The first will be the ever popular Query Tuning, and the second will be a talk on the SQL Server 2008 Resource Governor. The address and directions to the meeting can be found on the IE .NET User Group web site. If you are going to attend there meetings they have an RSVP link on the site.
Microsoft has now released the the majority of the upgrade exams from SQL Server 2005 to SQL Server 2008.
Now, I know that this has absolutely nothing to do with SQL Server, and if you read slashdot this is probably going to be old news for you.
But apparently scientists have taken some pictures which show planets outside of the phones in our solar system.
Here’s a blog about it from BadAstronomy.
This article on Spiegel.de has some great images (it’s in German or Dutch or something) but they have an amazing overlay of images of one of the planets from a few years ago as well as the most recent position, including the track of the planet which I think is just an awsome image. This have another planetary system graphic which shows the HR 8799 system compared to our system (the defination is in English on this one).
If you run across any other images feel free to post links to them below.
Here’s another pic of the planet which orbits Fomalhaut with it’s position from 2004 and 2006.
This is just amazing stuff that we are seeing today.
MSDTC (aka Microsoft Distributed Transaction Control) is a piece of software which a lot of people use, but they don’t really know what it does, or how it works.
MSDTC is used by SQL Server and other applications when they want to make a distributed transaction between more than one machine. A distributed transaction is simple a transactions which spans between two or more machines. The basic concept is that machine 1 starts a transaction, and does some work. It then connects to machine 2 and does some work. The work on machine 2 fails, and is cancled. The work on machine 1 needs to then be rolled back.
DTC is for the most part a black box. It just sort of works without much interaction exept for the initial setup.
The only time that DTC needs to be used is when more than one physical computer is going to be involved in an explicet distributed transaction. If you are going from one instance to another on the same server DTC will not be needed. If you are going from one instance to another within a cluster you will want to have DTC available as you may have to go between nodes of the cluster as you have no guarantee that the instances will be on the same physical node.
I hope this helps explain DTC a little bit at least. If you have specific questions about DTC, feel free to post them below and I’ll try and find the answers for you.