Help keep your command code organized by splatting parameters. Continue reading “Microsoft SQL Server – Powershell Splatting”
Tag: Enterprise Administration
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 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”
Regex: Removing Restore Statement Dupes
This is a great video to show you how to think in a way that gets you a good regex. Here I’ve got SQL Continue reading “Regex: Removing Restore Statement Dupes”
Replication: Initialize with Backup
Sometimes your DB is so big you need to initialize replication with a backup and restore instead of a snapshot. Here I show you Continue reading “Replication: Initialize with Backup”
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”
Server Properties
Have you ever wanted to be able to view instance-level stats or change certain values without having to use the GUI? Here I’ll show Continue reading “Server Properties”
Best Backup Class Evar: 3 of 6
The 3rd in the backup class at NTSSUG.
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”
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”
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?
Minion Backup: BackupRestoreDB
We’ve got some great new functionality in 1.3 for restoring DBs. Here I tell you what you need to know.
Katmai Server Group Management
Learn how to use the new group server mgmt functionality in the Katmai SSMS.
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”
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”
Inline Tokens
This is a great new feature of MB 1.3. It allows you to have dynamic paths and filenames for your backups. Here, I Continue reading “Inline Tokens”
Who is MinionWare?
Who is MinionWare Software? Here we explain the core of our product line and give you a short demo of a couple cool features.
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”
The Enterprise Maintenance Lifecycle: Problems & Solutions
Database maintenance isn’t a single event; it’s a lifecycle. Aside from the maintenance event itself, there’s also reporting, error management, specialized configs, HA/DR and more. Continue reading “The Enterprise Maintenance Lifecycle: Problems & Solutions”
Change Excel Delimiter
Description
Minion Backup: Dynamic Parts
Minion Backup 1.3 has a fabulous new feature: Dynamic Parts. This allows you to have unprecedented control over your paths and filenames.
Minion Backup: Backup ResourceDB
The ResourceDB in SQL Server doesn’t backup like regular DBs. Come see how to do this in Minion Backup 1.2 and below.
Minion Enterprise: User Scripting and Cloning
In this ME talk, we show off Minion Enterprise’s security audit and control features: login collections, Active Directory group expansion, sysadmin audits, and most impressively, Continue reading “Minion Enterprise: User Scripting and Cloning”
Introducing Minion Enterprise
Meet MinionWare and its flagship product, Minion Enterprise: the first SQL Server management solution. Here you’ll get a quick introduction and demonstration of the power Continue reading “Introducing Minion Enterprise”
Minion Enterprise Talk: Managing Backups
In our monthly series about Minion Enterprise, we show you how ME can help you with your database enterprise. Specifically, this month we show off Continue reading “Minion Enterprise Talk: Managing Backups”
Minion Enterprise Talk: Managing and Projecting Disk Space with ME
In our monthly series about Minion Enterprise, we show you how ME can help you with your database enterprise. In this session, we show Continue reading “Minion Enterprise Talk: Managing and Projecting Disk Space with ME”
Private video
This video is private.
Minion Enterprise Talk: Passing Your Security Audits
In the first of a monthly series about Minion Enterprise, we will show you how ME can help you pass your security audits, AND how Continue reading “Minion Enterprise Talk: Passing Your Security Audits”
Minion Enterprise: Introduction to ME Webinar
In this demo, we take a look at Minion Enterprise, our SQL Server management solution! We briefly introduce you to the key principles we used Continue reading “Minion Enterprise: Introduction to ME Webinar”
Minion Enterprise: Active Directory Group Expansion
What users are in this Windows group? We have solved this question. In this demo, we show you the SQL Server login and Active Directory Continue reading “Minion Enterprise: Active Directory Group Expansion”
Minion Backup: Shrinking Logs
When logs get too large because of large transactions or missed backups it can cause issues in your environment. And the DBA usually has to Continue reading “Minion Backup: Shrinking Logs”
Minion Backup: Striping Backup Files
Striping backups is an important step in tuning your backups so they run nice and fast. MB makes it so easy to have specialized configurations Continue reading “Minion Backup: Striping Backup Files”
Minion Backup: Include / Exclude Databases
MB has a few ways to include and exclude databases from the backup process. Here I walk you through the nuances of this feature. Some Continue reading “Minion Backup: Include / Exclude Databases”
Minion Backup: Status Monitor
We consider this one of our flagship features. The status of the current backup and of the entire job is updated in the log. You Continue reading “Minion Backup: Status Monitor”
Minion Backup: Server Labels
Server labels are one of our great high availability features. This feature allows you to organize Availability Group backups as well as mirroring, log shipping, Continue reading “Minion Backup: Server Labels”
Minion Backup: Replacing Diff Actions
Some DBs are too small to need a differential backup. MB makes it really easy to supply different actions in these situations. You can have Continue reading “Minion Backup: Replacing Diff Actions”
Minion Backup: Path Basics
One of the coolest aspects of MB is how it handles your backup paths. There are some really cool options for configuration and it even Continue reading “Minion Backup: Path Basics”
Minion Backup: File Actions
This is an important feature. MB allows you to copy or move your backup files after you take the backup. There are some pretty cool Continue reading “Minion Backup: File Actions”
Minion Backup: Mirroring Backups
Mirroring backups is not only easy it’s very flexible. Here I’ll show you the ins and outs of setting up and managing mirrored backups.
Download Minion Continue reading “Minion Backup: Mirroring Backups”
Minion Backup: Tuning Threshold Basics
One of Minion Backup’s most incredible features is its dynamic tuning. Here I talk about threshold basics and how to configure the settings to do Continue reading “Minion Backup: Tuning Threshold Basics”
Minion Backup: Encrypted Backups
SQL Server 2014 and above has native backup encryption and this is fully supported by Minion Backup. Here I’ll show you how to setup and Continue reading “Minion Backup: Encrypted Backups”
Minion Backup: Azure Backups
Here I show you how to setup backups to Azure blobs. This is an end to end video and I show you from both the Continue reading “Minion Backup: Azure Backups”
Minion Backup: Advanced Tuning Thresholds
Here I show you how to configure MB backup thresholds using the advanced options. If you’re going to get it right you need to watch Continue reading “Minion Backup: Advanced Tuning Thresholds”
Minion Backup: Certificate Backups
Minion Backup will automatically backup your server-level and database-level certificates. Here I’ll show you what you need to know to be successful with this feature.
Download Continue reading “Minion Backup: Certificate Backups”