March 2009 - Posts

Why I don’t want my clients to use SANs for Dynamics NAV (Navision)

I am sure I am not the only person that has had to argue with a client as to how hardware needs to be configured in a Dynamics NAV environment. Typically bigger companies with larger internal IT support generally have their way of doing things, and its often very hard to sway them to do things "The Navision Way" As well as new implementations, I often will be asked by a client if they should switch to SANs This Blog really is about and kind of "Virtual Storage" system, and to...

Select * FROM and how to do it better in NAV

Some background I met with Mark in Barcelona some time back at Tech Ed. We had both just been to a SQL (not NAV related) session, and it opened both our eyes at that moment as to why the Select * in NAV is so bad. I did my first NAV performance tuning job in 1993, (Navision on OS/2 Warp) so I am not new to performance tuning, and since most of my years in NAV have been spent recovering clients form disasters, I generally get to see the worst end of it all. Now-a-days I am seeing a few largish NAV...

If it takes one person 10 days to dig a ditch, how long does it take 10 people to dig the same ditch?

A simple question from primary school math class. If your answer was "one day" then you are wrong, if you said 10 days you are probably also wrong. If you said 5 you are getting warmer. My first job after University was working on a Gold Mine. I eventually worked up to mine manager, and managed the largest Vat Leaching Gold Retreatment operation in Australia, so moving dirt is something I know a lot about. I am not sure how many people out there have to dig big holes in the ground, but...