| (1) Expanded definitions and updated for SQL Server 2017 |
1. COLLATIONPROPERTY |
161 |
2017-10-15 |
2017-10-18 |
(2) Changes related to new Collations added in
SQL Server 2017 |
1. What’s new in Database Engine
– SQL Server 2017
2. Collation and Unicode Support
3. COLLATIONPROPERTY |
175 |
2017-10-25 |
2017-10-31 |
| (3) Make titles (and their formatting) consistent |
40 files modified, too many
to list here |
211 |
2017-11-09 |
2017-11-16 |
| (4) Correct false statements re: “Backslash” and fix title |
1. Backslash (Line Continuation) |
212 |
2017-11-09 |
2017-11-15 |
| (5) Correct and improve HAVING clause |
1. SELECT – HAVING |
235 |
2017-11-28 |
2017-12-06 |
| (6) Improve ALTER SCHEMA, sp_rename, and sys.sql_modules |
1. sys.sql_modules
2. sp_rename
3. ALTER SCHEMA |
335 |
2018-01-10 |
2018-01-17 |
| (7) Fix “Search Condition” note about code page conversions |
1. Search Condition |
343 |
2018-01-15 |
2018-01-17 |
| (8) Fix sys.column_store_segments |
1. sys.column_store_segments |
344 |
2018-01-16 |
2018-01-17 |
| (9) Improve “See also” sections for string functions |
32 files modified, too many
to list here |
346 |
2018-01-16 |
2018-01-17 |
| (10) Improve SERVER AUDIT filtering |
1. CREATE SERVER AUDIT
1. sys.fn_get_audit_file |
363 |
2018-01-23 |
2018-01-25 |
| (11) Fix technical inaccuracies in DBCC CHECKIDENT doc |
1. DBCC CHECKIDENT |
1602 |
2019-01-31 |
2019-03-08 |
| (12) Collation improvements: Part 1 of several |
1. Windows Collation Name
2. COLLATIONPROPERTY |
1727 |
2019-03-06 |
2019-03-07 |
(13) Added missing [internal_type] and [internal_type_desc]
values for “sys.internal_tables” |
1. sys.internal_tables |
1784 |
2019-03-14 |
2019-04-11 |
(14) Fix missing / misleading statements, and formatting in
CREATE and ALTER CERTIFICATE |
1. CREATE CERTIFICATE
2. ALTER CERTIFICATE |
1972 |
2019-04-23 |
2019-04-24 |
(15) Fix missing / misleading statements, and formatting in
BACKUP CERTIFICATE |
1. BACKUP CERTIFICATE |
1976 |
2019-04-23 |
2019-04-25 |
| (16) Improve accuracy for Table Value Constructor |
1. Table Value Constructor |
2115 |
2019-05-10 |
2019-05-23 |
(17) Please move DATABASE_PRINCIPAL_ID from “Metadata”
to “Security” in left nav / TOC |
1. DATABASE_PRINCIPAL_ID |
2188 |
2019-05-22 |
2019-06-04 |
| (18) Add missing page for USER_SID built-in security function |
1. USER_SID (missing) |
2190 |
2019-05-22 |
(pending) |
| (19) clean up CREATE ASYMMETRIC KEY |
1. CREATE ASYMMETRIC KEY |
2200 |
2019-05-23 |
2019-05-28 |
(20) Update conversion notes in “decimal and numeric” and
“float and real” pages |
1. decimal and numeric
2. float and real |
2951 |
2019-09-10 |
2019-09-26 |
(21) Minor fixes for 2 pages related to “clr enabled”
server config option |
1. CLR Integration – Enabling
2. clr enabled Server
Configuration Option |
2999 |
2019-09-17 |
2019-09-26 |
(22) Fix datatype in “Serialization Encoding” section of
“Serialization of XML Data” |
1. Define the Serialization of
XML Data |
3605 |
2019-11-15 |
2019-11-15 |
(23) Fix “Constant Folding” info in “Query Processing
Architecture Guide” |
1. Query Processing
Architecture Guide |
3698 |
2019-11-26 |
2020-02-26 |
| (24) Fix User vs Login for granting exec to “xp_cmdshell” |
1. xp_cmdshell |
3720 |
2019-12-01 |
2019-12-02 |
(25) Is sp_changedbowner deprecated or not? |
1. sp_changedbowner
2. Features deprecated in
a future version of SQL
Server (SQL Server 2017) |
Issue
3989 |
2020-01-19 |
2020-01-21 |
(26) Is sp_change_users_login deprecated? |
1. sp_change_users_login |
Issue
3990 |
2020-01-19 |
2020-03-16 |
(27) Should sp_changedbowner be replaced
with ALTER AUTHORIZATION? |
1. CREATE DATABASE |
Issue
3991 |
2020-01-19 |
2020-03-16 |
(28) Add missing datatypes + variations to
SQL_VARIANT_PROPERTY |
1. SQL_VARIANT_PROPERTY |
4218 |
2020-02-26 |
2020-04-01 |
| (29) Fix "READONLY" definition for CREATE FUNCTION |
1. CREATE FUNCTION |
4224 |
2020-02-26 |
2020-02-26 |
| (30) Fix both lists of "Supported .NET Framework Libraries" |
1. Supported .NET
Framework Libraries
2. Assemblies – Designing |
4638 |
2020-04-24 |
2020-04-28 |
| (31) Improvements to "Set or Change the Server Collation" |
1. Set or Change the
Server Collation |
4747 |
2020-05-11 |
2020-06-02 |
| (32) Is JSON a valid EXTERNAL FILE FORMAT? |
1. CREATE EXTERNAL
FILE FORMAT |
Issue
4916 |
2020-06-05 |
2020-06-26 |
| (33) Formatting fixes for "Manage Trigger Security" |
1. Manage Trigger
Security |
5026 |
2020-06-22 |
2020-07-02 |
(34) Logon Triggers: this is not the triggers overview
page you are looking for 🙃 |
1. Logon Triggers |
Issue
5027 |
2020-06-22 |
2020-06-30 |
(35) Syntax and deprecation clarification improvements
for "SELECT – GROUP BY" |
1. GROUP BY |
Issue
5208 |
2020-07-20 |
2021-10-12 |
| (36) Add missing property and datatypes for SERVERPROPERTY |
1. SERVERPROPERTY |
5261 |
2020-07-29 |
2020-08-05 |
(37) What exactly does "SQL Server 2019 does not
deprecate any features" mean? |
1. Deprecated database
engine features in
SQL Server 2019 |
Issue
5940 |
2021-01-21 |
2021-02-12 |
| (38) Add missing installation source for Express LocalDB |
1. SQL Server Express LocalDB |
6273 |
2021-04-09 |
2021-07-14 |
(39) Fix incorrect version, etc in "Collation
and Unicode support" |
1. Collation and Unicode
support |
6657 |
2021-08-02 |
🤷 |
(40) Mysterious sp_batch_params is in the documentation (and
SSMS IntelliSense), yet does not appear to be in SQL Server |
1. sp_batch_params |
Issue
6946 |
2021-10-18 |
🤷 |
