Browse by Tags

  • Blog Post: Synchronize metadata, please…

    One of new procedures/functions we have in NAV 2013 R2 is “metadata synchronization”. It is process when object (table) description done in C\SIDE by NAV developer is applied to SQL object (object structure in SQL becomes the same as we have in NAV object designer). It is described at http...
  • Blog Post: Working with SQL Server through .NET Interop

    The Upgrade Toolkit objects that shipped with Microsoft Dynamics NAV 2013 have a good example of code that works directly with SQL Server through the .NET Framework library. On the product media, navigate to this location: ..\UpgradeToolKit\Data Conversion Tools\601\ Import the Upgrade 601700.2...
  • Blog Post: Technical videos for Microsoft Dynamics NAV 2013

    The Microsoft Dynamics NAV support team have posted videos on YouTube that illustrate various aspects of deployment and configuration of Microsoft Dynamics NAV 2013, including tips for how to extend the core product. You can share the videos with other partners, and with your customers - they are the...
  • Blog Post: Manually restoring the NAV 2013 Demo Database

    With the release of Microsoft Dynamics NAV 2013, there are some new procedures for restoring the demo database manually. I have outlined the necessary steps below. 1) From within the Microsoft SQL Server Management Studio, restore the Microsoft Dynamics NAV 2013 demo database from the installation...
  • Blog Post: Example of How to use SQL Tracing Feature to Profile AL Code

    Enabling Tracing in Microsoft Dynamics NAV 2013 Microsoft Dynamics NAV 2013 has a feature that allows you to see the AL call stack for a SQL commands. Here I am going to describe how it can be used to profile your application code. There are multiple steps required to start tracing. First, you...
  • Blog Post: Compatibility Update with Microsoft SQL Server 2012

    Microsoft SQL Server 2012 was released in March with many new and interesting capabilities. For further information, please take a look at the product information at Microsoft SQL Server . Over the last few months the Microsoft Dynamics NAV product team has been testing the compatibility and we are...
  • Blog Post: "CREATE USER" SQL Error when creating and Synchronising New User in Dynamics NAV 2009

    In Dynamics NAV 2009 Service Pack 1 also later Builds on SQL Server 2005, SQL Server 2008 also SQL Server 2008 R2, when a new user is created and synchronised sometimes following error is thrown. 15023, "42000" User, group, or role '<Name>' already exists in the current database. SQL:...
  • Blog Post: Object Metadata update flow in Microsoft Dynamics NAV 2009

    My colleague Lars described in BLOG post “ About Object Metadata, and why I can’t see object changed in RTC ” and explained how to troubleshoot metadata update problems. With current post I’m trying to overview whole process and make it more clearly for all. So we have few...
  • Blog Post: More How Do I Videos for Microsoft Dynamics NAV on MSDN

    For your viewing and learning pleasure, a couple of new videos have been released and are available on MSDN. Check out the latest offerings: How Do I: Determine which granule the customer needs to use a specific function in Dynamics NAV 2009 SP1 How Do I: Perform a backup of Dynamics NAV 2009...
  • Blog Post: SQL Server Data Compression and Microsoft Dynamics

    I am pleased to announce the release of the SQL Server Database Compression Analyzer for Dynamics. This tool was created to help Dynamics partners and customers leverage the benefits of SQL Server Data Compression and to make the processing of analyzing and implementing compression quicker and easier...
  • Blog Post: Microsoft Dynamics NAV Changes by Version

    Microsoft Dynamics NAV has had multiple changes to the underlying code in order to optimize performance of NAV on SQL Server. The chart below shows the changes by version. REPEATABLEREAD In order to use the REPEATABLEREAD, changes are needed after installing the latest hotfix to enable the option...
  • Blog Post: About Object Metadata, and why I can't see object changes in RTC

    A few times we have seen case where changes to NAV objects are not seen in RTC until the NAV Server is restarted. This post explains a likely solution to such problems. And as we are on the topic anyway, also explains a bit about the process that turns C/AL code into Metadata (c#). How object changes...
  • Blog Post: Microsoft Dynamics NAV and SQL Server Database Compression

    Microsoft SQL Server 2008 introduces two new compression features (available in Enterprise Edition) that are of interest to users with large databases. Data compression applies to individual tables and indexes within a database and comes in two options: ROW and PAGE. Backup compression is a new option...
  • Blog Post: More Training Titles Released for Microsoft Dynamics NAV 2009

    Brand new training titles have been released and are available on PartnerSource and CustomerSource (account required). The trainings are available as downloads and as instructor-led training (ILT). Upgrading Microsoft Dynamics NAV 2009 Native Database to Microsoft SQL Server This training is designed...
  • Blog Post: Temporary Tables: Different Type of Sorting Order in SQL Server Environment

    Probably most of the partners have already noticed this and changed the C/AL code accordingly in order to let their customized application works properly. In ALL versions of NAV up to now (NAV 2009 R2) the SORTING of Temporary Tables / Temporary record variables has always been determined using a...
  • Blog Post: Dynamics NAV and SQL Azure

    With more and more focus on cloud computing and cloud services, I have been asked several times about the possibility of using Dynamics NAV with SQL Azure. So I decided to write this blog entry to help "shed some light" on the topic. What is SQL Azure you ask? SQL Azure is the cloud version of Microsoft...
  • Blog Post: Degraded Performance on Dynamics NAV and the SQL Server TokenAndPermUserStore

    I have recently come across an issue with a large Dynamics NAV customer where queries that normally ran VERY quickly became slower and slower over time and blocking was increased significantly. After going through the normal troubleshooting activities there seemed to be no easily explainable cause for...
  • Blog Post: Performance Analyzer 1.0 for Microsoft Dynamics

    The Microsoft Premier - Dynamics team has created and compiled a set of scripts and tools for helping analyze and troubleshoot SQL Server performance issues on the Dynamics products. These are the same tools that we use on a daily basis for collecting SQL performance data and troubleshooting SQL performance...
  • Blog Post: Microsoft Dynamics NAV/SQL Server Configuration Recommendations

    Michael De Voe , a Senior Premier Field Engineer at Microsoft, has compiled a set of recommendations for SQL Server configuration to improve performance when running Microsoft Dynamics NAV 5.0 and later versions with one of the following versions of SQL Server: Microsoft SQL Server 2005 SP3 x64...
  • Blog Post: Compatibility Update with Microsoft SQL Server 2008 R2 and Microsoft Visual Studio 2010

    A couple of big Microsoft products shipped recently, so time for an NAV compatibility update. Microsoft SQL Server 2008 R2 We are proud to announce that both Microsoft Dynamics NAV 5.0 SP1 Update 2 and Microsoft Dynamics NAV 2009 SP1 are compatible with Microsoft SQL Server 2008 R2! We will...
  • Blog Post: Books! Five Options for Learning More About How to Create RoleTailored Solutions with Microsoft Dynamics NAV (Updated!)

    [Updated with a fifth book!] This month the fourth fifth English-language book on Microsoft Dynamics NAV 2009 is being released. For those of us working on Dynamics NAV, it is exciting to see that partners are so invested in our product that they eagerly spend months writing a book to help other partners...
  • Blog Post: Saying Farewell to the Native Database

    I've met many people who imagine that everyone who works at Microsoft must be of a single mind, with one goal - much like a hive mentality . Nothing could be further from the truth. We are an organization of individuals, often passionate about our beliefs and very emotionally invested in the work that...
  • Blog Post: CREATE DATABASE failed when installing Cronus Sample Database

    Today I did run into a problem installing the “Cronus Sample Database”. In the error report view I found this error message SQL Server option Cronus Sample Database for Microsoft Dynamics NAV 2009 Fatal error during installation. CREATE DATABASE failed. Some file names listed could not...
  • Blog Post: “User ID and password are invalid.try again?”

    If you get "User ID and password are invalid.try again?" when starting RTC you need to first check that you can login to database in the classic client. Note that the database should be the same as the service tier (the service you are trying to connect with RTC) is connected to. Start "classic...
  • Blog Post: Run As Administrator if you are doing an upgrade from the same machine where SQL is hosted

    When doing an upgrade running Microsoft Dynamics NAV CSIDE client on the same machine as your SQL server, please run the CSIDE client with full administrator rights (Run as administrator). The reason why this is important is because, when connecting locally from a Vista/Windows 2008 server to SQL...
Page 1 of 4 (77 items) 1234