Has columnstore index enhancements for sorting and Always On Availability Group support. New security features: 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 SQ...
While the correct indexes can boost performance, the poor ones can really slow down the SQL server operations in both queries and writes. Clustered indexes sort and store the data rows in the table or view based on their key values. There can be only one clustered index per table. A Non...
Complex View Inline View An inline view is a SELECT statement in the FROM clause of another SELECT statement to create a temporary table that could be referenced by the SELECT statement. Inline views are utilized for writing complex SQL queries without join and subqueries operations. This is call...
In addition, details of any mismatches in metadata properties are now written to the MySQL server error log. The formats used for the error log messages differ slightly depending on whether the discrepancy is found on the table level or on the level of a column, index, or foreign key. The...
The following new SQL Server Agent jobs do index and log maintenance. MDS_MDM_Sample_Index_maintenance MDS_MDM_Sample_Log_maintenance By default the MDS_MDM_Sample_Index_Maintenance job runs weekly. You can modify the schedule. You can also manually run the job at any time by using the...
The new GTID format is UUID:TAG:NUMBER, where TAG is a string of up to 8 characters, which is enabled by setting the value of the gtid_next system variable to AUTOMATIC:TAG, added in this release (see the description of the variable for tag format and other information). This tag pers...
I/O Analysis View an analysis of your I/O performance in the Azure portal to find issues that result from exceeding virtual machines and data disks limits. This feature is currently in preview. Requires SQL IaaS Agent extension. Microsoft Entra authentication Enhance the secur...
Hello Insiders, Today, when updating Dev, I noticed that the welcome page was missing. It lead me directly to edge://help, the page that I had open when...
This is the final post in a series covering changes in SSMS 19. Please review Part 1 and Part 2 for details about Microsoft.Data.Sqlclient, MSAL, removal of the SQL Vulnerability Assessment, and mor... Erin, I see your point, although 19 and 20 do seem to be closer together than pre...
Learn about what's new in the latest version Power BI Report Server. This article covers the major feature areas and is updated as new versions are released.