sqlserver2022
Select and run SQL Server 2022 feature demos: IQP, Azure Arc, Entra authentication, contained AGs, MI link, Fabric/Synapse integration, ledger, S3, Parquet/Delta, containers, Kubernetes, tempdb, and T-SQL. Use for examples/sqlserver2022.
- License 许可
- MIT
- 所属仓库
- microsoft/bobsql
- 最近更新
- 2026-11-11
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- sqlserver2022
- description
- Select and run SQL Server 2022 feature demos: IQP, Azure Arc, Entra authentication, contained AGs, MI link, Fabric/Synapse integration, ledger, S3, Parquet/Delta, containers, Kubernetes, tempdb, and T-SQL. Use for examples/sqlserver2022.
03 SKILL.md 正文
SQL Server 2022 demonstration collection
Procedure
- Read the collection catalog and select one area. Use its local README and actual files, not a guessed script order or an obsolete folder name.
- Verify SQL Server 2022 edition/build, compatibility level, sample database, permissions, and client tools. For integrations, independently verify current Azure/service support, accounts, storage, and network prerequisites.
- Inspect scripts/manifests for endpoints, paths, and private configuration. Supply runtime credentials following secret setup, including SQLCMD mode where script headers require it. Never suppress findings.
- Present the target and operational impact. Require approval before creating Azure resources, exposing services, changing identity/HA configuration, restoring data, applying Kubernetes manifests, or generating heavy load.
- Run the selected walkthrough in its numeric/session order. Validate actual plans, feedback, data access, container/pod state, or integration evidence relevant to that demo. Treat captured examples as illustrative, not expected measurements.
- Follow the area's teardown and verify its scope before deleting cloud resources, databases, containers, volumes, or persistent storage.
Boundaries
This collection has no universal build. Kubernetes restart labs do not establish an availability-group guarantee. Parquet/Delta files are supporting data, not code; preserve metadata and inspect publication suitability separately. Follow secret checks.
04 同仓库更多 Skills
sql-versioning-apps
Launch, run, review, rehearse, test, or update the local SQL versioning click-through apps in examples/sqlversioning/apps. Use when the user says run the app, start the app, open the app, demo apps, browser demos, SQL versioning visuals, or asks about the Cowboys-themed demo pages. In this repository, running the app means opening a NEW normal external browser window, not the VS Code integrated browser.
shift-handoff
Find the patients who most need a shift handoff, and prepare a structured SBAR handoff for one named patient — grounded entirely in that patient's live chart — for the clinician to review and save.
nvidianim
NVIDIA NIM on AKS with GPU — vector embeddings and chat completions from SQL Server 2025 T-SQL using GPU-accelerated inference. Use when: deploying NIM containers on AKS, creating AKS GPU node pools, testing NIM endpoints, creating external models for NIM embeddings, Azure Local edge AI pattern, working in nvidianim/.
zavahospital
ZavaHospital – AI-powered inpatient clinical assistant using SQL Server 2025 vector search + NVIDIA NIM on AKS. Use when: deploying zavahospital scripts, building encounter embeddings, running vector search procs, generating clinical recommendations via NIM chat, creating doctor notes search, working in zavahealth/sqlserver2025/zavahospital/.
wardgeneral
Guide the cumulative Ward General Hospital Azure SQL Hyperscale demo: provision/schema, architecture, .NET 10 Blazor app, SQL AI, agentic shift handoff, security/RLS, observability, failover/PITR/geo, scaling, and tuning. Use for examples/wardgeneral.
waits-latches-spinlocks
Investigate SQL Server waits, scheduler yield, buffer latches, LOCK_HASH spinlocks, and Azure SQL log governance. Use when working with examples/insidewaitslatchesspinlocks and its debugwaits, latches, spinlocks, or loggovernance areas.