"Responsive, knowledgeable, and flexible service..."

— Program Manager, Serco NA

"Diamond Technology provided valuable solutions and programming ability in support of our project"

— Sr. Applications Developer, San Francisco Int’l Airport

"Professional, attentive, and highly competent"

— VP of Operations Cornerstone Consulting

"Reliable on-site services and project management"

— Executive Director, En Pointe Technologies

Some Pros & Cons of Selecting Microsoft SQL Server as your Database Platform


Databases are the engines of most business IT systems. They house critical business intelligence, help support important business decisions, and carrying out hundreds of thousands of transactions each day.

Database applications vary in price, cost of ownership, performance, functionality, and ease of use. There is a huge choice of database management systems (DBMS). One of the major database products is Microsoft SQL Server.

In considering MS SQL Server for your organization, here are some of the Pros and Cons you should consider

PROS:

Free Version Available

MS SQL Server's entry level version is free. This SQL Express edition has nearly all functionality and features of the full "Standard" version of MS SQL Server, with just a few minor limitations.

Easy Configuration

Most experienced DBAs find the set up process comparitively easy. This is especially true, if, like most organizations, yours has a significant amount of existing Microsoft infrastructure

Adapting Technology

SQL Server's beneficial technology and enhancements has been adapting and increasing, quickly. Column-based indexing, which turns out to be a great way to introduce NoSQL, was included in SQL Server. SQL Server 2014 introduced memory optimized tables. Future MS SQL Server enhancements will include: Query Store, Polybase, Stretch Database, JSON Support, Row Level Security, Always (Continuous) Encryption, and In-Memory Enhancements.

Time Saver

MS SQL Server comes with an impressive tool set. Components such as SQL Server Profiler, SQL Server Management Studio, BI tools and Database Tuning adviser can save you a lot of troubleshooting, development, and administration time. Additionally, as a core product in the Microsoft technology stack, MS SQL Server support and documentation is extensive.

CONS:

Cost

If your organization's database system needs are exceeded by features provided in the free SQL Server Express version, then investing in the high level versions of SQL Server can be significant, depending on your organization's circumstances.

Infrastructure Restrictions

If your organization has little or no existing Microsoft infrastructure, you will have to make additional commitments and investments in the Microsoft's ecosystem to use Microsoft SQL Server. This is related to the Cost obstacle in that the result would be purchase commitments to Microsoft server products which can, again, be costly.

Dependency

With investments in the Microsoft technology stack, your organization becomes dependent on Microsoft for any new features or improvements that your infrastructure might need. This, usually, means a 2 year cycle wait time for Microsoft updates.

Case Studies

Oracle DBA & IT Support Services for SFPM
Microsoft SQL Server Management & Development Services
MySQL Application Development
200 OK

OK

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [no address given] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.