Powershell

Powershell

Script PK/FKs in Powershell

Here I show you how to script out objects that belong to tables like primary keys, forgeign keys, constraints,...

Watch video

Object Properties in Powershell

This is a great video that shows you how to look at the properties collection in objects and explains...

Watch video

Get SQL Server Root Dir in Powershell

Here we’re finding the root install directory for SQL Server.

Watch video

Truncate Tables in Powershell

Here I show you how to truncate a mass of tables in the same schema. Of course, you don’t...

Watch video

Change Schema in Powershell

Changing object schemas is easy enough in T-SQL when it’s a single object, but it get considerably more complicated...

Watch video

Get IP and DNS in Powershell

Getting IP address and DNS info from your servers in a useful format isn’t as straightforward as you would...

Watch video

Calling Detach Methods in Powershell

Detaching DBs in Powershell is pretty easy, which is why you should learn how to do it. It takes...

Watch video

Attach DBs in Powershell

This continues the series on detach/attach for DBs. Along the way I show you how to deal with a...

Watch video

Cycle Error Log on all Servers using Powershell

Here I show you how to use the Carrier Method for using powershell to cycle all your error logs....

Watch video

Drop Tables in Powershell

Today I’m dropping tables based off of a regex expression and by rowcount. Good stuff here. The power of...

Watch video