General SQL Server Resources​

SQL Server Pages

• SQL Server Home Page
• SQL Server Developer Center
• SQL Server TechCenter

SQL Server Documentation

• Microsoft SQL Server on MSDN

SQL Server 2012

• Books Online for SQL Server 2012 
• Developer Reference for SQL Server 2012
• Installation for SQL Server 2012
• White Papers

SQL Server 2008 R2

• SQL Server 2008 R2 Books Online
• Download SQL Server 2008 R2 - Books Online

​ 

General SQL Server for Microsoft Dynamics NAV Resources​

Training Manuals

• SQL Server Installation and Optimization for Microsoft Dynamics NAV 2009
  • Setup and Installation
  • Advantages of SQL Server Option
  • Performance Audits
  • Improving Application Performance
  • Maintenance
• Upgrading Microsoft Dynamics NAV 2009 Native Database to Microsoft SQL Server

System Requirements

• System Requirements for Microsoft Dynamics NAV 2013
• System Requirements for Microsoft Dynamics NAV 2009 SP1 and Microsoft Dynamics NAV 2009 R2
• Microsoft Dynamics NAV Compatibility with Microsoft SQL Server 2008 R2
• Microsoft Dynamics NAV Compatibility with Microsoft SQL Server 2012

MSDN Developer and IT Pro Documentation

• Installation Considerations for Microsoft SQL Server
• Configuring Microsoft SQL Server
• Setting Database Owner and Security Administration Permissions
• Enabling the Object Change Listener
• Troubleshooting SQL Server Connection Problems

NAV Team Blog Posts

• Microsoft Dynamics NAV/SQL Server Configuration Recommendations
• Microsoft Dynamics NAV and SQL Server Database Compression
• SQL Server Data Compression and Microsoft Dynamics 
• Basic SQL - Overview of NAV specific SQL features
  • Basic SQL - Installing SQL Server 2005 / 2008
  • Basic SQL - Creating Extended Stored Procedure / xp_ndo.dll
  • Basic SQL - Enable trace flag 4616 on SQL Server
  • Basic SQL - How to create a new NAV database for restoring a NAV backup
  • Basic SQL - How to attach a database to SQL Server
  • Basic SQL - Creating users in NAV on SQL
  • Basic SQL - Restoring a SQL Server backup

More General  NAV and SQL Server blog posts

How Do I Videos

• How do I: perform a backup of Dynamics NAV 2009 SP1 Database using SQL Server‎​

Developing for SQL Server in Microsoft Dynamics NAV​​

Training Manuals

• C/Side Solution Development in Microsoft Dynamics NAV 2009
  • Chapter 11: Optimizing for SQL Server

MSDN Developer and IT Pro Documentation

• Data Format Considerations
• Identifiers, Data Types and Data Formats in the SQL Server Option for Microsoft Dynamics NAV
• SQL Server Data Types
• SIFT and Microsoft Dynamics NAV with Microsoft SQL Server
• C/AL Database Functions and Performance on SQL Server
• Keys, Queries, and Performance
• Bulk Inserts
• Locking in Microsoft SQL Server
• Maintaining Table Relationships on SQL Server
• Accessing Microsoft Dynamics NAV Tables with External Tools
• Using Linked Objects
• Creating Table Defintions from SQL Server Objects (Linked Objects)
• Login Stored Procedure on the SQL Server Option‎

NAV Team Blog Posts

• Record-level locking in the SQL Server option for Microsoft Dynamics NAV‎
• How using SQLIndex property can affect which index NAV uses
• Temporary Tables: Different Type of Sorting Order in SQL Server Environment

SQL Server Performance Optimization Resources for Microsoft Dynamics NAV​​

Training Manuals

• SQL Server Installation and Optimization for Microsoft Dynamics NAV 2009
  • Chapter 4: Performance Audits
  • Chapter 5: Improving Application Performance
  • Chapter 6: Maintenance
• C/Side Solution Development in Microsoft Dynamics NAV 2009
  • Chapter 11: Optimizing for SQL Server

MSDN Developer and IT Pro Documentation

Microsoft Dynamics NAV 2013

• Optimizing SQL Server Performance with Microsoft Dynamics NAV 2013
  • Data Access Redesign
  • Table Keys and Performance
  • Bulk Inserts
  • C/AL Database Functions and Performance on SQL Server
  • Query Objects and Performance
  • Configuring Microsoft SQL Server

Microsoft Dynamics NAV 2009

• Improving Application Performance in Microsoft Dynamics NAV 2009
  • Keys, Queries, and Performance
  • Bulk Inserts
  • Configuration Parameters
  • C/AL Database Functions and Performance on SQL Server

KB Articles

• 978100 - Blocking problems caused by Microsoft Dynamics NAV 2009 SP1 using Microsoft SQL Server SERIALIZABLE isolation level

NAV Team Blog Posts

• Microsoft Dynamics NAV/SQL Server Configuration Recommendations
• Performance Analyzer 1.0 for Microsoft Dynamics 
• Degraded Performance on Dynamics NAV and the SQL Server TokenAndPermUserStore
• Table Information including Index information (Usage, Blocks and Reads)
• Performance Optimization Changes for Microsoft Dynamics NAV with SQL Server - REPEATABLEREAD
• Microsoft Dynamics NAV and SQL Server Database Compression
• Simple query to check the recent blocking history
• Index Usage Query
• Index Usage Information Tool
• How to read a SQL Profiler trace file into a SQL table
• SQL Query to show tables, their indexes and index usage

More Performance blog posts

SQL Server Security for Microsoft Dynamics NAV​

Training Manuals

• SQL Server Installation and Optimization for Microsoft Dynamics NAV 2009
  • Chapter 2: Setup and Installation

MSDN Developer and IT Pro Documentation

Microsoft Dynamics NAV 2013

• Setting Database Owner and Security Administration Permissions
• Enhancing Microsoft Dynamics NAV Server Security‎

Microsoft Dynamics NAV 2009

• Security Model and Synchronization
• Setting Database Owner and Security Administration Permissions
• Enhancing Microsoft Dynamics NAV Server Security‎

Important Notice to Customers​​

We recommend that you contact your Microsoft Dynamics Partner before installing service packs or hot fixes. It is important to verify that your environment is compatible with the service pack(s), hotfix(es), or download(s) being installed. A service pack, hotfix, or download may cause interoperability issues with customizations, and third-party products that work with your Microsoft Dynamics solution.

Support Information​​

If you are experiencing issues with this page, please contact ITMBSSUP@microsoft.com

For technical support questions, contact your partner or, if enrolled in a support plan directly with Microsoft, you can enter a new support request to Microsoft Dynamics^® Technical Support from Customer Source or Partner Source under Support >> New Support Request.

You can also contact Microsoft Dynamics^® Technical Support by phone using these links for country specific phone numbers.
Partners - Global Support Contacts (requires PartnerSource login)
Customers - Global Support Contacts