Get-SQL Instance and the Credential user with PowerShell ISE

Alim Dogan
Feb 24, 2021

We can get info from SQL Server with PowerShell. I used Windows Powershell ISE.

You can following the below steps.

Finding SQL Server instance, version number, Product level, host platform, and with a credential user.

Finding databases, status, sizes, space available, recovery model, compatibility level, owner, collection, and containment type.

Finding all login objects from my instance.

--

--

Alim Dogan

I am a SQL Server Database Administrator, and I thoroughly enjoy my work. https://github.com/alimdogan