SQL Server Reviews

Probably the most useful feature of SQL Server is the ability to write and execute SQL on the fly.

Even though there are some very useful features on Oracle, MySQL, and other platforms, the SQL Server by far has the most robust capabilities of any database platform.

In my experience with numerous coding languages and platforms, the SQL Server has the only programming language that allows the user to create, compile, and execute code in its own language.

To clarify, Java, .NET, PL/SQL and all other programming languages can dynamically create code, but not their own. In other words, Java can dynamically create SQL and execute it, but it cannot create Java and compile/execute.

Other great features are:

• Passing tables as parameters
• Table valued functions
• Horizontal table partitioning
• Very granular disk partitioning

The most recent example is a data warehouse I've created for a client that enables us to use a "no-SQL" construct. This is only possible due to the dynamic SQL capability.

Our client collects data from dozens of sources with little to no commonality between them. With other platforms, this would require a table for each data source. However, because of the dynamic SQL, we have three tables that will accommodate ANY data source and it will never require us to change the data warehouse schema.

As a result, maintenance is virtually zero.

The only real improvement I've been looking for is finally being addressed by Microsoft.

Since SQL Server only ran on Windows, it was not competitive with other platforms which could run on Linux. This has recently been realized with the release of SQL Server for Linux. I currently have the pre-release version and I'm very impressed with what they have so far.

I have been using SQL Server for 17 years.

We did not encounter any issues with stability. None at all.

We did not encounter any issues with scalability. I have been able to create databases with billions of records with no degradation in performance. The partitioning has been a critical feature in enabling scalability.

In my experience with their support, I would rate it as outstanding. Their techs are professional and extremely helpful.

I typically use whatever database platform my client uses. However, whenever I am provided with the option to choose, I will always go with SQL Server.

In older versions, the setup was rather onerous. However, in the latest several releases, it has been extremely simple to install and set up.

Do the research and get the correct licensing model for your given purpose. A lot of people gravitate toward the Open Source databases because they don't have an upfront cost.

I find that what you don't pay upfront is what you have to invest in development and maintenance time on implementation. On far too many occasions, I have spent weeks writing code for features that SQL Server already has built in.

Either pay for the licensing cost or pay multiple times that for the labor involved in creating features, from scratch, that are native to products like SQL Server and Oracle.

I have a good deal of knowledge on SQL Server, and Oracle, MySQL. I have some familiarity with DB2 and PostgreSQL. The database platform chosen will ultimately depend on the needs of the client.

Look very closely at the built-in features. For those features that you may need, estimate what it would take to replicate that same functionality on the "free" products.

The comparison is not on the licensing cost. It's on the features and the license cost versus the labor cost.

The most valuable feature is the easy installation. The user just needs to know how to read.

The SQL Server is helping us with the most feared corporate problem: Excel spreadsheets. The individual user can perform an integration and share the same results with others without the necessity to "share" the file. This reduces the data traffic on my company network.

Table partition and memory management. The performance could be better.

I have used it for more than 10 years.

The SQL Server has a big issue when some systems use Java as a primary software interface. This database loses the ability to manage memory, consequently locking the processes and losing performance in the execution of some robust queries.

Unfortunately, this database doesn't have a good concept of partition table. If you need to create monthly (Jan. to Dec.) partitions in one table, this action creates 12 different files for the same table. In others databases, this process is more transparent and capable to create partitions inside the same database.

The technical support team for the SQL Server is very friendly, if we compare with others commercial database products. Not only with Microsoft, but this database has more technical information published on the internet, books, and self-taught users to help.

I am still using other commercial solutions, but the price of this database is much less expensive than others. It is about four times less expensive.

The initial setup is one of the good things about MS SQL. It is very easy to do and start the development that you need to use after the installation.

In my point of view, the MS SQL is the most inexpensive database commercial solution. If do you need to build a consistent ERP for example, with a medium to hard capability, and don't have much budget to spend it, this is your solution.

Of course, I evaluated other options! I never choose the first option and I always try to look around to find competitive vendor options. I already know and have expertise with IBM/DB2 and Oracle solutions. For this new architecture, MS SQL was the best option at the moment for being a pilot project.

