Studio di gestione di SQL Server 18.0 Anteprima pubblica 5 Rilasciato. You can download SSMS 18.0 Anteprima pubblica 5 Qui.
New features include:
- Static Data Masking
- Query Tuning Assistant
- Ability to launch Azure Data Studio from SSMS
SSMS improvements include:
- SSMS – Exposed “Maximum size for error log files” under “Configure SQL Server error logs”
- SSMS/Object Scripting – Adding new menu items for “CREATE OR ALTER” when scripting objects
- Database Compatibility Level Upgrade – New option under
Tasks > Database Upgrade. This will start the new Query Tuning Assistant to guide the user through the process of: - Collecting a performance baseline before upgrading the database compatibility level
- Upgrading to the desired database compatibility level
- Collecting a second pass of performance data over the same workload
- Detecting workload regressions and providing tested recommendations to improve workload performance
- SSMS – Query Store
- Improved usability of some reports
- New Query Wait Statistics report
- Vulnerability Assessment – Enabled Vulnerability Assessment tasks menu on SQL Azure Data Warehouse
- SSMS/Managed Instance– Improved support for Azure Active Directory logins, SMO Filegroup objects, and UI for credentials and audits
Inoltre, abbiamo anche diverse correzioni di bug nelle seguenti aree:
- Crashes/hangs
- AG dashboard
- Attach Database wizard
- Scripting of SMO Filegroups objects
SSMS 18.0 Anteprima pubblica 5 può essere installato parallelamente a SSMS 17.x a scopo di test. Come promemoria, l'uso del software pre-GA negli ambienti di produzione non è supportato.