I didn't either. Started reading on this subject and my head began hurting. Keep Advil nearby.

Welcome back, ., and thanks for the advice and congrats. 🙂

I'd recommend you study with SQL Server 2008 right now. SQL Server 2005 has been out for almost 4 years, nearly half it's life cycle. While there will likely be...

I agree on the DVR. I rarely watch anything live, including sports. I'll start recording, watch a little, can pause and go off with life. Come back later.

I enjoyed Star...

The firewall is a Vista thing. Check the control panel, Firewall. Be sure that it allows SQL Server or 1433, 1434 through.

Cathy,

There's also a Forcibly Shrink the log script here [/url]on the site that will run a few transactions and shrink the log. It repeats this to clear out VLFs and...

I'd suggest you reformat the query as Bryan has, but use aliases for the tables. It will make it much easier to read.

Then if you can't get it, explain more...

Also, if there's something specific you are wondering about, let me know. I've written some updates from past summits, but I'm not sure I'm capturing the event. My blog here...

This is my first time to Connections, so I can't answer. You might ping Brad McGehee from his blog and ask him.

I think that most conferences have a lot of...

ApexDiff should allow you do generate a script you can give to people. SQLCompare does.

The restore should allow you to restore to a different name and path with the MOVE...

Be sure you allow remote connections. This is disabled by default in some places.

Also, check the firewall. That would be my guess that it's preventing TCP 1433 from coming through.

I'd really recommend you look at one of the compare tools out there. I work for Red Gate, but ApexSQL and other companies have similar tools.

It's not that this is...

They do repeat some popular sessions at PASS on the last day, but no guarentee they'll be the ones you want. They record all sessions, and they offer some online...

Very strange. I might look at the Process utility from sysinternals and see if you can get some clue about process might be stuck there.

I'd be curious to know what you decide to do and why. It's a good debate, and others can learn from this. If you have a blog, post it there...