From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential thing in my personal toolset. That’s why I’m here at CodingSight to share my very first PowerShell tool, of many, I truly hope, that any SQL Server DBA can use to enhance the provided service value.Read More
At present, the gathering of SQL Server configuration information is no longer a problem— the opportunities to add value through an update and to build a stable database environment exist permanently. Most of the third party tools provide the appropriate functionality in order to capture the software market. Through this guide, you’ll figure out the ways to capture few SQL Server configurations and manipulate the data by using PowerShell.
Moreover, you will get the answers to the following questions:
- How to gather SQL Server configuration
- How to automatically discover SQL instances
- How to manually input the SQL Server instances to speed up the process
- How to transform data by using PowerShell
- And more…