http://mibuso.com/blogs/kriki Mostly about Dynamics NAV Thu, 18 Mar 2010 21:26:18 +0000 http://backend.userland.com/rss092 en Do you remember the Clustered Index bug of 4.0SP1 (see also http://www.mibuso.com/dlinfo.asp?FileID=594)? In short: 4.0SP1 forgot to set the index-property "Clustered" on the primary key (the default is that the primary key is clustered). The result is that the tables were heap-tables and that is (generally) bad for performance. The fix was ... http://mibuso.com/blogs/kriki/2010/03/18/clustered-or-not-clustered/ The title could also be "Windows 2000, XP SP2 and Vista End of Life Support", but I found my title funnier. The fact is that Windows 2000 is close to 10 years old and it is retiring (together with some younger versions). What is this about : Microsoft stops supporting some windows ... http://mibuso.com/blogs/kriki/2010/03/17/happy-birthdayretirement-windows-2000/ It is field 8725:"Signature" and it seems to be used in F8726:"Mobile Order Signature".   Question: Why a post about this field?   Answer: Because it can (and sooner or later) will cause performance problems.   What happened? A colleague calls me to tell a customer has performance problems open the sales order form. But not always. I ... http://mibuso.com/blogs/kriki/2010/03/09/did-you-know-table-36-has-a-blob-field/ I found out this virtual training and thought it could be of interest for SQL tuners. http://www.vconferenceonline.com/shows/spring10/quest/register/multireg.asp The bad thing is: it starts at 07:45 ET-time. That means  13:45 CET. And it stops at 23:30! Anyway, I am following it with the moka (to make italian coffee) nearby. http://mibuso.com/blogs/kriki/2010/02/17/sql-server-training-on-dmvs/ Maybe you ask: what title did he invent now? It has nothing to do with NAV or SQL Oh, yes! It is about both! Here it comes. The crime scene: NAV2009 classic client with NAV Jobqueus that launches a job in a Webservice and goes on with other jobs (thanks to ara3n for ... http://mibuso.com/blogs/kriki/2010/02/17/am-i-a-detective/ I read in some blog it was a 64bit only release, but that doesn't seem to be true (You can download a 32-bit CTP HERE). Some  other links: http://blogs.technet.com/dataplatforminsider/archive/2010/01/19/sql-server-2008-r2-gets-an-official-date.aspx  http://www.brentozar.com/archive/2010/01/sql-server-2008-r2-release-date-may-2010/  http://www.brentozar.com/archive/2009/11/sql-server-2008-r2-pricing-and-feature-changes/ http://www.brentozar.com/archive/2009/09/sql-server-2008-r2-frequently-asked-questions/ http://mibuso.com/blogs/kriki/2010/02/09/sql-server-2008-r2-release-date-may-2010/ Have you been at a customer where ONLY Windows logins are allowed?   So launching NAV (or SQL Server Management Studio) to connect to their database is impossible.   Can you connect to their database if you don't have a remote terminal or citrix to some computer in their domain?   Yes, you can!   Microsoft has a ... http://mibuso.com/blogs/kriki/2010/01/19/customer-with-only-windows-logins-and-you-are-not-in-their-domain/ I just read something very interesting: Backup compression is available in SQL Sever 2008 R2 Standard!  Read more That is very good news. No more need for Enterprise version for backup compression! This is the feature I like the most in SQL 2008! It speeds up backups (most processors are idle anyway) and ... http://mibuso.com/blogs/kriki/2009/11/27/backup-compression-in-sql-server-2008-r2-standard/ And now that I am busy with recursion: -- recursive CTE to generate numbers like the NAV date table DECLARE @from AS DATE; DECLARE @to AS DATE; SET @from = '2009-01-16'; SET @to = '2009-03-20'; WITH DateTable ([The Date]) AS (SELECT @to UNION ALL SELECT DATEADD(DAY,-1,[The Date]) FROM DateTable WHERE DATEADD(DAY,-1,[The Date]) >= @from ) SELECT * FROM DateTable ORDER BY [The Date] OPTION (MAXRECURSION 0) See ... http://mibuso.com/blogs/kriki/2009/11/20/nav-date-table-in-sql-statement/ If we want to loop on integers in NAV, we can use the integer table and put some filters on it. The problem is that in SQL, we don't have such a table. It is possible to create the table with a recursive CTE (Common Table Expression). If you want, you can also ... http://mibuso.com/blogs/kriki/2009/11/20/nav-integer-table-in-sql-statement/ I just got some strange error using STRSUBSTNO: The text '...' in STRSUBSTNO parameter no. 1 is too long. Surprise : Is the string I give already longer than 1024 chars? But shouldn't I have got an error when assigning that value to my variable that I sent into STRSUBSTNO????? I was wondering ... http://mibuso.com/blogs/kriki/2009/11/10/strsubstno-bug-or-feature/ A lot of times there are questions about the license in SQL. How to import it? At what scope serves the "Save license in database" toggle in Tab integration?   Here a short explanation:   *File=>Database=>Alter=>Tab Integration=>Save license in database. A license can be cut to be used at server level (this means the same ... http://mibuso.com/blogs/kriki/2009/09/30/license-file-in-sql/ As we all (should) know, SQL is based on sets and NAV works iterative with records. Sometimes it is possible to do set based programming also in NAV. I just found an example in which we can speed up something thinking in sets (1 record is also a set!) instead of iterative. ... http://mibuso.com/blogs/kriki/2009/09/09/set-based-thinking-in-nav-on-sql/ I receive quite often this question. Now someone answered it really well: Goals, obsessions, and aspirations: becoming an MVP http://mibuso.com/blogs/kriki/2009/08/26/how-to-become-an-mvp/ A little trick for all codefields on which there is a tablerelation to a table (Customer No., Vendor No., Items No.,...). You can always use F6 to select the value you want but there is a shortcut: For example: you have all your customers coded by "C000001".."C999999" and you know the code ... http://mibuso.com/blogs/kriki/2009/08/26/fill-code-field-without-typing-complete-value/ Why would someone want to use the Stand-By function on Windows 2008 Server? You even have to search for it (With Start =>  ...) you don't find it! You need taskmanager (or ProcessExplorer to be able to use the Stand-By function on Windows 2008 server. Ok, but why use the Stand-by functions. ... http://mibuso.com/blogs/kriki/2009/08/10/stand-by-on-windows-2008-server/ I just wrote a new how-to how to work with record-variables and the responses made me test some things. While testing the SQL-statements between GET,FINDFIRST, FIND('=') I noticed something VERY interesting! In the OPTION of the select, I noticed (OPTIMIZE FOR UNKNOWN)! Maybe you are asking why I am so exited about it? Remember ... http://mibuso.com/blogs/kriki/2009/08/02/select-option-optimize-for-unknown/ Lately I have very little time to write blogs or to be online in general. But I found some time anyway to write a new how-to. Took me over a month anyway to write it. I have noticed too many times that a lot of people use record-variables in a completely ... http://mibuso.com/blogs/kriki/2009/07/27/how-to-work-with-record-variables/ Well, I won't be blogging the sessions now because being part of the organization is quite a work.   But something I want to write anyway.   This is the third conference I do and the first one in which I am also an organizer. Well, to be honest, in reality it is Luc ... http://mibuso.com/blogs/kriki/2009/05/19/mibuso-conference-2/ The hotel was nice. Better than in Paris. Most of us there had a room where you had to walk a long way to reach it dealing with a labyrinth of hallways to reach the room. This hotel was a lot easier to navigate.   The only problem I found was to ... http://mibuso.com/blogs/kriki/2009/04/04/my-endnote-on-directions-emea-2009/ Yesterday Gerdien Cammeraat told me there that my blog would be mentioned in the endnote. And of course I missed it because I was still in the lab. I asked her what was told on it. And she told me that the speaker told that the event was being blogged ... http://mibuso.com/blogs/kriki/2009/04/04/lunch-and-closing/ This is the first time (ok, this is the second year Directions EMEA is organized) they organized a 'serial' session that is continued after the pause.   There were quite a lot of people and most haven't really worked with the transformation tool (neither did I :-( ). If the session took ... http://mibuso.com/blogs/kriki/2009/04/04/hands-on-lab-nav-2009-upgrading-and-transformation-by-olga-mulvad-brett-johnson/ I would say there are less people than on the other keynotes. How would that come? Well, some have already left for home. Some are visiting Barcelona (La rambla, Sagrada Famiglia,...) and some have a headache (confirmed by the speaker!). There is a lot to see in Barcelona but you need ... http://mibuso.com/blogs/kriki/2009/04/04/keynotes-3amr-research-by-nigel-montgomery/ Well, I skipped this one. But I did have some info on it. In busses they went to the stadium. There they had a tour in the stadium. There should have been a match, but it has been cancelled. After the tour the went to eat in the VIP-lounge (if I understood [and ... http://mibuso.com/blogs/kriki/2009/04/04/theme-dinner-at-the-fc-barcelona-stadium-camp-nou/ Well, if Convergence EMEA 2009 is cancelled, you can come to the Mibuso conference (http://www.mibusoconference.com/) on 14 May 2009. Microsoft wants to substitute Convergence EMEA 2009 with local events. And this is a local event and Microsoft is sponsoring it. One of the speakers is Michael Nielsen, a former Navision a/s ... http://mibuso.com/blogs/kriki/2009/04/04/mibuso-conference/ Why go into SaaS Strong growing demand CAPEX become OPEX TCO is predictable, visible, flexible and ... Lower Risk is reduced to the minimum Sales cycles are down Margin contribution is healthy Who is SaaSplaza 1 million end-users in 55 ... http://mibuso.com/blogs/kriki/2009/04/03/introducing-saasplaza/ Gerdien started with asking MS to get an object range for the add on, then Erik took over and we got really technical. And once his add on was ready, Gerdien took over again to finish the administration part with MS.   Before development Registered ... http://mibuso.com/blogs/kriki/2009/04/03/developing-a-certified-add-on-by-eric-wauters-gerdien-cammeraat/ Creating a complex report: most time goes in layout and coding. The transformation tool flattens all the dataitems of a report. E.g. an invoice with a dataitem for the header, a dataitem for the lines ... http://mibuso.com/blogs/kriki/2009/04/03/upgrading-reports-from-50-to-nav-2009-by-dmitry-chadaev/ What is Agiles workflow effect All process in one solution Better control Getting it right Employee productivity Design concepts Simple yet powerful A solution for all Partner friendly (few changed objects) E.g. Create item => automatic trigger => workflow for items (master data) => examine base data (who ... http://mibuso.com/blogs/kriki/2009/04/03/agiles-workflow-by-michael-rosenorn-and-mandy-dore/ Well, this session was part of another and should have been done after the other. If you read the other session, you will know why this wasn't the case : http://mibuso.com/blogs/kriki/2009/04/03/net-vs-cal-use-of-net-and-webservices-by-thomas-hejlsberg/     The later a defect is discovered the more money it costs and that goes exponential. How we test ... http://mibuso.com/blogs/kriki/2009/04/03/testing-dynamics-nav-by-rusty-miller/ He'll do some coding from scratch from c# to call C/AL and vice versa. Visual Studio : new project. Add a service- or webservice reference. (VS 2005 is webservice, VS2008 can do both) The URL needed for the service can be found in the documentation. Of course we are in a demo, so something ... http://mibuso.com/blogs/kriki/2009/04/03/net-vs-cal-use-of-net-and-webservices-by-thomas-hejlsberg/ Well, this is mostly sales talk. Explaining all their products.   All their products are build in NAV. So no problem interfacing. This is one thing I wanted to note because in the past I strongly supported that idea. Only recently I am accepting the idea to use ... http://mibuso.com/blogs/kriki/2009/04/03/winning-more-business-with-lanham-solutions-by-mary-lanham/ They started with a small video of last year. I still remember all the yellow people (it was raining! ; see also http://mibuso.com/blogs/kriki/2008/04/21/theme-dinner/) going out to Disneyland for the Theme dinner.   Some talking about the crisis. Seems a lot of people are complaining, but maybe it is not so bad at ... http://mibuso.com/blogs/kriki/2009/04/03/keynotes-2growing-together-by-wim-jansen/ I retarded a little with this post, because I wanted to be sure there was nothing under NDA. And I only found Dan Brown after 1 day and a half of searching. Last year the organizers had yellow shirts, now they are the 'pink panters'. Jan Sillemann and ... http://mibuso.com/blogs/kriki/2009/04/03/keynotes-1dynamics-nav-2009-and-beyond/ We had an MVP lunch and Kipper York told us that she read yesterday that the Convergence EMEA 2009 has been cancelled. I searched on internet and found some sites with more info.   More info: http://www.microsoft.com/dynamics/convergence/vienna09/default.aspx http://msdynamicsworld.com/story/dynamics-ax/microsoft-cancels-next-dynamics-european-convergence-event-save-customers-money http://mibuso.com/blogs/kriki/2009/04/03/bad-news-about-convergence-emea-2009/ General code changes in W1 New page objects 979000 lines of code in 50SP1 and 2421000 lines of code in NAV2009 325000 lines of code generated by transformations of forms General properties and triggers added 3500 objects ... http://mibuso.com/blogs/kriki/2009/04/02/upgrading-database-from-50-to-nav-2009merging-nav-2009-by-per-mogensen/ To check #users /#transactions Multiple countries in 1 DB #users>200 : attention   Large opportunities Amount $ # transactions # users   Competitors say: NAV is not scalable and for small customers How to address challenges 1 or more instances (scale out) Check #users/transactions Check user profiles (light/medium/heavy users and which modules do they ... http://mibuso.com/blogs/kriki/2009/04/02/dynamics-nav-strategies-and-resources-to-make-large-nav-implementations-successful-by-arend-jan-speksnijder/ Data migration To NAV from other systems Data loading Load customer order data on a nightly 'batch' basis Data integration Automatic processing of orders from an eCommerce application Synchronize customer/order data with other applications Business activity ... http://mibuso.com/blogs/kriki/2009/04/02/configurable-data-migration-and-integration-software-for-microsoft-dynamics%c2%ae-nav-by-lynn-harrington-and-david-baker-scribe/ History: 1990 : report designer 1990 : account schedules 2002 : jet reports 2008 : NAV 2009 report designer 2009+ : SSRS What did we learn: Fast in NAV Slow in Excel Security issues SSRS ineffective SSRS desirable Steeper learning curves Techie/power user No end user tool "Complex" NAV UX desirable Expensive Resistance to "new" We need right technology (fast,secure,...), user experience (familiar, easy ... http://mibuso.com/blogs/kriki/2009/04/02/dynamics-nav-reporting-roadmap-by-jay-malik-ron-summers-centerline-software/ What to write about the welcome reception?   I'll start with a small description of the hotel. It is a 5 star hotel build in 2006, so quite recent and you can see that. Wireless network everywhere, but not without problems. At a certain moment the network failed and after that my ... http://mibuso.com/blogs/kriki/2009/04/02/welcome-reception/ What happened? You have a full backup of your customer and restore it on your server. Once the restore is finished, you have to create a user in NAV that is known on your server. THIS BEFORE getting out of NAV. But of course you have forgotten to do it and ... http://mibuso.com/blogs/kriki/2009/02/18/how-to-get-access-when-you-cant-get-into-your-nav-sql-db/ I just noticed that ara3n made a blog-post about SQL2008 crunching (http://mibuso.com/blogs/ara3n/2009/02/17/sql-2008-compression-on-nav-database/) and I decided to add some information too. He did testing on DB-scale to see what happens to the DB. I did testing on some tables with enough records in it. I wanted to know how tables would ... http://mibuso.com/blogs/kriki/2009/02/18/sql-2008-compression/ Well, it is not my idea to point you to this, but Microsofts. But they have a point (and more than one) in doing it. ·        Early Registration discount date has been extended to January 21, 2009.  Save $300 by registering early, secure your favorite hotels ... http://mibuso.com/blogs/kriki/2009/01/24/convergence-2009-new-orleans/ I have a customer where all servers are virtualized into one BIG machine. And now we are implementing NAV. What do they have? They have 2 physical servers (64bit) with each 16GB of memory, 2 quadcore processors. They are completely virtualized with ... http://mibuso.com/blogs/kriki/2009/01/09/another-virtualization-project/ What is this? Well, here is some detailed info : http://en.wikipedia.org/wiki/Berkeley_Open_Infrastructure_for_Network_Computing or http://boinc.berkeley.edu/ But in short : it all started with SETI@home (http://en.wikipedia.org/wiki/SETI@home). To detect signs of extraterrestrial intelligent life in radiosignals. This asked for a lot of processing power that only supercomputers have (at a very high cost). So they invented ... http://mibuso.com/blogs/kriki/2009/01/07/boinc-berkeley-open-infrastructure-for-network-computing/ It has been some time that I blogged. But lately I really have little time. But this does not mean I don't follow up on blogs, topics and so on. Lately I found some rather interesting things (but I don't remember on which blog) for the transactionlog-performance.   First I will talk a ... http://mibuso.com/blogs/kriki/2008/12/23/some-tips-tricks-for-the-transaction-log/ As we all know, SQL has the "negative" aspect that it is possible to read records that are not yet commited (with some transaction type you can avoid this, but this is an other discussion). With the native DB, this is not possible.   Why do I put double quotes around negative? ... http://mibuso.com/blogs/kriki/2008/11/14/nav500sp1-bulk-insert-and-code-testing-on-sql/ A week ago, we (my wife and me) decided to buy a new desktop. What was to be just buying and re-installing turned out to be quite an adventure (... well not really, but it sounds good ...)   First thing I noticed is that even the lowest priced computers are quite ... http://mibuso.com/blogs/kriki/2008/10/13/a-new-desktop-pc-2/ We have a go-live date: the weekend of 20-21 September 2008! Read here for more info:Website maintenance (upgrade of forum) http://mibuso.com/blogs/kriki/2008/09/08/website-maintenance-upgrade-of-forum/ Inbox Here are all the messages that have been send to you. If it happens your PM-box is full, you need to delete some PM's to make place. This can also be done automatically by a setting (Private messages=>Rules, folders & settings=>Folder options [see later for more info]). http://mibuso.com/blogs/kriki/2008/09/06/private-messages/ This function is REALLY underused by the forum-members! What (and when or why) is reporting a post/topic? WHAT: Reporting means to bring a topic or post to the attention of the moderators/administrators. WHEN (WHY): When you think that a post/topic is spam or advertising or if it contains offensive text or pictures,... In the ... http://mibuso.com/blogs/kriki/2008/08/28/reporting-a-posttopic/ Someone has responded to your topic and you want to give more information or ask some extra information on the topic. So, go to the topic and then click the "postreply" button (not the newtopic! This will create a completely new topic). For the rest, this is less- or more the same ... http://mibuso.com/blogs/kriki/2008/08/28/create-a-new-post/ This has completely changed! The RSS-MOD we found has a lot of possibilities. Actually, it has so many options I had some problems too. After studying them, I advised Luc to remove some of them and to make some options standard. First thing: It makes a difference if you are logged in ... http://mibuso.com/blogs/kriki/2008/08/28/rss-feeds/ After you searched the forum and didn't find your problem (and solution), you decided to write a post. But first you needed to create a login and do some setup. After all that, finally you can make a new topic. First problem: in which forum? Well read the forum-descriptions and it will ... http://mibuso.com/blogs/kriki/2008/08/27/create-a-new-topic/ This one is new and quite interesting. What are friends for? Well, in general you want to keep them close! How? I think it is easier to explain it with an example. Manage friends If for example you send a lot of PM's to a certain person, in the new version you ... http://mibuso.com/blogs/kriki/2008/08/19/ucp-friends-foes/ Edit memberships Until now, Luc did change some things in the forum software to simulate groups (Administrators, Moderators, MVP, Site Supporters). Now this is integrated in the forum-software. All users, once they confirmed the registration, are placed into "Registered users". In some you can apply to join and if you meet the conditions, ... http://mibuso.com/blogs/kriki/2008/08/19/ucp-user-groups/ Edit global settings Also this is quite familiar. http://mibuso.com/blogs/kriki/2008/08/19/ucp-board-preferences/ Edit profile This is quite familiar, I would say. Ok. I admit it, the birthday part is new... http://mibuso.com/blogs/kriki/2008/08/12/ucp-profile/ Manage subscriptions If there are forums or topics that interest you, you can subscribe to it. If a post is created in that forum/topic, you will be notified. To subscribe a forum : Open the forum and in the top, you wil see "Subscribe forum" To subscribe a topic : Open the topic ... http://mibuso.com/blogs/kriki/2008/08/04/ucp-overview/ After registering and confirming it, best thing is to setup your profile before starting to post. Where to do that? In the User Control Panel. From now on, I will call the User Control Panel the "UCP"! And here is the UCP front page: It gives some basic information like when you joined, ... http://mibuso.com/blogs/kriki/2008/08/04/user-control-panel/ After searching something, it is possible you don't find anything, so you have to write your own topic to ask for help. Where to start? First step, I would say, is to read the forum rules (of course you can also read them BEFORE you start searching [The first rule ... http://mibuso.com/blogs/kriki/2008/08/04/forum-rules/ First and for all: Mibuso 3 has a new possibility to search: You can search on "Topic Titles Only"! In the old version, I always missed this possibility. Including the message texts in the search can give you a lot of extra topics that are NOT about your problem, but they are ... http://mibuso.com/blogs/kriki/2008/07/18/searching-mibuso/ About what do I need to blog and in which order? First what is there to blog about? I made a tour of Mibuso 3 to see what is new and make some note for a blog. I noticed that in almost (or all) places something was changed or added. Now I ... http://mibuso.com/blogs/kriki/2008/07/11/order-of-the-mibuso-3-blogs/ Well, actually it is not a new version of Mibuso, but a new version of the forum software. We are planning the upgrade in first half of September 2008! This is the first post about the new version. Other posts will follow in which I will explain the new features and some ... http://mibuso.com/blogs/kriki/2008/06/30/mibuso-v301/ We all know that the theoretical limit is 1GB for the cache on the native database. But the practical maximum we ever reached (or heard/read from others) is around 850MB. The same for me. I never installed or heard someone install a native database service and got over that 850MB limit (and ... http://mibuso.com/blogs/kriki/2008/05/26/cache-on-native-database/ When reading this blog, I first thought it was such an obvious thing, hardly worth to blog about it. But then I read the last part and he points out something that is obvious for me but probably it isn't THAT obvious for everyone: You really have to know your ... http://mibuso.com/blogs/kriki/2008/05/21/how-hard-is-it-to-pick-the-right-non-clustered-indexes/ On Directions EMEA 2008, Mark Brummel showed how to integrate performance monitor and SQL profiler. Later I tried to do it but couldn't and asked Mark to blog about it. But seems he is too late for it! I found this blog : How to Integrate Performance Monitor and SQL Profiler http://mibuso.com/blogs/kriki/2008/05/21/how-to-integrate-performance-monitor-and-sql-profiler/ Well, we all find (a lot of) bugs in programs. So why talk about them? Well, this bug is REALLY different. This bug is a very ancient one. One that came from the era of the first computers! What it is the story? Well, I was at a customer when suddenly someone told me ... http://mibuso.com/blogs/kriki/2008/05/15/i-found-a-bug/ I hoped to put the blogs online while I was waiting for the airplane, but I didn't have a connection at the airport. Sunday I had other (more important!) things to do: playing with my daughter and also her performance for her nursery school's 'gymnastics essay' (I don't find a ... http://mibuso.com/blogs/kriki/2008/04/21/some-general-remarks/ My first impression was that it was mostly salestalk to sell courses and certifications to both partners and customers, but later on it got more interesting. It was focused on NAV5.0 and NAV2009 though. Why do you care about training your people? -more consultants=more revenue, more margin. -more productive consultants=more revenue, more margin, ... http://mibuso.com/blogs/kriki/2008/04/21/partner-readiness-building-training-plans-for-your-employees-on-dynamics-nav-by-gina-haineslotte-cordt-ihlemann/ Integration options in previous versions -C/front -C/ODBC -OCX -Automation -Navision Application Server (NAS) Web services -new method of interacting programmatically with the MS Dynamics NAV system --Access over a network --execution on remote system -Widely-used, industry-standard --Understood/used by other systems/products --Best way to integrate across systems http://mibuso.com/blogs/kriki/2008/04/21/webservices-for-nav-by-kris-rafnsson/ "Directions was a great success." This is not my statement, but I definitly agree! Directions EMEA can become bigger then Directions US, because we have a very big community. MS business solutions guiding principles -build most recognizable brand in business applications market -deliver most innovative&easily adaptable platform of ISV's -preserve our customer and partner investments ... http://mibuso.com/blogs/kriki/2008/04/21/the-future-of-dynamics-by-jan-sillemanndan-brown/ Well, it started quite good: RAIN RAIN RAIN! Luckily the hotel provided some coats to protect us: Luc (at the right) and me (at the left). http://mibuso.com/blogs/kriki/2008/04/21/theme-dinner/ Before I posted this, I asked Michael if I could. He answered me that I could do it because it was already public. And also : there were also some customers on the event even if it was partners-only! Doomsday:What is there for the future: .NET, C#, reporting services,...? I will ... http://mibuso.com/blogs/kriki/2008/04/21/dynamics-nav-2009-exposed-major-technical-changes-by-michael-rosenorn/ We are talking about hosted applications. Why does business want hosted applications? What does this mean to the delivery model? What does this mean to your business model? It is an opportunity! http://mibuso.com/blogs/kriki/2008/04/18/hosting-dynamics-nav-by-john-brown/ SQL2005 can do a lot more for reporting then SQL2000. Why use datawarehouse when -native db is used for NAV -many users on NAV -large SQL Navision DB -need to combine or consolidate several companies in one report or cube with same structure and currency -heavy use of NAV dimensions -when you have additional data sources http://mibuso.com/blogs/kriki/2008/04/18/sql-reporting-services-and-bi-by-thomas-black-petersen/ Finished the sessions. Now we have some expo-time. Waldo is showing me some add-ons of his company, so he hasn't much time to blog. This is the proof: BTW:I only noticed it on the foto, but he does have a weird look in his eyes. http://mibuso.com/blogs/kriki/2008/04/18/expo-cocktails/ First : Sorry for the error in the name but I don't have the Umlaut on my Italian keyboard and I am to lazy to get it from MSWord.Well we started with some salestalk: -"the NAV/SQL Performance toolbox" -book "THe NAV/SQL Performance Field Guide" -syntax for commands -trace-flags At least the salestalk ended fast and ... http://mibuso.com/blogs/kriki/2008/04/18/navsql-troubleshooting-blocks-deadlocks-by-jorg-stryck/ -develop smart client applications -create MS office applications -build Windows Vista Applications -Handle data more productively -Enable new web experience -gain better developer experience -application lifecycle management (ALM) Until know I didn't understand a lot, probably because I don't know anything about .NET... Demo-time: office business application using: -Visual Studio tools for Office -Windows Presentation Foundation -LINQ to SQL Creating a ... http://mibuso.com/blogs/kriki/2008/04/18/enhance-nav-with-visual-studio-a-powerful-tool-by-marianne-van-wanrooij/ Mark told me that his session was more-or-less the same as for Directions US. But I didn't follow that so I will blog anyway. Waldo already blogged about the session, so I would suggest to read also his blog (http://dynamicsuser.net/blogs/waldo/archive/2007/11/09/directions-diary-dev-session-migrating-from-c-side-to-sql.aspx). SQL benefits are : -better performancee -higher availability -better backup/recovery -new technologies (analysis/reporting/integration services) -64 bit technology. Upgrade ... http://mibuso.com/blogs/kriki/2008/04/18/moving-from-native-cside-to-sql-by-mark-brummel/ This is a lot less technical and more sales. The company is specialised in vending support for going international. Going international is completely different from staying local. A lot of companies spend 3-4 years to get their add-on international. This is too long because they make mistakes. These are 25 points to remember ... http://mibuso.com/blogs/kriki/2008/04/18/going-international-dos-and-donts-by-theo-doelman/ Eric will probably not blog about this session for obvious reasons. I am not writing everything he said or showed, only the things that are most important or something I didn't know myself. In general performance problems are created by the application (80-90%) and sometimes (10-20% by infrastructure). http://mibuso.com/blogs/kriki/2008/04/17/hardware-recomendations-to-make-installations-hum-by-eric-wouters/ There are about 300 persons on Directions EMEA 2008. The next year, they want to get 500-600 persons! Directions US has been going now for 3 years and there were 600 persons last time. This time it is 80% salespeople/consecutives and 20% techies (like me). In the US they had 50/50. It is ... http://mibuso.com/blogs/kriki/2008/04/17/introduction-keynote/ Eat and drink and talk with others. When I was in Belgium I knew it's Navision world was small:everyone knew everyone. Now with international company, it is still the same: most people know each other. Nice seeing everyone with the Mibuso lanyard. There is some problem. There are a lot of parallel sessions, so ... http://mibuso.com/blogs/kriki/2008/04/17/reception/ First and for all : Luc installed some things to avoid that a spam-robot can create a new account and use it for spam. It is a picture with text in it that the user must copy into a textbox. A spam-robot cannot read it, so it is secure the ... http://mibuso.com/blogs/kriki/2008/04/05/how-to-fight-spam-in-the-mibuso-blogs/ I don't know about you, but I have a lot of problems on my local computer to have Navision connect to a SQL2005 with Windows Authentication when my computer is not in the domain. It takes a lot of time for the login and in the end I generally an ... http://mibuso.com/blogs/kriki/2008/04/05/local-sqlserver-2005-with-windows-authentication/ I did some tests with 5.0SP1 with SQL. First thing I noticed: WHERE ARE MY SIFTLEVELS! They are gone! How can we decide which levels we want to keep? http://mibuso.com/blogs/kriki/2008/04/01/sql-changes-for-50sp1/ We all hope that this never happens, but it is better to be prepared for the worst. And sooner or later it will happen. I think I can consider myself lucky. This is the first time in my (computer-)life this has happened. I always keep in mind that it might happen, ... http://mibuso.com/blogs/kriki/2008/03/26/computer-crash/ We found out that my blog had some problems with RSS-feed. The RSS feed on the main page didn't work. After several retries to fix it (and creating/deleting a new blog) I found out what messed up the RSS-feed. In Options=>Permalinks=>Common options I changed the radiobutton from customized to numeric. This messed ... http://mibuso.com/blogs/kriki/2008/02/25/recreation-of-blog/ Ever wondered if a company is cheating with their G/L entries (and thus taxes)? Now you can check it very easily. Benford's law defines how the first digit of the amounts are divided. As you can see in the picture, the CRONUS International Ltd. company is cheating! :-) The numbers in read are quite ... http://mibuso.com/blogs/kriki/2008/02/14/benfords-law/ Luc just told me there is a new community for Dynamics. It is primarily for Belgium, but I think it can be usefull for the whole world. It is in English after all. Ok I'll admit it: I found 1 blog in Dutch. GOOD LUCK FOR THE NEW COMMUNITY. This is a ... http://mibuso.com/blogs/kriki/2008/02/01/belgian-dynamics-community/ Thanks to Plataan, I found this site : http://www.microsoftdynamicsaddons.com/ I would say : spread the word. This is something that can help us all. http://mibuso.com/blogs/kriki/2008/01/23/online-add-ons/ A lot of times, my colleagues ask me what the maximum size is for a Navision DB. And I suppose a lot of other persons want to know too. This is the answer (or better: these are the answers): 3.01..5.00 : 256 GB (maximum 16 files of maximum 16 GB) 2.50..2.65 : 64 ... http://mibuso.com/blogs/kriki/2008/01/04/maximum-size-for-navision-dbs/ As a moderator, I keep also track of the new users and if the users change something in their profile. So it means I look at the info people leave in there profile (the info everyone can see) and sometimes I find some website I just check out. This website had ... http://mibuso.com/blogs/kriki/2008/01/04/navision-girl-learning-journal/ Well, Luc asked me to start a blog. A long time I thought a blog was a little overkill, and that I could use the different Mibuso forums (especially Navision Tips & Tricks, Download Section and How To's Section) to post my findings/musings/brainstorms/rattling (or whatever one might call them:). Until … ... http://mibuso.com/blogs/kriki/2008/01/03/my-first-blog-post/