SQL Server

imageMarketing is nice as long as it matches the reality. With Microsoft Dynamics NAV 2013, Microsoft has promised a lot of improvements, but how well does NAV 2013 stand the reality test?

Apparently, outstandingly well.

Over the past two days, I have intensively tested NAV 2009 and NAV 2013 through a series of five different tests that measure different aspects of NAV data handling. My conclusion is clear: NAV 2013 is faster than any NAV you have ever seen, including the Classic client on the native database.

Continue reading to find out more about my findings and testing approach.

[click to continue reading…]

{ 32 comments }

Top 5 SQL Server Improvements in NAV 2013

by Vjekoslav Babic on June 21, 2012

imagePerformance is one of those things you can’t get enough of and NAV is one of those systems where an extra operation per second is always welcome. Yesterday, during the Expert Panel at the NAV day of the Decisions Spring conference, there was a question: is there any improvement in how NAV 2013 works on SQL Server.

And the answer is: oh yeah!

As a matter of fact, everything is new and improved.

Jörg has already posted an overview of the news of NAV on SQL Server in his last blog post, but I still think there’s room for a couple of more words on the really amazing palette of news and improvements.

[click to continue reading…]

{ 20 comments }

Was it necessary to kill the Classic client?

by Vjekoslav Babic on October 31, 2010

dinosaurAbsolutely.

The world needs to move ahead. The technology advances. Who doesn’t want to keep up with the progress, stays behind. That’s how it has worked since the dawn of civilization.

I can’t know the exact reasons why Microsoft has decided to stop support for the Classic client with NAV “7”, but I can offer my view and position on why I believe this was absolutely necessary.

[click to continue reading…]

{ 12 comments }

Death of Classic (C/SIDE) Client

by Vjekoslav Babic on October 28, 2010

tomb_guardYesterday, during a coffee break at the What’s New in Microsoft Dynamics NAV 2009 Technical for Application Consultants training in Vilnius, Lithuania (a fabulous place, by the way), a discussion arose around the destiny of the Classic (or C/SIDE) client in NAV. Some participants stated that “it’s never going to go away” because “Microsoft would not dare shutting it down”.

Unfortunately, it is going away, and quickly. Maybe it wasn’t too obvious at first, because Microsoft never actually said explicitly that “Classic client is going to be discontinued”, but if you read the latest Statement of Direction for Microsoft Dynamics NAV, it’s there.

[click to continue reading…]

{ 9 comments }

Microsoft Dynamics NAV Team Blog has just published a mega-useful post about recommendations for configuring Microsoft SQL Server for optimum Microsoft Dynamics NAV Performance. If you haven’t yet, you should check it here.

The blog post delivers a PDF document summarizing certain important parameters, configuration settings and suggestions for improving and maintaining a speedy SQL Server for your NAV installation. The recommendations have been written for x64 version of SQL Server 2005 SP3, SQL Server 2008 SP1 and SQL Server 2008 R2. The document was compiled by Michael De Voe, a Senior Premier Field Engineer at Microsoft specializing in performance, scalability, infrastructure and high-availability for in NAV and AX.

{ 4 comments }

NAV blogosphere in April

May 4, 2009

April. There is definitely something upside down with this month. I’ve started it with a somewhat ambitious decision to blog a post a day. And it worked. Kind of. For the first eight days, anyway. And then it happened. Suddenly I’ve found myself blogging only occasionally, practically chasing my promise to deliver a blog post twice [...]

[click to continue reading…]

Tip: Microsoft Dynamics NAV 2009 code page validation

March 31, 2009

This is bazillionth time that I’ve encountered this issue, so I’ve decided to post a solution to it. If you live in a country which doesn’t have Microsoft Dynamics NAV 2009 localized version yet, you might have tried installing the W1 (worldwide, English, non-localized) version. Did it work out? If you install the NAV 2009 [...]

[click to continue reading…]

What did NAV bloggers say in February?

March 2, 2009

Microsoft Dynamics NAV blogosphere wasn’t particularly active in February. Trust me, I don’t blame anyone for it. February is a slow month. Economy is down, forests are burning in Australia, planes are crashing in Netherlands. Whatever the reason, NAV bloggers weren’t as active in February, as they were in January. Still, there were some noteworthy [...]

[click to continue reading…]

Automated Version Management 2.0 – An Update

August 28, 2008

[Updated] I had to update this post a little bit, see below for the details, but the killer feature had to go [/Updated] Remeber that tool “Automated Version Management” that I published here and on Mibuso five months ago? It has just got an update: version 2.0.

[click to continue reading…]

Mystery laptop: an update

June 12, 2008

Never trust the customer We were sure that the server had last service packs applied, that’s the first that we asked of the customer IT, and got a definite answer that “But, of course!”. So we didn’t really think this might be an issue. Then we noticed that SQL Server build number was 1399, while [...]

[click to continue reading…]

Mystery laptop

June 12, 2008

I had no clue how good my laptop was. Seriously. Today it kicked ass of an 8-processor server. Tomorrow we have a go-live of a Microsoft Dynamics NAV deployment, with manufacturing customized to support configure-to-order functionality. Refreshing manufacturing orders now calculates dynamic BOMs and routings, and it takes time.

[click to continue reading…]