Alexandre Hamel

Recent stories

User “Guest” Does Not Have Permission to Run DBCC CHECKIDENT For Object


DBCC CHECKIDENT Example DBCC CHECKIDENT is used to check or change the value of an identity column in the specified ...

2 min read

Upgrade SQL Server Reporting Services to 2017


In the past, we could run the SQL installer to do an in-place upgrade of SQL server including the SSRS instance to a ...

3 min read

Resolving an Availability Group Sync Issue - HADR_AR_CRITICAL_SECTION_ENTRY


We recently ran into an interesting issue on a three-node SQL Server Availability Group (AG) cluster. There was a ...

3 min read

More stories