Released: Sep 16, 2020
Updates in 10.4.x
v10.4.7
Updated Nov 9, 2020
Features
- General performance improvements.
v10.4.6
Updated Oct 26, 2020
Fixes
- Fixed Smart Rename and Split Table for connections using TrustServerCertificate.
v10.4.5
Updated Oct 15, 2020
Fixes
- Fixed a crash on startup in Microsoft Visual Studio.
v10.4.4
Updated Oct 15, 2020
Features
- Added support for Smart Rename and Split Table for Microsoft Azure MFA connections.
Fixes
- Fixed script being misinterpreted when AT TIME ZONE was used with a variable.
- Fixed an...
Released: Jul 2, 2020
Updates in 10.3.x
v10.3.9
Updated Sep 7, 2020
Fixes
- Fixed an issue where the template parameters window appears after auto-completing a snippet containing XML.
- Fixed an issue where the refactor insert into update operation failed when using certain SQL scripts.
v10.3.8
Updated Aug 28, 2020
Fixes
- Internal improvements on SQL Prompt Tab History functionality.
v10.3.7
Updated Aug 12, 2020
Fixes
- Fix for crash on startup when using extensions with conflicting versions of the Serilog logging library.
Released: Jun 2, 2020
Updates in 10.2.x
10.2.1
Updated Jun 10, 2020
Fixes
- Fixed an issue where default values for snippet placeholders were not being saved after being changed.
10.2.0
Updated Jun 2, 2020
Features
- SQL Prompt no longer uses a vulnerable version of SQLite.
Fixes
- Fixed an issue with tab reconnection in SSMS 18.5.
Released: Feb 19, 2020
Updates in 10.1.x
10.1.7
Updated May 11, 2020
Fixes
- Fixed an error with loading tab history options with different locales.
10.1.6
Updated May 11, 2020
Features
- NOTE: The keyboard shortcut for "Show Open Tabs" has been changed from Ctrl+Q to Ctrl+Shift+X.
Fixes
- SP-7985 : SQL Prompt no longer attempt to qualify objects when they are already qualified.
- Fixed an error where running inline exec on certain procedures would change behaviour.
- Fixed an error where SQL Prompt would fail to parse certain QUERY_STORE...
Released: Nov 6, 2019
Updates in 10.0.x
10.0.11
Updated Feb 5, 2020
Features
- Added suggestions support for new permission types in SQL Server 2019.
Fixes
- Fixed an issue with columns sometimes not being qualified when qualifying object names.
- Fixed an issue with some functionality not appearing for servers connected using Windows authentication.
10.0.10
Updated Jan 29, 2020
Fixes
- Fixed an issue that caused SSMS to crash when connecting to an Azure server using Multi-Factor Authentication.
10.0.9
Updated Jan 28, 2020
Released: Oct 28, 2019
Updates in 9.5.23
Fehlerkorrekturen
- Fixed an issue which would sometimes cause the Tab History/Code Analysis UI to fail to load.
Released: Oct 24, 2019
Updates in 9.5.22
Funktionen
- Enhanced Tab History *
- You can now star the tabs you use most often, so they're easier to find and restore when you need them.
- Tabs are now shown in time buckets, making them easier to search through.
- Added support for the APPROX_COUNT_DISTINCT aggregate function, introduced in SQL Server 2019.
- Added support for the index options RESUMABLE and MAX_DURATION in CREATE INDEX statements, introduced in SQL Server 2019.
* SQL Prompt keeps a history of query tabs you open in Management...
Released: Oct 16, 2019
Updates in 9.5.21
Funktionen
- Added a new ranked ordering option for suggestions.
- Added suggestions support for
ADD/DROP SENSITIVITY CLASSIFICATION
syntax introduced in SQL Server 2019.
- Added suggestions for
COMPATIBILITY LEVEL
values for all supported versions of SQL Server.
Fehlerkorrekturen
- Fixed scenario that could lead to corruption of Prompt Options during export to a zip archive.
- Fixed an issue which would sometimes cause formatting to fail when applied to a script containing a
PIVOT
clause within an UPDATE...
Released: Oct 2, 2019
Updates in 9.5.20
Funktionen
- Smart Rename and Split Table refactorings are now no longer supported for SQL Server 2000/2005.
Fehlerkorrekturen
- SP-7804 : Fixed an issue with suggesting synonyms when schema/database filtering is enabled.
- SP-7824 : Fixed an issue which would cause the Qualify Object Names refactoring to sometimes generate incorrect SQL when used on an UPDATE statement.
- SP-7825 : Fixed keyboard shortcut _(Ctrl+Shift+E)_ for the [code analysis issue details pane](
Released: Sep 25, 2019
Updates in 9.5.19
Fehlerkorrekturen
- Fixed an issue where square brackets were being incorrectly applied to IS_ROLEMEMBER during formatting.