Filter Ratings and Reviews
Filter 1143 vetted Microsoft SQL Server reviews and ratings
Reviews (1-25 of 63)
November 07, 2019
A good tool for data exploration.
Microsoft SQL Server is the base of all of our in-house servers. We use it to access all of our internal and external data that comes from Verint and other places. It solves our need to store the data that we have in one location and to create a data warehouse on top of it.
- The workbench is very good. I like that you can explore multiple databases in one query window.
- Exploring data is very manageable compared to other SQL querying tools.
- Simple language to learn and very easy to transition from other SQL learned in other environments.
- IntelliSense slows down query writing. It sometimes freezes the query window.
- The data that you can copy-paste from the results is limited and I'd like to be able to copy-paste whatever I want.
- It isn't case sensitive, which isn't a problem until you get to reporting.
October 17, 2019
Industry standard for databases
Microsoft SQL Server primarily serves as the back end of our core business system, which is built on Microsoft Dynamics NAV on the front end. Essentially everything our business does goes through this system, making access to the data crucial. While SQL Server is a required component of NAV, the system still needs to perform and be reliable all of the time. Luckily SQL Server is widely supported and time tested, allowing us to choose it with confidence.
- Support: Microsoft support and documentation make usage and maintenance worry-free.
- Performance: developers and admins have the ability to tune performance to meet their application needs.
- Prevalence: being an industry standard, compatibility and support are widespread.
- Learning curve: while SQL databases share many of the same concepts, admins and developers need to be familiar with the interface and quirks specific to SQL Server and the Management Studio.
- Cost: as with most enterprise software, especially from Microsoft, the investment needs to be considered.
- Required resources: both system resources and other considerations for maintenance and in-house support may be heavy compared to other solutions.
September 23, 2019
This is basic and has most of the required tools in Data Analytics
In my company we use it project/account wise, Our main purpose to use it is because it has a very easy user interface and lots of internet communities for providing the solution.
- We used to merge the data from different sources. For this, it is very to do in SQL Server.
- Main times we used it to clean the data by reducing the unwanted rows and removing the delimited values.
- Creation of stored procedures are pretty much simple in it, and these created procedures are very handy and simple to create because syntax is very easy in it.
- There are no data visualization options available in it. For that, we need to connect it with different tools.
- No inbuilt statistical modules/formulas. We need to make our own.
- If data is more than 100 Columns and rows then it will definitely crash on its own.
September 12, 2019
The way to go for your database implementations
I use Microsoft SQL Server primarily as the back end database server to ASP.Net C# websites. For authentication and authorization, the database uses tables and stored procedures to implement membership or identity for user login and defining roles. Of course, the database is used to hold data entities for the needs of the website. Use of stored procedures, views, and sequences full-text indexing are just some of the useful features I take advantage of.
- Speed of selects with appropriate indexes.
- Use through C# of Linq queries to the data.
- Ability to use CLR assemblies to program in C#.
- Replication to keep the database mirrored to another server.
- I sure wish the T-SQL language was more like C# - it's really primitive.
- I would like an easy way to pass an array to stored procedures and a way to iterate through the array in the code.
- Integrated source control for the database would be appreciated.
September 10, 2019
Microsoft SQL Server is a Great Enterprise Database Option
Microsoft SQL Server is our primary data storage for our in house software as well as 3rd party financial software and provides the data for all of our enterprise reporting. We also leverage the additional services that come with Microsoft SQL Server including SQL Server Reporting Services and SQL Server Integration Services.
- Extremely Reliable - We have not had an instance of SQL Server itself having issues or causing downtime. We have had AWS hardware failures but not Microsoft SQL Server failures.
- Total Cost of Ownership - Having Enterprise Edition provides us with the additional features of SQL Server Reporting Services, SQL Server Integration Services, and if we would like, SQL Server Analytics Services.
- Multiple disaster recovery options - You can use mirroring (replaced by Always On Availability Groups), replications and log shipping to name a few options.
- Elastic Database options - You can have a mix of on-premises and Azure instances if your use case requires it.
- Easy Manageability - Microsoft has done a great job of making the management of Microsoft SQL Server easier with every release.
- In-Memory Database options - You can have in-memory tables for any business case needing that level of performance.
- While I really like their disaster recovery options, they could make them more affordable and easier to implement. Always On-Availability Groups is improving with every edition but still can come with some gotcha's if you do not watch it. Including Security across instances, jobs across instances, etc.
- In memory, at least in 2014, once you enable it that is it. You cannot go back. This makes it difficult to retire this feature.
- Better native Enterprise management meaning, in a use case where you may have multiple servers or clusters with multiple instances the native tools are lacking and typically require purchasing 3rd party tools or building out tools for monitoring and managing the servers and databases.
October 29, 2019
A helpful tool
IT uses it to design queries within our ERP platform, as requested by various stakeholders throughout operations. There are over 100 separate queries that are used daily.
I use it for various accounting reports, as I find it provides more of an exact "what I'm looking for" than the canned reporting available through the ERP.
I use it for various accounting reports, as I find it provides more of an exact "what I'm looking for" than the canned reporting available through the ERP.
- Able to zero down to a specific instance.
- Having new queries on separate pages eases going back and forth.
- The capability of changing databases quickly.
- Older versions had an auto-fill feature for columns that seems to have disappeared. That's why I prefer using the 2008 version.
July 30, 2019
Keeps my information safe without corrupting
We have used SQL Server for years, and it has been our main database for desktop projects. It also has been the database engine to choose when developing financial applications for its speed and security. We also use it when working with complex data and a variety of fields.
- It is quick and easy to create data and tables using their built-in aid, and it has a wide variety of fields.
- We like to correctly support stored procedures which facilitates processes and enriches functions within the application and can delegate more responsibility to the database.
- It integrates seamlessly with other Microsoft applications, such as Visual Studio in addition to many other third-party applications either natively or by means of ODBC connectors.
- Can manage user permissions easily.
- The installation may take longer than expected.
- It requires a lot of resources for its implementation.
November 07, 2019
SQL Server Review
We use MS SQL Server as our main database to store customer data. We have a monolith web application that is using a single MS SQL Server database. MS SQL is one of the best RDBMS in terms of speed and its really easy to use with a lot of pre-built functions that are really convenient for our application.
- It has quite a lot of pre-built function that helps speed up development time.
- One of the fastest SQL database engines.
- Built for enterprise use with enterprise-level of support available.
- It could be very expensive to utilize MS SQL server to its full potential due to the licensing tier limit.
- It does not have a built-in JSON type column, unlike PostgreSQL, although it has built-in functions to help to work with JSON.
- Require more space to install the database engine compared to other SQL databases.
October 04, 2019
Microsoft SQL Server for small and medium scale companies
Microsoft SQL Server is being used by the whole organization. Our core OLTP database system is on the MS SQL Server.
- I think that Microsoft SQL Server is the best database software for small and medium-sized companies
- Microsoft SQL Server has a user-friendly interface for the database admins.
- Microsoft SQL Server is cheaper than other databases (like Oracle, etc.).
- Microsoft SQL Server is not suitable for big companies.
- Microsoft SQL Server has to improve with more transactions. If you have too many transactions on the database, there is no response from the database to the user.
- Microsoft SQL Server has to improve its big data technologies.
October 01, 2019
Well Established, Reliable DBMS That is Scalable and Compatible with Many Platforms and Languages
Microsoft SQL server is the official database management system for Microsoft, and it is a very reliable tool. Our team has a platform for analyzing city infrastructure which has multiple instances and a DBMS is crucial for managing all of the data. We use Microsoft SQL Server to check queries before publishing them to the live website. The tool is dependable and fairly straightforward to use, even for someone inexperienced with database management.
- The tool is scalable and able to handle large amounts of data.
- Microsoft SQL Server is compatible with many platforms and languages.
- It is reliable and has the backing of a large and well established company.
- The performance and speed of Microsoft SQL Server could possibly be improved.
- Better tools for monitoring databases and better interface for these tools would be helpful.
- Easier ways to create complex queries would make the tool even more user friendly, for instance drag and drop style tools to create queries.
September 20, 2019
Excellent tool for enterprise data management
My department uses SQL Server (and Azure Data Studio, increasingly, but still primarily SQL Server) for database management and analysis. Other departments use it as well, including our QA team, to verify the expected output of data manipulation or the functionality of changes to the code base. It's a pretty standard tool at this point.
- Query analysis and execution plan details - You can see indexes you may be missing that would (if used) possibly improve performance of your stored procedures and queries.
- Data storage - It's easy to restore and back up entire databases and to set up automatic jobs to do this.
- Scheduled tasks - You can plan health checks or updates to data, or reports, from the Jobs tool.
- Unlike Visual Studio, there isn't a built-in or out-of-the-box way to format your SQL scripts/queries. You can easily install plugins and extensions to do this (paid or free) but it would be a nice-to-have.
- Occasionally it's not obvious from a query execution plan what piece is causing the most bottleneck, and even then, side-effects of implementing the suggested index(es) aren't always obvious.
September 12, 2019
Best DBMS solution for professionals as well as beginners
Microsoft SQL Server is being used as the default database management solution. It is used across the whole organization and is responsible for managing different types of databases such as ERP, Spatial and regular ones. SQL server caters to regular reports generation, establish relational queries between different datasets, provide backup in case of any issues.
- Microsoft SQL Server has a very user-friendly interface. It is a breeze to create and schedule jobs for data reporting and updates.
- The online community support and the numerous forums for Microsoft SQL Server are really handy in case of any issues.
- Microsoft SQL Server supports Spatial Databases which is a critical requirement for an organization like ours.
- It would be great if working with SSIS packages would be much more streamlined in the Microsoft SQL Server. As of now, the only option is to use Visual Studio which in itself is not very forthcoming in how to work with a package.
- The version upgrade can be a bit of nuisance in case you have different databases created on different versions of Microsoft SQL Server. The version compatibility for different databases can definitely be improved upon.
September 10, 2019
Easy to implement this complete set of tools
It is used as a data warehousing and business intelligence platform across the whole organization.
- Troubleshooting is easy because of several forums available on the internet. We can Google error messages and find solutions easily.
- It has a complete set of tools for data warehousing and business intelligence, so integration and automation are easy.
- Easy access to training and skilled workforce availability.
- There are some in-memory tools in the market that I have used to replace analysis services. Those in-memory tools have reduced the aggregation time to a few minutes as compared to a couple of hours on analysis services.
- Mobile apps for SSMS and SQL agent would be a good addition to the toolbelt.
- A built-in SQL source code control tool that can be used to track code changes and schema changes from SSMS would be very useful. It should easily show who made the changes, what changes were made and when, and provide an option to roll back to any of the previous versions if needed.
February 12, 2019
MS SQL server best software to manipulate data
My whole company uses the Microsoft SQL Server, almost every department and team makes use of the SQL Server. Basically it is used as RDBMS to manipulate and store data for business purposes. Developers use this to handle data of the products on which they are working. I am using SQL server since I joined the company in 2013.
- Provides good interface and intelligence help to write queries easily.
- Provides many built-in functions to perform various operations on data.
- Helps to store and manipulate data.
- 4 Users can create their own functions and procedures.
- Provides various types of data for analysis.
- Due to many features included in SQL Server it takes large memory and some times it slows down.
- You need to refresh many times for intellisense to show up.
- Installation takes more time.
January 21, 2019
My opinion on using Microsoft SQL Server
Microsoft SQL Server is used as a relational database management tool by our organisation. It's mostly used by every department in our corporation to insert, update, delete, manage data and to provide various encryptions to it.
- SQL Sever supports multiple users in one setup which make it a multiuser system.
- SQL profiler tracks the background queries and helps with the debugging and management of SQL queries
- By analysing estimated and actual test plans, it helps to make queries more optimized
- Issues exist when restoring a database for low screen resolution system. This should be debugged and corrected.
- Doesn't auto backup an unsaved query window. So when SQL server is restarted it [loses] previously unsaved work.
- Hanging issues while booting SQL Server.
May 14, 2019
Microsoft Database
We currently use Microsoft SQL Server, integrated with Automation Anywhere, to develop automation scripts. We opted for SQL Server for its Microsoft support and native Automation Anywhere functions that allow us to work with this Database.
- SQL Server, because it is Microsoft, has the support of the company, and it is possible to integrate with thousands of applications that run on windows.
- The price of the paid version of SQL Server is well below the market average, although we do not lose in quality.
- It allows the developer to use a managed programming language, such as C # or VB.NET, to address queries, rather than using SQL statements.
- The main point that displeased me most in SQL Server 2008 is the lack of intelligence of the tools.
- Since Microsoft decided to support the creation of stored procedures and other database objects in .NET framework languages it seems that T-SQL has been a bit sideways.
- Difficult to mount a cluster, mirroring, replication...
December 04, 2018
Microsoft SQL Server makes it easy to focus on the important stuff
Microsoft SQL Server is the database of used by all web applications. Hosted web applications that collect gigabytes of information directly store data into one or more Microsoft SQL Servers being used by our organization. We need these servers to not only store data but provide an easy means to make available to other software and services.
- Easy to setup with the included Wizard that helps to get you up and running with the essential components covered. You won't waste a lot of time reading through documentation to just get started.
- There is a large community of support for Microsoft SQL Server that can help to troubleshoot issues and explain how to tackle a problem.
- The other components and modules to the system make is easy to setup backups and connections to other services.
- I would like to see them overhaul the Microsoft SQL Report Server included. Its very outdated and lacks modern features.
- I would like more artificial intelligence support to help make the databases run more efficiently.
- I would like have better support for ORM management within the included Studio Manager.
August 21, 2018
The power that comes with SQL Server at a glance...
Microsoft SQL Server is an RDBMS (Relational Database Management System.) This means it helps an organization to store and manipulate their data. The way our company uses it is no different: it stores the company's large consumer user base. Our company provide services to our clients via our website, and maintaining that website consist of two parts: front end, and back end.
So, in my organization, SQL Server is used as the back end. This means all the work related to storing the date (e.g. using tables), retrieving the data (e.g. using procedures and functions provided by SQL Server) and manipulating the data (e.g. necessary update and alter statements) are all tasks performed by SQL Server and some helpful programming language.
It is being used not just by any one department, but by the whole organization. Proper functioning of a website highly relies on its back end, so SQL Server is solving this business problem for us, in addition to generating visual reports using services like SSIS and SSRS, which are provided by SQL Server.
So, in my organization, SQL Server is used as the back end. This means all the work related to storing the date (e.g. using tables), retrieving the data (e.g. using procedures and functions provided by SQL Server) and manipulating the data (e.g. necessary update and alter statements) are all tasks performed by SQL Server and some helpful programming language.
It is being used not just by any one department, but by the whole organization. Proper functioning of a website highly relies on its back end, so SQL Server is solving this business problem for us, in addition to generating visual reports using services like SSIS and SSRS, which are provided by SQL Server.
- It can store large amounts of data. Moreover, it doesn't just store the data, but performs important operations with it. Things like backup, restore, etc., are all handled pretty well by SQL Server.
- It is equipped with different tools like SQL Profiler (for visualizing what's going on), SQL Tuning Advisor (for better suggestion of indexes, etc.) and also third party tools like SQL Search and SQL Code Guard. This really makes life easier for us.
- SQL Server integrates to almost all the programming languages that work as front end for SQL Server, such as asp.net, C++, etc.
- Services provided by SQL Server do solve some high business level problems using SSIS and SSRS.
- Support and service from a company like Microsoft is another big advantage.
- The above mentioned points are all strengths of SQL Server, as this one RDBMS does a lot of jobs, and with relative ease and efficiency compared to any other software in this sector.
- In terms of resource utilization, there is room for improvement for SQL Server, so that it can cost less CPU usage.
- There are lot of third party services like SQL Search and SQL Code Guard. Why is there a need for these if SQL itself can implement these necessary functionalities inbuilt?
November 18, 2018
Would not be in my career and successful without it!
It is being used in a limited capacity which is why many SQL users are demonstrating the power of the tool.
Current use cases are order management, vendor performance metric building and maintenance, supply/demand views.
Current use cases are order management, vendor performance metric building and maintenance, supply/demand views.
- Group and count data
- Join multiple data sets together across entire organization rather than a single site view
- Monitor exception cases at scale
- Intellisense won’t turn back on
- Enhance object explorer to help find tables previously unknown
- Easier note taking
June 05, 2018
A Growing Company Dives Into The Big TIme
Microsoft SQL Server is used to ramp up the capabilities of a growing business that began using Excel in place of an actual database.
- Support is a major factor. Day-to-day functionality is reliable, but for those times when there are issues support is available.
- Security is key, and Microsoft SQL Server has clearly put this concern in its design.
- Perhaps not a strength of SQL Server itself, but the pool of professionals with SQL Server experience ensures the ability for growth.
- User setup should be allowed to be copied from other users
May 29, 2018
Microsoft SQL Server Review
We use Microsoft SQL server to perform analytics with a large set of data from different kinds of clients. All the data preparations are done with SQL server. It is being used by everyone in our service line. also, most of our client uses SQL server as well. Using SQL Server to process unstructured data is not very effective.
- It's fairly quick to manipulate large sets of data
- Quick and easy to learn
- Cost efficient
- Implement features to process unstructured data easier
- Increase performance speed
- Add multiple results table in the same window
May 25, 2018
Simplest tool for basic data analysis
SQL server is the only data management tool we have. Its used all the way from Data preparation, transformation, and data aggregation. Its used across all the teams. Its used to analyze credit card transaction level data as well as customer demographic data to help inform product, pricing, and marketing strategies.
- SQL Server is really good at working with large structured datasets
- Great customer support and online resources available
- One of the most intuitive and easy to learn a programming language for data analysts
- Add more built-in functions
- Having the ability to work with unstructured data would be useful
- Having an in build data visualization would also be very helpful
June 08, 2018
Microsoft SQL Server Review
In our Organisation Microsoft SQL Server is widely used because SQL server is a very powerful tool for managing the database. Yes, it is used widely worldwide because it is a Microsoft product and is trustworthy. It has a lot of security features. We solve our many businesses related issues like database management, save time and reduce the paperwork and also the burden of an employee. We increase our customers and our profitability.
- it has a lot of security feature, no one can access if they have no credentials.
- easy to use and maintain the database
- very flexible and easy to install and for new users it very easy to learn and implement.
- it has little bit performance issue
- output window panel is single if we run multiple select commands it shows all results in one after that so that is more clumsy
- it goes hang in low System RAM configurations.
July 16, 2018
SQL works very well for larger datasets
SQL server is used by most of the teams in the organizations where I worked. It is used to store the data for the large projects especially.
- Faster in performance.
- The concept of CTE(Common table expressions) is really great.
- Temp tables works well and easy to use.
- We need to always use BEGIN TRAN to start a transaction which adds an additional step each time.
January 08, 2018
Microsoft SQL Server will be the Best!
Microsoft SQL Server is our database back-end option to use in our Software Factory. Also, our Client is using this database from 2000 version after 2016 version. From 18 year ago I'm using SQL Server it has grown from this time today is compared with ORACLE and another RDMS in the market but the most important is SQL Server can run on LINUX. Great! From the most simple project after the must complex project our first option is MS SQL Server.
- Runs on LINUX
- Job and Task schedule and Email Notification
- Distribution Transaction
- Support
- RDMS Database backend for Web Site Application
- RDMS Database backend for Reporting Services
- RMS Database backend for ERP, CRM etc Software Tool Project
Microsoft SQL Server Scorecard Summary
About Microsoft SQL Server
Microsoft SQL Server is a relational database.
Categories: Relational Databases
Microsoft SQL Server Integrations
Microsoft SQL Server Technical Details
| Operating Systems: | Unspecified |
|---|---|
| Mobile Application: | No |