CEO at SkyNet
Real User
Easy to manage and configure, reliable, easy to expand, and good documentation
Pros and Cons
  • "What I like most is the management, as it is very easy compared with other products."
  • "Security is an issue."

What is our primary use case?

I am an IT professional, I write services for my clients. I provide support services for SQL, firewalls, and operating systems. IT infrastructure support in general is what I provide.

What is most valuable?

What I like most is the management, as it is very easy compared with other products.

What needs improvement?

Security is an issue. This is an area that needs to be improved.

There is security built-in, but most of the developers don't emphasize the security enough. When they are building the products or databases, they don't focus on the security of the database.

For how long have I used the solution?

I have been providing services for this solution to my clients for five or six years.

Buyer's Guide
SQL Server
April 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.

What do I think about the stability of the solution?

We have had no issues with stability. It's one of the most stable products.

What do I think about the scalability of the solution?

This solution is scalable. It is easy to expand.

How are customer service and support?

In the five or six years that I have been handling SQL Servers, I have not had to contact technical support. 

Their documentation is sufficient for troubleshooting and maintenance activity.

Which solution did I use previously and why did I switch?

I am also using Sophos.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

We have our in-house team of more than 10 engineers for maintenance.

What's my experience with pricing, setup cost, and licensing?

Pricing is a bit on the higher side. It could be reduced.

What other advice do I have?

To others who are interested in using this solution, I would say go for it. It's a stable database that is easy to configure and maintain. I would suggest this solution when compared with other databases.

I would rate SQL Server an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
System Engineer at asa
Real User
Top 10
Good system architecture but they need to implement load-balancing capabilities
Pros and Cons
  • "SQL Server is a stable product."
  • "The number of concurrent users is too limited and other databases are better than SQL in this regard."

What is our primary use case?

We are currently developing our own business application and we are using SQL Server as the database. We deploy it as a .NET application and the webserver is IIS. The SQL is a three-node clustered system.

What is most valuable?

The most valuable feature is the system architecture.

What needs improvement?

The number of concurrent users is too limited and other databases are better than SQL in this regard.

There are limitations with load balancing.

We would like to see support for in-memory processing.

For how long have I used the solution?

We have been using SQL Server for more than seven years.

What do I think about the stability of the solution?

SQL Server is a stable product.

What do I think about the scalability of the solution?

We are the largest micro-credit finance company with more than thirty companies internally. We have 25,000 employees using the business application and SQL does not scale to our requirements.

I think that Oracle is better suited to smaller applications.

How are customer service and technical support?

The supporting sites are good.

Which solution did I use previously and why did I switch?

I have also worked with SAP HANA.

How was the initial setup?

Setting up the database clustering is too complex.

Our current deployment has been ongoing for three years and it is not yet complete because our application is still being developed.

What about the implementation team?

Our in-house team is handling the deployment.

Which other solutions did I evaluate?

We are currently searching for other products to replace this one with.

What other advice do I have?

My advice for anybody who is considering SQL Server is that it works well for small applications. However, large business applications that use a content delivery network or geographical location, it is not suitable for.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

On-premises

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Amazon Web Services (AWS)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
SQL Server
April 2024
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
769,236 professionals have used our research since 2012.
it_user715902 - PeerSpot reviewer
CEO and Founder at a tech services company
Consultant
For Mission Critical Systems, Data Warehouses, And Big Data Solutions.

What is most valuable?

Performance improvements, optimizer enhancements. Most of our clients have high demands for performance, and this version of SQL Server delivers what we need.

How has it helped my organization?

We are a professional services company, so we use SQL Server to help our clients achieve their goals. Our clients use SQL Server 2016 for their most demanding mission critical systems, for data warehouses, and big data solutions.

What needs improvement?

The Query Store is a good start, but I expect the query processor to be a lot smarter and to use machine learning in order to improve and adjust execution plans automatically.

For how long have I used the solution?

One year.

What do I think about the stability of the solution?

Since we are working with a lot of clients on many edge cases, we encounter bugs and stability issues once in a while, but these are rare.

What do I think about the scalability of the solution?

If you know how to work with the product and leverage its various features and possibilities, then you can achieve great scalability.

How are customer service and technical support?

Microsoft offers several levels of technical support, which is OK, but not too good. But there is a wonderful community with lots of resources on the internet, so most issues can be solved without contacting Microsoft support.

Which solution did I use previously and why did I switch?

No, I have been using SQL Server for the past 20 years.

