Recently GrassDew got great knowledge sharing by Microsoft on SQL 2016 and its benefits for business. I am sharing few of points which are well known Mission - Critical Performance pillars of Microsoft SQL Server 2016
1. Performance
In-Memory OLTP Enhancements -
Greater T-SQL surface area, terabytes of memory supported, and higher number of parallel CPUs
Operational Analytics -
Insights on operational data; works with In-Memory OLTP and disk-based OLTP
Query Store -
Monitored, optimized query plans
Temporal Tables -
Query data as points in time and recover from accidental data changes and application errors
2. Security
Always Encrypted -
Sensitive data remains encrypted at all time, with ability to query
Dynamic Data Masking -
Real-time obfuscation of data to prevent unauthorized access
Row-Level Security -
Fine-grained access control for table rows
Other Enhancements -
Audit success/failure of database operations
TDE support for storage of In-Memory OLTP tables
Enhanced auditing for OLTP with ability to track history of record changes
3. Availability
Basic Availability Groups -
Its available with SQL server 2016 Standard Edition
Enhanced Always On -
Distributed Availability Groups, automatic replica seeding, distributed transactions, automatic failover, load balancing, manageability
Backup Enhancements -
Managed backup to Azure, Database Recovery Advisor
4. Scalability
Windows Server Support -
Support of new features in Windows Server 2016
Live Migration -
Faster live migration, live migration for non-clustered VMs
Scalability Enhancements
Hardware acceleration for TDE, parallelized decryption, TempDB optimization, and more
I hope above summery points will give good idea on SQL Server 2016 benefits.
GrassDew has four main business streams – Consulting Services, Software Solutions, Security Services and Knowledge Services. Our primary focus is on various software development and maintenance services.
To know more about our services, email us at shekhar.pawar@grassdew.com