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.

Here's the vid.

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.

Here's the vid.

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.

 Here's the vid.

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. 

Here's the vid.

This is another excellent video that shows the power of powershell in SQL administration.  I love this video because it’s a very common scenario and keeps you from writing a SQL cursor.  This is one of my favorites.

Here's the vid.

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.

Here's the vid.

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.

Here's the vid.

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.

Here's the vid.

This is a beautiful bit of script that allows you to set DB permissions for a user.  This is particularly useful for adding a user to multiple DBs on the server.  And the code to accomplish this is much shorter than its T-SQL counterpart.  If you need a bit more explanation about how this is put together then look at the video for granting schema permissions with Powershell.

 Here's the vid.

I’m going over the basics of how to implement data compression here.  I’m not really touching on where and why you’d want to do it, but how to once you’ve made the decision.

Here's the vid.