Get 147 SQL Server object management scripts with PowerShell. Work with databases, Analysis, Integration, and Reporting services. Compatible with SQL Server 2016 & 2017, Azure SQL Database, and Windows Server 2016.
I recently came across a collection of free SQL Server PowerShell scripts that have proved to be incredibly useful in my daily work. The package contains 147 scripts in total, with 89 of those being example scripts for managing SQL Server objects.
The package is divided into different categories to make it easy to find what you need. There are scripts for Analysis, Integration, and Reporting services, with experimental support for SQL Server 2016 also included. Additionally, there are new scripts for exploring In-Memory databases and query store features.
When it comes to managing the database engine, these scripts make it simple to connect to a server instance, manage databases, and publish scripts. You can also work with policies and SQL Server logs, maintain security and backups, and create and manage SQL Server jobs. The package also includes a script to get extended event information.
For Analysis Services, connection to an instance is straightforward, and you can get connection information, a list of databases, and perform backups and restores. Integration Services scripts allow for starting and stopping services, getting package information, and publishing a project. Modifying catalog settings is also possible.
When it comes to Reporting Services, you can start or stop services, get instance information, backup and restore encryption keys, and get configuration and event log information.
In the package, you'll also find scripts for In-Memory databases, which allow you to get overall utilization, size on disk, detailed utilization by table, and checkpoint size. Query Plan scripts allow you to set the desired state, set data retainment and get query store status and information.
CIS benchmarks are included to help with surface area reduction, authentication and authorization, password policies, auditing and logging, application development, and starting and stopping the SQL Server browser service.
Finally, there are scripts for Azure SQL Database, including initializing the PowerShell module, setting scaling levels, auditing and threat detection, getting database properties, alerts, and query results and metric data.
I highly recommend this package to any SQL Server user looking to streamline their daily tasks and workload. The scripts are well organized and easy to use, making it an excellent addition to any developer or administrator's toolbox.
The package is divided into different categories to make it easy to find what you need. There are scripts for Analysis, Integration, and Reporting services, with experimental support for SQL Server 2016 also included. Additionally, there are new scripts for exploring In-Memory databases and query store features.
When it comes to managing the database engine, these scripts make it simple to connect to a server instance, manage databases, and publish scripts. You can also work with policies and SQL Server logs, maintain security and backups, and create and manage SQL Server jobs. The package also includes a script to get extended event information.
For Analysis Services, connection to an instance is straightforward, and you can get connection information, a list of databases, and perform backups and restores. Integration Services scripts allow for starting and stopping services, getting package information, and publishing a project. Modifying catalog settings is also possible.
When it comes to Reporting Services, you can start or stop services, get instance information, backup and restore encryption keys, and get configuration and event log information.
In the package, you'll also find scripts for In-Memory databases, which allow you to get overall utilization, size on disk, detailed utilization by table, and checkpoint size. Query Plan scripts allow you to set the desired state, set data retainment and get query store status and information.
CIS benchmarks are included to help with surface area reduction, authentication and authorization, password policies, auditing and logging, application development, and starting and stopping the SQL Server browser service.
Finally, there are scripts for Azure SQL Database, including initializing the PowerShell module, setting scaling levels, auditing and threat detection, getting database properties, alerts, and query results and metric data.
I highly recommend this package to any SQL Server user looking to streamline their daily tasks and workload. The scripts are well organized and easy to use, making it an excellent addition to any developer or administrator's toolbox.
What's New
Version 6.0: This is a major product update
Version 3.0: This is a major product update