Since SQL Server 2016, Microsoft has separated SSMS installation from SQL Server Engine installation, and the SQL Server setup page now includes an option to install SSMS.
DBAs are frequently confronted with the problem of needing to obtain storage capacity data on a server, if the server has mount points configured then xp_fixeddrives does not provide complete information.
In such circumstances, I use the script below to retrieve free disc space on the servers, as well as mount point space. This script has been updated to output in the format below.
Keep On ReadingI previously wrote a blog post about using PowerShell and the registry editor to modify the default installation path for SQL Server Management Studio here.
Since then, I’ve tried a few alternative approaches, and now I’m back with a new method for installing SQL Server Management Studio via the command line to a user-specified location.
Azure Data Studio is a new graphical user interface (GUI) application for connecting to SQL Server from Microsoft. In this blog article, we’ll look at why we need it and what this new tool is.
Whether a SQL Server DBA is a newbie or an experienced, rebuilding the master database is one of the most dreaded tasks.
It’s similar to the fear of walking into the unknown without knowing what’s on the other side of the road.
Continue reading
Saurabh Srivastava's SQL Server Blog 