AGENT SKILL

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

  1. Read the collection overview and select ADR, containers, the data hub, Kubernetes, or performance. Read the selected subfolder's README and actual scripts/notebooks.
  2. 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.
  3. Inspect paths, targets, credentials, notebook outputs, and cleanup. Obtain approval before installing tools, provisioning resources, restoring data, changing configuration, or running stress/failure reproductions.
  4. 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.
  5. 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.
  6. 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

microsoft
microsoft/bobsql

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.

数据分析师后端与接口
★ 1
microsoft
microsoft/bobsql

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.

★ 1
microsoft
microsoft/bobsql

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/.

数据分析师测试与质量后端与接口
★ 1
microsoft
microsoft/bobsql

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/.

数据分析师后端与接口
★ 1
microsoft
microsoft/bobsql

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.

★ 1
microsoft
microsoft/bobsql

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.

★ 1