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...
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...
This is going to be an article about "Index Hinting". I'm ashamed that I did not know about this feature until for a few weeks ago. Why? Because it has been in the bible for a long time (fyi, "the bible" is "The Application Designer's Guid" aka the w1w1adg.pdf on...
I recently got an interesting explanation on why x64 is more interesting when your system has more than 4 Gb of memory. The background is the size of the memory. An x86 server system can manage a maximum of 4 GB of memory. This limits the addressable memory space for Windows server 2003 systems to 4...