Microsoft has separated installation of SSMS from SQL Server Engine Installation since SQL Server 2016 and if you see the SQL server setup page it has an option to Install SSMS
DBA’s are faced with this issue most of the time where they have to get disk space details on a server but the server has mount points configured and xp_fixeddrives doesn’t give you full information.
In such cases I use below script to get free space on the servers including mount point space as well, This script has been modified to give output in below format
I have earlier written a blog post on how to change default installation path for SQL Server Management studio using PowerShell and registry editor here.
Since then I have tried different things and here I am again with a new way to install SQL Server management Studio from command line to an user desired path.
Microsoft has introduced a new GUI tool to connect to SQL server named Azure Data Studio.Why do we need it and what is this new tool we will see in this blog post.
Rebuilding master database is one of the dreaded task for a SQL Server DBA whether they are novice or expert.
It is like fear of venturing into unknown without really knowing whats at other end of the road.Read More »