Read our high-quality articles on SQL Server administration. Learn how to efficiently administer the world’s biggest DBMS, that is SQL Server.
A common question I usually get from fellow SQL Server community members, is how to update SQL Server Reporting Services (SSRS) 2017? This is a good question, because since SQL Server 2017 and later, SSRS is no longer part of the SQL Server installation media. To this end, SSRS 2017 and later can be found … Read more…
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…
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…
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…
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…
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…
SQL Server is one of the world’s leading data platforms. It is a mature platform, full of features that enable you to store, organize, retrieve and transform your data into useful business insights and knowledge. Like in all Database Management Systems, in order for your SQL Server instances to operate to the best possible level … Read more…
Each SQL Server version has a specific native compatibility level, as a way to distinguish it from other SQL Server versions. The compatibility level is used internally in SQL Server for many operations. For example, if you try to restore a database backup taken on SQL Server 2017 with native compatibility level 140, to an … Read more…
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 SQL Server Browser Service listens on incoming connections for SQL Server services on SQL Server machines and provides information about SQL Server instances installed on the machine. This article discusses about the SQL Server Browser Service and UDP Port 1434, as well as what its use means throughout a simple example. What Does … Read more…
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…
DBAs play a major role in the everyday operation of any organization that uses databases. However, the term “healthy database” is often misinterpreted. In the databases world, a healthy database is not just a database that is online and is not corrupted. A healthy database, and consequently an RDBMS instance, have also an “accepted” up-time … Read more…
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…
If you are trying to add a new node to an existing SQL Server failover cluster and you are getting the error message “There is no SQL Server failover cluster available to join“, then you follow the below procedure for resolving the issue. Procedure for Resolving the “There is no SQL Server Failover Cluster … Read more…
Encrypting a SQL Server database backup is necessary in many cases, especially when the database has sensitive data. SQL Server provides an easy way to encrypt database backups. Let’s further examine this functionality with a step-by-step example. In this example, we are going to backup a SQL Server 2014 database, encrypt it, and then restore … Read more…
