What are SQL Server Always On Availability Groups?

SQL Server AlwaysOn Availability Groups is a technology that was initially released by Microsoft with SQL Server 2012. The main concept, is that you have your data available in more than one sites at the same time. To this end, you have groups of databases that have primary replicas and secondary replicas. These replicas are hosted … Read more…

How to Find the OS Version of your SQL Server Machine – Single vs Many Machines

Finding the Windows OS version of a single SQL Server machine is easy. There many ways you can do it. However, what about when you work with hundreds of SQL Server instances? How can you efficiently generate a report with the OS versions? This article discusses some of the methods you can use to find … Read more…

Installing SSIS on a SQL Server Failover Cluster Instance

This short post, discusses about installing SSIS on a SQL Server Failover Cluster Instance and how you can resolve the error message: The instance selected for installation is already installed and clustered on computer [ComputerName]. To continue, select a different instance to cluster.   Reproducing the Error Message If you have already deployed a SQL … Read more…

How to Resolve “The Parameter is Incorrect” Error when Adding New Disk Mount Point

Hi friends. Here’s a quick tip on Windows Clustering and Windows Disk Management and specifically on how to handle the error message “The parameter is incorrect” when working with disks and mount points. Why you get the “Parameter is Incorrect” Error Message Most probably, under certain circumstances, you get the above error message when attempting … Read more…

How to Resolve “Property SpaceAvailabable is not available for Database ‘[tempdb]'”

Under certain circumstances, when working in SQL Server Management Studio, you might get the error message “Property SpaceAvailabable is not available for Database ‘[tempdb]’“.   Why I got this message? Most of the times, you might get the above message because something else happened prior to the action that triggered the error message. For example, … Read more…

How to Add a Database to a SQL Server Availability Group Using T-SQL

In some cases, while trying to add a database to a SQL Server availability group using the wizard in SQL Server Management Studio, you might get some warnings or errors. There is a chance that these warnings/errors won’t let you continue and add the database. For example, a possible warning could be the below: This … Read more…

The Maximum Number of Concurrent Connections Setting in SQL Server

Among its plethora of available and useful settings, SQL Server has a setting that is called “Maximum number of concurrent connections“. This setting by default is set to 0 (zero), which means “unlimited” concurrent connections and it is generally advised not to change it. In case  you changed this setting there is the risk to … Read more…

How to Patch a Standalone SQL Server Instance

Patching SQL Server is an ongoing process. Service packs and cumulative updates are being regularly released, in order to apply possible bug fixes as well as provide additional functionality. This article, suggests a procedure for how to patch a standalone SQL Server instance.   First Patch SQL Server on the TEST Environment First, always patch the … Read more…