Ok, we had the drawing for the SQL Server 2008 Internals ebook.

Come watch the vid to see if you won.

So thanks for playing guys and we'll see you next time.

Sean and Jen.

Hey everybody... I've just completed the drawing for the winner of the 70-433 Training Kit from MSPress.

Click here to see if you won.

 Thanks for playing, and we'll do another again soon.

--Sean and Jen.

OK, we have a winner for the Windows Internals book.

Watch the drawing vid to see if your name was drawn.

Thanks to everyone who played.  We'll have another one soon.

Sean and Jen.

Here’s a quick talk on relational multiplication that gets us to take a closer look at what our  joins are really doing.

Here's the vid.

Here we discuss relational division, the counterpart to relational multiplication (cross joins).  We’ll hit a couple of examples, using subqueries to implement two different kinds of set division.

 Here's the vid.

This is a continuation of the class at the NTSSUG.  These are being held once a month before the main user group meeting.

This class went much smoother than the first one.  I start out with my top 10 list of how powershell is better than your wife,

and I end with my top 10 list of how powershell is better than your husband.  And somewhere in the middle there, we get to some scripting.

Here's the vid.

This is a live class I gave at the NTSSUG (North Texas SQL Server User Group).

Let me just say now that it was a disaster from the start.  My laptop wouldn’t  work with the projector so

I had to use someone else’s box at the last minute so I hadn’t tested my demos on that box and to top things off,

the guy who was supposed to speak after me wasn’t ready so I had to go completely without a script for over an hour so I got into some things

I wasn’t prepared for.  That said, it’s still a decent class and will give you an idea of powershell.

But it was definitely one of those nights when I was initially thrown by problems in the beginning and never got back on track.

Here's the vid.

Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect.

Using telnet you can tell pretty clearly whether or not the access is being blocked by the firewall or not.

One thing I didn’t mention in the video is that this works for all DBs and not just SQL Server.

And again, you have to verify that the server is actively accepting connections.  But this is a really good way

to determine whether the firewall is blocking access or not.

Here's the vid.

Here I show you how to trouble a DB connection issue to eliminate the firewall as a suspect.

Using telnet you can tell pretty clearly whether or not the access is being blocked by the firewall or not.

One thing I didn’t mention in the video is that this works for all DBs and not just SQL Server.

And again, you have to verify that the server is actively accepting connections.  But this is a really good way

to determine whether the firewall is blocking access or not.

Here's the vid.

Continuing with schemas, here I talk about ownership chaining and how schema ownership effects them.

I start with the basics of chaining and then get into the meat of the topic right after that.

 Here's the vid.