Before we discuss about fine-tuning the performance of the database for Dynamics NAV, it is important to discuss some key features of the Dynamics NAV application that comprise the core architecture of the application, and the majority of performance issues could be attributed to improper use or misuse of these features.
In this article, by Sharan Oberoi & Amit Sachdev, authors of Microsoft Dynamics NAV Administration, we will cover:
- Using indexes/keys in Dynamics NAV
- Investigating the performance of the database
- Updating statistics
In the previous article, Microsoft Dynamics NAV 2009 Development Tools, we gained an overall view of NAV as an application software system.
The goal of this article by David Studebaker, author of Programming Microsoft Dynamics NAV 2009, is to learn about many of the debugging tools and techniques available to the NAV developer. As it has been pointed out, "Without programmers, there are no bugs." As we are all developers and therefore a primary source of bugs, we need to be knowledgeable about the tools we can use to stamp out those bugs. Fortunately, NAV has a good arsenal of such tools.Read Code Analysis and Debugging Tools in Microsoft Dynamics NAV 2009 in full
The key goal of this article by David Studebaker, author of Programming Microsoft Dynamics NAV 2009, is to gain an overall view of NAV as an application software system. We're not going to study its functional operation, but gain a basic understanding of the process flow of the system. We also want to have a good understanding of the structural "style" of the software, so that our enhancements are designed for a better fit.Read Microsoft Dynamics NAV 2009 Development Tools in full
Debatching data is the process of turning one huge pile of data into many small piles of data. There are multiple tools for debatching large bulk data loads including BizTalk Server and SQL Server Integration Services (SSIS). One can use such tools to break up large batches of data, manipulate it as needed, and send it on to its next reincarnation (for example, into an API, a relational database, or a text file). In this article by Mike Sexton, co-author of Applied Architecture Patterns on the Microsoft Platform, we will take a look at options for processing large data sets and explain how to take giant sets of data and insert them into databases for analysis.Read Debatching Bulk Data on Microsoft Platform in full
Parallel programming is becoming one of the hottest topics in software today as multi-core CPUs decrease in price and increase in power. Parallelism in programs allows multiple processes to be executed concurrently using separate threads and processing units. This is appealing to developers and users alike, because it can help reduce runtimes while still producing the same results as if it were run in serial. This article by Daniel Bolella gives us an overview to Parallel Programming and CUDA and is accompanied with a sample code to present the concept.Read Introduction to Parallel Programming and CUDA with Sample Code in full
In the previous article, Content Based Routing on Microsoft Platform, we took a look at how to send data messages to the correct target system.
In this article by Richard Seroter, co-author of Applied Architecture Patterns on the Microsoft Platform, we will actually construct a working version of the proposed solution, which will leverage core components of .NET 4.0 (WCF and Windows Workflow Services) as well as the AppFabric extensions to IIS. Note that for this demonstration, we are only building the first aspect, which accepts orders, not the second piece which supports querying the status of a given order.Read Building the Content Based Routing Solution on Microsoft Platform in full
Communication between enterprise systems is an essential part of an organization's architecture. How you decide to link these systems and by which criteria you distribute data, is something that you will be faced with time and again. In this article by Richard Seroter, co-author of Applied Architecture Patterns on the Microsoft Platform, we will look at how to send data messages to the correct target system.Read Content Based Routing on Microsoft Platform in full
This article, by Vibor Cipan, author of Silverlight 4 User Interface Cookbook, deals with data input controls, primarily those related to date and time input since those data formats are somewhat specific. Fortunately, Silverlight comes with good support for these data types and implementations; design and development involving those controls is pretty straightforward.
In this article we will be specifically covering:
- Designing date picker interface
- Using and implementing the calendar interface
- Designing time input interface
- Implementing star-based rating
- Designing list views with alternating row colors
Microsoft LightSwitch is the latest standalone product from Microsoft belonging to the Visual Studio suite of products. It is expressly targeted to tech savvy but non-programmers (hobbyists) to develop line of business applications using Microsoft Databases or other sources. This is a new game plan by Microsoft to catch a wider audience as well as encourage them to use its cloud offerings. If priced right and supported well, this may help businesses to develop applications on their own or call in junior level programmers with some knowledge of individual technologies like databases, user interfaces, mouse clicks, window navigation etc.
The LightSwitch Beta 1 was out on August 23rd for the general public while it has been used by MSDN members and Microsoft insiders for couple of months. This article by Jayaram Krishnaswamy shows how you may download and install this program. The article also shows how you may develop a simple database application using this product retrieving data from the Cloud hosted relational database, the SQL Azure.Read Microsoft LightSwitch Application using SQL Azure Database in full