I too wrote database backends in VB6 around that timeframe (late 1990's) and am still maintaining them. My latest "re-install" of VB6 was Win7 Pro, the previous one was...

When I first got into computers I was both in operations and programming, employed as an operator and programming for the company on my "spare time". This was on...

We recently hit a nasty upgrading some clients from 2008 to 2012, full text search! We have hundreds of clients (hosted or otherwise) some of whom use full test...

Drag and drop with Windows 7 (and earlier) is the worst. Windows explorer has a habit of changing the folder in the left pane arbitrarily while I am dragging...

I'd have to say I'm in the "zero is good" camp and flag the exceptions, so Deleted=0/NULL is a normal row, InActive=0/NULL is a normal row. I disagree that...

Yet Another DBA (9/29/2015)

---

I do find watching slow motion train crashes a bit sad at the moment. Currently watching yet another project that is ORM based. I asked how...

Sad but true. In my decades as an independent I have twice walked away from database implementations pushed by a company's accounting firm that I tried to convince both...

DVCS all the way! Having started with a "first generation" VCS and coordinating the changes necessary between multiple developers, then progressing to SVN and now to GIT there is...

And how about we assign GUIDs for all primary keys? ... oh ... and clustered too ... No one listened to this veteran, and while we're at it let's...

I was just about to correct my post being the wrong way around when I saw Hugo's correction, that is correct 🙂

Not quite, it's still the COALESCE. In a comparison such as "select case when coalesce(cast (null as date),'')='' then 'true' else 'false' end" the result is "true" because of...

Unless I miss my guess here, from the responses it is quite apparent there is a mixture of DBAs and developers, and of both there is a mixture of seasoned...

My philosophy is that once in production names are written in stone, spelling mistakes and all. As has been mentioned by others, our customers have many tools they use...

This is sad news indeed, but from Microsoft not so surprising. Microsoft has never been "fence sitting" (sorry Steve), the only thing that has ever mattered to MS is...

Michael L John (9/5/2013)

---

Microsoft's move in this area does not surprise me.

Simply put, they were not making money on this program. They probably are making lots of...