It's a sad reality that a lot of people who are currently using SQL Server are underutilizing it. This is the natural result of Microsoft commoditizing an otherwise high-end RDBMS. I've seen "enterprise" apps built on SQL Server databases where every single table consisted of varchar (50) columns. Know why? It's the default in the GUI, and 80% of people using Microsoft products use the default because they can and it "seems to work OK." On the other hand, organizations that spend millions on Oracle or DB2 are not about to let ordinary knowledge workers go around creating tables with wizards. Teams of DBAs have to toil for weeks over schema changes.
Because of this, SQL Server has become the most "low hanging fruit" for MySQL to raid users from. For people who don't know what it really means to make online backups with transactional integrity and negligible performance hit, MySQL seems "good enough." For people who don't "get" multidimensional data analysis, MySQL seems "good enough." For people who have no use for distributed queries, MySQL seems "good enough."
In a way, even Microsoft's ease of use has backfired in favor of MySQL. I was talking to someone on the phone who was certified in SQL Server administration but insisted that he couldn't see triggers in Enterprise Manager. I didn't have EM open in front of me, but I told him to right-click the table and find "Manage Triggers." He tells me that it's not there, there's no such thing. I ask, is there an "All Tasks" submenu? Yes, he says. Is it there? Pause...Yes.
In other words, people have gotten so accustomed to being spoonfed by Microsoft products that they're ready to give up as soon as something isn't totally obvious and in-your-face. But in MySQL, people approach every task expecting to look up some arcane command syntax, or to search for a clever script, or even to download an update and port/compile/link for their platform. But that seems easier than looking under the "All Tasks" menu because nobody expects Microsoft to require two clicks. Everybody expects MySQL to be an adventure.
|