Gerard Conroy articles

Gerard Conroy
6 min read

Using SQL Server Extended Events to produce a Blocked Process Report 

Blocking in SQL Server is a mixed blessing! It is a SQL Server’s way of ensuring data integrity which is a basic requirement for any database management system but when users encounter a lot of blocking it makes the application appear slow and sometimes unusable.
3 min read

How to change the collation on a Microsoft Dynamics NAV 2013 R2 database. 

Some significant changes have been introduced to the internal database structure for Microsoft Dynamics NAV 2013 R2 in order to support the powerful new Multitenancy functionality. These changes impact on how the NAV application manages a collation change whether or not you are using Multitenancy.