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.
Category Archives: TestLab
Change the default installation path of SQL Server Management Studio
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
Building Windows Domain and Installing SQL server and Windows Cluster
This is the first of a multi-part article on how to run a SQL test lab on a laptop. To begin, we must first enable Windows’ hyper-V feature. Hyper-V is included with Windows 10, however it is turned off by default. We can utilize the GUI, PowerShell, or the command line to enable HyperV.
Setting up a SQL Server Lab on your laptop using Hyper-V
With the Cloud at our disposal and a myriad of virtual Labs available, setting up a lab in this day and age is like reinventing the wheel. (MSDN membership, AWS free credits, additional offers) Both Azure and AWS provide free credits up to the tune of $150/mo or $100/mo to test their products, but sometimes your desire to build from the ground up takes over and you plunge in without a second thought.