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.

· Size: 49,748 KB

· Length: 21:44

Scripting DB Objects in Powershell (Advanced Topics)

Here I get past the basics of using the Script() method and take you to how to recreate some of the scripts you can create in SSMS by instantiating a scriptingOptions object and passing it to the method. 

· Size: 52, 397 KB

· Length: 19:55

Working with PSDrive in PowerShell

Here I go over what PSDrive is and how to work with it.  I also go into aliases again as well as how to find help in powershell. 

We’re still covering important basics here because I can write scripts for you all day long, but you’ll never go far unless you can understand them yourself.

· Size: 28,284 KB

· Length: 13:33

Powershell with –NoExit

Here I show you how to get around the problem of your Powershell window closing down when you call it from either the run window or from other programs.  If you get errors or want to see something that was printed on the screen it’s quite often impossible unless you startup PowerShell or dos first.  This way you can call your scripts in a way that allows you to see the results no matter what.  It’s a very simple technique, but very useful.

· Size: 19,331 KB

· Length: 5:13

Change SQL Server Job Owner

This is a really cool method for changing SQL job owners or any job property I would imagine.  It really simplifies it from using SQL syntax.  So learn this method and it’ll be your friend for years to come.

· Size: 30,723 KB

· Length: 18:28

Grant DB Permissions

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.

· Size: 18,824 KB

· Length: 9:28

Grant Schema Permissions in Powershell

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.

· Size: 48,716 KB

· Length: 17:51

Building a Powershell BCP Routine

Here I show you how to build a script that will BCP an entire group of tables and even log the progress.  You can make the routine as simple or as rich as you like.  These are the building blocks of such a process and will take you far in your endeavors.  There are several techniques taught in this video so pay attention to the details and you’ll come away with a richer knowledge of powershell.

· Size: 58,428 KB

· Length: 31:21

Powershell Profiles

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

Pass Params to Scripts (Powershell)

Wanna know how to pass parameters to scripts, and when to use each method?

· Size: 10,789 KB

· Length: 7:46

Find DB Files with Powershell

Here I need to find the .MDF for a database so I can attach it, but I have no idea where the .MDF is.

So I use powershell to get the answer in just a few secs.

· Size: 3,196 KB

· Length: 2:10

Index Scripting Problems

This is just a fun vid.  Again, we're sitting here late at night feeling a little punchy so we're a little goofier than usual.

Still we manage go show you some really nice troubleshooting on 2 specific problems that come up all the time when you're scripting

something like this.  We're trying to script all the indexes in a DB.  Watch while we troubleshoot the issues live and get the script working.

· Size: 67,727 KB

· Length: 21:59

Beginning PowerShell for DBAs

Beginning Powershell for DBAs 1

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

· Size: 136,803 KB

· Length: 1:27:38

Beginning Powershell for DBAs 2

This is the 2^nd video in the schema series.  Here I give you a really good reason to adopt schemas in your architectures.

Hope you enjoy.

· Size: 42,193 KB

· Length: 38:33

Beginning Powershell for DBAs 3

Coming soon.

Beginning Powershell for DBAs 4

Coming soon.

Beginning Powershell for DBAs 5

Coming soon.

Beginning Powershell for DBAs 6

Coming soon.