Released: Dec 21, 2021

Aggiornamenti in V6.1.14

Funzionalità

• Added support for Execution step in Jenkins, TeamCity, and Bamboo plugins.
• Added support for UPDATETEXT, SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE functions.
• Added check constraint hints for ALTER TABLE statements.
• Added support for WAIT_AT_LOW_PRIORITY option for ALTER TABLE ... SWITCH PARTITION statements.
• Added DISTRIBUTED_AGG hint for SELECT - GROUP BY queries.
• Added keyword suggestions for ALTER/DROP DATABASE SCOPED CREDENTIAL statements.
• Added keyword suggestions for ALTER DATABASE SCOPED CONFIGURATION statement.
• Added keyword suggestions for MEMORY_OPTIMIZED in ALTER SERVER CONFIGURATION statements.
• Added support for CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE statements.
• Added support for Query Store options in ALTER DATABASE statements.
• Improved behavior when sorting data in Data Editor.
• Improved display of table relationships in Query Builder diagrams.
• Improved error diagnosis when working with source control.
• Added the ability to resize the search text field.
• Added a warning when trying to save read-only files with the applied changes.

Correzioni

• Excluded collations from elements falling into the category of identifiers when working out the Enclose identifiers within square brackets option.
• Fixed search behavior for the UNIQUEIDENTIFIER columns.
• Fixed unexpected exception thrown when creating a connection.
• Fixed unexpected exception thrown when generating database documentation.
• Fixed unexpected exception thrown when closing the SQL Document with the running Query Profiler.
• Fixed unexpected exception thrown when running the application tracer.
• Fixed an issue with saving changes in the table editor.
• Fixed a request to get events in Event Profiler.
• Fixed a definition of columns and data for importing data from a JSON file in which JSON properties are missing.
• Fixed an issue that occurred when starting the application with the Object Viewer open and the Database Explorer closed.
• Fixed an issue with getting the name of the branch for the Git repository.
• Fixed the 'Connection Timeout' error in the SQL Document.
• Fixed the 'The connection is closed' error in the SQL Document.
• Fixed an issue with data export freezing on a database with a large quantity of objects.
• Fixed an issue with reading comparison parameters in console mode in Data Compare.
• Fixed a query execution error in the SQL Document in Data Compare.
• Fixed an issue with using the object names mapping options in Data Compare.
• Fixed an issue with defining unique keys when using object names in different registers in Data Editor.
• Fixed a bug in the Link Database to Source Control wizard in Source Control.
• Fixed an issue with synchronizing the list of connections to database servers.
• Fixed an error in the document service that occurred when starting the application.
• Fixed an issue with accessing partition functions for SQL Server 2000 Storage options in Object Editor.
• Fixed an issue with generating Excel and HTML reports when the 'Hide unmodified columns' option is enabled in Data Compare.
• Fixed the behavior of Code Completion on case sensitive servers.
• Fixed false positives of Syntax Check.
• Fixed an issue with calculating Quick Info.
• Fixed an issue with launching Monitor.
• Fixed an issue with highlighting associated IF/ELSE keywords.
• Fixed an issue with calculating Parameter Info when accessing the procedure using a synonym.
• Fixed an issue that occurred when performing Refresh Suggestions.
• Fixed an issue with Output that occurred when working with SQL Tools versions integrated into SSMS.
• Fixed an issue with data import through templates.
• Fixed an issue with navigating to the similarly named triggers in different schemas.
• Fixed an issue with calculating Parameter Info.
• Fixed an issue with creating an incorrect tooltip for a connection element when starting the application.
• Fixed an error that occurred with comparing data.
• Fixed an issue with comparing user-defined object schemas that differ only in spaces.
• Fixed an issue with reading data in the table editor.
• Fixed an issue that occurred when comparing a database with the Script Folder.
• Fixed an issue with synchronizing objects with data recovery when comparing schemas.
• Fixed an issue with renaming a snippets folder.
• Fixed an error that occurred when starting SSMS.
• Fixed an issue that occurred when creating a connection with custom parameters.
• Fixed an issue that occurred when starting the application.
• Fixed an issue when starting the application with the opened Start Page.
• Fixed an problem with poor performance when working with TFS.
• Fixed the OutOfMemoryException error that occurred when synchronizing schemas.
• Fixed an issue with generating a data comparison report in the XLS format.
• Fixed an issue that occurred when closing the application.
• Fixed a syntax error in the STRING_AGG construction.
• Fixed an error that occurred when comparing a database with an empty folder.
• Fixed an issue in Source Control when working with a case sensitive database server.
• Fixed the behavior of keyboard shortcuts.
• Fixed an error that occurred when starting the SQL Server Monitoring Tool.
• Fixed an issue with zooming text in the SQL Server Monitoring Tool.
• Returned the capability to insert a JOIN condition after an open parenthesis.