How was the initial setup?

The initial setup is very clear and friendly. It has improved from the previous version.

What's my experience with pricing, setup cost, and licensing?

Unfortunately, SQL Server licensing is a very complex topic. I advise people to consult with a licensing expert.

Which other solutions did I evaluate?

No.

What other advice do I have?

Download the Developer Edition for free, install it on your personal computer (it’s very easy), and start exploring. If you need help with something, just search for it on the internet, and you’ll find a wealth of resources about everything you need.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Data Analyst at a media company with 1,001-5,000 employees
Real User
We're able to easily upscale previous systems to provide an efficient interface for our internal clients to do their jobs effectively

What is most valuable?

The ability to organize and structure our data in order to extract and provide it to various products and systems within our organization. It is widely used and has great online support from many third-party sites.

How has it helped my organization?

We're able to easily upscale previous systems to provide an efficient interface for our internal clients to do their jobs effectively.

What needs improvement?

Learning SQL could be easier. Some inbuilt tools to enable faster query writing would be very useful.

For how long have I used the solution?

I have used various versions for at least 25 years, on and off.

What do I think about the stability of the solution?

No, none.

What do I think about the scalability of the solution?

When upsizing, some tools do not do a very good job of scaling efficiently and lots of after tweaks need to be made.

How are customer service and technical support?

From Microsoft -- poor/very expensive, but there are many other helpful resources out there.

Which solution did I use previously and why did I switch?

Used MS Access, but data ports became too large for it to support, so we needed a product to take us to the next level as our data ports grew.

How was the initial setup?

A lot of initial reading was required to carefully manage the process of setting everything up correctly.

What's my experience with pricing, setup cost, and licensing?

Not my area.

Which other solutions did I evaluate?

No, others evaluated.

What other advice do I have?

Do your homework first and be prepared for a tough learning curve.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
PeerSpot user
Enterprise Architect with 51-200 employees
Vendor
We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation.

What is most valuable?

  • Business intelligence platform
  • Analysis services (multidimensional and tabular)
  • Relational database features
  • Data extraction and transformation (integration services)

How has it helped my organization?

It provides the ability to create an end-to-end automated BI platform through data management and provisioning, transformation and publication.

Data platform development process improvement: Integrating the features of Visual Studio Team Foundation Server data projects for SQL Server development. Allows for smooth operation between development environments in conjunction with an agile process to release database changes.

What needs improvement?

Hosting multidimensional OLAP instances in conjunction with Tabular, rather than the either/or installation.

OLAP multidimensional ongoing maintenance - automated partitioning or interface for streamlining the mechanism within the cube and data layers.

Integration Services: There is a great deal of room for improvement here in that thepackages are the least extensible part of the platform. Even with the feature ofplatform variables, since these are not easily managed and deployed. Our testers have had a great deal of difficulty swapping environments, particularly where the connection information changes (underlying database name, for example). Changing servers with identical database names is less problematic.

For how long have I used the solution?

I've used it since its release in 2012 until now.

What was my experience with deployment of the solution?

No issues encountered.

What do I think about the stability of the solution?

There were some avoidable issues, primarily due to a lack of scaling in our own design.

What do I think about the scalability of the solution?

There were some avoidable issues, primarily due to a lack of scaling in our own design.

How are customer service and technical support?

Customer Service:

Online information for SQL Server is extensive.

Technical Support:

I did not have the need to contact technical support for any reason.

Which solution did I use previously and why did I switch?

Open Source database and OLAP solution was found to lack stability, and required the installation of many moving parts in order to have a complete stack. These services don't always work together well, and the various online communities would frequently blame the other for issues.

How was the initial setup?

It's straightforward to install a new instance, but more complex if new features are added to an existing instance. Deployment of SQL code is efficient through Visual Studio database project development methodologies.

What about the implementation team?

I have used both in-house, and vendor teams for implementation, both with very high levels of expertise into different aspects of database development.

What was our ROI?

It's very high as the data platform is business-critical.

What's my experience with pricing, setup cost, and licensing?

I don’t concentrate on this issue, but rather the necessary features and the version required.

Which other solutions did I evaluate?

No other oprions were evaluated.

What other advice do I have?

Make sure that you have an experienced database administrator to implement the infrastructure of the solution.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
GaryM - PeerSpot reviewer
GaryMData Architect at World Vision
Top 5LeaderboardReal User

