A short while ago I informed you about an important hotfix for Navision 4.0 SP3 and 5.0 SP1. At one of my larger customers in Germany we implemented this build. It is really working great and solves a lot of problems caused by the Dynamics cursors introduced in build 26410. However we have managed to...
Time for some tips about how to use the SQL Server Management Studio. This is a really great tool which should be more used by NAV DBA's. First tip is how to include column headers when copying query results. This is something we often use when analysing systems remotely. When opening the management...
Currenly I am again fighting with SQL2005 at a customer. Many, many reads on tables whilst there are perfect and selective indexes. Now I've never experienced this problem on SQL2000. SQL always uses the right index for the query. I also know Navision has not changed the communication with SQL. What...
Today it started. Just got of Bob's keynote's. The opening was pretty cool with Christopher Lloyd from Back to the Future in his Time Machine. For me one thing was clear after the keynotes. This is the period of integration. Although TechEd is a Microsoft Classical event there are loads of information...