Business level data storage and reporting
March 28, 2017
Business level data storage and reporting
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Microsoft SQL Server
We use Microsoft SQL server as a base platform for our enterprise resource program. Not only is it the data warehouse but it also serves as the SSRS report server so we can use SQL views and stored procedures to create SSRS reports more effectively based on the user needs. The tools in SQL Server allow for all maintenance to be scheduled, simplifying maintenance.
- Backing up databases both full and differential as well as transaction logs so data recovery is simple.
- Database cleanup and maintenance tools that can be scheduled to keep the database running at optimal performance.
- The performance monitor allows you to track query performance so you can maintain the best user experience and tune the server for optimal usage.
- A better way to remotely connect to the database to maintain and review current transactions is needed.
- SSRS report designer needs better tools to build the reports you need. Too many workarounds due to limitations in SSRS.
- Logs need to be less cryptic and more meaningful at times so that diagnosing problems can be done quicker.
- Centralized our data into a secure database that can be backed up and replicated as required by business needs.
- Created a central source for reporting using SSRS so that all users use the same reports for business needs.
- SQL servers allow us to replicate the database between locations so everyone is working with real-time data at all locations.
Microsoft Access while a data tool cannot scale to number of concurrent users or the great amount of files needed to run a business. Microsoft Access can attach to sql server as a backend but the interface is still limited to less than 20 concurrent users at a time.