SQL Server

Exporting all tables with BCP

MSSQL on Docker

This will start a container called mssql, on the default port of 1433 while limiting it to 8GB RAM and setting a password for sa.

docker run --name mssql -m 8G -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<password>' -p 1433:1433 -d mcr.microsoft.com/mssql/server

Note you have to accept the EULA by passing 'ACCEPT_EULA=Y' or the container won't start

The container will also shutdown if the sa password you specify doesn't meet the minimum requirements: minimum 8 characters

Viewing all SQL Error Codes & Messages

SELECT * FROM SYSMESSAGES WHERE msglangid='1033' ORDER BY error ASC

How To

Creating a machine account login for SQL Server

Performance and Optimization

Disable Customer Experience Improvement Program

Under Services, stop the SQLTELEMETRY service (SQL Server CEIP service (MSSQLSERVER) service) and set it to Disabled.

Snapshot Isolation

Enable Snapshot Isolation for the database:

Microsoft.Playwright.PlaywrightException: Error: The language "tsql" has no grammar.
    at Object.highlight (http://127.0.0.1:41899/main.js:3978:11)
    at eval (eval at evaluate (:226:30), :2:18)
    at UtilityScript.evaluate (:233:19)
    at UtilityScript. (:1:44)
   at Microsoft.Playwright.Transport.Connection.InnerSendMessageToServerAsync[T](ChannelOwnerBase object, String method, Dictionary`2 dictionary, Boolean keepNulls) in /_/src/Playwright/Transport/Connection.cs:line 209
   at Microsoft.Playwright.Transport.Connection.WrapApiCallAsync[T](Func`1 action, Boolean isInternal) in /_/src/Playwright/Transport/Connection.cs:line 535
   at Microsoft.Playwright.Core.Frame.EvaluateAsync[T](String script, Object arg) in /_/src/Playwright/Core/Frame.cs:line 548
   at SiteGen.Extensions.Markdown.Prism.PrismHost.Highlight(String source, String language)
   at SiteGen.Extensions.Markdown.Prism.PrismCodeBlockRenderer.Write(HtmlRenderer renderer, PrismCodeBlock obj)

Enable Read Committed Snapshot isolation level:

Microsoft.Playwright.PlaywrightException: Error: The language "tsql" has no grammar.
    at Object.highlight (http://127.0.0.1:41899/main.js:3978:11)
    at eval (eval at evaluate (:226:30), :2:18)
    at UtilityScript.evaluate (:233:19)
    at UtilityScript. (:1:44)
   at Microsoft.Playwright.Transport.Connection.InnerSendMessageToServerAsync[T](ChannelOwnerBase object, String method, Dictionary`2 dictionary, Boolean keepNulls) in /_/src/Playwright/Transport/Connection.cs:line 209
   at Microsoft.Playwright.Transport.Connection.WrapApiCallAsync[T](Func`1 action, Boolean isInternal) in /_/src/Playwright/Transport/Connection.cs:line 535
   at Microsoft.Playwright.Core.Frame.EvaluateAsync[T](String script, Object arg) in /_/src/Playwright/Core/Frame.cs:line 548
   at SiteGen.Extensions.Markdown.Prism.PrismHost.Highlight(String source, String language)
   at SiteGen.Extensions.Markdown.Prism.PrismCodeBlockRenderer.Write(HtmlRenderer renderer, PrismCodeBlock obj)