View Issue Details

IDProjectCategoryView StatusLast Update
0002136Database Workbench v6Microsoft SQL Server Modulepublic2023-08-28 15:21
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status closedResolutionfixed 
Fixed in Version6.3.0 
Summary0002136: Proper support for latest SQL Server versions
DescriptionFull support for latest SQL Server versions.
TagsNo tags attached.

Activities

Martijn Tonies

2023-05-11 11:22

administrator   ~0000582

Last edited: 2023-05-16 11:39

https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2016?view=sql-server-2016

- JSON functions > https://learn.microsoft.com/en-us/sql/t-sql/functions/json-functions-transact-sql?view=sql-server-2016
- data masking > https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-2016
- encrypted tables > https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-database-engine?view=sql-server-2016
- STRING_SPLIT function > https://learn.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver15

Martijn Tonies

2023-05-11 11:29

administrator   ~0000583

Last edited: 2023-05-16 11:38

https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2017?view=sql-server-2017

- Graph support > https://learn.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-overview
- New string functions are CONCAT_WS, TRANSLATE, and TRIM, and WITHIN GROUP is now supported for the STRING_AGG function. (CTP 1.1)
- new system views: sys.dm_db_log_stats - sys.dm_tran_version_store_space_usage - sys.dm_db_log_info -sys.dm_db_stats_histogram - dm_os_host_info
- TRIM function > https://learn.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql

Martijn Tonies

2023-05-16 11:29

administrator   ~0000584

Last edited: 2023-07-20 14:39

https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2019

- new management functions
  - https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-query-plan-stats-transact-sql?view=sql-server-ver15
  - https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-page-info-transact-sql?view=sql-server-ver15
- graph edge constraints > https://learn.microsoft.com/en-us/sql/relational-databases/tables/graph-edge-constraints?view=sql-server-ver15
- Unicode support > https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-ver15
- new function APPROX_COUNT_DISTINCT > https://learn.microsoft.com/en-us/sql/t-sql/functions/approx-count-distinct-transact-sql?view=sql-server-ver15

Martijn Tonies

2023-05-16 11:33

administrator   ~0000585

Last edited: 2023-07-19 10:44

https://learn.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-2022

- 2 new functions APPROX_PERCENTILE_CONT & APPROX_PERCENTILE_DISC > https://learn.microsoft.com/en-us/sql/t-sql/functions/approx-percentile-cont-transact-sql?view=sql-server-ver15
- time series functions > https://learn.microsoft.com/en-us/sql/t-sql/functions/generate-series-transact-sql & https://learn.microsoft.com/en-us/sql/t-sql/functions/date-bucket-transact-sql
- Ledger table > https://learn.microsoft.com/en-us/sql/relational-databases/security/ledger/ledger-overview?view=sql-server-ver16
- new server roles > https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-ver16#fixed-server-level-roles-introduced-in-sql-server-2022
- new permissions > https://techcommunity.microsoft.com/t5/sql-server-blog/new-granular-permissions-for-sql-server-2022-and-azure-sql-to/ba-p/3607507
- new functions
  - GREATEST > https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-greatest-transact-sql?view=azure-sqldw-latest&viewFallbackFrom=sql-server-ver15
  - LEAST > https://learn.microsoft.com/en-us/sql/t-sql/functions/logical-functions-least-transact-sql?view=azure-sqldw-latest&viewFallbackFrom=sql-server-ver15
  - DATETRUNC > https://learn.microsoft.com/en-us/sql/t-sql/functions/datetrunc-transact-sql
  - LEFT_SHIFT, RIGHT_SHIFT, BIT_COUNT, GET_BIT, SET_BIT > https://learn.microsoft.com/en-us/sql/t-sql/functions/get-bit-transact-sql

Issue History

Date Modified Username Field Change
2023-05-11 11:18 Martijn Tonies New Issue
2023-05-11 11:22 Martijn Tonies Note Added: 0000582
2023-05-11 11:29 Martijn Tonies Note Added: 0000583
2023-05-16 11:29 Martijn Tonies Note Added: 0000584
2023-05-16 11:33 Martijn Tonies Note Added: 0000585
2023-05-16 11:34 Martijn Tonies Note Edited: 0000584
2023-05-16 11:38 Martijn Tonies Note Edited: 0000585
2023-05-16 11:38 Martijn Tonies Note Edited: 0000583
2023-05-16 11:39 Martijn Tonies Note Edited: 0000582
2023-05-16 11:40 Martijn Tonies Note Edited: 0000585
2023-05-16 13:20 Martijn Tonies Assigned To => Martijn Tonies
2023-05-16 13:20 Martijn Tonies Status new => assigned
2023-07-19 10:44 Martijn Tonies Note Edited: 0000585
2023-07-20 14:39 Martijn Tonies Note Edited: 0000584
2023-07-20 14:40 Martijn Tonies Status assigned => resolved
2023-07-20 14:40 Martijn Tonies Resolution open => fixed
2023-07-20 14:40 Martijn Tonies Fixed in Version => 6.3.0
2023-08-28 15:21 Martijn Tonies Status resolved => closed