Why we don't choose MSSQL!

Everybody always raves how great Microsoft SQL Server is, and how much data it can hold, and how much bigger it’s “package” is than your own.

But the truth is that I hate it with a passion!

I use RDBMS‘ on a daily basis and never used to hate MSSQL so much until recently when I had to modify a very large site that was built in Classic ASP(yuck) and MSSQL.

The way the whole thing was setup made life a real nightmare to deal with and everytime I wanted to do the simplest thing, I would be hit with thousands of problems, from linked tables that I would have to affect my changes “manually” in multiple places to stored procedures that just wouldn’t execute because everything was done so manually.

This is merely a rant from me as doing the whole thing from scratch using MySQL would have been faster and also much easier for anyone to maintain thereafter. This problem was definitely hightened due to the coding language in the site itself being VB which is just nasty!

I always seem to have these rediculous issues when I delve into the Microsoft Programmers world – bear in mind that I used to do a LOT of Microsoft coding of my own a few years back, and decided to move away from it for many many good reasons just like experiences of this kind.

One thought on “Why we don't choose MSSQL!

  1. Well I always hated Microsoft programming since it’s been always a hassle. Escpecially when you’re a web developer, it looks easy to use .net but try to do some enterprise development in .net and you’ll find out how hard it is.

    Since .net has many things that are built in, once you face a problem in the code you’re doomed.

    To come back to MSSQL, I don’t deny it’s an important software, but I’m comfy with mySQL, I can build huge websites using it, and whenever I want an Enterprise DB I would go for ORACLE and not for MSSQL or I can even use mySQL Enterprise.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>