-
This is often an issue when you get a SQL Backup from a customer to analyse. Off course you can create a user on SQL and change the password, but it is easier. Navision stores the users into two tables. User and 'Windows Login', The first table is for database logins, the latter for Windows Logins...
-
This tip is about the SQL Server Management studio again. Many Dynamics Nav customers and consultants are very new to SQL and the programming language T-SQL. The SQL Server has solved that with introducting tons of wizards for common tasks like backing up databases and creating users. Let's look...
-
In my previous tip ( http://dynamicsuser.net/blogs/mark_brummel/archive/2009/06/13/tip-6-find-locked-records.aspx) I showed you how to find which exact records are locked and 'proved' row locking with the 'LOCKTABLE' command. But even then you can eperience another fact. Sometimes SQL...
-
Sometimes, when you investigate performance issues you see users blocking each other on small tables with good indexes and small locks. In that case it can be very interesting to know exactly which record in the table is locked and which records are available. That is what this tip is about. Most hardcore...
-
BE CAREFUL : NEVER IMPLEMENT A HOTFIX IF IT IS NOT NESSESAIRY THIS IS A VERY NEW HOTFIX AND IT MIGHT CONTAIN ERRORS For everyone who is involved in the art of performance tuning of the Dynamics NAV (Navision) product on SQL Server 2005 I would like to focus some attention on this hotfix. Slow performance...
-
Recently in DynamicsUsers.net some "Wiki" was posted showing how to audit Object changes in NAV with SQL site Triggers; see http://dynamicsuser.net/wikis/navdev/auditing-who-changes-an-object-sql-only.aspx This actually describes how to add some fields to the NAV Object table and to save the...
-
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...
-
After all the theory about VSift in my previous blog posts now a tip about how to tune VSIFT. Before I continue first this. VSift is not a bad technology but the implementation in NAV has one big downside. The good old SIFT levels have disapeared. In older versions of NAV there was a SIFT Level property...
-
With the introduction of VSIFT, a new perception was introduced. There are no more Zero SIFT records. More about VSift in http://dynamicsuser.net/blogs/mark_brummel/archive/2009/04/12/vsift-the-day-after.aspx With the classic SIFT it was possible to have SIFT records that did not contain any totals....
-
This time another tip on how to use the SQL Management Studio. Dynamics NAV (Navision) keeps a copy of all tables on SQL server for each company you create, no matter if the table is populated or not. This way of creating tables can lead to a long list of tables in the SQL Management Studio. Expanding...
-
Some time ago a new technology for SIFT was introduced. SIFT is a technology that makes it possible in NAV to use the flowfields with the powerfull flowfilter technology. It stands for Sum Index Flow Techology. In the classic database the flowfield data was kept at index level. SQL does not have these...
-
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...
-
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...
-
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...
-
BLOB = [ B inary] L arge OB ject Well, several tables in MS Dynamics NAV use such "BLOB"-fields to store binary data like pictures. This could be quite convenient for the application, for example for creating Item catalogues displaying such pictures, etc. but from a NAV/SQL performance perspective...