Microsoft SQL Server Reviews & Product Details

I like Microsoft SQL because I’m able to guarantee avalabilty with always on Review collected by and hosted on G2.com.

I don’t like T-SQL language because There isn’t a wizard interface for create stored procedure Review collected by and hosted on G2.com.

It is very fast and stable.

The engine offers the ability to adjust and track performance levels, which can reduce resource use.

You are able to access visualizations on mobile devices.

It works very well with other Microsoft products. Review collected by and hosted on G2.com.

Enterprise pricing may be beyond what many organizations can afford.

Even with performance tuning, Microsoft SQL Server can gobble resources.

Many individuals have issues using the SQL Server Integration Services to import files. Review collected by and hosted on G2.com.

The industry leading powerhouse for well over 20 years, Microsoft SQL is the only way to go. Review collected by and hosted on G2.com.

High processor utilization and complex queries. Review collected by and hosted on G2.com.

Ease of use. SQL Is without a doubt one of the easiest to manage database systems available. Review collected by and hosted on G2.com.

It tends to have performance issues more than oracle, it can be tuned but you need to put hardware in place to make it work the best. Review collected by and hosted on G2.com.

The dependability of the system, the reliability are the goof aspects Review collected by and hosted on G2.com.

The usability is not so good with syntax being different from some open source options Review collected by and hosted on G2.com.

The ease of connecting the databases and writing SQL code. Review collected by and hosted on G2.com.

It is not extremely intuitive as compared to DB2 platform. Review collected by and hosted on G2.com.

SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter. Review collected by and hosted on G2.com.

Many problems with SSIS. It's a nice framework, but there are some big things missing that they haven't bothered changing. Working with xml isn't easy, neither is having reusable components. One of the biggest things that's just ridiculous is that you can't reasonably import a simple csv with SSIS. CSV is the most common form of text export on the planet yet SSIS seems to blog up when it comes across embedded text qualifiers. DTS handled it just fine, but the SSIS folks have seen fit to remove that troublesome feature from the product. I don't know if they're trying to teach us all a lesson about how to form text files properly or what, but we can't always control the feeds we receive. I've recently had to spin up a 2000 instance for the sole purpose of handling an embedded text qualifier because SSIS is too big and enterprisey to deal with it. There are some other things that are wrong with it too but I can't spill them all here. I could write an entire essay on what's wrong with SSIS though. Review collected by and hosted on G2.com.

We use Microsoft SQL on many of our applications and it is easy to use and run reports from. Review collected by and hosted on G2.com.

I would say some of the complex queries are not easy to write Review collected by and hosted on G2.com.

I like the replication feature it saves our clients data a lot, like the easy data manipulation, like the query check before executing feature, like object explorer which lists all servers in one place so I can import and export data between them, like the easy backup and restore DBs, like the administration in SQL as it gives me full control on who should see what and with which level of authorization, like the generate scripts feature. Review collected by and hosted on G2.com.

Security needs to be enhanced and some hangs happened with big data. Review collected by and hosted on G2.com.

From my perspective the best attribute of Microsoft SQL is the flexibility to retrieve a collection of data attributes in ways that you chose Review collected by and hosted on G2.com.

The sql statements can become quite cumbersome and complex Review collected by and hosted on G2.com.