AGENT SKILL

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.

License 许可
MIT
所属仓库
microsoft/bobsql
最近更新
2026-11-11
Stars
★ 1
Forks
0

01 前言 Front Matter

name
wardgeneral
description
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.

03 SKILL.md 正文

Ward General cumulative application

Procedure

  1. Start with the collection map. Identify the requested area and read its README, scripts, and prerequisites. The database and application carry forward; do not scaffold a replacement.
  2. Verify subscription, identity, target database/replicas, PowerShell/Azure CLI tooling, and prior-stage readiness. The app requires .NET 10 and lives in first-app/src.
  3. If setup is missing, follow Getting Started's reviewed provisioning, replica, schema, seed, and verification stages. Get approval for billable resources, role/firewall changes, database writes, or tool installation.
  4. For application or AI work, preserve the shared data/retry layer, Entra authentication, replica routing, and documented feature flags. Enable AI features only after their SQL/models/DAB prerequisites are verified.
  5. Distinguish observation from mutation. Architecture/observability evidence does not authorize tuning, scaling, failover, recovery, geo-replication, or security-policy changes. Use the owning area's preview and approval gates.
  6. Verify the requested outcome with that area's SQL, application, plan, retry, audit, or resource evidence. Treat previous validation dates and captured results as historical, not certification of the current deployment.
  7. End workload/probe processes and follow only the approved, area-owned cleanup. Never delete the shared database as routine per-area cleanup.

Scope and safety

Use synthetic data only. Preserve the runtime shift-handoff skill's grounding and save-approval requirements; it is not the same as this workspace skill. Inherited references to optional granular skills/figures may not be bundled: use the actual area scripts and report missing prerequisites explicitly. 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

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
microsoft
microsoft/bobsql

waits-latches-spinlocks-workshop

Guide the numbered Inside Waits, Latches, and Spinlocks workshop: WinDbg basics, blocking, scheduler yield, preemptive waits, threadpool exhaustion, log governance, latches, and spinlocks. Use for examples/insidewaitslatchesspinlocks_workshop.

★ 1