Monthly Archives: June 2018

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

Continue reading

SQL Server 2008 R2: Adding SSRS to already existing SQL Cluster Installation

In most cases, adding any service, such as SSAS, SSRS, or a database engine, to an existing installation is not possible, and such additions require a named Instance installation.

This problem first appeared in 2013 on a SQL server 2008 R2 that was running on Windows Server 2008 R2.

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