Home > SQL Server > Why do we need SQL Server 2017

Why do we need SQL Server 2017


SQL Server 2017 (Linux)

DIM (Data is Money) is the latest or at-least a new business model. Microsoft did a fantastic job in implementing SQL Server in Linux as a cross platform. This strategy has surprised Microsoft community and overturned the way we think about Microsoft database management products. In this story, I am going to talk about the SQL Server 2017 on Linux.

Reference:

https://blogs.technet.microsoft.com/dataplatforminsider/2017/08/31/six-reasons-to-consider-sql-server-2017-especially-if-youre-on-linux/

SQL Server 2017 runs on Windows, Linux, Docker containers. It has key features that attract many industry leaders for these features.

  • Cost
  • Security
  • Performance
  • Simplicity
  • Flexibility
  • Everything built in

Cost:

First of all, I would think about product cost. Because, there are many technologies available as an open source. Linux is open source and free for commercial use. So, we can remove Operating system license cost from the investment. Linux can run on any hardware and we can have affordable hardware to setup a business. It reduces the infrastructure cost. Well, With these two cost reduction options, it would possible to achieve ROI in short period of time.

  • With SQL Server 2017 on Linux, it’s possible to realize a lower total cost of ownership (TCO) and quicker return on investment (ROI)
  • Expand your hardware options and achieve ROI more quickly with Linux.
  • Mobile BI anywhere at a fraction of cost.

Security:

Next, with the current digital environment, we are worried about data protection. Past several yearly we have been hearing about data breaches in different sectors. Some events are unavoidable but we need to take maximum effort to protect it. In this way, we need to give preferences to security. So, what kind of security does SQL Server have?

SQL Server 2017 – Data Sheet

  1. Fewest NIST vulnerabilities over last 7 years
  2. Encrypt data at rest and in motion with Always Encrypted
  3. Dynamic Data Masking conceals sensitive data
  4. Control access to database rows with Row-Level Security

Performance:

We do not have much time to wait for a task to complete. It is due to heavy competition and vast amount of data to process to get serious decision quickly. Such as, Weather forecast, Medical diagnosis and real-time sale performance during holidays, etc. So, what does SQL Server 2017 have?

From Data Sheet:

  • Speed query performance without tuning using Adaptive Query Processing
  • Faster transactions with In-Memory OLTP and up to 100x faster analytics with in-memory Columnstore
  • Real-time operational analytics when you combine inmemory technologies

Simplicity:

Who do like to spend lot of man hours for just migrating database from one platform to others. With SQL Server 2017, we can transfer database from Windows to Linux easily by taking backup and restore. For security, we can use encrypted backup with master key.

Reference:

https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-migrate-restore-database

Flexibility:

This word “Flexibility” is more complicated then it looks. Because, it has to satisfy every audience from every perspective. SQL Server 2017 is also a flexible platform to connect with any application. Also, it gives various flexibility for language of your choice, on the platform of your choice, on premises or in the cloud.

Language of your choice:

  • C#, Java, Ruby, or another coding language

Platform of your choice:

  • Support for Windows and Linux operating systems and Docker containers

Cloud:

  • Any cloud, any platform including OpenShift, Red Hat OpenStack, Kubernetes, Docker Swarm and Pivotal

Everything built-in:

SQL Server 2017 is a complete package that can be used for data management with 99.99% availability, simplicity, security, efficiency, affordability and reliability. Also, features like data compression, columnstore, partitioning, high availability, and disaster recovery.

Advertisements
Categories: SQL Server
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: