A Powerfull and Indispensable Database Server
Anonymous | TrustRadius Reviewer
January 08, 2018

A Powerfull and Indispensable Database Server

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Microsoft SQL Server

SQL Server is our main database platform, across the whole organization, we've taken slow applications and moved querying logic into stored procedures and views to maximize performance.
  • If configured correctly with the proper hardware, SQL Server can be incredibly powerful, delivering millions of data points in the blink of an eye
  • If you're just starting with relational databases, you would probably be fine with opting for an open source solution. However, if you need a solution that can handle an enormous number of requests and return results with considerable speed, SQL is worth researching to see if it fits your needs.
  • Managing database using SQL Server Management studio provides very good flexibility
  • There isn't as much that I dislike with SQL Server. It will be good to have features where we have fine grain control over internal things. For example, it would have been a good feature to have historical tracking of the metrics as opposed to setting up custom metrics. Overall SQL Server made my life easy to manage a lot of databases and ease of use while migration projects.
  • The database is the target of many attacks from it's SA account, this must come disabled by default and just after the instalation, some of 30 seconds, the attacks start, with many requests per second, it needs to improve the firewall to prevent these attacks, or put the SQL Server inside of a VPN and local network to avoid these attacks.
  • It requires knowledge and in-depth technical skills to make complex processes truly performing, especially if we are in very complex infrastructures
  • Since SQL Server 2014 Developer Edition, Microsoft has been offering these tools free of charge. The ROI is mainly focused around training investment. We do the training in-house, so the ROI is around one year.
  • The cost-benefit ratio offered by Microsoft's data warehouse solutions is, by a long shot, much more convenient for our customers, small and medium-sized companies, than solutions from other vendors.
  • Every system upgraded will benefit; from the improvements in Clustered ColumnStore, to increased throughput in Always On Availability Groups, to the enhancements of In Memory OLTP, not to mention the new security features.
  • We implemented with an in-house team only, with proper, prior training that was also done in-house.
Which one is better? That depends on your IT specs and platform, but I highly recommend SQL Server than others, newer versions 2014 and 2016 both introduced features appealing to everyone trying to build modern enterprise business applications: in-memory processing by way of table pinning, support for JSON, encrypted backups, Azure-backed storage and disaster recovery, integration with R for analytic's, and so on. Having access to all this without needing to jump platforms -- or at the very least make room for Windows Server somewhere -- is a bonus.
We use SQL Server to deliver large amounts of data to our clients. As some have moved away from stored procedures and views in favor of technologies that are faster to develop, such as LINQ with Entity Framework, we've noticed that data load time performance has degraded. To fix this, we've taken slow applications and moved querying logic into stored procedures and views to maximize performance.