Category: Uncategorized

Okay, we’ve posted NINE new videos in the last two weeks: Index Scripting Problems  Find DB Files with Powershell T-SQL: Over() and Partition By Backup File Extensions Pass Params to Scripts (Powershell) Deploy Packages Troubleshoot Missing DB File Troubleshoot SSIS: “Script component cannot build user component” T-SQL:  Find Last Day of Month We also got […]

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.