PowerShell Tips

Solve your SQL Server PowerShell issues with these valuable tips, tutorials, how-to's, scripts, and more for SQL Server DBAs.

SubCategory Tip Title Author
Administration Complete Common SQL Server Database Administration Tasks In Parallel with PowerShell V3 WorkFlow Jeffrey Yao
Administration One Line PowerShell Solutions To Common SQL Server DBA Tasks Jeffrey Yao
Analysis Services PowerShell for SQL Server Analysis Services Multidimensional Aaron Nelson
Analysis Services Using PowerShell for SQL Server Analysis Services tasks - Part 1 Daniel Calbimonte
Auditing Get Total Line Counts for all SQL Server Source Objects Using PowerShell Jeffrey Yao
Backups Backup SQL Server Databases in Parallel with PowerShell Pablo Echeverria
Backups Backup SQL Server Databases with a Windows PowerShell Script Edwin Sarmiento
Backups Check the Last SQL Server Backup Date using Windows PowerShell Edwin Sarmiento
Backups PowerShell changes for database backups in SQL Server 2012 Shawn Melton
Backups Retrieve Default SQL Server Backup Folder using PowerShell Edwin Sarmiento
Backups SQL Server Backup Testing and Verification Alejandro Cobar
Backups Using PowerShell for SQL Server Database Backups Shawn Melton
Backups Using PowerShell for SQL Server Transaction Log Backups Shawn Melton
Calculations PowerShell and Object-Level Math Functions Tim Smith
Comparison Invoke Nz Powershell script similar to Nz VBA function Chad Boyd
Comparison Using PowerShell to Check or Compare Values Tim Smith
Configuration Enable PowerShell on Windows Server 2008 R2 Core Edition Manvendra Singh
Configuration Enable Powershell Remoting on SQL Server Instances Manvendra Singh
Configuration How to Modify the Global DNS Configuration on Servers Using PowerShell Daniel Farina
Configuration Reading Text Files With PowerShell For Configurations Part I Tim Smith
Configuration Setting the PowerShell Execution Policy Jugal Shah
Connections PowerShell and ADO.NET Connection String Settings for SQL Server Tim Smith
Connectivity SQL Server Database Connectivity Testing Using PowerShell John Grover
Data Consider New Ideas for SQL Server Data Analysis Tim Smith
Data Getting the Count of Non-Null Values in a SQL Server Table with PowerShell Tim Smith
Data PowerShell Invoke-SQLCmd outputs DataTables you can INSERT into SQL Server Aaron Nelson
Data Pre-validating Data in Delimited Files with PowerShell Prior to Importing to SQL Server Tim Smith
Data Mining Video on Text Mining SQL Server Data Using PowerShell Tim Smith
Database Create SQL Server Database with PowerShell Joe Gavin
Database Configurations Generating SQL Scripts using Windows PowerShell Edwin Sarmiento
Database Configurations Retrieve a List of SQL Server Databases and their Properties using PowerShell Edwin Sarmiento
Date Range Limit Time Ranges In PowerShell for Calculations Tim Smith
DBCC CHECKDB Check SQL Server Database Consistency and Backups Without Impacting Performance Richard Vantrease
Delete PowerShell Script to Delete All Data in a SQL Server Database Jeffrey Yao
Deployment Deploy Database Objects to Multiple SQL Server Instances Using PowerShell Alejandro Cobar
Deployment Use PowerShell to Determine the number DML operations in SQL Server Scripts Tim Smith
Development Develop and Debug PowerShell Scripts with MyInvocation Tim Smith
Development Iterating through SQL Servers and database objects with PowerShell Diana Moldovan
Development Using Nested Switch Statements In PowerShell Tim Smith
Dynamic Using PowerShell With Configuration Tables in SQL Server Tim Smith
Error Handling Error handling with try-catch-finally in PowerShell for SQL Server Diana Moldovan
Error Handling Introduction into handling errors in PowerShell for SQL Server tasks Diana Moldovan
Error Handling Options For Reporting Errors In Catch Statements Using PowerShell Tim Smith
Error Handling Try Catch Finally with PowerShell Chad Boyd
Error Handling Using PowerShell to access event logs for SQL Server Manvendra Singh
Export Create File with Content Using PowerShell Tim Smith
Features New Features and Best Practices of SQL Server PowerShell Aaron Nelson
File System 6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers Tim Smith
File System Getting Started with PowerShell File Properties and Methods Tim Smith
File System Parsing all the files in a directory using PowerShell K. Brian Kelley
File System PowerShell Module to Read Directory Contents and Store in a SQL Server Table Nisarg Upadhyay
File System PowerShell script to find files that are consuming the most disk space Jugal Shah
File System PowerShell Scripts for Obtaining File Metadata Tim Smith
File System Rename and Move a File with PowerShell in a SQL Server Agent Job Tim Smith
File System SQL Server Video to Rename and Move a File using PowerShell Tim Smith
File System Using a PowerShell Script to delete old files for SQL Server Jugal Shah
File System Using PowerShell to Encode Files Tim Smith
File System Using PowerShell to Work with Directories and Files John Miner
File System Video of 6 Useful PowerShell Scripts to Help SQL Server DBAs and Developers Tim Smith
Foreign Keys Drop and Re-Create All Foreign Key Constraints in a SQL Server database using PowerShell Johan Bijnens
Free Space Find Drives with Low Disk Space for all SQL Server Instances using PowerShell Pablo Echeverria
Free Space Monitor SQL Server Disk Space Using PowerShell Richard Vantrease
Functions Verify File Exists Using PowerShell Tim Smith
Import and Export Extract and convert all Excel worksheets into CSV files using PowerShell Tim Smith
Import and Export Extracting API Data Using PowerShell and Loading into SQL Server Tim Smith
Import and Export SQL Server Video Automating Flat File Imports using PowerShell Tim Smith
Import and Export SQL Server Video to Extract All Excel Worksheets into individual CSV files Tim Smith
Import and Export SQL Server Video Validate File Properties Prior to Importing Data Tim Smith
Integration Services Execute SSIS Package from Catalog with PowerShell - Part 2 Koen Verbeeck
Integration Services Execute SSIS Package from PowerShell - Part 1 Koen Verbeeck
Integration Services Execute SSIS Package in Cloud and Package Deployment Model with PowerShell - Part 3 Koen Verbeeck
Logins Add, Remove, and Get SQL Logins, New SQL PowerShell 2016 cmdlets Aaron Nelson
Monitoring Find current running SQL Server queries with a PowerShell script Eli Leiba
Monitoring Monitor a SQL Server Cluster using PowerShell Ben Snaidero
Multi Server Query Multiple Azure SQL Databases and Save Results Centrally Jim Evans
Oracle Bulk Copy Data from Oracle to SQL Server Jeffrey Yao
Overview Introducing PowerShell V2 Remoting for SQL Server Diana Moldovan
Overview Introduction to Windows PowerShell for the SQL Server DBA Part 1 Edwin Sarmiento
Overview Introduction to Windows PowerShell for the SQL Server DBA Part 2 Edwin Sarmiento
Overview PowerShell changes and new cmdlets for SQL Server 2016 Rajendra Gupta
Overview PowerShell Support in SQL Server 2008 with the Invoke Sqlcmd Cmdlet Ray Barley
Overview Using PowerShell with SQL Server Management Objects (SMO) Edwin Sarmiento
Performance Improve PowerShell SMO Performance for SQL Server Diana Moldovan
Permissions Update SQL Server Agent Job owner and Database owner with PowerShell Tim Smith
Processes Handling Windows Processes using Windows PowerShell for SQL Server Manvendra Singh
Restore PowerShell to automate multiple database SQL Server restores to refresh environments Jeffrey Yao
Restore Restore-SqlDb Automate a SQL Server Database Restore improved with Powershell Chad Boyd
Scheduling 4 Convenient Ways To Run PowerShell Scripts Tim Smith
Scheduling Run PowerShell Scripts with SQL Server Agent or Windows Task Scheduler Alejandro Cobar
Scheduling Scheduling a SQL Server PowerShell script using the Task Scheduler Diana Moldovan
Scripts Executing scripts on multiple servers by SQL Server version and edition using PowerShell Tim Smith
Scripts Generate T-SQL Scripts for all SQL Server Databases and all Objects using PowerShell Angel Gomez
Scripts How to Query Arrays, Hash Tables and Strings with PowerShell Tim Smith
Scripts PowerShell and Hash Table Examples Tim Smith
Scripts PowerShell Script to Parse HTML Code with SQL Server Build Numbers Alejandro Cobar
Scripts Using PowerShell to export Active Directory information Douglas Correa
Security Connect to SQL Server via Windows PowerShell with SQL Server authentication Edwin Sarmiento
Servers Find SQL Server Instances Across Your Network Using Windows PowerShell Edwin Sarmiento
Servers Using PowerShell to Pull SQL Server Services Configuration Information Shawn Melton
Services Controlling Windows and SQL Server Services using Windows PowerShell Manvendra Singh
SQL Server Agent Checking SQL Server Agent jobs using Windows PowerShell Edwin Sarmiento
SQL Server Agent Disable or Enable SQL Server Agent Jobs using PowerShell Edwin Sarmiento
SQL Server Agent Modifying SQL Server Agent Settings Using PowerShell Johan Bijnens
SQL Server Agent SQL Server 2016 PowerShell cmdlets for SQL Agent Rajendra Gupta
SQL Server Agent SQL Server Agent Error Logging for Powershell Job Steps Diana Moldovan
Storage Drive inventory for clustered SQL Server instances using PowerShell Johan Bijnens
Stored Procedures Call SQL Server Stored Procedures with PowerShell using Parameter Objects Tim Smith
Stored Procedures Execute SQL Server Stored Procedures from PowerShell Tim Smith
Strings How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger Jeffrey Yao
Strings Parsing Strings From Delimiters In PowerShell Tim Smith
Strings PowerShell and T-SQL Regular Expression Examples for SQL Server Tim Smith
Strings PowerShell Regular Expression (RegEx) Video Examples for SQL Server Tim Smith
Strings Removing HTML tags from text data using PowerShell Diana Moldovan
Tables New PowerShell cmdlets to read and write SQL Server tables Rajendra Gupta
Text Files Processing text files with PowerShell John Miner
Transaction Logs Check SQL Server Virtual Log Files Using PowerShell Edwin Sarmiento
Transaction Logs Determine Minimum Possible Size to Shrink the SQL Server Transaction Log File Edwin Sarmiento
Transaction Logs Using PowerShell To Record SQL Server Virtual Log File (VLF) Growth Tim Smith
Troubleshooting Debugging PowerShell Scripts Tim Smith
Tutorials PowerShell Commands for SQL Server – Getting Started Alejandro Cobar
Tutorials PowerShell for the DBA - Basic Functions Alejandro Cobar
Tutorials PowerShell for the DBA - CMDLETs and Advanced Functions Alejandro Cobar
Tutorials PowerShell for the DBA - If Else and Switch statements Alejandro Cobar
Tutorials PowerShell for the DBA - Performing DBA tasks using SQL Server CMDLETs Alejandro Cobar
Tutorials PowerShell for the DBA – FOR and WHILE Loops Alejandro Cobar
Tutorials PowerShell for the SQL Server DBA - Pipelines Alejandro Cobar
Tutorials PowerShell for the SQL Server DBA - Variable Fundamentals Alejandro Cobar
Tutorials PowerShell for the SQL Server DBA – Environment Setup Alejandro Cobar
Variables PowerShell Parameters Part II - ValidateSet and ValidatePattern Tim Smith
Variables Validating PowerShell Parameters - Part I Tim Smith
View Detect and rename invalid VIEWs in a SQL Server database using PowerShell Johan Bijnens
No Records Found
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (33)
Analysis Services Analysis Services Development (95)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tutorials (6)
Business Intelligence Artificial Intelligence (23)
Business Intelligence Big Data (25)
Business Intelligence Data Science (3)
Business Intelligence Data Warehousing (7)
Business Intelligence Import and Export (81)
Business Intelligence R Language (11)
Business Intelligence Snowflake (29)
Cloud Amazon AWS (38)
Cloud Amazon AWS RDS (21)
Cloud Azure (149)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Functions (7)
Cloud Azure SQL Database (51)
Cloud Azure SQL Managed Instance (5)
Cloud Cloud Strategy (24)
Cloud Google Cloud (10)
Cloud Analytics Apache Spark (13)
Cloud Analytics Azure Data Factory (73)
Cloud Analytics Azure Databricks (39)
Cloud Analytics Azure Integration Services (14)
Cloud Analytics Azure Synapse Analytics (41)
Cloud Analytics Microsoft Fabric (17)
Data Quality Data Cleansing for Validation (4)
Data Quality Data Quality Services (10)
Data Quality Master Data Services (41)
Database Administration Central Management Servers (10)
Database Administration Comparison Data and Objects (14)
Database Administration Database Administration (208)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Scripts (35)
Database Administration System Databases (31)
Database Configuration Compression (22)
Database Configuration Database Configurations (19)
Database Configuration Database Mail (18)
Database Configuration FILESTREAM (9)
Database Configuration Full Text Search (21)
Database Configuration In Memory OLTP (32)
Database Configuration Linked Servers (18)
Database Configuration Policy Based Management (29)
Database Configuration Recovery Models (4)
Database Configuration Resource Governor (5)
Database Configuration SQL Server Configurations (75)
Database Design Constraints (20)
Database Design Data Types (22)
Database Design Database Design (92)
Database Design Identities (17)
Database Design JOIN Tables (23)
Database Design Synonyms (5)
Database Design Table Valued Parameters (4)
Database Design Temp Tables (15)
Database Design Temporal Tables (13)
Database Design User Defined Type UDT (3)
Database Design Views (17)
Database Development Application Development (46)
Database Development Common Runtime Language (13)
Database Development Debugging (4)
Database Development DevOps (36)
Database Development Entity Framework (13)
Database Development Language Integrated Query LINQ (7)
Database Development Paging (5)
Database Development Referential Integrity (5)
Database Development Service Broker (11)
Database Development Testing (32)
Database Development XML (14)
Database Maintenance Database Console Commands DBCCs (25)
Database Maintenance Fragmentation and Index Maintenance (28)
Database Maintenance Maintenance (34)
Disaster Recovery / High Availability Availability Groups (79)
Disaster Recovery / High Availability Backup (81)
Disaster Recovery / High Availability Clustering (77)
Disaster Recovery / High Availability Database Mirroring (33)
Disaster Recovery / High Availability Disaster Recovery (23)
Disaster Recovery / High Availability High Availability (3)
Disaster Recovery / High Availability Log Shipping (18)
Disaster Recovery / High Availability Replication (77)
Disaster Recovery / High Availability Restore (42)
Functions Dates (56)
Functions Functions System (99)
Functions Functions User Defined UDF (41)
Infrastructure Contained Databases (4)
Infrastructure Containers (12)
Infrastructure Hardware (14)
Infrastructure Spatial Data Storage (9)
Infrastructure Virtualization (25)
Integration Services Admin Integration Services Administration (10)
Integration Services Admin Integration Services Best Practices (12)
Integration Services Admin Integration Services Configuration Options (22)
Integration Services Admin Integration Services Performance (12)
Integration Services Admin Integration Services Security (7)
Integration Services Admin Integration Services Upgrade (4)
Integration Services Development Data Transformation Services (6)
Integration Services Development Integration Services Analysis Services Tasks (5)
Integration Services Development Integration Services Connection Managers (5)
Integration Services Development Integration Services Control Flow Transformations (14)
Integration Services Development Integration Services Data Flow Transformations (19)
Integration Services Development Integration Services Development (116)
Integration Services Development Integration Services Error Handling (8)
Integration Services Development Integration Services Excel (14)
Integration Services Development Integration Services Execute Package Options (8)
Integration Services Development Integration Services Oracle (4)
Microsoft Office Microsoft Access Integration (8)
Microsoft Office Microsoft Excel Integration (44)
Microsoft Office Microsoft Flow (1)
Other RDBMS Other Database Platforms (16)
Other RDBMS PostgreSQL (11)
Other RDBMS SQL Server and Oracle Comparison (29)
Other RDBMS SQL Server on Linux (78)
Other RDBMS SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance Dynamic Management Views and Functions (34)
Performance Error Logs (11)
Performance Extended Events (22)
Performance Indexing (94)
Performance Locking and Blocking (43)
Performance Monitoring (110)
Performance Partitioning (17)
Performance Performance Data Warehouse (4)
Performance Performance Tuning (124)
Performance Profiler and Trace (20)
Performance Query Optimization (15)
Performance Query Plans (20)
Performance Query Store (7)
Power Platform Power Apps (20)
Power Platform Power BI (172)
Power Platform Power BI Charts (57)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (20)
Professional Development Professional Development Certifications (62)
Professional Development Professional Development Community (16)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (24)
Professional Development Professional Development Management (14)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Python Python (88)
Reporting Services Admin Reporting Services Administration (21)
Reporting Services Admin Reporting Services Best Practices (6)
Reporting Services Admin Reporting Services Configuration (10)
Reporting Services Admin Reporting Services Installation (10)
Reporting Services Admin Reporting Services Migration (5)
Reporting Services Admin Reporting Services Monitoring (5)
Reporting Services Admin Reporting Services Network Load Balancing (4)
Reporting Services Admin Reporting Services Performance (6)
Reporting Services Admin Reporting Services Security (8)
Reporting Services Development Reporting Services Analysis Services (4)
Reporting Services Development Reporting Services Charts (25)
Reporting Services Development Reporting Services Data Sources (10)
Reporting Services Development Reporting Services Development (67)
Reporting Services Development Reporting Services Dynamic Reports (11)
Reporting Services Development Reporting Services Formatting (26)
Reporting Services Development Reporting Services KPI (5)
Reporting Services Development Reporting Services Overview (5)
Reporting Services Development Reporting Services Parameters (15)
Reporting Services Development Reporting Services Report Builder (9)
Security Auditing and Compliance (47)
Security Encryption (35)
Security Security (199)
Security SQL Injection (5)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
SQL Coding Change Data Capture (16)
SQL Coding Common Table Expressions (4)
SQL Coding Dynamic SQL (7)
SQL Coding Error Handling (11)
SQL Coding Stored Procedures (30)
SQL Coding Transactions (9)
SQL Coding Triggers (44)
SQL Coding TSQL (342)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
Tools SQL Server Management Objects SMO (3)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (35)
Versions Deprecated Features (6)
Versions Express Edition (16)
Versions Install and Uninstall (33)
Versions Licensing (4)
Versions SQL Server 2016 (96)
Versions SQL Server 2017 (44)
Versions SQL Server 2019 (20)
Versions SQL Server 2022 (21)
Versions Upgrades and Migrations (55)










get free sql tips
agree to terms