SQL 2000 post SP4 Hotfix 8.00.2162

A SQL Server 2000 Post SP4 hotfix has just been released to the public. Bringing the SQL Server 2000 version number to 8.00.2162

This hotfix is a cumulative hotfix containing:

  • Hotfixes that were built since SP4 shipped
  • Hotfixes that were done for SP3 but did not make it into SP4 (because of the cutoff date for fixes that made it into service pack SP4)

This build has undergone more testing than a typical hotfix build but not as much as say a service pack.

The build is available at the following download locations:

Ia64 version – http://www.microsoft.com/downloads/details.aspx?FamilyId=920707DE-AAF0-412F-8B26-1074E91E494D&displaylang=en

X86 x64 version – http://www.microsoft.com/downloads/details.aspx?FamilyId=4773BF7E-21AE-4F1E-AD48-6CA739E10217&displaylang=en

The following KB articles have been published to help answer questions about this hotfix build:



VB 6.0 died, rightly so.

Visual Basic 6.0 support died 31 March 2005. Rightly so. Everyone is up in arms. http://classicvb.org/


There is far too much badly architected, badly developed and security-less VB v1.0-6.0 code out there. And it is a risk to every business that is using it.

Now how can a developer not want to move forward, improve on what he/she has written, and at the same time, keep up with the technology boom that put them where they are?

If a VB 6.0 developer can not handle the migration to VB.NET (or better c#), maybe the developer needs a LOT of re-training, or be re-evaluated if he/she is actually good enough for the position held. Developers generally earn a lot of money, but in most cases, they are not worth it.

Yes, a re-write will expose the security holes and the coding monstrosity that was created over the years, but maybe it is good for the IT industry. A good clean out will help drive down costs (those developers who are not productive and competent will be pushed out the industry) and at the same time, sort out all the security flaws that are lying around.

In my opinion, it is time to do a clean sweep. Developers who can not be multi-faceted, not willing to learn the newer languages like c# and Java have no place in this industry. A corporation needs someone who can work on code that runs on the Unix/Linux platforms, and at the same time, pretty and secure UI Windows desktop code (no, I don’t believe that Java is the answer to everything, actually, far from that).

Microsoft kept everyone warm and cozy too long. The brutal reality is here. Java is mainstream, c# is getting there, VB has been left behind in the corporate environment. The large corporates have had too much trouble with mediocre VB applications that just don’t work in a properly “locked-down” desktop environment.

What about the small company who runs on VB? Well, that same company is still running, now, unsupported Windows 95 and Windows 98. They still will in 2 years time (until the hardware dies and nothing new will run the old Windows). They are not spending 3-5% of turnover on IT. For them, they can wait out this round of development upgrades, and then in 2 years time, get something that works better, and is secure, and will run on Windows Vista/Longhorn.

Maybe Microsoft should not have made VB.NET, as it was trying to be too backward compatible to be really helpful to the average developer. It probably hurt the developer by extending their IT career when they should have left it a long time ago.


VB 1.0, 2.0, 3.0, 4.0, 5.0 and 6.0, I started out my career with you, I used your heavily over the years, but I outgrew you. So did Microsoft.


Long live c# and SQL Server!

Microsoft SQL Server Management Studio Express – CTP – November 2005

Microsoft have been working on a free management tool for SQL Server 2005 Express, and what they were working on during the betas was mostly tossed away in the July timeframe.

Now, the CTP for the new tool, Microsoft SQL Server Management Studio Express is available.

Something that looks and works like the full Microsoft SQL Server Management Studio is really the right choice.


Scalable shared databases are supported by SQL Server 2005

Something that seems to have been added to SQL Server 2005 Enterprise Edition, very late in the development cycle, seems to be on of it’s best features.

The ability to have one DB, located on SAN, available to multiple SQL Servers at the same time, as a read only DB is just incredible.

You can really scale out reporting, and might save you from having to flatten the data so that it is report friendly. Just throw more servers at the problem now. You need a bit of effort to update it, but it is really worth the while for those scenarios where data is loaded on a daily or weekly basis.

As long as your SAN can handle the throughput, it think it is a great feature.

The documentation in not in the SQL Server 2005 RTM BOL, but is available as a KB article: http://support.microsoft.com/?kbid=910378

Well done Microsoft!

SQL Server 2005 row level security

Ok, so Microsoft removed row level security from SQL Server 2005 early in the development cycle. Pity, but looks like it was just one of those trade-offs that needed to be made.

A bunch of guys from Microsoft Consulting has produced a paper on how to implement “Row and Cell” level security in SQL Server 2005.

“Implementing Row and Cell Level Security in Classified Databases Using SQL Server 2005” http://www.microsoft.com/technet/prodtechnol/sql/2005/multisec.mspx

I like the idea of keeping it simple, yet still powerful though roles. It is a bit of work, but compared to what we have in SQL Server 2000, it is a workable and maintainable solution.

Some basic rules have to be followed, but once everyone on the development team understand them, it gets very easy. Developing with security as a base, and doing most of the DB architecture up front in still a foreign concept for most developers, even those in corporates. With the added complexity of the new features in SQL Server 2005, you can really end up in trouble if the implementation is not though through first.

MVP again

Microsoft has decided to re-award me my MVP status again. Good. 3rd year running.

I must be doing something right. The joke among the Germans is that MVP stands for “Muss Viel Posten” (translated: “must post a lot“). True, the presence in the newsgroups does influence the re-nomination.

I am happy. My time has been well spent.

Back from Basta!/SQLCon05

It was great. The sleepy town of Mainz in Germany, then 600 .NET and SQL Server geeks arrive.

My 2 sessions went well, and had great fun presenting them. I did not get much time to see the others, pity.

I did see Ingo Rammer’s “Migrating .NET to Indigo”. Awesome.

Then there was Meinrad Weiss’ “SQL Server 2005 Business Intelligence”. He had the audience in awe by showing the new features in SQL Server 2005 and a great product called DeltaMiner. Jaws dropped when this BI tool from Bissantz & Company was shown. I have never seen such a simple UI and the graphic rednering technology to look at data was just best of the best. 

All in all, a good conference.

SQL Server 2005 – Database Mirroring off the cards for RTM.

So, Database Mirroring will not be “on” in SQL Server 2005 when it releases.

From what I have read, it looks like it is not performing up to expectations. You can still enable it, but it’s probably going to be one of those “we told you so” scenarios.

I do not doubt that it is robust and won’t trash your data, but I do think it is a bit too slow for production use.

I just thought it was the June CTP that made it slow. I have not been able to crash it yet.

Paragraph 5.1.2 from the September CTP shows how to enable it


The updated letter from Paul Flessner’s really raises the point


Pity, my presentation for this Wednesday at SQLCon 05 in Germany has just been blown out the water.

Swiss Vodka – xellent

A Russian Colleague living here in Switzerland told me about Swiss produced Xellent Vodka 6 weeks ago. She swore by it.

So, the next day I went and bought a bottle, went to friends for dinner, put it in their freezer and 4 hours later, I took the bottle in my grip and promptly finished half of it over dinner (I was greedy and would not share). The next morning I had no hangover and promptly had a bit more. I swear by the stuff, it is very good. Pity it is not available as a small bottle for me to keep on me during those long meetings or when I am getting cold whilst waiting for the tram here in Zurich.

It is not cheep, but it is very good. I rather pay with my wallet than pay with a hangover and since I am really only a vodka drinker (ok, under duress a beer will do, or a very decent Cognac), I think the best will only do.

Have a look at their site http://www.xellent.ch