Overall Satisfaction with Microsoft SQL Server
In our database department, we use Microsoft SQL Server for storing data, data aggregation, and manipulation. We use Reporting services tools for creating, managing and deploying reports for our clients. For creating a report definition I personally used Report Builder which makes defining data source connections, queries used to retrieve data, expressions, parameters and others extremely easy to perform. We also try to improve the performance of stored procedures, user-defined functions, and triggers by learning the execution plan in detail. One of our clients has a web app for an insurance company and they have a large amount of data stored in the Microsoft SQL Server database. Our goal is to improve performance from queries that are used in that web app, so we try controlling execution plans with hints or adding indexes. In cases when we meet a new client who already has some database storage then we use replication technology for copying and distributing data and objects from one database to another. Besides that, we also help our clients to build parameterized queries in order to defend from SQL injection which is one of the most common web hacking techniques.
- It offers a lot of functionalities, such as Reporting Services, Integration Services, Job Scheduler, Resource Manager, Query Analyzer and Profiler, etc.
- You can connect it to Active Directory if you so desire.
- The price of the enterprise version could be a little lower and also licensing should be more understandable.
- There can be problems when connecting with software that is not owned by Microsoft.
- We have established cooperation with one insurance company which brought us a good profit.
- Reports which we make for some powerful companies are simple and fast to perform and we earned from them.
We used MySQL for some smaller projects because this RDBMS works better with a small amount of data and a lot of young workers, especially students, can handle MySQL very well because they learned it at the university. One important thing to keep in mind is that MySQL is completely free and very easy to set up. For some basic queries and beginner websites, it is indeed the best solution. We also, for a short period of time, used DB2 database for developing Java web applications. It is a product from IBM and it has support for XML structures. It has its use but I would say that Microsoft SQL Server and Oracle are the two best choices.
Do you think Microsoft SQL Server delivers good value for the price?
Yes
Are you happy with Microsoft SQL Server's feature set?
Yes
Did Microsoft SQL Server live up to sales and marketing promises?
Yes
Did implementation of Microsoft SQL Server go as expected?
Yes
Would you buy Microsoft SQL Server again?
Yes