Recent Powershell Posts
Get SQL Server TCP Connections from Operating System Level
Our systems (server) administrator who got local administrator rights to our SQL Server wanted to get the remote TCP connections on SQL Server instance.
Knowing that the server admins already have local administrator rights to our servers, this solution can be achieved without giving them access to the database instance.
The issue happened when we formatted the drive on the new node. It is supposed to only format the drive on the server where it was ran. But for some reason, it also formatted the drive on the existing nodes.
Get SQL Server Windows Cluster Information
I have already identified that there is a SQL Server installed on a server. Using PowerShell, I wanted to know if the server is using windows clustered WITHOUT connecting the database instance. This is an option that system administrators since they have admin rights on the Operating System but don't have access to SQL Server instance.
Check Installed Windows Operating System Patch On Servers Using Powershell
Do you need to check if all of your database servers were patched correctly but you don't have access to your patch deployment software like SCOM? This can help you check a list of servers in just one run with a nice summary.
Updating SSMS v17.x Remotely On Server/s
A GUI base powershell script that allows the DBA's to upgrade SQL Server Management Studio v17.x or higher remotely on a server or on a list of servers.
Installed SSMS Version Checker
Do you have a need to find if a software is installed on your server/s? I designed this GUI based powershell tool to check the SQL Server Management Studio version from a server or list of servers. This can also be used to find other software that are installed your server/s.
