Get-SQL Instance and the Credential user with PowerShell ISE

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.



Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Alim Dogan

I am SQL Server Database Administrator. So, I am doing this job and I am enjoying it super.