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