Question : I have a AD group that needs to be added to multiple SQL instances, I am wondering is […]
Tag: powershell
Using ODBC drivers to connect to Postgres database via Powershell
Question : I’ve routinely connected to a postgres database via ODBC using a powershell script. Like this…. $DBConnectionString = “Driver={PostgreSQL […]
PowerShell to get all servers with SQL Server or Oracle installed
Question : Overview: Trying to get all servers with SQL Server or Oracle installed. Troubleshooting: get-service -computername “” works fine […]
Passing in multiple instances into the dbatools command GET-DBADBFILE
Question : I am attempting to gather all of the dbfile information on all of our sql instances in one […]
Changing SQL account password in specific database
Question : I am trying to change the password for userId in a specific database called LionsDB. If I am […]
Are cursors/While loops the only way to make administrative changes to multiple databases?
Question : I specifically want a programmable way to change the recovery model of all the databases on a server, […]
Executing Powershell SMO against a cluster with elevated privileges to update service accounts
Question : I’m working on a Powershell script to update service accounts on named SQL instances in a failover cluster. […]
Powershell Format Table Combine Values
Question : I have an awesome script that gives vital data for running worker processes. What I’m attempting to do […]
Why am I missing some output?
Question : Archiving to avoid ID Exhaustion We are about to run out of IDs in one of the tables […]
Deleting expired SQL server database backup file on data domain using PowerShell
Question : I am backing up the database on data domain however I’ll have to delete an expired backup using […]