SQL Server Reviews

We have a Windows Server environment.

This is a production system for secure document issuing in a government department.

It helped reduce licensing costs and also running costs, as well as the learning curve.

The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.

I would like to have more replication scenarios.

Our correlation and relational databases are on Microsoft SQL Server.

The company uses two platforms: MySQL and Microsoft SQL Server. Some applications are on MySQL, and some applications are SQL Server. 

I have pretty much worked all my life in Microsoft SQL Server.

I am in the process of creating a data strategy to consolidate multiple siloed data centers. Once my plan is finalized and approved, then we are going to execute it on the Microsoft platform.

• Performance-wise, it is an excellent tool.
• It is a Microsoft product, so there's a lot of support. 
• It's not a new tool; it has been around for a while. 
• It is one of the top five relational databases in the market. 
• It is very user-friendly.
• There are a lot of resources available for it.

I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins.

I know that they are building SQL Server for the Unix environment, which is in the beta version, and not out yet. This has been a long time wish for a lot of people. Once that is out, we'll be able to tell how diversified they have become in regards to other platforms.

It hasn't 100 percent on scalability and third-party plugins.

It is one of the most stable relational databases out there.

With the new versions and Azure, which is in the cloud, these do accommodate scalability. Until the 2014 version, the scalability wasn't there, but from the 2016 version and above, I think they have taken all these scalability features into consideration.

I have not used technical support for Microsoft with my current company. I have used them in the past. It depends on the tier of support that was purchased by the company as to the level of support that you receive.

Our company has probably been using this solution since it was released.

It is expensive, but you get what you pay for.

Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license.

From my perspective, the two vendors for this are Microsoft and Amazon (AWS).

They are working on making it better with every release, compared to Oracle Db2 and IBM.

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.

Very pleasing and satisfying experience.

• Used to create queries
• Implemented store procedures
• DBA can also use this effectively.

• Used to create queries
• Implemented store procedures
• DBA can also use this effectively. 
• Reduces other manual work.

• Creating and executing SQL queries, transactions, ACID properties
• Creating and implementing stored procedures.

Every good tool has its own limitations. 

• First of all its cost. It is very high. 
• We need a good amount of RAM to properly use this. 
• Sometimes, query sticks in between. 

But our organization provides great RAM, so we don't have any issue with its speed.

No.

It's good.

No.

Go for it. Thumbs up.

The customer's MES system  use it.  The database system desgin as always on architecture.

Like Data guard in Oracle , always on contain double data and sync data by using transactions store in transaction log

It is easy to establish, and the license price is lower than that of Oracle.  

Otherwise, our customer could can replace primary databases from Oracle into MSSQL AG

Base on  windows cluster,  the always on no needs complicated config process.

Just click and click following  GUI interface.

table partition options,  that is very useful to separate unnecessary cost. 

For legacy data,  we can do partition swith out and store into flat files or old tables.

When it necessary, we can switch in back.

Horizontal partitioning.  

In that case,  cold , warm and hot data can be distributed into different database not only table partition located on different FGs .

Sometimes , when windows server suddently failed, the database still can be turn on when DB server started.

When do "sp_rename" or "table rebuild" , the cluster index or non-cluster index no needs to rebuild at same time

Customer always comes out many questions

I have no choice. our customer choose MS SQL 

 initial setup straightforward

ordinary level

database administrator

Migration local database into cloud

No, I  have to accepted it 

subpartition is necessary

• Effectiveness in a production environment
• New features test

Besides that, SQL Server has become very expensive like Oracle. Its stability delivers performance and usability.

• SSMS
• SSIS
• Reporting services
• FCI clustering
• AlwaysOn
• Basic availability groups.

I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.

It is widely used and we never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient. It is something unique that tracks reporting of records, personnel, finances and more. It also integrates well with everything, not just Microsoft tools. 

It would be nice to search for specific value across multiple tables. This would save a lot of time. 

I have never had a problem with the stability of the solution. 

We have never really had a problem with the scalability of the solution. 

I have never used technical support. It is the joke at the office that you cannot get help on the Microsoft website at all. Also, downloading anything from Microsoft is usually a nightmare. Honestly, I end up googling the problem and solving it myself. This is definitely something Microsoft needs to improve.

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. 

This is a departmental database engine which supports primarily localized solutions, data capture, and retrieval. However, with the exception of our aviation group, it is used for localized data lake or reporting solutions support.

It is cost effective with easy integration into the core MS Office tools. Hence user adoption is easy. Also, being a commodity product there is an abundance of cheap resources having experience with the toolkit, but very few senior or truly expert support personnel are available. Again because it is viewed as a commodity product even by developers, no serious time is spent on skills development with this toolkit.

Traditional DB toolkit closely integrated into Microsoft Office. This makes it truly easy to deploy in a light non-business critical environment.

• It does not scale up to a truly global environment. We operate in 220+ countries and territories with data services centralized in three data centers. The ability for MS SQL to operate in this environment is a challenge for anything spanning regions or having a global footprint. 
• It is best suited to supporting a single functional instance by business domain or a single country. 
• MS needs to work better at the WAN implementations transoceanic. 
• It also needs to have a less closed or less MS centric tool dependency as integration with other databases and non-MS development environments is always problematic.

The database is primarily used as back-end storage.

As an engineer working for multiple organisations, MS SQL has proven stability and operational power.

The additional tools, like SSIS and reporting services, make this solution useful.

Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.

MS SQL is constantly improving their products. New options, such as managing with PowerShell, are good improvements.