I spend a lot of my time in SQL Server Management Studio. I rarely ever run tables anymore from Object Desingner and run most of my data conversions directly in T-SQL.
Why? Because it is so much faster, I can script things, save and restore scripts, share accross customers etc.
One of the pain points of working with SQL Server Queries has Always been the full companyname in front of the real table name. For this reason Intellisense was more or less useless for NAV databases.
This is fixed in SSMS 2016!
When you type
select * from Custom
SQL Server Management Studio will show this
How cool is that!
You can download SSMS 2016 for free here
Yesterday I had a pleasant surprise when I did my Chicago Master Class. I had upgraded my machine to CU8 the day before.
When CU2 was released, I totaly forgot to test something I should have.
Based on my “what the BEEP” post my friends at Microsoft decided that it was time to “clean up” and gave me a heads up.
If you type “BE” in NAV2016CU2 the keyword you get is BEGIN, not BEEP.
THANK YOU TEAM!
From what I have been told the obsolete commands are hardcoded. If you find anything that should be removed, just reply to this blog. Microsoft folks read it :). (Trust me I know).
As far as I could test I could not find the BEEP in the Symbol menu either, but I might have looked in the wrong place.
NAV 2016 Cumulative Update 2 is released. I have to admit, normally I don’t pay that much attention to updates, but the last ones are on my radar because of some promisses.
Nobody could be happier with the new code editor than me. It makes me more productive and makes our environment sexier and more attractive to young people.
However, the very first piece of feedback I gave was that in some cases the Symbol Menu was not bad.
This feedback was first ignored during the Technical Preview process, but due to pressure after release it is now back.
Glad I was not the only one.
Events & Extensions
There are a couple of interesting KB articles in CU2. Mainly about Extensions and Events.
||You cannot publish an extension if it contains too many objects.
So somebody is trying to wrap their entire vertical solution in an Extension? 😉
||An extension object cannot be added when a deleted base object had the same ID.
This is a strange one. First and foremost, if you package an extension ALWAYS use ID’s in you CfMD range. I don’t recommend packaging custom objects as Extension.
You can change the automatically generated ID in the Database-Alter menu on the Advanced Tab.
I admit, it does not work too well with distributed development where each developer has their own database.
Hopefully in the (near) future Microsoft will make the required changes in NAV to make proffesional development easier out of the books so we can safely say distributed development is easy. I would also like to see GIT support.
Today I was a happy man when I got home. I unboxed the first 25 copies of my new book Learning Dynamics NAV Patterns. Just in time for Directions EMEA next week.
I will take 25 copies with me next week. If you would like a copy, find me at the event, between the 1000+ other people. You can easily find me. I am the tall guy with the ponytail wearing a NAV Skills t-shirt.
I hope and expect the book to have a positive impact on the way the NAV partners develop software. I believe it is time to take the next step in proffesional software. This book explains how and which elements of Dynamics NAV are good to be reused.
Looking forward to see you next week!
(Did I say I am happy?)
PS: You can order the book here
Or on Amazon:
As I am writing this blog, Microsoft is showing Windows 10 to the world. I have always been a Windows fan and worked with the very early releases back until Windows 1.
When Windows 8 was introduced we quickly got some screenshots emailing aroundhow the new “Live Tiles” would influene Dynamics NAV.
In reality this never happened. Live Tiles failed as people did not like the big bathroom interior on their desktop experinece and NAV never adopted the possibilty of showing data on the tile.
A big mistake still if you ask me, also considering that it looks like with Windows 10 we will still have the tiles as part of the start menu. I love the tiles and the fact that it shows me stuff without opening the application.
We got tiles in Dynamics NAV in the Role Center, with sentiment. I love that feature. I would still like to be able to make these bigger or smaller like in Windows 8 and put more on them like images and text.
But that is not what I wanted to write. Get to the point I hear you think.
What is that, I hear you say. It means that each device that runs Windows can run the same apps and adopts to the device. If you have a small device without keyboard and mouse it optimises for that, if you run on a tablet you get more real estate and if you attach a keyboard it automatically optimises again. Like in this video:
I would love to see this feature adopted in Dynamics NAV. We already have an app for tablets, what if that would be cross-device and works on all devices? Adopting to keyboard if required.
Please Microsoft! Make this work. And while you are at it, please use the live tile to display information. Like the number of Workflow alerts from your roadmap.
Dynamics NAV should have the best Windows 10 experience of all ERP products out there. We have the architecture to make it happen.
Ok, writing about a new version before it is released with a current NDA is like walking on eggs. It can almost only go wrong.
But, I am so exited about the upcomming release that I have to let that know to our community.
The reason for my exitement is the roadmap, presented by Microsoft on the events of fall last year. If you look at that roadmap you see a lot of functional areas. This is the first time in almost a decade that the list of new functional features is as long as it is for this release.
Let’s have a look at that roadmap.
This screenshot is taken from the video of the NAVTechDays keynotes, but the other events showed similar announcements. I highly recommend watching the entire video.
The roadmap shows Workflow, OCR & Document Mgt and e-services integration.
There is another functional enhancement and I am 100% sure it was mentioned during an event, but I cannot find proof online so I won’t mention it here.
The future of NAV is looking bright. Adding functionality is so important for everyone.