Data Management made so easy with MS SQL Server

Pros

For any developer, before first they can this own what their apps are going to be developed in their should think of what server should host their database. I do believe that MS SQL Server is the best on the marketing when comes to data management and administration. The best feature that i really love the most on MS SQL Server is the ability to disable remote execution of your queries and really helps protect data integrity in case your server authentication has been compromised. You can also be rest assured that your data is consistent and accurate at all times. Yes hackers some times can try sql injection but i believe MS SQL Server its the most secure servers around.

Cons

The license key for MS SQL might cost you an arm and a leg but at the end of the day its really worth it when you think of a platform where you are able to develop enterprise apps that secure and helps with Business Intelligence.

SQL is getting better as it grows older

SQL Server centralized my data and allows my staff to "believe" that they are working in Excel, It is super fast for loading data from the server, and allow large data set that will normally take hours, or even crash the Excel spreadsheet to load without any issue. When I am ready for a web app.. SQL server is easy as piece to develop a simple CRUD application and push live. It seem to connect to every thing - from MS Word Mail merge, MS Excel, MS Access and of course for development environment such as Visual Studios. One Database ( Centralized) and many presentation modes for the end users. I love it!

Pros

MS SQL Server is certainly a competently relational database engine, with reporting service and now R. Easy to install for small onpremise application. Easy to administer, easy to backup, easy because it is a Microsoft application. It is so easy that most of the application today I work on seem to be pulling data from SQL into Excel and or Power BI. You can start from free version and expand as time goes by. The management studio take the pain our of scripting, and the online support community most likely have your questions answered with T-SQL scripts for copy and pasting. If you deciding on an option for an Relational Database system - you should look at this as your most productive option. It allows you to focus on the problem by making the technology easy.

Cons

The new the version, the more memory intensive this management studio will become. Microsoft need to create some more easy to use tool for change control and change tracking. Backward compatibility - if you used a higher version during development, then it become a pain to use a lower version during production environment.

SQL Server 2017 on Linux! It works..

I have been a SQL Database administrator for over 10 years. I recently had the challenge of implementing it in Linux environments, mainly due to the low cost of licensing / subscription. The product behaves in a very stable way, and delivers superior processing capacity (performance).

Pros

Operating system licensing is always an additional cost. What I like most about SQL for Linux is the possibility to reduce this cost drastically, with an amazing OS and extremely stable SQL in this environment. Adjusting the environment variables for SQL is a differentiator.

Cons

The lack of reporting services is a terrible shortage. It could have an alternative in Apache, or even allow integration with Windows servers for this demand.

Easy and Fast for Development

Pros

MS SQL makes your life easy by bringing SQL Management tool easy to create new database on the fly. Free express Database for development purpose Easy to troubleshoot performance issue,. Same SQL can be published to azure or get the same feeling on Azure. Most used database

Cons

When DB size grow large then it leads to performance issue. these days in world on No SQL database, ppl tend more use other kind of DBS

SQL Server review

SQL server is great, because i can use the same language same application, and for small customers it uses free option, and only for best performnace or bigger data need to pay for it Can use it locally on on cloud

Pros

SQL Server is a great system to develop databases with great functionalities like jobs, procedures, functions ans so one

Cons

For me the only think not so good is performance for bigger batabases, but for me between 10GiB and 15GiB works fine