Since 2006 I'm supporting Dynamics customers and partners within their NAV
projects as a freelancer. I'm developing & distributing the optimization utility
"The NAV/SQL
Performance Toolbox" and I am the author of "The NAV/SQL Performance
Field Guide" (ISBN 978-3-8370-1442-6)
Syndicated From:
http://dynamicsuser.net/blogs/stryk/default.aspx
-
I really have a deep conflict here … we have recently started a "Database Security" project where we are developing solutions to fix certain NAV issues … so yes, this means there are " security issues ", and talking about...
Read More...
|
-
Recently I was asked by MSDynamicsWorld.com if I would like to write some articles for their website. Of course I would like I call this column " NAV/SQL Quickies " and I try to pick out several NAV/SQL related topics to put a brief spotlight...
Read More...
|
-
Hi all, Puuuuhh, that was quite a rush … originally my idea about the TA was just to attend, but unfortunately one of the speakers got sick, and fortunately MS asked me if I could be available … <big grin> Of course I was available...
Read More...
|
-
While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts...
Read More...
|
-
A frequently asked feature for NAV is some kind of advanced search feature , which allows to search multiple fields of the same record at once . For example, to search for " Contacts " which have the expression "The" either in the...
Read More...
|
-
Wow! I came across Erik's BLOG ( http://dynamicsuser.net/blogs/admin/archive/2009/06/12/the-100-most-influential-microsoft-dynamics-people.aspx ) and I was more than surprised when I saw my name on this list. The British Community " Dynamics...
Read More...
|
-
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...
Read More...
|
-
LOB = [ 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...
Read More...
|
-
The following matters only for those who still run on SQL Server 2000 , as since SQL Server 2005 the DBCC DBREINDEX and DBCC INDEXDEFRAG actually have been replaced by the ALTER INDEX REBUILD/REORGANIZE command (I don't know if the following problem...
Read More...
|
-
Well, it is a frequently asked question „ How to prevent multiple logins of the same user in NAV? ". Usually the reason for this is to save client-licenses, or other things. When browsing the known web-forums you'll find several approaches...
Read More...
|
-
Well, "Performance Optimization" in NAV & SQL is some sort of "Cornucopia of issues" – starting from Hardware Sizing, Platform Configuration, Index Tuning, SIFT Optimization, etc. … and – last but not least – the question: "...
Read More...
|
-
While struggling with NAV/SQL performance issues for many years I scribbled down countless pages about various issues, learned by own experience or from colleagues, taken from numerous knowledgebase articles, whitepapers, etc. or heard in several webcasts...
Read More...
|
-
Well, we all know that " Index Statistics " are crucial for optimized query processing in SQL Server, that we shouldn't use "Auto. Create Stats" or "Auto. Update Stats", that we should use "Jobs" or "Maintenance...
Read More...
|
-
Well, a current discussion is whether to go for NAV 5.0 Service Pack 1 or not. On the one hand, NAV 5.0 SP1 has lots of improvements regarding SQL performance (Indexed Views, Buffered Inserts, etc.), on the other hand there are other issues and problems...
Read More...
|
-
Today I just ran a brief test to compare the performance of queries on " SIFT Tables " (older NAV versions) with queries on " Indexed Views " (introduced with NAV 5.00 SP1) called VSIFT . Well, in previous BLOGs or forum threads I...
Read More...
|
-
Well, "Performance Optimization" in NAV & SQL is some sort of "Cornucopia of issues" – starting from Hardware Sizing, Platform Configuration, Index Tuning, SIFT Optimization, etc. … and – last but not least – the question: "...
Read More...
|
-
Ho, ho, ho … well, X-Mas is coming soon, time to make a wish-list! In my special case I would like to ask for several things making life with NAV and SQL easier. I'm not asking for "science fiction" features like " non-blocking posting...
Read More...
|
-
Well, at Convergence 2007 in Copenhagen it was announced (Session: NAV Keynotes) that in Q1 2008 the SP1 for NAV 5.00 would be released (dates are subject to change, of course). During the "Meet the Experts" session little more information about...
Read More...
|
-
Base on David's "hint, hint ) I made my promise come true and copied this from a current thread: SIFT tables include aggregated information of e.g. "Ledger Entry" tables to display these values in FlowFields. The aggregation is done...
Read More...
|
-
Here we go! So, this is my very first BLOG! I don't know why .... I have been writing postings in hundreds of forum threads, but never dared to put it a BLOG ... hmmm, feels somewhat "different" than answering or asking questions ... Most...
Read More...
|
|
|
|