Author Archives: sqlx86

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

In normal circumstances addition of any service SSAS ,SSRS or DB engine is not allowed on existing installation and addition of these would need a named Instance installation.

This issue occurred somewhere in 2013 on a SQL server 2008 R2 hosted on Windows server 2008 R2.

Continue reading

Building Windows Domain and Installing SQL server and Windows Cluster

//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js

(adsbygoogle = window.adsbygoogle || []).push({
google_ad_client: “ca-pub-4682017180978474”,
enable_page_level_ads: true
});

This is first post in the multi post series for running a SQL test lab on laptop. To begin we need to enable hyper-V feature in windows. Hyper-V is shipped along with windows 10 but is not enabled by default. To enable HyperV we can use GUI, PowerShell or cmd line.

Continue reading

Setting up a SQL Server Lab on your laptop using Hyper-V

Setting a Lab in this day and age is like re-inventing the wheel,  with Cloud at our disposal and plethora of virtual Labs available. Both Azure and AWS offers free credits up to tune of $150/mo or $100/mo to test their products, (MSDN subscription, AWS free credits , other offers) but  sometimes your want of building  from ground up takes control and you jump in without giving a second thought

Continue reading