I suggest that you are first familiar with the bundle functions and plan some of the functions before starting the project. Find more information about the routines and how easy or hard it might be to start the development when you are thinking about cascade and constraints.

There are many, but I would have to say the two most important for me have been SQL Server Profiler -- to run traces and the ability to kill sessions in the enterprise manager tool. This command-based functionality lets you search and sort through processes actively running on the system to find your i/o hog – that is the user that is overloading the database either through a hung query or bad SQL code.

Once the hog user is found, the terminate or “kill” command can be used to shut down the hanging transaction. Similar to how clearing a vehicle crash on the interstate frees up waiting traffic, this kill command gives other users the ability to continue work as normal once the terminated transaction has been killed. This should be used sparingly though since it can cause waiting applications to corrupt data depending on how the application was written, but it is an often used research feature when a system starts to overload or show major signs of slowing.

In an effort to forego a data warehouse purchase, one company I worked with used a second SQL Server instance loaded to separate hardware as a reporting environment avoiding the need to hire additional employees to support a data warehouse. Essentially, the production database was snapshot and copied nightly to the reporting instance where it was restored through automated processes.

All employees who wrote queries and reports against the reporting instance utilized the same knowledge, skillset and tools already used in the OLTP production environment. While it didn’t have all the abilities of a true data warehouse, it was quickly implemented and well served for the desired purpose.

Multiple operating systems support should improve. The ongoing and newly marketed support for Linux and Unix environments running SQL Server is a big win for Microsoft, in my opinion.

Previous hold back related to open source environments stemmed from admins or management who would not run SQL Server for various reasons which many times boiled down to not liking Microsoft as a company.

Open source and Microsoft have conflicted in the open source world for years, but I think Microsoft is finally starting to turn that tide in an effort to compete with other vendors.

20 years. I began as a Microsoft Access database programmer in 1998 connecting early dynamic intranet websites to Access backend databases.

I later progressed to the SQL Server 2000 environment and have utilized SQL Server ever since then.

Issues encountered with stability were always correctable assuming we as a business were willing to spend money. The two major issues that come to mind were slowing of image files loading to disk using SQL Server and lack of proper indexing.

Images were archived for a 30 year legal period at a rate of at least 12 million per year and we eventually just hit a max depth of data where SQL Server had a hard time returning results. Shortening the physical file path structure of how deep SQL Server had to dig through the hard drive in addition to changing to new and improved disk technologies resolved the problem.

After this drive change occurred, a separate problem started where our database came to a crawl which is when we realized our regularly scheduled database index had not been updated to accommodate the new structure changes. A new index was put in place which is when SQL Server started humming along better than ever.

Microsoft makes life easy to expand your environment through clustering tools and after-hours operational scheduling features. SQL Server is easily suited for small businesses where it found huge popularity, but daily operations can sometimes be overlooked as the business grows causing intermittent operational kinks. I have seen a few small businesses determine that a slowing or overloaded SQL Server environment means they should look at more enterprise level databases, which is simply not the case.

Just like a Windows PC needs basic defragmentation maintenance to run effectively, SQL Server needs its own regular maintenance. There are many options available to improve the performance of SQL Server including the simple add-on clustering features which will balance excess load on the server.

In addition, database indexes need to either be created or re-indexed periodically. A database does not automatically know how an application was designed although it’s very good at trying to guess using built-in scheme mapping software. Creating indexes and related maintenance schedules specific to your environment can make a huge difference in how quickly SQL Server responds to data requests.

Disk partitions are another method for improvement. No matter how well SQL Server software is configured, it is limited by the hardware level. Underlying disk usage grows as data grows meaning the more data you add to the database results in the longer it will take for the database to find data on-disk. That’s when it’s time to either spread data across many independent disk sets or move to more expensive flash drives which save time by avoiding read & write disk operations.

These options, of course, require time, effort, and money, but they have been well worth the costs of doing business based on my experience.

I have only had to call Microsoft support 5 times in my nearly 20-year career, but they were extremely helpful. The one frustrating experience was 10 years ago when I worked over the phone 8 hours straight with 3 separate techs from the India location. Keep in mind, these were days pre-remote support meaning I had to verbally translate every diagnostic error I was seeing on the screen and assume the tech was clear on the meaning. The techs I worked with were extremely nice and tried hard to help, but I reached my frustration level due to the verbal language barrier.

