SQL Server Other Advice

it_user79482
Senior Developer at a tech vendor with 201-500 employees
I rate it eight out of 10. It is quite a good product and has improved dramatically. Like all products, it has bugs here and there and some areas still need improvement. I have been using the solution for the past two and half years, however, I have worked with older versions of SQL Server (2012, 2008, 2005). The solution is quite powerful and versatile and I have not yet used all the areas/modules of the solution. It is not always easy to utilise all the available modules for the solution, especially if your work is focused solely on a particular area. Nonetheless, I try to use different areas for side projects. Plan thoroughly before, and once implemented go through the structure regularly and remodel accordingly. When planning, go through all the various sections, resources, accessibility, security etc. View full review »
Недашковский Евгений
Senior SQL DBA at a financial services firm with 51-200 employees
Though I do like the SQL Server, I must say it is very hard to find a good DBA nowadays and having a DBMS without a DBA is like having a car without a driver and skills to drive it yourself. Before choosing or switching to this DMBS, check what kind of workforce is available in your area. You may consider Azure SQL Database as a simple alternative, but I would advise it only for small workloads though. View full review »
Aju Mathai
Database Architect at Huron Consulting
I would definitely recommend SQL Server. It's not cheaper any more, like it used to be, but if you can afford it, then it's the best. When I select a vendor, from a tool perspective, I make sure that they have full support available, have been in the market for awhile, and the solution/application is stable. From an open source perspective, like MySQL, Aurora, and MongoDB, they have done a great job in making a robust database container. View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: November 2019.
382,547 professionals have used our research since 2012.
it_user272976
Managing Director at a tech services company with 11-50 employees
It's good if you need OLAP services. I give it a seven out of 10 overall, because of the things mentioned: First is that during the version upgrades, sometimes things are complicated. The second thing is the support is not so... without an open-source community it would not be so good. Third is the pricing, because it's changing, sometimes it's confusing. View full review »
it_user117381
Lead Software Engineer at a tech services company with 11-50 employees
I’ve been working on Microsoft SQL Server since 2005, and currently I’m using SQL Server 2014 in my development environment and SQL Server 2012 in the production environment. View full review »
Lei Liu
DBA,data architectuire at a tech services company
subpartition is necessary View full review »
Daniel Du Toit
Systems Analyst Developer with 1-10 employees
It is definitely important for someone looking at a new vendor to consider the support of the solution. In addition, the customer should really do their research and understand what their needs are, and make sure the new solution will solve those needs. View full review »
it_user540858
IT Technician / Support Supervisor at a transportation company with 501-1,000 employees
Naming conventions are very very important. Make sure that your principle and mirror servers have the same disk space from the outset. View full review »
reviewer1030020
Programmer Analyst at a tech services company with 10,001+ employees
Go for it. Thumbs up. View full review »
Paul Fijma
Engineer / MS SQL DBA with 201-500 employees
MS SQL is constantly improving their products. New options, such as managing with PowerShell, are good improvements. View full review »
Find out what your peers are saying about Microsoft, Teradata, Oracle and others in Relational Databases. Updated: November 2019.
382,547 professionals have used our research since 2012.
Sign Up with Email