May 29, 2010 11:20

Optimizing SIFT and VSIFT

Well, I guess SIFT/VSIFT tuning is also some kind of standard task, and even though I previously – briefly - explained something about this I never got into the details. This is what I'd like to do now. 1. What's "SIFT"? SIFT is for " S um I ndex F lowfield T echnology ", hence it is a technology used to display " FlowFields " in NAV. The idea of "FlowFields" (FF) is to not save any sum-values within a table, but to calculate these sums "on...
Posted by Jörg A. Stryk | 4 comment(s)
Filed under: , , , ,
May 25, 2010 9:02

#13 of Top 100 Most Influential Dynamics People (2010)

Wow, again! I just got the notice that the British Dynamics Community " Dynamics World " ( http://www.dynamicsworld.co.uk ) voted me on rank #13 of " The Top 100 Most Influential People in the Dynamics World 2010 "! I have to admit that I'm really proud about this and feel quite flattered - thank you all so much for voting for me! And congratulations to all others who made it on " The List " Cheers, Jörg
Posted by Jörg A. Stryk | 3 comment(s)
Filed under:
May 20, 2010 11:00

Directions EMEA 2010 – NAV/SQL Performance: Indexes

Directions EMEA 2010 from 19 th to 21 st May 2010 in Prague/CZ. Website: http://www.directionsemea.com/ Well, actually this is not some new stuff, actually the presentation is quite similar (but stronger focus on indexes) than this one: http://dynamicsuser.net/blogs/stryk/archive/2010/02/10/technical-airlift-2009-munich-nav-sql-performance-optimization-indexes.aspx The scripts & templates (attached) have been improved. ALL SCRIPTS, TEMPLATES ETC. ARE PROVIDED "AS IS". NO WARRANTY, NO...
Posted by Jörg A. Stryk | 4 comment(s)
Filed under: , , , , ,
May 19, 2010 20:00

Decisions Spring 2010 – NAV/SQL Performance: Blocks and Deadlocks

Decisions Spring 2010 from 19 th to 20 th May 2010; MSDynamicsWorld.com 's spring online conference and trade show, is coming to your desktop, live! Website: http://decisions.msdynamicsworld.com/ Well, actually this is not some new stuff, actually the presentation is quite similar (but shorter due to time) than this one: http://dynamicsuser.net/blogs/stryk/archive/2008/11/03/blocks-amp-deadlocks-in-nav-with-sql-server.aspx The scripts & templates (attached) have been improved. ALL SCRIPTS...
Posted by Jörg A. Stryk | 4 comment(s)
Filed under: , , , , ,
Mar 4, 2010 0:00

„NAV/SQL Quickies“ on MSDynamicsWorld.com

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 on them; having in mind the articles should not be as long and detailed as my BLOG uses to be. But as I'm lacking any " gossip capabilities " it will be somewhat "technical" anyway. (Please regard that the articles might be...
Posted by Jörg A. Stryk | with no comments
Filed under: ,
Feb 16, 2010 12:00

Extended NAV/SQL Database Hardening

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 potential solutions is not possible without describing the problem … we have the proverb " You should not wake up sleeping dogs ", especially not the mean, filthy ones, having no good in mind … you see my problem? Anyway...
Posted by Jörg A. Stryk | 3 comment(s)
Filed under: , , , ,
Feb 10, 2010 17:30

Technical Airlift 2009 (Munich) – NAV/SQL Performance Optimization: Indexes

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! </big grin> The pity was, I just had half a day to prepare my session, but according to the great feedback I got so far, my session was very much appreciated! Edit 10.02.2010: Finally - the Video (German): https://training.partner.microsoft.com...
Posted by Jörg A. Stryk | 7 comment(s)
Filed under: , , , , ,
Dec 9, 2009 8:00

The NAV/SQL Performance Field Guide - 4th Edition

News Update 9th June 2010: Recommended by Microsoft, see http://blogs.msdn.com/b/nav/archive/2010/06/08/books-four-options-for-learning-more-about-how-to-create-roletailored-solutions-with-microsoft-dynamics-nav.aspx >> 09.12.2009 - Important Notice In the past days I received several complaints that Amazon.com (and probably Amazon.co.uk , too) are still shipping the old - 3rd - edition. This is due to a big mistake by my publisher " Books on Demand ". I reported the issue to them...
Posted by Jörg A. Stryk | 19 comment(s)
Filed under: , ,
Sep 26, 2009 11:34

Using SQL Server Full Text Search with NAV

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 " Name " or "Name 2" or " Address " or " Address 2 " or " Search Name " or … and so on. To accomplish this in NAV this might require a lot of programming, but the filters which have to be used...
Posted by Jörg A. Stryk | 3 comment(s)
Filed under: , , , ,
Jun 13, 2009 11:51

#38 of Top 100 Most Influential Dynamics People (2009)

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 World " ( http://www.dynamicsworld.co.uk ) voted me on rank 38 among the Top 100 Most Influential Dynamics People together with lots of other people well known from http://dynamicsusers.net or http://www.mibuso.com . I feel really proud and honored...
Posted by Jörg A. Stryk | with no comments
Filed under:
May 18, 2009 13:43

Object Auditing

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 User Name etc. who has changed an Objects. Also, on German NAV Developer's BLOG recently was shown how to generate a SQL Report about " Schema Changes "; see http://blogs.msdn.com/german_nav_developer...
Posted by Jörg A. Stryk | with no comments
Filed under: , , , ,
Feb 12, 2009 18:53

BLOB Fields with NAV & SQL

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 BLOB could also be a real pain – I'd like to explain why, and what I recommend to do to avoid the problems … The basics A NAV " BLOB " data-type is actually the "...
Posted by Jörg A. Stryk | 3 comment(s)
Filed under: , , , , ,
Dec 18, 2008 11:08

DBCC DBREINDEX vs. DBCC INDEXDEFRAG

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 also affects ALTER INDEX). Why executing anyway? Well, Indexes will fragment over time, as data is inserted, modified or deleted anytime when processing NAV (or other) transactions. Basically it's the same like a hard-disk-drive could fragment...
Posted by Jörg A. Stryk | with no comments
Filed under: , , ,
Dec 10, 2008 21:20

Prevent multiple Logins in NAV with SQL Server

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 to perform this; from executing 3 rd -party applications to kill processes, to sending Alt-F4 keys via " Windows Scripting Host " to manually kill a session in " Session Monitor " (NAV) or " Activity Monitor " (SQL Server...
Posted by Jörg A. Stryk | 2 comment(s)
Filed under: , , , , ,
Nov 3, 2008 0:00

Blocks & Deadlocks in NAV with SQL Server

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: " How to prevent and solve blocking conflicts? " At the " Directions EMEA 2008 " Event in Paris I tried to give some feasible, practical advices to answer this question. The following should give some further...
Posted by Jörg A. Stryk | 17 comment(s)
Filed under: , , , , ,
More Posts Next page »