The senior tech, who I spent the most time working with, had an extremely thick accent and was hard to understand. I could tell he had hit a dead-end on his knowledge of the product so I finally asked to be transferred to a specialist in America. Once I found the right person in the US, my problem was resolved within an hour.

In hindsight, I knew the senior tech was lost at the 6-hour mark, so I should have spoken up then, but he never complained and kept trying different solutions, which is good on Microsoft’s part.

My team and I have tried many different technologies including MySQL (cheap but effective), Oracle (expensive and effective), PostgreSQL, and DB2. I never jumped on the PostgreSQL or DB2 train, but could not give you a specific reason why due to my limited knowledge of the products. It usually came down to lack of knowledge for available programmers in our area, meaning we would have to train new hires and take a lot of time getting them familiar with a new database structure. That defaulted us to either Oracle or SQL Server since MySQL was not used in production at the time due to limitations surrounding support.

Oracle owns MySQL these days and they, of course, would prefer you run full fledged Oracle database for support needs. Oracle’s supremely expensive licensing has normally pushed me and coworkers to Microsoft SQL Server although every organization I have worked with pays for some form of Oracle even though SQL Server is primarily touching end users.

I personally feel Oracle is a great database but also think Microsoft SQL Server can be configured to run just as well as Oracle in most cases. The problem I normally find is that many bloated applications run SQL Server where more streamlined (and many times less functional) applications run Oracle. For that reason primarily, Oracle has had a better reputation in the pre-Amazon world.

This could all change in the years to come as Microsoft starts to fight Amazon and Google in cloud processing.

Creating a SQL Server instance using the pre-installed GUI setup screen available in either Visual Studio or Enterprise Manager can be very simple to create and maintain database “instances” making it a prime choice for small startup businesses.

In addition, Microsoft has added loads of training videos on their website along with step-by-step instructions for creating and maintaining servers. The user can get as complex as desired in SQL Server by learning all the behind-the-scenes commands the GUI is using. You will start researching commands quickly once the first SQL Server error occurs and the GUI doesn’t know how to resolve it.

For the most part, what you see is what you get with Microsoft’s licensing website. I sat through many hours of negotiations with many database and application vendors. Some application vendors try negotiating a better deal based on their licensed volume, but only twice have I seen Microsoft cater to lower licensing and it was because they wanted to make long-term wins with the customer knowing they had the possibility of gaining market share.

That said, Microsoft is still usually cheaper than Oracle who will sometimes look cheaper to start with but add the possibility of higher long term rates. Asking for a discount can never hurt.

MySQL (now owned by Oracle) is sometimes used internally for dynamic website needs, but Oracle is the only competitor evaluated for SQL Server.

Start in the cloud if feasibly possible and if it makes sense for your business. I have mostly worked with organizations that still don’t trust the cloud for security and legal reasons, but Amazon, Microsoft, and Google are releasing promising products in the cloud that are leaps and bounds ahead of processing power for local servers assuming your organization is willing to pay what it takes. I have priced cloud services enough to know they’re expensive, but they could replace a lot of unknowns for growing businesses or those starting from scratch; mainly network security, redundancy and technical skillset of employees.

Cloud services have full-time employees focusing on those niches meaning you as an employer will have less headaches at night.

According to CNBC and Synergy Research Group as of this writing, Amazon AWS leads 33% of global cloud market share. That may sound like a small number, but it’s by far the majority of customers since Amazon’s AWS cloud revenue is more than the next five providers combined. Two of those 5 providers are Microsoft and Google.

And for those of you new to the cloud, you do have the ability to run Microsoft products, including Microsoft SQL Server, in the AWS cloud.

Database Engine

Integration Services

Reporting Services

I am a Senior Software Engineer. I've used SQL Server for most of the solutions that I worked with, from web crawlers to logistic platforms and medical devices.

• The Server Objects area of SQL Server Management Studio
• The SQL Server Configuration Manager

Over 10 years.

Yes, I encountered issues only when using the Express editions during the development. SQL Server, generally speaking, is stable also in high transaction environments.

Yes, I encountered issues in the CPU intensive application, like web crawlers. It was difficult to reach the desired scalability through the fine tuning options available.

