About SQL Server Compatibility Levels

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…

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…

Microsoft SSIS Service failed to start. Configuration system failed to initialize

In this article, we will be discussing about the error message: “Microsoft SSIS Service failed to start. Configuration system failed to initialize”.  We will talk about what this error message means, as well as, how you can resolve it.   About the “Microsoft SSIS Service failed to start” Issue It happened at some point to … 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…

Top 10 SQL Server DBA Daily Tasks List

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…

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…

There is no SQL Server Failover Cluster Available to Join

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

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…

Operating System Requirements for all SQL Server Versions and Editions

SQL Server is the world’s most powerful data platform and it is constantly evolving. From release to release significant new features are added. Besides the features and functionality, one of the typical question DBAs have is which are the Operating System requirements for each version and edition of SQL Server. In this post you can … Read more…