Main Features
SQL Server 2017 Standard includes the following key features:
- Adaptive Query Processing
- Automatic Tuning
- Graph Data Processing
- Machine Learning Services
- Native JSON Support
- Resumable Online Index Rebuild
- Row-Level Security
- Temporal Tables
Benefits
- Improved query performance and scalability
- Enhanced security with row-level security and Always Encrypted
- Increased availability with automatic failover and resumable online index rebuild
- Support for graph data processing and native JSON support
- Integration with machine learning services for advanced analytics
What's New in SQL Server 2017 Standard?
SQL Server 2017 Standard is Microsoft's popular relational database management system. It comes with several new features and improvements over its previous version, SQL Server 2016.
One of the most significant changes in SQL Server 2017 Standard is the support for graph data processing. This feature allows users to model and analyze complex relationships between data points, making it easier to identify patterns and insights.
Another major improvement is the inclusion of automatic database tuning. This feature uses machine learning algorithms to optimize database performance by analyzing query patterns and making recommendations for index creation and other optimizations.
SQL Server 2017 Standard also includes enhanced security features, such as the ability to encrypt data at rest and in transit, and improved auditing capabilities. Additionally, it offers better support for Linux-based environments, making it easier to deploy and manage SQL Server in a variety of settings.
Overall, SQL Server 2017 Standard represents a significant step forward in terms of functionality, performance, and security compared to its predecessor, SQL Server 2016.