Author: Alexandre Hamel

DBCC CHECKIDENT Example DBCC CHECKIDENT is used to check or change the value of an identity column in the specified table. To run this command, the login needs at least one of the following: own the schema that contains the…

In the past, we could run the SQL installer to do an in-place upgrade of SQL server including the SSRS instance to a newer version. As of 2017, SSRS is a separate install from SQL server, so this is no…

We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a cluster failure that impacted the availability group for a few minutes during which the replicas changed to resolving state. Once the…

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on a Windows 2012 environment. You will quickly find out that there are a number of compatibility issues that can make…

What are Statistics? There are multiple paths a database can use to answer a query, some of them being faster and more efficient than others. It is the job of the query optimizer to evaluate and choose the best path,…