Determine Hosted SQL Server if running on VM or Physical Using Powershell

Problem:- 

You had hundreds of servers and for any kind of reporting or analysis, you need to know current SQL Server hosted environment if it Virtual or Physical Server, so we will use PowerShell to achieve that goal in a simple way as usual😊

Delete Update Cache folder in SQL Server

Problem:-
You got a disk space issue in C drive for more than one production server because of the bad configuration you had inherited.

Or

if you got a question from your system admin about that update cache folder if you needed or not seeking Clean up by this question?

Test SQL Server listening ports for hundreds of servers Using Powershell

Problem:-

As one of dba's every day manage hundreds of servers including dealing with lots of connectivity issues between application servers and database servers throw specific port, or because security team perform segregation between clients, apps and database servers bypassing only traffic between source IP and destination IP throw specific port, of course for good reasons including security best practice too.

Find sqlcmd.exe Path for SQL Server Using Powershell

Problem:-

In somehow we can’t find sqlcmd.exe location easily and that may be stress in a difficult situation like the down of one critical production server and for that, I figure out a solution for that problem by running below script to find where sqlcmd.exe in my server regardless of the location of SQL Server setup files, commonly that used when using Windows Core as an OS with SQL Server.

I want to point out that yes, we can use Powershell instead by using Invoke-sqlcmd cmdlet. I know not all of us know Powershell and most of us do know T-SQL. Until that changes happen and I expect it will 😃 SQLCMD will be around.

Connect SQL Server When Lost SA Credential

Problem:-

You may inherited MSSQL Database Server from another dba without any documentation for sysadmin user name and password or lost all password even sa password or sa account is disabled or no one knows the password  or get lab machine without taken a password from your trainer or any good intention reasons 😃