TSQL

Relational Division

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.

· Size: 37,104 KB

· Length: 19:41

Relational Multiplication

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

· Size: 13,948 KB

· Length: 10:51

T-SQL:  Find Last Day of Month

Follow Jen as she steps you through 3 progressively elegant solutions for finding the last day of the month.

· Size: 44,649 KB

· Length 22:03

T-SQL: Over() and Partition By

Show how to use OVER and PARTITION BY to get groups of data with aggregation

Reference: SQLTeam.com has a nice step by step exercise here: Using OVER() With Aggregate Functions

· Size: 7,940 KB

· Length 4:16

Setup Server-Side Trace

I go over the difference between client side and server side traces, the benefits, and how to set up, edit, run, and stop a server side trace. 

· Size: 44,909 KB

· Length 13:45

Insert Non-duplicate Rows

Here we work our way through a coding scenario—inserting rows—that should illustrate the process of solving a problem from the simplest case to your intended result.

· Size: 44,909 KB

· Length 11:53

T-SQL: CASE Statement

Here’s an intro to case statements, in the form of a conversation with Sean.  I cover simple case and searched case, and the special use of null.  BTW, I really like this video, and I don’t say that very often.

· Size: 24,096 KB

· Length 11:44

Grouping Basics: Level Zero

Here’s a ground level intro to grouping, with a lovely 80s arcade theme.  This is a reshoot of the original Grouping Basics video (now retired).

· Size: 24,818 KB

· Length 10:01

Dirty Tricks:  List from CMD

Here’s one of my dirty tricks: getting a list of folders or files from a command prompt, and formatting it for use in code using  Word. This is the extended remix version of a Midnight Snack.

· Size: 10,348 KB

· Length 6:41

Troubleshooting Simple Flatfile Load Errors

In this video I put together a small SSIS flatfile-to-SQL package, and troubleshoot a couple of errors.

· Size: 34,048 KB

· Length 11:23