Category Archives: SQL 2017

Change the default installation path of SQL Server Management Studio

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.

Keep On Reading

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.

Keep On Reading

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.

Keep On Reading