View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002136Database Workbench v6Microsoft SQL Server Modulepublic2023-05-11 11:182023-05-16 13:20
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityfeatureReproducibilityhave not tried
Status assignedResolutionopen 
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-05-16 11:34

 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
- Java library support > https://learn.microsoft.com/en-us/sql/language-extensions/how-to/call-java-from-sql?view=sql-server-ver15 & https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-language-transact-sql?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-05-16 11:40

 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
- 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