TrustRadius Insights for Microsoft SQL Server are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
Ease of Use and Integration: Users have consistently found the software easy to use, praising its simple design and common interface. They also appreciate its seamless integration capabilities with various frameworks and tools like Visual Studio, Dot Net, MSBI, PowerBI, Crystal Reports, etc.
Reliability and Performance: Reviewers have highlighted the software's reliability in handling high volume transactions and data staging operations. They also value its fast performance, intuitive SQL coding experience, efficient data table management, and quick information filtering capabilities.
Data Management Capabilities: Users have praised the software for its functionalities as a relational database server and its support for OEM applications. They particularly appreciate its features for data storage, manipulation, scalability options, quick data analysis abilities, troubleshooting tools availability, and maintenance procedures.
We use Microsoft SQL Server almost exclusively as our database solution.
Pros
SQL Server Management Studio provides an excellent UI for developing in SQL
SQL Server integrates well into the other business intelligence components of the Microsoft suite (e.g. SSRS, Integration Services, PowerPivot, etc.)
Cons
My main issues with SQL were related to limitations in programability. For instance, it was once cumbersome to build things like running totals. However, recent releases (e.g. SQL 2012) have addressed some of these limitations
Likelihood to Recommend
Microsoft SQL is very-well suited for any small to mid-sized company. I don't have experienced with very large roll outs so I cannot speak to performance on a large scale. However, I have found MS SQL to be near-perfect for our institution. The reality of it is the business world is still well rooted in Microsoft products. Having MS SQL allows us to integrate easily with products like Microsoft Excel. Additionally, MS SQL has many front-end tools that allow for the automation of maintenance plans and monitoring. This is especially good for small to mid-sized companies that often find their IT personnel stretched thin. Finally, MS SQL is not as cost-prohibitive as some of the larger database solutions.
VU
Verified User
Technician in Information Technology (Higher Education company, 1001-5000 employees)