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
DBA’s are faced with this issue most of the time where they have to get disk space details on a server but the server has mount points configured and xp_fixeddrives doesn’t give you full information.
In such cases I use below script to get free space on the servers including mount point space as well, This script has been modified to give output in below format
I have earlier written a blog post on how to change default installation path for SQL Server Management studio using PowerShell and registry editor here.
Since then I have tried different things and here I am again with a new way to install SQL Server management Studio from command line to an user desired path.
Microsoft has introduced a new GUI tool to connect to SQL server named Azure Data Studio.Why do we need it and what is this new tool we will see in this blog post.
With new version of SQL server i.e. 2017 out last fall, I too wanted to try the new and shiny features so I decided to install it on one of my VM’s
I have faced numerous issues , but some are strange and may occur if certain default values are left enabled. Either they were skipped during post config check after SQL was installed or were enabled later for some issue and weren’t reverted.
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.
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.
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