As long as it's not in your department's budget, Microsoft SQL Server is great
Overall Satisfaction with Microsoft SQL Server
We use it as our central data warehouse across the entire organization for most of our data needs. We base our MicroStrategy Analytics software off of it, executive reporting off of it, and use it to house several years of transaction and inventory data. It serves as the central source of truth.
Pros
- Is reasonably responsive even when thousands of queries are executing at the same time
- Provides an end user experience that allows for intuitive use of structured query language coding
- The database explorer is intuitive and easy to use for SQL neophytes
Cons
- This is probably a sys admin setting, but it forces me to reset my password every month
- I've heard the enterprise edition is quite costly
- If we want to do anything substantial with it beyond simple storing and reporting, we often need to hire consultants
- Uptime--we have a truly 24/7 business and can't afford even a moment of downtime
- Universal SQL inputs--if your analyst knows SQL in other environments, you can plug them in right into their role
- Security--keeps our data safe in the age of daily cyber security hacks
- Enabled weekly reporting for executives to make timely decisions
- Allows analysts to support ad hoc initiatives to drive organizational value
- Automated updates ease workload on the database administrators, allowing labor expenses to be lowered
Microsoft was the original creator of the SQL database, and thus, they still rule the market and drive innovation when it comes to data warehousing systems. It's comparable in price and allows you to retain the structured datasets that you lose when you change to a NoSQL database structure.
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?
I wasn't involved with the implementation phase
Would you buy Microsoft SQL Server again?
Yes
Comments
Please log in to join the conversation