GitHub

Powershell CUCM SQL Query/Update GUI script

This PowerShell script will send a SQL query or an update to CUCM over HTTPS. It uses the AXLAPI wsdl that you must first download from your version of CUCM. See Installation section of this README.
GitHub

XEvent Query Replayer is a PowerShell script that reads the RPC:Completed and SQL:BatchCompleted events from XEL files captured with Extended Events and replays the Store…

XEvent Query Replayer consists of a total of 5 files. The codebase is built within the xe-query-replayer.ps1 and functions.psm1 files. If you want to determine which version of the .NET Framework is ...
MCPmag

Connecting to an Azure SQL Database with PowerShell

One way that organizations are storing data in the cloud is by moving their databases to the cloud. What once meant building an entire physical server, patching it, installing software like Microsoft ...
MCPmag

Creating a SQL Server Login Using PowerShell and SMO

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...
Redmond Magazine

PowerShell-Based SQL Server Backups Revisited, Part 2

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...