Gerard Conroy Posts

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. Therefore, system administrators need to be able to analyse SQL
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. At first glance, changing the NAV database collation seems to
<1 min read

Filter values specified on a request page for a report are not saved by the Web Client 

When running a report from the Windows Client with Microsoft Dynamics NAV 2013 R2, filter values specified on the request page are saved along with the relevant user’s personalization information. These filter values are conveniently restored to the request page the next time the user runs the same report. The Web Client does not save