Skip to content
Microsoft Dynamics 365 Blog

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...

Read more

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...

Read more

It IS possible to instantiate the Visual Studio bridge. 

Solution developers will often have different versions of Dynamics NAV installed on a single machine for their development environment. The way this is often implemented is to fully install the latest version and simply copy the Classic Client binary files for earlier versions into separate folders so you have something like this: NAV 2009 R2...

Read more