Virtual log file growth In previous versions of SQL Server, if the next growth is more than 1/8 of the current log size, and the growth is less than 64 MB, four VLFs were created. In SQL Server 2022 (16.x), this behavior is slightly different. Only one VLF is created if the grow...
Always Encrypted:When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL Server. Dynamic Data Masking:If specified in the table definition, masked data is hidden from most users, and...
SSMS 17.3 provides support for almost all feature areas on SQL Server 2008 throughthe latest SQL Server 2017, which is now generally available. In addition to enhancements and bug fixes, SSMS 17.3 comes with two new exciting features:
Analysis Services projects and SSMS are updated monthly with new and improved features that typically coincide with new functionality in SQL Server. While it's important to learn about all the new features, it's also important to know what is being deprecated and discontinued in this release...
Object storage integrationSQL Server 2022 (16.x) introduces new object storage integration to the data platform, enabling you to integrate SQL Server with S3-compatible object storage, in addition to Azure Storage. The first isbackup to URLand the second is Data Lake Virtualization. ...
Recently (honestly it's been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server lifecycle. That has the huge benefit of not having to wait on a new version of SQL to get new features in SSMS. They come out so often, i
Always Encrypted:When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL Server. Dynamic Data Masking:If specified in the table definition, masked data is hidden from most users, and...
SQL Server Compact supports case-sensitive collations at the database level. For more information, see Working with Collations (SQL Server Compact). You can administer a SQL Server Compact database stored on a smart device or on the desktop computer by using SQL Server Management Studio (SSMS)...
Analysis Services projects and SSMS are updated monthly with new and improved features that typically coincide with new functionality in SQL Server. While it's important to learn about all the new features, it's also important to know what is being deprecated and discontinued in this release and...
Object storage integrationSQL Server 2022 (16.x) introduces new object storage integration to the data platform, enabling you to integrate SQL Server with S3-compatible object storage, in addition to Azure Storage. The first isbackup to URLand the second is Data Lake Virtualization. ...