BCP

BCP out

Learn how to BCP data out of a table.

· Size: 8,698 KB

· Length: 17:04

BCP in

Learn how to BCP data into a table.

· Size: 4,056 KB

· Length: 5:15

BCP in errors

Learn how to diagnose BCP import problems.

· Size: 17,805 KB

· Length: 17:48

BCP With Hyperbac

Here I show you how to automatically compress BCP operations with Hyperbac.  It’s just a cool bonus you get when you do you database backups with this utility.

· Size: 12,461 KB

· Length: 9:57

Perfmon

Windows Performance Monitoring: Part 1

This is a nice video that discusses the basics of performance monitoring in windows.  This is actually a live class that I taught to a group of developer/admins and just decided to record it.  We got cut off there at the end for time, but the next version is coming soon.  There’s a lot of stuff on perfmon counters, Task Manager, command line tools for monitoring and killing tasks, loading and unloading perfmon counters, etc.  There’s lots of good stuff in here.

· Size: 98,355 KB

· Length: 1:17:05

Windows Performance Monitoring: Part 2

This is the continuation of the live presentation I did a couple weeks ago.  This one covers disk counters, memory architecture, and counters.

· Size: 63,101 KB

· Length: 1:04:00

Schemas

Introduction to Schemas

This is an excellent video that explains what schemas are and why you should care.

· Size: 7,736 KB

· Length: 7:45

Other

Trace Flag 1807

This one covers restore with move syntax to restore DBs while moving the files to a different location.

· Size: 15,241 KB

· Length: 8:28

When did SQL start?

Find out 2 ways to tell when SQL Server started.

· Size: 26,030 KB

· Length: 7:21

sp_HelpIndex Shortcut

There's a nifty keyboard shortcut to help you with things like sp_helpindex. It works with many SPs so have fun.

· Size: 9,651 KB

· Length: 6:18

Moving DB Files

Moving database files is easy, but misunderstood. Here I'll show you how to move user DB files using 2 methods.

· Size: 37,644 KB

· Length: 17:34

Interpreting Disk Queues

Disk queues are a mystery for the majority of DBAs.  They may know that they need to look at them, but they have no idea what they mean.  Here I’ll show you how to know what you’re looking at to see when your disk queues are too high.  This tutorial doesn’t go into how to fix the problem really, it’s more just how to diagnose it. 

· Size: 9,175 KB

· Length: 9:43

Running Websites with AD Accounts

This is an excellent tutorial on how to run a website under a specific AD account so you can use windows authentication in the database.  This is a common request and now I’m showing you how to do it start to finish.

· Size: 33,798 KB

· Length: 12:59

Find Log Space Used

Find out how to query the log space usage for all DBs on the server with a single statement.  This is a quick way to get the % of log space used and even program against the results.

· Size: 2,269 KB

· Length: 2:04

Using ServerProperty 

Here I show you the benefit of using ServerProperty() instead of @@Version to find the version of SQL Server you’re on.

· Size: 7,622 KB

· Length: 8:32

RunAs Magic

This is a really good video on how to use the RunAs utility in windows.  There are several scenarios when a DBA/Dev may need to logon to a program with separate credentials and this takes you a good way to getting there.  The process is simple, but it comes with some caveats.  I don’t even come close to discussing the whole topic here but like I said, it’s an excellent start that takes you past the basics of the right-click.

· Size: 47,845 KB

· Length: 23:58

Select Into with Identity()  

This video shows you how to use the Identity() function to create an identity column on the fly during a select into statement.

You don’t have to settle for Alter Table anymore.

· Size: 10,371 KB

· Length: 5:27

Powershell

PowerShell Basics

Here I start the first in an exciting new series of vids on PowerShell both in Windows and SQL.  I go over how to download PowerShell and some of the command basics.  It’s just an intro so

I’ll get into specific tasks in later vids.

· Size: 32,050 KB

· Length: 20:24

Scripting DB Objects in PowerShell

Continuing with PowerShell I thought I’d show you something really cool you can do that would make a difference in your shop right away. 

So here I’m showing you how to script your tables, etc in PowerShell so you can automate them and add them to your processes.  This is an excellent example of

how cool and useful this scripting language is.  I hope it makes you as excited about PowerShell as it does me.