SQL Server 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 (31)
Analysis Services Analysis Services Development (94)
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 Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (24)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (40)
Cloud Amazon AWS RDS (21)
Cloud Apache Spark (10)
Cloud Azure (146)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (37)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (3)
Cloud Azure Synapse Analytics (41)
Cloud Cloud Strategy (22)
Cloud Google Cloud (9)
Cloud Microsoft Fabric (10)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Availability Groups (79)
Database Administration Backup (80)
Database Administration Central Management Servers (10)
Database Administration Clustering (75)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (203)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (28)
Database Administration Hardware (15)
Database Administration High Availability (3)
Database Administration Indexing (92)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (43)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (112)
Database Administration Other Database Platforms (82)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (133)
Database Administration Policy Based Management (29)
Database Administration PowerShell (131)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (5)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (24)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (21)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (55)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (43)
Database Development Artificial Intelligence (13)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (4)
Database Development Constraints (20)
Database Development Data Cleansing for Validation (4)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (80)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (74)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (44)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (80)
Database Development Query Optimization (15)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (9)
Database Development Temporal Tables (13)
Database Development Testing (32)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (386)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (162)
Power Platform Power BI Charts (56)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (57)
Professional Development Professional Development Community (15)
Professional Development Professional Development Conferences (2)
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 (18)
Professional Development Professional Development Management (14)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (21)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (35)
Security Security (197)
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)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (36)










get free sql tips
agree to terms