Any guy can work on MS SQL server. Its an easy thing to go on.
August 04, 2017

Any guy can work on MS SQL server. Its an easy thing to go on.

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Microsoft SQL Server

Microsoft SQL Server is being used by our enterprise proprietary products as a backend database. Our entire organisation across departments widely uses Microsoft SQL Server. Microsoft SQL Server caters the needs of the following aspects. 1. Easy accessibility of data 2. Easy connectivity of data 3. Securing layers of information. 4. Hosting/Supporting/ acting as a backend database to all major applications (internal/ external).

Pros

  • Strengths of Microsoft SQL Server creating an ease even for a newcomer who just knows basics of the database. Creates an easy adoption for any other database programmer who is working on another platform (Oracle, MySQL etc.) to get migrated over to Microsoft SQL server version with minimal efforts.
  • Primarily when the application data to be hosted is very less there is less complexity involved in the creation of databases, securing access to a database table, schema and role wise. Much of the functionality of DML, DDL operations can be achieved through user interface called SQL management studio - best tool for any programmer to senior DBA.
  • SQL Server integration services, analysis services, and reporting services which are included in BI pack will definitely help enterprise customers save a lot of revenue spent on the additional BI stack Reporting products like Cognos, Crystal Reports, Informatica etc.

Cons

  • SQL Server has certain limitations in terms of functionality of SQL management studio. But there are a lot of third party programming tools which are available in the market which is powerful enough to overcome these limitations.
  • Database comparison tool - Lack of a tool where you can compare entities of database like tables, views, indexes between 2 databases of the same application (like comparing production to stage sites).
  • Version control management system (to maintain different versions of code checked in / checked out). Had to be driven using 3rd party tools.
  • SQL replication - coverage for all 3rd party databases has been withdrawn in recent editions which are a limitation especially while migrating from previous SQL server editions. This is a gray area of SQL Server often challenged to due to limitations of integration to 3rd party software's like Oracle, MySQL etc.
  • Performance management tools - even though there are built-in reports like "Activity Monitor", they are existing to monitor the performance of SQL Server. It's better to have an individual console to connect to SQL server instead of depending on Windows or other 3rd party tools like APEX SQL console, IDERA tool to monitor SQL server performance.
  • Positive impact: Easy application maintenance - once you have the application ready for your production sites and have the SOP's defined *(standard operating procedures) documented well and automation of certain scripts using PowerShell scripts, BAT files or 3rd party applications like IDERA it's a cakewalk for a single system administrator maintain a pool of databases.
  • A slight Negative Impact: (but can be managed easily if DBA is smart ): Based on the complexity of application database or database operations and under higher concurrency environments you need a professional DBA/programmer support which will increase the maintenance aspects especially while handling complex replication/mirroring/ backup/ clustering mechanisms and debugging very critical applications without bringing downtime to the actual server. There is a ton of documentation/blogs support help available online and success rate of debugging errors using these blogs is close to 85% which is compared to high than other database products like "MySQL", "Oracle".
My-SQL, Oracle.

My-SQL - recently they coped up a lot on contrast to MS - SQL server with all the latest features.

Oracle - When you are trying to get a complete package of all product lines MS-SQL server enterprise/ developer edition stands first where it's simple to get all the features in 1 stack.
Microsoft SQL server is well suited in the following scenarios:
for SAAS based solutions.
for any application hosting/ storing data < 1 TB.
for any application where the native code is written in Microsoft based technologies like C#, C#.net, VB.net etc.
for applications where it requires utilisation of BI stack (Reporting - SSRS, analysis - SSAS, and developing ETL based solutions - SSIS).

Comments

More Reviews of Microsoft SQL Server