What's new in SQL Server 2017 and how can we help?

​

We can ramp up to the cloud easily, with greater mobility and provide a consistent experience between your datacenter, private cloud, or Microsoft Azure.

​

Hybrid Solutions

• Store and access historical data more cost-effectively with Stretch Database, which allows you to “stretch” your warm and cold transactional data to Azure without making application changes.

• Backup data to the cloud more easily than ever.
  Several built-in features make your backup and restore options simpler and more reliable, while saving the cost and aggravation of managing hardware for backup and restores.

• Migrate on-premises SQL Server to Azure with ease using point-and-click migration. Use the simplified Add Azure Replica Wizard to create a new Microsoft Azure VM in hybrid IT and configure it as a secondary replica for a new or existing Always On availability group.

​

Enhanced Performance Solutions
Reduce downtime while increasing scalability and processing power to avoid disruptions to your business.

​

• Get better performance. Benefit from enhanced in-memory performance with up to 30x faster transactions, more than 100x faster queries than disk-based relational databases, and real time operation analytics.

• Ensure higher availability With three synchronous replicas for auto failover across domains, round-robin load balancing of replicas, DTC and SSIS support, and automatic failover based on database health

• Improve scalability by caching data across multiple cores. SQL Server 2017 also allows you to deploy databases on Windows Server 2017 Storage Spaces Direct to create highly flexible storage solutions.

• Analyze a full history of changes without additional code. Focus your data analysis at any point in time, simply and efficiently.

​

Security Solutions
With advanced security features, SQL Server 2017 brings unmatched security and performance to the least vulnerable database over the last seven years.

 

• Protect sensitive data at rest and in motion, on-premises and in the cloud with Always Encrypted,
  which encrypts and decrypts data within the client. The actual, unencrypted data is never known to SQL Server.

• Limit access to specific rows in a database Table based on individual privileges with Row-Level Security, and satisfy compliance standards.

• Conceal sensitive data in multiple ways. Hide personally identifiable information like credit card and social security numbers, and control how data appears by obscuring sensitive information without making physical changes to the database itself with Dynamic Data Masking.

​

End-to-End Mobile BI Solutions

Transform data into actionable insights, online or offline, at one-fourth the cost of other self-service solutions.

​

• Access relational and non-relational data at all volumes and with high performance. Pull data from countless sources into data models and reports.

• Build comprehensive, scalable analytic solutions with SQL Server Analysis Services and benefit from the lightning-fast performance of in-memory built into the tabular model.

• Gain insights on nearly any device. Transform your business with modern, paginated reports and rich visualizations. Use SQL Server  Reporting Services to publish reports to any mobile device— including Windows, Android, and iOS devices—and access reports online or offline.