sql-docs

sql-docs copied to clipboard

Update contained-availability-groups-overview.md

3

Suggestion following a CSS engagement. Customer pushed his database on contained AG which blocked his production for some time before they understood they needed to recreate the logins. Adding explicit...

ccarozzoMSFT

Update predict-transact-sql.md

4

PREDICT is off by default in Azure Synapse Analytics Add annotation The following syntax error occurs Incorrect syntax near '='. 

komorita000

New format file options

4

Added new parameter options, which are supported in SQL 2022 and included in new examples already in this document

way0utwest

Removing duplicate info box

3

Seems some merge gone wrong so the info box is displayed twice. Not sure which to keep, but "cached" sounds better in my ears

siggemannen

Fix installing-the-microsoft-odbc-driver-for-sql-server.md: key verification debian 12

3

apt changed the way it verified signature thx to Philip Z (https://learn.microsoft.com/en-us/answers/questions/1328834/debian-12-public-key-is-not-available)

S7uX

Update declare-cursor-transact-sql.md

4

Reflect that STATIC OPTIMISTIC is converted to STATIC READ_ONLY without warning.

HugoKornelis

Update sql-server-deadlocks-guide.md

4

adding information about how to handle deadlock error using try/catch block (see https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2005/ms179296(v=sql.90)?redirectedfrom=MSDN#working-with-trycatch) @microsoft-github-policy-service agree

OleksiiKovalov

Update sql-server-linux-performance-best-practices.md

6

Add a note for open file limitation. This setting do not apply to systemd services. Most Linux dist now have hard limit of nofile at least 1048576. There is no...

bangjiehan

Update sp-executesql-transact-sql.md

4

There are way more than 12 statements generated. You get one statement for each year and month combination for each language where the first 3 characters of the month name...

bpd0018

Update authentication-aad-configure.md

6

This pull request includes a small change to the `azure-sql/database/authentication-aad-configure.md` file. The change advises associating the Microsoft Entra admin ID with an Entra Group for better management. * [`azure-sql/database/authentication-aad-configure.md`](diffhunk://#diff-ea96a7646503bd8e08fec3959d7ae89454311fe65708aff399818d979324039eR83-R84): Added...

JFolberth