Howard, yes our database name/server name changes across the environments. We manage this via visual studio configuration environments when creating the ispac or doing deployment from VS but that's just for initial setting defaults to show up within the jobs so we don't have to manually worry about them getting set correctly in the job parameters. The trick is making project parameters (package also works if in the driving package) do all the work for you in the connections by using a simple expression to set the connection values at runtime using those parameters. If your problem is that staff hard coded connections with no parameter override then that's a pretty serious staffing competency issue rather than technical problem.

See all 6 comments
PeerSpot user
Network Engineer & Web Developer at OneTexh
Vendor
Consequently, Microsoft SQL server is best choice.

SQL Server Microsoft
Microsoft itself is the name of trustworthiness, solid promise, reliability, steadfastness, loyalty and commitment. Among its ranges of products which are mostly open source and freely available for consumers, Microsoft SQL server is useful for the “Great Data Storage” tool. The latest version of MS SQL server is 2012 which incorporates many enhanced features but previous versions like 2003 and 2008 also meet the needs to store data and analytics of data during structuring query.
Microsoft SQL server 2012 emerged in three different versions Standard, Enterprise and Business edition. The basic standard version can be used by smaller companies' databases and include many vivacious features to manage the data integration. Some features are not available but still it meet the needs of consumers and data handlers. Other two editions have more features like high end data integration, large data analysis, query optimization and other data encapsulation.
It can also integrate to Apache Hadoop e.g. running on different remote machines, capturing queries and send them to SQL server for further investigation. It can manage both relational and non relational data through its built in data-connectors. Database creation is trouble-free along with transportation of database from one platform to another much more uncomplicated.
The best feature in my point of view in its Enterprise and business intelligence edition builds on Power view, a web service BI toolkit that can be attached to the share point. So one can pull the data from any other source from the network and throw in Power View to view them (it mainly includes reports).
Disadvantage
As 2012 edition has a data-connector to have a connection with other data centers but it is still available for the windows environment. It can only be enforced in that hardware configuration which suits windows environment.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Senior Systems Engineer at Dimension Data
MSP
Top 5Leaderboard
Good usability, satisfactory performance, and easy setup
Pros and Cons
  • "Its usability is very good. Its performance is satisfactory."
  • "Their support could be better. There should be more visibility on the progress of the ticket, and their last line of support should be more knowledgeable. Other than that, we have nothing to complain about."

What is our primary use case?

It is for supporting our custom applications. We have a number of custom applications that we use that have SQL embedded.

I am using the version before the latest one.

What is most valuable?

Its usability is very good. Its performance is satisfactory.

What needs improvement?

Their support could be better. There should be more visibility on the progress of the ticket, and their last line of support should be more knowledgeable. Other than that, we have nothing to complain about.

For how long have I used the solution?

I have been using this solution for seven to eight years.

How are customer service and support?

Their support could be better. Sometimes, you don't have much visibility of how your service request is progressing. There should be more visibility, and the last line of support should be more knowledgeable.

How was the initial setup?

It was straightforward. It took two to three hours.

What about the implementation team?

We have internal staff for its implementation. We have a team of about three or four people who are well-versed with SQL Server, and we have 30 to 40 users who use this solution.

What's my experience with pricing, setup cost, and licensing?

You need to pay for the license. It most probably has per-core licensing.

What other advice do I have?

I would recommend this solution to others. We are satisfied with the product in general. Overall, I'd rate it an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Managing Director at D3
Real User
Efficient data retrieval, scalable, and straightforward installation
Pros and Cons
  • "One of the best features of SQL Server is the efficient retrieval of information."
  • "We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."

What is our primary use case?

We are using SQL Server for our financial application package.

What is most valuable?

One of the best features of SQL Server is the efficient retrieval of information.

What needs improvement?

We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud.

For how long have I used the solution?

I have used SQL Server for approximately seven years.

What do I think about the stability of the solution?

SQL Server is stable. However, Microsoft products have a tendency to crash. I would rate it a five out of ten in terms of stability.

What do I think about the scalability of the solution?

The scalability of SQL Server is good.

How was the initial setup?

The solution is straightforward to install.

What's my experience with pricing, setup cost, and licensing?

The price of SQL Server could be better in the African market. The licensing model needs to be improved, it is confusing.

What other advice do I have?

I rate SQL Server an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2024
Product Categories
Relational Databases Tools
Buyer's Guide
Download our free SQL Server Report and get advice and tips from experienced pros sharing their opinions.