Browse by Tags
All Tags »
SQL Server »
Development (
Get this RSS feed)
My first full year (January-December)of writing on my blog has passed. When I saw this post on the "NAV Developer's blog", I just thought: "hey, that's a good idea to end this year of blogging. Let's make an overview of my blog as well". And here it is. I was quite surprised...
Some time ago, I explained how you could use ADO to call stored procedures and stuff ... . Just another way to do stuff on SQL Server (or another database type). In this post, I will try to explain another cool feature. What you see quite often in forums is people trying to find a way to display a view...
Today, I received a very interesting summarizing mail from Microsoft with the announcement that SQL Server is released ... or at least released to manufacturing (RTM). Besides the announcement, it contained a bunch of references to very interesting articles to get started with it. I wanted to share this...
The "Key" virtual table contains information about the keys that are defined in each table in the database. At least, that's what the bible (in other, less popular words: The Application Designer's Guide) says. Actually, that's about all it explains about the "Key" virtual...
Normally, I would have done an article about Sumindexfields on versions previous to 5.0 SP1, but I decided not to do that. The Belgian version of Microsoft Dynamics NAV 5.0 SP1 is just released, and the Belgian release is always pretty late. In fact ... I just checked ... every localized version is available...
Time for the next chapter for the "what impact does my C/AL have on SQL"-story. I already covered the following in previous blogposts: What impact does my C/AL have on SQL This one was the first. It dealt mainly with the FIND statements, en the looping and modifying of records. What impact...
Finally found some time to write Part II of this topic. The first part was quite a popular post, if I may say so myself . I didn't expect this. I just prepared an internal developer meeting at my company about "how to use the FIND statements", as I noticed that things are sometimes misunderstood...
This session is presented by Michael DeVoe and Robert Miller. They're both really good, so I expect a lot of it. Apparently, there is a new tool coming available to analyse the performance of a NAV database on a SQL Server: the SQL Server Performance Troubleshooting and Analysis tool. Robert and...
I had this issue at a customer of ours. The error message " Login failed for user 'sa' because the account is currently locked out " surprised me a bit. I didn't know this was possible. Actually, it is even possible to not have any admin anymore in the database, by locking out sa...
This is a very challenging blogpost in my opinion. I see many stories going around on what would be the best way to use the new FIND-instructions, what C/AL to write in what case. I have my own thoughts on this which I would like to share. I don't want to say the following is the best way to go,...
Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies. Furthermore, the companies were also spread over multiple databases. They wanted quick answers on questions like "What is the inventory of this item in any location in any company in any...
I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn't available for download though, so just updated some sections below. The second edition of the Belgian MSDN/Technet sessions was even more successful than the first. About 50 people registered, and about 45 of them showed...
It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled all tools that are important for SQL Server, and put it on one CD: the SQL Server Technical Kit for Microsoft Dynamics NAV . Actually, I got it on CD on Directions, but you can also download it from...
When I was on the plane to New York a few weeks ago (After Convergence, but before Directions), I wrote this blog post ... . I forgot to put it online though. Better late then never . At this moment, I'm sitting on the plane to New York, together with my wife. We'll spend some time sightseeing...
Mark Brummel is presenting this session. As you might know, we're quite good friends so I was kind of obligated to go to his session. I've been reviewing his presentation, gave him some input and I'm curious if he payed attention and changed his slides . First of all: why should people move...
More Posts
Next page »