Jen McCown

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.

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.