Help keep your command code organized by splatting parameters. Continue reading “Microsoft SQL Server – Powershell Splatting”
Category: Powershell
Powershell Classes: Part 5 – Inheritance con’t
Here we finish up the discussion on inheritance and we Continue reading “Powershell Classes: Part 5 – Inheritance con’t”
Powershell Classes: Part 3
This is part 3 of our series on how to
create classes in powershell.
We start by going over homework and then get into hidden classes and creating a fire hazard in our code.
Watch Part 1
Watch Part 2
Watch Part 4
Watch Part 5
Classes in Powershell: Part 2
Here I’m continuing my live class in writing classes in powershell. We go over adding some useful properties and developing a help system.
Classes in Powershell: Part 1
Ever want to create your own classes in powershell? Continue reading “Classes in Powershell: Part 1”
Powershell Error Handling Basics 2
Continuing with our discussion on PS error handling.
Watch the first vid here:
Powershell Error Handling Basics
This is a live session where I teach someone the
basics of PS error handling.
Here’s the 1st vid in the series.
Beginning SQL Server SMO
Recently I was invited to talk about beginning SMO on Continue reading “Beginning SQL Server SMO”
Loading SQL Data From Powershell
Learn how to load data into and out of SQL Continue reading “Loading SQL Data From Powershell”
Beginning Powershell for DBAs: Part 1
The time has come where DBAs can no longer afford to ignore Powershell. Not only has it become an integral part of SQL Server, but Continue reading “Beginning Powershell for DBAs: Part 1”
Script PK/FKs in Powershell
Here I show you how to script out objects that belong to tables like primary keys, forgeign keys, constraints, and indexes with powershell. It’s Continue reading “Script PK/FKs in Powershell”
Object Properties in Powershell
This is a great video that shows you how to look at the properties collection in objects and explains what the different properties mean. Continue reading “Object Properties in Powershell”
Get SQL Server Root Dir in Powershell
Here we’re finding the root install directory for SQL Server.
Truncate Tables in Powershell
Here I show you how to truncate a mass of tables in the same schema. Of course, you don’t have to limit it to Continue reading “Truncate Tables in Powershell”
Drop Tables in Powershell
Today I’m dropping tables based off of a regex expression and by rowcount. Good stuff here. The power of the shell shines through Continue reading “Drop Tables in Powershell”
Server Configuration Settings in Powershell
I love making vids on the trickier stuff and this one is it. Here we’re talking about duplicating sp_configure in Powershell. It’s pretty Continue reading “Server Configuration Settings in Powershell”
Change Startup Params in Powershell
I heard someone today say that you can’t change startup parameters in Powershell. So I made this vid to set the record straight.
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. This is an excellent way Continue reading “Cycle Error Log on all Servers using Powershell”
Read SQL Server Error Logs in Powershell
Would you like to work with the SQL Server error logs in Powershell? Well here I’m gonna show you how. Not only do Continue reading “Read SQL Server Error Logs in Powershell”
Change SQL Server Permissions in Powershell: Part 2
Continuing from the 1st video, here I show you how to capture useful errors from the method call. I explain how to Trap the Continue reading “Change SQL Server Permissions in Powershell: Part 2”
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 when you’ve got several objects to Continue reading “Change Schema in Powershell”
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 think. Here I’m going to Continue reading “Get IP and DNS in Powershell”
Calling Detach Methods in Powershell
Detaching DBs in Powershell is pretty easy, which is why you should learn how to do it. It takes less typing than the t-sql Continue reading “Calling Detach Methods in Powershell”
Attach DBs in Powershell
This continues the series on detach/attach for DBs. Along the way I show you how to deal with a powershell provider bug, work with Continue reading “Attach DBs in Powershell”
Replace sp_MSForEachDB with Powershell
A user request came in to write something in powershell that would replace sp_MSForEachDB. I took it a step further and showed you how Continue reading “Replace sp_MSForEachDB with Powershell”
Sum DB Sizes with Powershell
Quite often it can be useful to not only get a list of DB sizes, but also sum it up in the last line. Continue reading “Sum DB Sizes with Powershell”
Audit Service Accounts with Powershell
How would you like to be able to audit your service accounts with powershell so you can tell how many boxes are running on the Continue reading “Audit Service Accounts with Powershell”
Monitor Backups with Powershell
I know you guys are just begging for an easy way to monitor your backups and alert when one hasn’t been backed up recently. Continue reading “Monitor Backups with Powershell”
Start Agent Jobs in Powershell
Starting SQL Agent jobs in powershell is easy, but there’s a trick to it that’s not obvious. Here I’ll show you how to start Continue reading “Start Agent Jobs in Powershell”
Start Agent Jobs in Powershell: Part 2
Starting SQL Agent jobs in powershell part 2.
Manage DB Files in Powershell
I’m excited to be able to film this one because it has the potential to save you so much time and effort. I’m showing Continue reading “Manage DB Files in Powershell”
Get Table Stats with Powershell
Let’s get stats for every table in the DB and put them in a file so we can send them to a customer or view Continue reading “Get Table Stats with Powershell”
Build .Net Objects in Powershell
I just love the topic of this video. Here we show you how to create .NET code with powershell. While we create an Continue reading “Build .Net Objects in Powershell”
Change DB Compatibility Level in Powershell
Here I show you 2 easy ways to change the DB compatibility level in powershell. Otherwise you have to use a T-SQL cursor and Continue reading “Change DB Compatibility Level in Powershell”
Get a Specific Method in Powershell
Sometimes the list of properties and methods is too big to sift through when you do a get-member on an object. Here I’ll show Continue reading “Get a Specific Method in Powershell”
Add User to Windows Group with Powershell
I love this video because it’s so unusual to find something like it in the DBA community. We’re quite often called on to do Continue reading “Add User to Windows Group with Powershell”
Replace Text in File
Here I show you how to replace a given string in a file and either write it back to the same file, or write the Continue reading “Replace Text in File”
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.
Beginning Powershell for DBAs 4
Here I continue with the 4th class in the series at the NTSSUG user group.
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.
Pass Params to Scripts (Powershell)
Wanna know how to pass parameters to scripts, and when to use each method?
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 Continue reading “Building a Powershell BCP Routine”
Beginning Powershell for DBAs 1
This is an excellent video that explains what schemas are and why you should care.
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 Continue reading “PowerShell Basics”
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 Continue reading “Scripting DB Objects in PowerShell”
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 Continue reading “Scripting DB Objects in Powershell (Advanced Topics)”
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 Continue reading “Working with PSDrive in PowerShell”
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 Continue reading “Powershell with –NoExit”
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 Continue reading “Grant DB Permissions”
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 Continue reading “Grant Schema Permissions in Powershell”
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 Continue reading “Powershell Profiles”
Beginning Powershell for DBAs 2
This is the 2nd video in the schema series. Here I give you a really good reason to adopt schemas in your architectures. Hope Continue reading “Beginning Powershell for DBAs 2”
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 Continue reading “Change SQL Server Job Owner”
Beginning Programming with Powershell
Have you ever wanted to learn how to code, but you don’t think you have enough knowledge to jump into a class? In this Continue reading “Beginning Programming with Powershell”