SQL Server Advantages over MYSql

-

SQL Server Advantages over MYSQL


Ultimately, the choice is yours. As a rule of thumb, if you’re developing
medium/small-sized applications and predominantly use PHP, go with MySQL.
 Whereas, if you’re interested in building large-scale, secure, resilient enterprise applications, SQL Server should be right up your alley.

On the surface, there isn’t much to look at when comparing security differences between MySQL and SQL Server. Both are EC2 compliant, which means that you are mostly in safe hands choosing either of the two. Having said that, Microsoft’s shadow also looms large here, as it has equipped SQL Server with proprietary, state-of-the-art security features. A dedicated security tool – Microsoft Baseline Security Analyzer – ensures robust security for the SQL Server. So, if security is a major priority for you, your choice has just been made for you.

Native compatibility: You can use either database with both Windows and Linux projects, but MySQL works natively with PHP and MSSQL is mainly used with .NET. It makes integration simpler if you stick with MySQL for PHP and MSSQL for Windows projects.ORM when we are developing an application is ASP.net we need to implement ORM  and best ORM for ASP.net is Entity framework which works best with SQL server only.

SQL server comes with rick BI tools like SSIS SSRS and Power BI.

Some more pros to SQL Server
  • ·  It comes with lots of excellent tools like SQL Server Profiler, SQL Server Management Studio, BI tools and Database Tuning adviser. all will save you a lot of time in development and troubleshooting.
·       You will find setting up almost everything exceptionally easy.

·       It's one of Microsoft's premier products so it is well supported with a ton of documentation and you will easily find help from MVPs

·       SQL server has been evolving rapidly in multiple technologies, in SQL Server 2012 they introduced column-based indexing which in a way is an introduction to NoSQL in the SQL server.

·       SQL Server 2014 will be coming with memory optimized table (It should not be compared to MEMORY engine of MySQL)

·       T-SQL remains consistent across new versions of SQL Server.

·       Best XML support

·       SQL Express edition is free and includes almost all functionality of full-featured SQL server with the limitation of supporting on 10 GB of Database.

·       There are connection drivers for almost all platform to connect with it. 

MYsql  Cons: 

·       Extensive tooling support only available in Enterprise Edition

·       SQL can have some inconsistency between different versions.

·       Features are a bit less compared to SQL server

·       Money saved in cost but sometimes errors are hard to troubleshoot due to a lack of proper tools and more time consumed.

·       MySQL has XML support but lacks lots of features to query over the XML column.
                      
           One of the Pros is Con also. Too many choices at times. hard to select at times.

           The image below shows how  SQL  Server evolved in past years.



some reference links are as below

https://blog.pythian.com/top-10-new-features-of-sql-server-2019/


Comments

Post a Comment

Popular posts from this blog

Setup source code of Visual studio on Bitbucket

-
Image
Setup source code of Visual studio on Bitbucket  Prerequisites:  Download and install  bitbucket extension for Visual studio  from following URL https://marketplace.visualstudio.com/items?itemName=MistyK.VisualStudioBitbucketExtension Download the following software for command-line access of Bitbucket https://git-scm.com/downloads The following are the steps to set up  VS for Bitbucket. 1.        In the file menu, go to the source control options and clear the bindings. You'll specifically want File - Source Control - Advanced - Change Source Control... 2.        You will see the screen as bellow 3.    Now one by one remove connect checkboxes by clicking the unbind button in the top toolbar and at the end press ok.      4.  To tools--> options--> Source Control change current source control plug-in to as following ...
Read more

.Net Core WebClient and proxy setup

-
Image
In .net core, if you need to call 3rd party API, you may have to create an object of WebClient and do some steps to retrieve and send data to that API. today I am going to explain to you  how you can create WebClient and how you can set up proxy settings in WebClient so you can call API throw proxy and retrieve any data.  First of all, you need to create a dictionary of strings which can contain headers for 3rd party API, that code should be as following, you can add more parameters as per your need, for me, I just added one header. public    Dictionary < string ,  string >  GetHeaderForJson () {      Dictionary < string ,  string >  headers  =  new   Dictionary < string ,  string >();      headers . Add ( "Content-Type" ,  "application/json" );      return   headers ; }   one you created a header dictionary its time to create WebClient...
Read more

Tables with ledger in sql server 2022

-
Image
Ledger  in Sql Server 2022 In SQL Server 2022, you can create a ledger using the built-in functionality of the system-versioned temporal tables. A ledger is a record of all transactions that have affected a particular account or set of accounts, and it can be used to keep track of financial data, inventory data, or any other data that involves transactions. Append-only ledger Are ideal for application patterns that are insert-only, such as security information and event management (SIEM) applications. Append-only ledger tables block updates and deletions at the API level. This blocking provides more tampering protection from privileged users such as system administrators and DBAs. To create a table with append-only control use following is the   query CREATE SCHEMA [AccessControl]; GO CREATE TABLE [AccessControl].[KeyCardEvents] ( [EmployeeID] INT NOT NULL , [AccessOperationDescription] NVARCHAR ( 1024 ) NOT NULL , [ Timestamp ...
Read more