SQL – Page 10 – Pardaan.com

How to schedule and automate backups of SQL Server databases in SQL Server Express

SQL Server Express editions do not offer a way to schedule either jobs or maintenance plans because the SQL Server Agent component is not included in these editions. Therefore, you have to take a different approach to back up your databases when you use these editions.…

22 April 2015

Dynamics NAV & BC Tips & tricks

Watch Out for Zombies When Using Microsoft Dynamics NAV with “xact abort” Enabled

If you have turned on the xact abort connection setting option for the Microsoft Dynamics NAV SQL Server instance, then you should watch out for Zombies. With this option turned on, users of your solution risk seeing an error stating This SqlTransaction has completed; it is…

21 April 2015

Dynamics NAV & BC Tips & tricks

Microsoft Dynamics NAV How To: Add A User To NAV 2013 Using Microsoft SQL Server

To add a user to Microsoft Dynamics NAV (Navision) 2013 using SQL Server, execute the following script. Bron : Peter Musu Blog Lees meer...

10 April 2015

Dynamics NAV & BC Tips & tricks

Microsoft SQL Server 2014 Runtime

The Microsoft SQL Server Runtime edition is an interesting way for partners to offer a decent SQL Server edition for their Microsoft Dynamics NAV customers. It’s in fact a standard edition of SQL Server, but better priced for Dynamics NAV customers. Bron : Waldo's Blog Lees…

8 April 2015

Dynamics NAV & BC Tips & tricks

Inventory to GL Reconcile SQL Report

Here is the sql report for Inventory to GL Reconcile Report. For Large customers the report probably is running out of memory or taking too long to run. Bron : Rashed Amini Lees meer...

19 March 2015

Dynamics NAV & BC Tips & tricks

NAV SQL Trace Analysis

This tool analyzes a SQL Trace created from a Microsoft Dynamics NAV database using SQL Server Profiler. It will show how many times each table has been read and written to. I will also show each transaction in detail, including the values used for INSERT and…

10 February 2015

Dynamics NAV & BC Tips & tricks

Different techniques to identify blocking in SQL Server

SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests from many clients, there is a strong possibility that conflicts will occur because different processes request access to the same resources at the same time. Bron…

29 January 2015