TrustRadius
Microsoft SQL Server is a relational database.MicrosoftKeeps my information safe without corrupting2019-07-30T16:06:02.508ZWe 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.,10,We have a secure database.
We have no limitations as to what we can do.
The return on investment has been fast!,MySQL,Visual Studio IDE, MySQL, Barracuda Backup, SAP CrystalRobert S HoughMicrosoft Database2019-05-14T19:30:08.093ZWe 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...,7,The return by using SQL Server, for us, is more due to the use of the Automation Anywhere tool.Verified UserMS SQL server best software to manipulate data2019-02-12T20:06:10.590ZMy 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.,8,Full return on investmentPardeep GoyalMy opinion on using Microsoft SQL Server2019-01-21T21:52:04.988ZMicrosoft 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.,9,SQL Server has a positive impact on our corporation.
Our company owns the SQL Server Enterprise edition. The return is pretty good when investment is done with SQL Server.,MySQL,Microsoft Visual Studio Code, JabberSimran SinghWould not be in my career and successful without it!2018-11-18T20:45:25.525ZIt 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.,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,10,Saved millions of dollars in resolving invalid billings
Identifying delays in a process for improvement
Solutions architecture based on existing models,Alteryx Analytics,Alteryx Analytics, Dell BoomiSpencer LewisMicrosoft SQL Server makes it easy to focus on the important stuff2018-12-04T15:24:54.098ZMicrosoft 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.,9,With just one server we can easily host databases for many applications, which makes it easier to maintain.
The ROI on Microsoft SQL Server is very good as we have been able to set it and forget with out too much time invested in keeping it up and running.
The Microsoft SQL Server down time has been minimal and 90% of the downtime is due to our user error.,,Microsoft 365 Business, Microsoft Azure, Microsoft Azure HDInsightVerified UserThe power that comes with SQL Server at a glance...2018-08-21T18:52:25.180ZMicrosoft 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.,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?,10,Our organization is using SQL Server for its business, and we are quite happy with its ROI, so I would say SQL has positive impact.
Organizations have to invest money somewhere for the operations of a DBMS (database management system,) so why not choose SQL, considering its huge benefits.,Oracle Database and MySQL,Microsoft Visual Studio Team System, Chrome DevToolsRahul Kumar SinghA Growing Company Dives Into The Big TIme2018-06-05T20:12:56.447ZMicrosoft 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,8,It's too early in my latest implementation to have metrics to show its benefit.,Greg UrbaitisMicrosoft SQL Server Review2018-05-29T19:40:19.696ZWe 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,7,Cost friendly
Fairly easy to use and learn
Fairly easy to manage,Darren DengSimplest tool for basic data analysis2018-05-25T17:06:14.143ZSQL 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,8,As a data analytics company, all the revenue my company generates is based on the data that we consume through sql server
SQL Server has limed our ability work with only certain kind of datasets,Hadoop, Imonggo and Amazon Redshift,Tableau Desktop, Teradata Database, Alteryx AnalyticsAshish GuptaMicrosoft SQL Server Review2018-06-08T15:13:27.657ZIn 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.,8,low cost so that is affordable for all industries.
very flexible and easy to use
beautiful GUI and lots of features like security, debugging, intelligence,MongoDB,MongoDB, Devart ODBC Driver for OracleVerified UserMy experience with SQLServer and its R Integration2018-04-02T21:11:28.494ZWe used to SQL Server to build a decision support system for mid-size companies (e.g. bakeries) offering perishable goods. The core of the system is a machine learning algorithm that provides demand forecast based on transactional data (POS data) that are required for daily production and order decisions. Hence, the provided demand forecasts are used by operational staff at the headquarters that control the complete supply chain.,Integration of the R programming language and its eco-system.
Transact-SQL is quite expressive and allows implementing complex application logic.
MS Excel can be used as front-end.,OLAP queries on non-aggregated POS data can be very slow. Hence, it is required to persist aggregated views on the data.
Debugging R-Code is not convenient.
Versioning of SQL procedures.,8,Decision support leads to better inventory management of perishable items.
Provided demand forecasts lead to time saving of operational staff.
Better product availability causes a revenue increase.,Verified UserSQL works very well for larger datasets2018-07-16T21:05:00.873ZSQL 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.,9,Use of temp tables increases the performance of queries which makes to run the batch jobs faster.,Toad for Oracle,Toad for Oracle, MySQLVerified UserSQL server pivot function and automatic data table name pop up are awesome2018-05-18T20:12:03.603ZMicrosoft SQL server is currently used only in the IT department and Data Analytics department. We mainly use it for database management. For our data analytics team, I use SQL server to write queries to produce desired tables of data,Tables in database automatically pop up in writing SQL, makes it easier to navigate
Has pivot functionality, so I can query pivot tables instead of making them in Excel
Great connection to Excel in terms of exporting queries,Windows set up time takes longer than other DB software
Does not allow numbers in "group by" clause, users need to write the column names explicitly,9,It's easy to use and have data table pop up in writing queries, that reduced time in writing codes. That also eliminate memorization of the tables.
Using pivot function eliminate the need to export data to excel, which saves a lot of time.,MySQL and IBM Netezza Data Warehouse Appliances,Tableau Desktop, Microsoft Access, MySQL, IBM Netezza Data Warehouse AppliancesVerified UserMicrosoft SQL Server will be the Best!2018-01-08T18:26:46.247ZMicrosoft 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,10,Business growing very fast
Saves money
Customer Satisfaction,Microsoft Office 365,Microsoft Visual Studio Team System, Microsoft Office 365, Microsoft Azure, Amazon Web Services, Telerik,Reporting Service will better
OLAP or BI embedded
Replication will be better and easy to implement,Replication
Cluster Installation
OLAP Service,10Rony Vargas M.Microsoft SQL Server great for refining2017-09-06T14:19:54.726ZI use Microsoft SQL Server to write SQL queries for my healthcare organization to do reporting for national quality metrics.
It allows me to write efficient, fast queries that export nicely to Excel.,Error logging and indicators
Colors keywords
Allows for easy formatting
Allows for multiple tabs
Allows for multiple subqueries,Needs more specific error messages
Sometimes it seems "buggy" with the predictive text
Needs an in application help resource that is easier to understand,9,Positive: fast reporting
Excel exporting
Can meet national guidelines with the data
Can be used for import files for reporting which saves money that we would usually use for manual data entry,SAP Crystal Reports,SAP Crystal Reports, Microsoft Access, Microsoft Power BI,Predictive text
Color for keywords
Error checking is decent,Error messages can be vague.
Queries can be hard to stop.
It allows joins that don't make sense (joining a table/column back to itself) without an error.,9Keri SchneiderA Powerfull and Indispensable Database Server2018-01-08T17:32:01.600ZSQL 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,10,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.,MySQL, MongoDB and Microsoft Access,MySQL, MongoDB, Microsoft AccessVerified UserSQL Server in view of a Start Up Organisation after 3 Years2017-09-27T21:28:29.494ZSQL Server is used to store the organizational data, which is entered by the users using the forms in front end. We have been using SQL Server to store data and sort it out for the Managers to view it. We also create email alerts for the leads and managers, consisting of employee performance, using database Email Services.,Automated jobs on schedule
Easy integration with the Com Components (Assemblies Integration)
History of the jobs executed, gives the failure and the success email alerts after executing
Database file partition for the large databases
Log Shipping is a very easy to implement and very useful feature,Better GUI for inbuilt functionalities. For example, I would like to have the Database email services have a good interactive GUI instead of the current one.
It would be nice to have a Start Ups Guide for SQL Server which explains all the basic and necessary services needed for a start up company to use SQL Server.,9,As of now I am not in a position to determine ROI.,MySQL,Visual Studio IDE, Alpha AnywhereVerified UserSQL SERVER PREFERENCE2017-09-13T15:25:53.411ZIt is used as a data storage engine and also for providing information to users based on the business user's requirement. It also supports multiple users' requirements. It is also used for reporting services for providing run time reports or summarized reports from OLAP cubes. We also use the various security features and different editions available based on the requirement and budget. I have been working with this product for over 15 years and I am a great admirer of how the product has evolved since 2000.,In a single package, you get a data base/OLAP/reporting.
Ease in using the best documentation and books are available for anyone to start working on it and use tons of features.,Columnstore indexes need to be improved further even after many limitations were removed in SQL 2016.
Pricing of the SQL Server license should be made more simple to be understand easily.,10,Based on the features available and cost it always makes for a prudent decision to have SQL in the organization as the main data.storage.
Some of the improvements are: Improvement in query response time without any changes in hardware, database, or application. Total cost of ownership (TCO) for storage dropped to the low end of the industry average scale. Forrester calculated a 3-year, risk-adjusted Return on Investment (ROI) of 100% with a payback period of six months after upgrading to SQL Server 2014.,MySQL,Azure SQL Database, Amazon Relational Database Service, Amazon Redshift, MongoDB, MySQLVerified UserMicrosoft SQL Server - Stores your Gold2017-07-21T14:41:54.049ZWe use SQL Server to data mine and report on data for all departments including finance, production, shipping/receiving and purchasing. We are constantly studying our data trends to help us run our business proactively. Many other departments request data trends, etc., that may not be available in the ERP application. We are able to retrieve this data using SQL Server.,Excellent Speed
Backup/Restore fast
Automated processes work well,Data encryption
Security
Fuzzy SQL logic,10,The data stored is worth its weight in gold.,Oracle Data Warehouse,BizNet Excel Suite, Epicor ERPDon JohnsonUsing Windows? - Go SQL2017-06-27T15:55:16.954ZSQL Server underpins all our line of business applications and is the database of choice for our case management application. It is used firm-wide from our helpdesk, through to the finance and HR teams. It is used to log support calls, time record and bill our customers.,SSMS provides useful tools such as the database tuning advisor - providing recommendations for missing indexes.
SSMS provides useful tools such as the SQL Profiler - Providing in-depth trace files of queries currently executing in your database.
SSMS provides useful tools such as the Activity Monitor allowing you to find expensive queries, resource waits, processes, and I/O.,Would prefer more built in queries for DB optimization rather than having to find scripts on the internet.,8,Without SQL server we would struggle to run our business.
Without SQL server we wouldn.t have a Case Managment System to sell to our customers.,MySQL,Microsoft Dynamics CRM, Visual Studio IDE, MS SharePoint / SQLRich MephanSQL Server to the rescue2016-04-22T19:01:44.144ZOur company uses Microsoft SQL Server for much of our database storage needs. In the energy section, we use SQL Server to store sample data, generate reports and spreadsheets, as well as internal reporting and data manipulation.,SQL Server is a whole package that usually connects well with other Microsoft products.
SQL Server has a large community of users for tips and advice on SQL programming.
SQL Server works fairly seamlessly with Power BI, Power Query.,One glaring example is importing spreadsheets through SSIS, SQL Server only seems to sample the first few rows and generates errors if larger text cells are further down the rows.
SQL Server tends to be a bit more touchy with database object names than MySQL.
The good - SQL Server has a lot of ways to get at the data, the bad - finding particular settings is often buried in dialogs.,7,Since our company is mostly a 'Microsoft shop' it is easier to deploy SQL Server projects than any other solution.
Licensing issues still thwart my efforts to implement quick web tools with SQL Server.
Applying Power BI is a great technique to give project managers a view to the data fairly quickly and relatively seamlessly.
Drag and drop coding speeds up my queries, there are lots of built in query strategies that make quick work of code production.
Import from Excel with SSIS has consumed large quantities of my time with mixed results.,MySQL, PostgreSQL, SQLite and Couchbase Server,MySQL, NetBeans,Simple data imports work well.
Drag and drop queries and selecting into new query techniques allow you to generate queries with less typing.
Accessing stored procedures is nicely organized by the 'folder tree'.,Importing through SSIS can be a real pain, my associates indicate that this is not usually the best approach.
Debugging SSIS errors can be difficult due to the number of things that can go wrong.
Field investigation/prefilling from data sources is often plagued with incorrect choices - requiring manual intervention.
Accessing import fields through levels of 'wizard dialogs' can be confusing.,7Andy EricksonSQL...not as bad as a lot of Microsoft Products out there2016-04-13T18:26:50.100ZWe use Microsoft SQL Server 2008 R2 in our environment for all of our .NET applications. We have also found that most any enterprise level software will provide a means to store their database within SQL Server. With one database server for all of our applications it is very easy to backup and create disaster recovery points for the future.,Fast and efficient compression on backups. Typically we see about a 65% reduction in size compared to the data file.
It just "works". We say this very little in IT but it really does just work. Almost every enterprise application out there works with it and the downtime is very minimal.
You have the opportunity to cluster servers. You can easily create a cluster of SQL servers to share resources instead of buying all new equipment and scattering the database footprint.,The patching has sometimes been an issue for us. It either doesn't work or the process isn't explained well for the different SQL instances on one engine.
I wish they would design a way to allow SQL backups to go somewhere other than a local drive. A UNC path would be best. This would allow us to rotate off the backups to a longer term storage device.
It takes up a huge amount of memory and space on a server.
There is no benefit to running it in VMWare. We typically find that servers run better in VMWare for our use cases but SQL seems to run just the same and you don't save on licensing so there really is no benefit.,10,We can very quickly and easily start up a new database.
Active Directory integration has been a huge time saver for us.
It changed the way we did our data backup strategy by giving us a backup 4-5 times a day instead of once at night.,RDS,Blackbaud NetCommunity, Financial Edge NXT, The Raisers Edge, NetworkerJohn GlennSQL Server from a mid-level DBA perspective2016-02-23T21:53:43.167ZSQL Server is used throughout the organization in differing capacities. Research and Development uses it to develop new software and to fix previously coded bugs or issues. Our software communicates with a SQL server database that has almost 1000 tables with varying relationships and data amount. Support uses SQL to log customer/client issues and to see what clients have downloaded what products and who the contacts are that are viewing our released software from the Salesforce website which communicates with a local SQL database we have on site. Our Professional services team will configure databases in SQL server at client sites to help set up a new client or to solve issues that the client is encountering.,Handle large amounts of data. SQL can process thousands of rows of data in a pinch when given the correct hardware to utilize. SQL likes memory and it will utilize it very efficiently when given the chance.
SQL provides at least 2 methods to do everything. You can write simple SQL query scripts or you can use the built-in GUI (which coincidentally just runs SQL scripts behind the scenes).
Allows for jobs to be setup that can do simple tasks such as database backups, database restores, export and import data and even send out notifications when SQL Server encounters a problem.
Integrates with a lot of other programs and software. Microsoft allows SQL Server to integrate with Visual Studio and you can utilize SQL tools with SSIS, SSMS, SSAS, and SSRS to get deep into integration tools, Analyzing data, and reporting on various data in each database. You can also integrate with third party tools such as the suite of products from RedGate.,Speed up installation times. A manual installation of SQL server can take up a good chunk of time. You can be forced to go through an installation wizard screen by screen and it can take a lot of time waiting for each screen to load.
Allow for easier integration with GUI's. SQL has the capability to use a visual query builder where you can drag and drop fields, tables, etc to build a query but it is not as user friendly as you would imagine.
Make the permissions more stream lined. Users can have permissions to a SQL Server but not a particular database and trying to find the right spot to add the correct permissions can be painful for someone who is new to SQL Admin work.,10,Allowed my company to expand the services we offer and the speed at which our software runs due to the efficiency that SQL has.
Negatively, it is hard to find SQL experts or seasoned veterans who can handle the data load and enterprise level functionality we have implemented.,,Team Foundation Server, Hyper-V,150,3,Development of new technology is the main focus of our company.
Troubleshooting and debugging previously released code and databases.
Configuring new servers and maintaining current SQL servers either individually or as a cluster.,We have utilized SQL to have a client that has 2 offices on opposite sides of the planet utilize one central SQL database at the same time with no issues or hesitations.,We can utilize the integration Microsoft allows to utilize tools outside of SQL to making reporting, error reporting, troubleshooting and data integrity easier, and more effective.
We could utilize the new technologies being released in the new versions of SQL to allow us to process data faster and more efficiently in order to have faster processing times in our applications.,10,No,Product Features
Product Usability
Product Reputation
Existing Relationship with the Vendor,The evaluation and selection process wouldn't change. SQL did everything we did and it gave us room to grow. Training was provided and support is always accessible. Being an industry leader SQL Server is easy to maintain and troubleshoot. Finding certified and qualified individuals to service SQL is very easy as it is taught by most schools and training centers.,Implemented in-house,No,Change management was a small part of the implementation and was well-handled,It can be time consuming.
If you change SQL's default values it can get tricky if you don't update those names or values in every SQL instance.,9,8,I've never personally had to call Microsoft for SQL Server support. I have heard from coworkers that it has been fairly easy to get through to Microsoft Support and that their questions were answered. They were kept up to date on their cases and in all cases a resolution was provided or was at least documented with a reasonable work around solution.,Writing and executing SQL queries is fairly simple. Just open up SQL Management studio and you can find a table you want and select rows from it using the drop down GUI when right clicking it or you can write SQL scripts into the query editor.
Connecting to new database servers is as easy as typing the name (assuming you have permissions to connect to said server).
Installation is easy but time consuming. Following the installation wizard allows you to get SQL installed and running in no time.,Understanding the errors one might receive when you have incorrect permissions on a server or database.
Setting up permissions can be difficult to grasp since there are permission levels for each server and database.,No,8Bill StarlingSQL Server for quick and easy wins2016-06-06T18:28:03.807ZMicrosoft SQL Server is being used extensively in my organization. It is the default database for SharePoint sites and also the default choice for custom database applications. SQL Server Database is very commonly used in the IT department since it is well suited with the Microsoft umbrella of products. Other departments also use SQL Server for self-served Microsoft Business Intelligence reports and SharePoint. Analytics is one of the main business problems that SQL Server handles efficiently and effectively. SQL Server Reporting Services, PowerPivot, Power BI, SharePoint rely heavily on SQL Server engine and database in the back-end.,SQL Server handles a relational database very well. The fundamental logic for Extract, Transform and Load (ETL) hasn't changed much for a long time, so there is no learning curve if you upgrade from older versions to new ones.
One of the strong advantages of using SQL Server is its better compatibility with Microsoft product suites. Choosing Microsoft SQL server is the first choice if your organization relies on other Microsoft products.
It is very stable, fast, affordable, and extremely popular. There is an easy learning curve to acquire SQL Server skills. Microsoft SQL Server Management Studio is very graphical and requires very little programming to achieve basic tasks.,SQL Server is only operable on the Windows platform. It should support the Unix platform too.
There are a few object types missing in SQL Server, e.g. no packages (collection of procedures and functions), no "before" event triggers.
SQL Server doesn't support partitioning.,8,Microsoft SQL server is priced less as compared to other enterprise database choices. This makes the initial investment more cost effective and in turn reflects better ROI.
Microsoft is easy to use and administer. Resources are readily available to support SQL Server. Microsoft SQL Server Management Studio makes life simpler when it comes to basic database administration tasks. As resource cost to maintain SQL Server is much less, it helps in gaining more positive ROI.
ROI can easily turn into negative side if solution evolves into a complex enterprise one, requiring better performance and bigger size of data. SQL Server cannot handle enterprise data as well as Oracle. Detailed architectural planning is needed before choosing SQL Server for an enterprise solution as the cost to move from SQL later could be more.,Oracle Database,Oracle Database, MySQL, Microsoft AccessVed Mishra
Unspecified
Microsoft SQL Server
1079 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