The support is good. The knowledge base is very good.

I have experience with Sybase SQL Anywhere .

I switched mainly because the SQL Server is widely deployed and known, for better XML support, and for better integration with .NET framework and its related technologies.

It was straightforward for most of the installation, thanks to the wizards.

I am not a direct purchaser, so I don’t know.

SAP/Sybase SQL Anywhere for the small footprint which makes it suitable for embedded solutions.

SAP/Sybase SQL Anywhere for the built-in synchronization technologies available.

Improve the built-in database replication technologies.

It’s easy to develop and learn for newbies, and community MVP’s are so powerful and qualified, so info is easily accessible.

Also, SQL Server is not only a DBMS solution anymore, it is also a BI platform, and improvements are being made continuously.

SQL Server is our main RDBMS for SIS (Student Information System) and also our DWH, which are hosted on our SQL Server.

Version management, editor capabilities, CDC (change date capture), and some advanced analytic functions should be added; continuous integration solutions.

I’ve been developing with MS SQL Server for nearly 20 years, since Version 6.5.

Not in this version.

Yes, we did, with the 2008 version.

We have a yearly technical support agreement with a major partner. Consultant meetings are a requirement.

No. We’ve been using SQL Server for 17 years.

We’ve been using AlwaysOn availability groups for three years. It took a while to model the structure, but now it is stabilized, and safe with disaster recovery and failover configurations.

It was years ago, so it’s not relevant info anymore.

Database modeling and indexing best practices are so important. Do not defer to implement these practices. Before installation, planning different file groups for temp, data, and index files will help to gain performance and maintenance advantages.

The database engine within SQL Server 2014 is one of the most valuable components of the platform to me.

The engine provides a solid and efficient database backend for any relational database requirement, performance is strong and there are options such as table, index partitioning and columnstore indexes that enhance the scalability of the platform.

In addition to the database engine, I would also highlight the built-in integration services platform (SSIS) for ETL purposes as well as the Reporting and Analysis Services functionality (SSRS and SSAS respectively).

One of the key features that I would use regularly to support the delivery of a Data Warehouse solution would be the Master Data Services (MDS). This is an extendable Master Data Management platform that works very well out-of-the- box.

As an IT Services organization, our companies have used this product in dozens of customer deliveries for solutions such as ERP applications, Data and Analytics solutions, and more. We also use the product internally as the backend for some of our most important operational systems.

The user interface to the web frontend of MDS could be more intuitive and the Analysis Services platform has not evolved much in recent times, these are the two things that come to mind.

This specific version (2014), I have used for approximately three years. However, I use other versions of the software on a regular basis, such as 2012 and 2016.

There were no issues with stability.

There were no issues with scalability.

Microsoft has a solid support structure for the SQL Server platform and I’ve always been provided with a good service.

We used a combination of RDBMS platforms and we still do in addition to this solution.

The installation and configuration was very straightforward. The full setup typically takes less than one day.

The Enterprise license includes features that enrich the product experience as well as performance and scalability options. Choose this over the standard license where possible.

We reviewed many RDBMS platforms for suitability depending on the requirements of the customers. We would also use the likes of Oracle 12c and Amazon RDS.

Install a trial version as soon as you can and give it a try.

The SSIS, SSRS, and DB are the most valuable features because they help in everything.

There is improvement in the performances and stability.

SSIS needs improvement.

I think that it should be easier in managing SQL packages, especially when we have multiple environments. With Kerberos Authentication, we had different issues on this and sometimes, we needed Microsoft Support too. Thus, a better and an organized SQL package review is needed.

When using HA (high availability), we experienced some stability issues.

There were no scalability issues.

Technical support is the best, I would give them a 10/10 rating.

We were using a few other solutions such as MySQL, Oracle and Pervasive PSQL.

It’s okay as compared to the features that it has.

We evaluated the Oracle solution.

If you want stability, then choose the best.

The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.

MS SQL is a recognized data tool, it provides many ways to help us organize data and process information.

MS SQL need to improve the big data functions and also own market share.

since 1999

few problems

no

i didn't use it like admin, i don't know.

great product

Oracle, some times i used others solutions, but working by compatibility.

easy.

never calculate.

according you need