sql-server-2022

"SQL Server 2022 as the primary database on Linux via the official container: connection, schema conventions, indexing, and T-SQL style."

DonArtkins 0 Updated 4d ago

Install

npx skillscat add donartkins/griot/sql-server-2022

Install via the SkillsCat registry.

SKILL.md

mcr.microsoft.com/mssql/server:2022-latest on host port 14333; data in mssql_data volume (infra owns the compose file).

docker exec gtp-sqlserver /opt/mssql-tools18/bin/sqlcmd -S localhost -U sa -P "$GTP_SA_PASSWORD" -C -Q "SELECT @@VERSION"

dbo schema; PascalCase names matching entities; nvarchar(max) bodies; UNIQUEIDENTIFIER PKs; SYSUTCDATETIME() timestamps.
Index every FK; composite indexes for board reads and the dashboard query.
Procs: usp_ prefix, NOCOUNT ON, fully parameterized (OWASP line).
T-SQL versioned in .sql files under Griot.Infrastructure/Sql/.

Table list matches the ERD; the dashboard query plan is single-pass without object scans.