sql-by-example
Guide the SQL Server By Example collection: SQL Server 2019 ADR, containers, Kubernetes, PolyBase data-hub connectors, query processing, and lightweight profiling. Use when working with examples/sqlbyexample or choosing one of its bundled walkthroughs.
- License 许可
- MIT
- 所属仓库
- microsoft/bobsql
- 最近更新
- 2026-11-11
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- sql-by-example
- description
- Guide the SQL Server By Example collection: SQL Server 2019 ADR, containers, Kubernetes, PolyBase data-hub connectors, query processing, and lightweight profiling. Use when working with examples/sqlbyexample or choosing one of its bundled walkthroughs.
03 SKILL.md 正文
SQL Server By Example
Procedure
- Read the collection overview and select ADR, containers, the data hub, Kubernetes, or performance. Read the selected subfolder's README and actual scripts/notebooks.
- Verify the historical SQL version/build, edition, sample database, tools, and connector requirements. Check current compatibility before using an old container tag, Kubernetes manifest, driver, or external service endpoint.
- Inspect paths, targets, credentials, notebook outputs, and cleanup. Obtain approval before installing tools, provisioning resources, restoring data, changing configuration, or running stress/failure reproductions.
- Execute the chosen walkthrough in numeric/session order on a disposable lab. Validate its specific result: recovery, container state, external joins, query-plan behavior, or live profiling evidence.
- Distinguish captured notebook output from current measurements. Use synthetic data and privately supplied connection settings; inherited credential examples must not be published as working configuration.
- Stop lab processes, close transactions, and follow the selected teardown with approval before removing databases, containers, or persistent storage.
This collection retains its own sqlperf/iqp material. It does not import the
separate demos/sqlserver/iqp collection. Follow
secret checks before publishing.
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.