Tag Archives: Database

Cool undocumented feature

I hate it when I don’t have time to blog. I’d like if I could tell you what I’ve been doing, but let’s leave it at this: I am enjoying my vacation, away from my office, my job, my projects, my customers, my partners, and obviously – my blog. You should take a vacation, too – great stuff!

Another thing I hate is to start anything with “I hate”. So, let’s switch the tone.

I love undocumented features. They afford you some brag time with your friends and colleagues. I’ve just found about a great undocumented feature in Microsoft Dynamics NAV: import objects from a .FBK backup (found on Plataan Knowledge Blog). If you just need the objects, there is no need to restore the whole database. Nice one!

(I already see myself using this – after the vacation, of course…)

Mystery laptop

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.

Continue reading Mystery laptop

Native vs. SQL: The Delta

Early versions of SQL Server option for Microsoft Dynamics NAV (then called Navision) didn’t scale up as high as one would expect. Although SQL Server itself could scale up to thousands and tens of thousands of concurrent users, running a production environment of an ERP system is way different from running generic lab tests.

SQL Server 2000 brought many improvements, and finally outperformed Navision Database Server at any level of user concurrency. SQL was gaining momentum, and became the platform of choice for new implementations of Navision. When SQL Server 2005 came out, and when support for it was included in Microsoft Dynamics NAV 4.0, it could outperform the native database platform as much as 35%.

Continue reading Native vs. SQL: The Delta

Native vs. SQL: The Evolution

One of the choices a customer interested in Microsoft Dynamics NAV must definitely make is the choice of the database platform. With NAV, there are two possible options: so called native database server, which is not really officially called that (the official name is Microsoft Dynamics™ NAV Database Server), and Microsoft SQL Server.

Continue reading Native vs. SQL: The Evolution