Business Central SaaS Exporting Database Backup and Restore it on your Sql Server

Business Central SaaS Exporting Database Backup and Restore it on your Sql Server Since some days, Microsoft has activated the feature for downloading a backup of a Business Central SaaS Azure SQL Database directly from Admin Center. A selected database (in this case a BC v15 Wave 2 production database) can be backuped and exported … Read more

SQL Server Performance with Business Central

SQL Server Performance with Business Central Lately interesting articles have been published on how to optimize business central with sql server, how to better use the data cache, how to use partition tables, how to use compression, how to monitor performance, since they are interesting to report. Optimizing SQL Server Performance with Business Central https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/optimize-sql-server-performance … Read more

Using SQL Server Transparent Data Encryption (TDE) with Dynamics NAV

Using SQL Server Transparent Data Encryption (TDE) with Dynamics NAV Transparent Data Encryption (TDE) is available in Enterprise Edition of SQL Server as well as Azure SQL Database. “With TDE, you can encrypt sensitive data in the database and protect the keys that are used to encrypt the data with a certificate. TDE performs real-time … Read more

SQL Monitor

SQL Monitor I’ve done a lot of NAV optimizations and sometimes it’s enough to isolate the bigger issues to get a good result. Since NAV 2015 and with latest releases of NAV you can use standard monitoring systems… take a look to my old post about NAV 2015 Performance Counters: Monitoring Microsoft Dynamics NAV 2015 … Read more

XACT_ABORT “OFF” using NAV linked views on linked servers

XACT_ABORT “OFF” using NAV linked views on linked servers I describe this scenario because it’s interesting: NAV with linked views based on linked servers (distributed views). In my scenario i can’t change SQL Server Default XACT_ABORT option, we have two differents configurations for both SQL Servers involved in linked views. The issue is related to … Read more

Best practices for installing and configuring Microsoft SQL Server for Microsoft Dynamics NAV

The documentation on Installation Considerations for Microsoft SQL Server and Microsoft Dynamics NAV has been updated with information on recommended settings for SQL Server 2012, 2014, and 2016. The documentation contains recommendations on topics such as Storage and recommended disk block size Virus scanning Memory TempDB database configuration Auto-growth of database and/or transaction log files … Read more

“ALL ABOUT” Kill (In)active Sessions when “no more licenses”

Sometimes it happens that there are “no more licenses available” for Dynamics NAV, from NAV 2013 R2 and next releases, it’s necessary to run the Windows Client or to use Powershell statements to kill some sessions and unlock others. If you are unable to access to NAV (“no more licenses”), you should need to use … Read more

“ALL About” How To Boost Dynamics NAV Server

Hi Guys, another post of “ALL About” Series, in this case, some people have asked me about NAV configuration and how to configure NAV Server for better performance (Boosting NAV..);  also in Microsoft Forum there are several posts about this topic, i searched and collected a variety of useful information for a correct NAV Server configuration. … Read more

SQL Server Migration Assistant for Datazen now generally available

A blog from the SQL Server Reporting Services product team at Microsoft. Source: SQL Server Migration Assistant for Datazen now generally available | SQL Server Reporting Services Team Blog Post Views: 1,218

SQL Server 2016 is generally available

Official News from Microsoft’s Information Platform Best News A new platform for intelligent applications Benchmark leadership through efficient use of modern hardware Large performance improvements from prior versions Unmatched security record Unmatched value proposition Gartner Magic Quadrant for Operational DBMS Leader Datasheet http://www.microsoft.com/it-it/server-cloud/products/sql-server-2016/ Source: SQL Server 2016 is generally available today Post Views: 1,373

%d bloggers like this: