Dynamics NAV SQL Server

The Microsoft SQL Server option allows employees easy access to accurate business data. Employees can access information concurrently and make comparisons. The server allows for data warehouses of any size to attract more customers, expand marketing strategies and enhance partnerships. The Microsoft SQL Server is the industry standard that easily integrates with third party products and applications as well as other Microsoft products. Many administrative tasks can be automated to improve data management.

Robust Security

SQL Server 2008 enforces password complexity and password expiration to enhance database security. Policies for individual users can be set form within Microsoft Dynamics NAV to help ensure that users adhere to password policies and expiration. Microsoft Dynamics NAV domain policies are retained, freeing administrators from the need to define and monitor additional policies.

Business Analytics

With extended OLAP functionality, administrators can build data warehouses of any size. Information is easily stored and accessible for analysis to people across your organization. SQL Server Analysis Services provides integrated views of business data for advanced reporting, OLAP analysis, key performance indicator (KPI) scorecards, and data mining. Users can create SQL Server Analysis Services and SQL Server Reporting Services reports directly in Excel and Word formats. SQL Server Analysis Services integrates out of the box with Microsoft Office PerformancePoint Server 2007, empowering users to quickly populate data cubes and perform analyses in PerformancePoint Server with data from Microsoft Dynamics NAV.

Efficient Data Management

Provide IT staff and administrators with an integrated management environment to monitor, manage, and tune databases and services. Handle growing transaction volumes and user efficiently with fast integration of data into data warehouses and simplified indexing, partitioning, and management for database tables. Consolidate all your data with support for both relational and non-relational data, including new data types that enable you to efficiently store, manage and analyze unstructured documents and image. Help protect data against hardware incidents and failures with backup capabilities that can speed recovery with fine-grained error repairs, online backups, and controlled checkpoints.

High Availability

Significantly reduce downtime needed for database maintenance and repair. In the event of hardware failure, Database Mirroring captures a database copy and Database Snapshot enables recovery from operator error by creating read-only copies of a database at a point in time. SQL Server 2008 also makes it easy to create a new index or defragment and rebuild an existing index, while the Microsoft Dynamics NAV installation remains online.