One thing that’s annoyed me for years when using SQL Server 2005 was that there are many inconsistencies in the UI. You’d think that the most obvious of these would be fixed in subsequent releases…

The most obvious one that I’ve always noticed is the Select Database File dialog. In some parts of SQL Management Studio, the standard windows Select File dialog is used for opening a file. In others, you get this:

I don’t understand why this archaic piece of interface is still present today. It seriously looks like they gave the job of creating an open database dialog to a first year developer who couldn’t find GetOpenFileName().