Other

Red-Gate's Data Generator

A walkthrough of Red-Gate's new data generator tool.

· Size: 24,810 KB

· Length: 11:09

Write Good Dynamic SQL

Here I show you a couple methods for getting around really hard to read dynamic SQL.

· Size: 37,461 KB

· Length: 14:44

Commenting Tribal Knowledge in SPs

There is a lot of tribal knowledge that accumulates in any organization.  Here I discuss some ways to document your SPs so you can start to record some of this information.  Your SPs will be more supportable, easier to update, and you’ll take hours or sometimes days off of a re-design or support effort.  You won’t be sorry you started doing this.

· Size: 25,804 KB

· Length: 27:03

Sending HTML SQL Emails

I’m actually excited to be able to bring you this video because this is a topic that comes up quite often in DBA circles.  The topic is how do you format a nice HTML email that you send through SQL.  Being able to return a query as the body of an email comes in handy all over the place.  I really hope you guys get as much out of this as I do.

· Size: 80,538 KB

· Length: 39:42

Select Into with Identity()

Here I finally address how to connect to SQL Server from powershell proper by adding the SQL Server snapins.  Then I show you how to add them to your profile so you don’t have to add them manually every time you start powershell.

· Size: 18,239 KB

· Length: 8:15

SSIS

SSIS Data Cleansing

Fix data errors with derived cols and conditional split transformations.

· Size: 57,864 KB

· Length: 33:58

SSIS text file errors

Dealing with SSIS txt file errors. You will learn how to properly redirect outputs to maximize your scrubbing efforts.

· Size: 16,403 KB

· Length: 7:47

SSIS Using Variables in Script Tasks

Here I talk about how to setup the script task to work with variables, and how to access them through code once the script can see them.

· Size: 13,732 KB

· Length: 7:11

SSIS Variable Scope

Learn how SSIS scopes variables.  It’s not a complicated topic, but worth covering.

· Size: 7,831 KB

· Length: 4:36

MultiFlatFile Connection Manager

Here I talk about how to use the multiflatfile connection manager in SSIS to loop through flatfiles.

· Size: 17,645 KB

· Length: 6:12

Derived Columns

Here I show you how to work with derived columns in SSIS and use it to not only marry columns, but also troubleshoot data flows.  This is a nice intro to this versatile transform.

· Size: 27,679 KB

· Length: 13:06

Connection strings in Package Config Files

Here I show you how to put your data source connection string inside a package configuration XML file.

This was inspired by a forum post by a user so I decided to make a video for him.

· Size: 21,313 KB

· Length: 7:45

Forcing Package Failures

This one was by user request to show how you can compare the counts of 2 tables and use it to force the package to fail if the counts don’t match.

This comes in handy when comparing the counts of the source and destination tables after your load.  The scenario is specific but can be modified to anything you like. 

· Size: 30,246 KB

· Length: 13:20

Execute SQL Task with Parameters

This video discusses how to pass parameters to queries and SPs inside the Execute SQL Task.  It doesn’t teach the basics of the task.  It assumes you already know how to use it.  This video is only concerned with passing parameters.

· Size: 13,464 KB

· Length: 7:56

Row Count Transform

Here I discuss how to use the row count transform in SSIS and give you some good advice for naming and working with the variable associated with it.

· Size: 25,371 KB

· Length: 11:05

Introduction to ForEach Loops

Here I show you the basics of how to work with ForEach loops.  Good stuff.

· Size: 22,936 KB

· Length: 11:07

Creating Files with ForEach Loop

Here I take the intro one step further and show you how to create multiple txt files based off of a looping variable in the ForEach loop container.

This is a very common task and I see this question quite a bit in the forums, so I documented it.

· Size: 16,120 KB

· Length: 8:29

Introduction to Sequence Containers

This video takes a look at the basics of using the Sequence Container in SSIS.  There’s not a lot to it, but it’s a good intro if you don’t know what it is.

· Size: 18,825 KB

· Length: 6:29

Commenting Tribal Knowledge in SSIS Packages

There is a lot of tribal knowledge that accumulates in any organization.  Here I discuss some ways to document your SSIS packages so you can start to record some of this information.  Your packages will be more supportable, easier to update, and you’ll take hours or sometimes days off of a re-design or support effort.  You won’t be sorry you started doing this.

· Size: 52,224 KB

· Length: 29:24

SSIS Basics

This is a live presentation I gave recently.  Here is a bare bones bottom of the barrel discussion on SSIS.  This is for complete beginners.  I’m explaining in this session, the simplest of basics on SSIS and BIDS.  I give a couple of basics demos.  This is the beginning of what I’ll build on in the next couple sessions as we get deeper into the specifics of this cool product.  So if you know absolutely nothing about SSIS then this is the place for you.

· Size: 100,985 KB

· Length: 1:06:23

SSIS Basics 2: Flatfile Olympics

Here we’re just going to jump into SSIS and do some real practical work.  We’re going to learn all about taking things to/from multiple files.

This is not to be missed because there are some really good concepts here that will carry over to many other tasks in SSIS.  I specifically chose these operations because they teach such a wide variety of skills.

So come learn how to get a gold medal in flatfiles.

· Size: 143,559 KB

· Length: 1:02:15

HTML

Basic HTML for DBAs 

After my last video I got some emails saying that not all DBAs already know HTML.  So I decided to teach some basic HTML

that DBAs can use in their daily jobs.  So if you’re a DBA and you’ve always wanted to tackle HTML, don’t worry… it’s easier than it sounds. 

· Size: 58,231 KB

· Length: 35:35

HTML Styles: Part 1

Here I continue with the HTML basics video by showing you a better way to do styles.  I hinted about this in the basics video so I decided to go ahead and do it.  I’ll show you the ultimate way to do styles in the next one.  All methods have their uses and we’ll get into that sometime too.  For now though, just enjoy learning header styles.

· Size: 36,904 KB

· Length: 16:19