SQL Server

Dynamics NAV databases grow every day. While little can be done to stop this, much can be done to ensure you are only storing the data that you really require.

Essential SQL back-up and management tips.

Essential concepts you should understand to manage SQL backups.

Understanding the SQL transaction log architecture will give you peace of mind and make you a better administrator.

The Buffer Manager is an integral component of SQL Server’s architecture. Understanding the Buffer Manager is important for administrators and application programmers.

The aim of this blog is to introduce query object and to provide an overview of different scenarios where queries can be used to improve NAV performance.