PowerShell

The requirement is to implement a quick method to find current executing queries on any SQL Server instance. There are times when you need to quickly check an instance, but it takes time to connect using SSMS so this tip shows a quick and simple way to ch

In this tip we will see what's new in PowerShell for SQL Server Agent jobs and explore some of the new cmdlets related with SQL Server Agent.

Check out this PowerShell tip that let's you generate scripts for all databases and all objects.

In SQL Server 2016 there are some significant changes along with new PowerShell cmdlets and in this tip we will explore a few of these new PowerShell cmdlets.

Use PowerShell to determine the number DML operations (insert, update, delete, truncate, drop, etc.) in SQL Server scripts.

This tip includes PowerShell scripts to update SQL Server Agent Job and SQL Server database owners across the entire instance to standardize and fix ownership issues.

When using PowerShell it is helpful to restrict parameter values to ensure proper values are being passed. Check out this tip to learn about ValidateSet and ValidatePattern.

When working with databases, sometimes there is a need to remove all data inside the database, but doing so is not always that easy. Read this tip to learn how using PowerShell.

Learn how to validate integer, string, file path, etc. input parameters in PowerShell as well as see how to test for invalid parameters.

Learn how to limit time ranges in PowerShell by year, month, day of week, day of year, hour, minute and second with examples.

One question I get asked a lot is where I run PowerShell scripts. In this tip we look at various ways a PowerShell script can be run.

Unfortunately the SQL Server Agent error logging can be deceiving for job steps when you run PowerShell scripts. In this tip I explain how I setup my SQL Agent jobs to get correct error messaging from my PowerShell scripts.

In this tip we look at how to export Active Directory data that can be used to populate a SQL table or other system.

Read this tip to learn how to use PowerShell to collect VLF (virtual log file) counts for all databases on all SQL servers.

Learn how to find invalid views in a SQL Server database using this PowerShell script.

Learn how to handle certain PowerShell connection issues when connecting to SQL Server.

Improve SMO performance when using PowerShell scripts by invoking server.SetDefaultInitFields.

Using text files for configurations can be especially useful in some environments, to avoid re-use or long arrays with many elements in them. Can we use PowerShell with a configuration text file, where we could extract the contents of the file and then us

In our quest to standardize SQL Server installs, one of the things we need to alter are the SQL Server Agent settings for Maximum History Rows (MaximumHistoryRows) and Maximum Job History Rows (MaximumJobHistoryRows). These settings determine how much jo

One of the most popular questions I've been asked relates to how we look at data. Most are derivatives of the question, What are some other ways I can look at these data, whether that's in the form of other dimensions, correlations, comparable data sets

I have a need to run the same processes on multiple SQL Servers and I want to use PowerShell, but I also want to pass in values from a configuration table to make this dynamic. In this tip we will look at an example of using PowerShell with configuration

In my daily work as a SQL Server DBA, there are many times I want to do things in parallel, for example: I have a weekly full backup job for multiple big databases on a server, each job step doing one full backup of one database. However due to the size

I maintain different SQL Server environments by version and was curious if you had any useful approaches to automating and obtaining scripts depending on the version of SQL Server. In this tip we show how to use PowerShell to help identify what scripts t

If you keep track of your SQL Server instances disk space, you may well be aware that the out-of-the-box procedure xp_fixeddrives, but this doesn't always provide all the info you need. In this tip we look at using PowerShell to give you more disk informa