sqlsim

Run SQL scripts and ad-hoc queries against the Ward General Azure SQL Hyperscale database (and any SQL Server / Azure SQL) for the hyperscale-developer talk, using the sqlsim.exe bundled in this kit. Use when: deploying the sql/ scripts, running a quick query against wardgeneral, connection testing, or driving a multi-threaded / scale workload. Full Microsoft Entra support (token, interactive, managed identity) — the passwordless path that works when sqlcmd -G fails.

跳到安装

仓库: microsoft/bobsql
最近来源活动: 2026年7月28日 22:44
检测到的 SKILL.md 语言: 英语
星标: 317
分支: 170

安装方式

默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。

用 Codex 或 Claude 帮你安装复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。

直接命令不会经过审查 Prompt；运行前请先检查来源。

npx skills add https://github.com/microsoft/bobsql --skill sqlsim

命令会保持在同一行。复制前请横向滚动并检查完整内容。

想先保存到本地？可下载 SkillsMP 当前能够提供的文件。

检查来源文件

决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。

SKILL.md

来源说明 · 只读预览

返回搜索返回安装

build-appdev-demo

Provision, repair, verify or tear down the Azure environment for DATACON 2026 Demo 5 — "the database is the event producer" (Azure SQL Hyperscale + Change Event Streaming → Event Hubs → two Azure Functions → SignalR → browser, with a Microsoft Foundry agent triaging each ticket). USE WHEN the presenter says any of: "build the app dev demo", "build demo 5", "provision the ticket stream demo", "set up the change event streaming demo", "deploy demo 5 on this machine", "rebuild demo 5", "the agent verdict never shows up", "05-verify passes but the agent does nothing", "redeploy the function app", "re-run the model bake-off", "move demo 5 to another region", "tear down demo 5", or moves this talk to a new laptop and needs Event Hubs + SignalR + the Entra-only Hyperscale server + CES + the function app + the Foundry agent in place. Scope is PROVISION + CONFIGURE + VERIFY + TEARDOWN ONLY. Do NOT use to present or rehearse the beats (that's run-appdev-demo), to build the Private Link demo 3 environment (that's build-

2026-08-24

build-privatelink-demo

Provision, rename, re-region, verify or tear down the Azure environment for DATACON 2026 Demo 3 — "the control plane is the security perimeter" (Private Link + Entra-only Azure SQL Hyperscale + a client VM whose managed identity is the server admin). USE WHEN the presenter says any of: "build the private link demo", "provision demo 3", "set up the control plane demo", "deploy the privatelink demo on this machine", "rebuild demo 3", "move demo 3 to another region", "rename the demo 3 server", "the VM got deallocated, redeploy it", "run pre-flight for demo 3", "why is 05-verify failing", "tear down demo 3", or moves this talk to a new laptop and needs the VNet + VM + Entra-only server + demo kit in place. Scope is PROVISION + CONFIGURE + VERIFY + TEARDOWN ONLY. Do NOT use to present or rehearse the five beats (that's run-privatelink-demo), to build the Adventure Works / SQL MCP kit, or to deploy the Ward General hyperscale talk — those are separate.

2026-08-24

run-appdev-demo

Drive the live three-beat app-dev demo for DATACON 2026, "Why Azure Is the Best Cloud for SQL" — Demo 5, the database is the event producer (one INSERT into Azure SQL Hyperscale → Change Event Streaming → Event Hubs → two Azure Functions racing on separate consumer groups → SignalR → a live browser, with a Microsoft Foundry agent triaging the ticket). USE WHEN the presenter says any of: "let's run demo 5", "start the app dev demo", "run the ticket stream demo", "let's do the change event streaming demo", "walk me through demo 5", "next beat", "rehearse demo 5", "pre-flight demo 5", "is demo 5 ready", "reset the ticket demo", "fire another ticket", "what do I say when the card appears", "the agent verdict is slow, is that normal", or wants step-by-step help presenting this arc on stage. Scope is RUN / REHEARSE / RESET the beats ONLY. Do NOT use to provision, redeploy or tear down the environment (that's build-appdev-demo), to run the Private Link demo 3 beats (that's run-privatelink-demo), or to run the Advent

2026-08-24

查看这个仓库的全部 Skills

name

sqlsim

description

sqlsim — bundled SQL runner for the hyperscale-developer talk

This kit ships its own copy of sqlsim.exe so the whole presentation folder is self-contained (the tool's source repo is not public). It is a standalone, xcopy-deploy executable — the only dependency is ODBC Driver 18 for SQL Server.

Use this instead of sqlcmd -G (Entra-integrated sqlcmd fails on some machines with "unknown error"). sqlsim's token path is the reliable passwordless option.

Path (relative to the presentation root)

.\utilities\sqlsim\sqlsim.exe

Run commands from presentations/hyperscale-developer/, or substitute the full path.

Live talk environment

Server: collierhealth-17.database.windows.net
Database: wardgeneral (Hyperscale HS_Gen5_8)
Auth: Microsoft Entra as bobward@microsoft.com

Entra authentication (choose one)

-T <token> — Azure access token (most reliable; see example below)
-A — Entra interactive (ActiveDirectoryInteractive, default)
-A ActiveDirectoryMsi — managed identity (e.g. from App Service)
-E — Windows integrated (local SQL Server only)

Common commands

# Ad-hoc query against wardgeneral via Entra token (the reliable path)
$token = (az account get-access-token --resource https://database.windows.net/ --query accessToken -o tsv)
& '.\utilities\sqlsim\sqlsim.exe' -S collierhealth-17.database.windows.net -d wardgeneral -T $token -Q "SELECT @@VERSION"

# Deploy a schema/seed script (GO batch separators handled natively)
& '.\utilities\sqlsim\sqlsim.exe' -S collierhealth-17.database.windows.net -d wardgeneral -T $token -i .\build\sql\05-seed.sql

# Entra interactive (no token needed, pops a browser)
& '.\utilities\sqlsim\sqlsim.exe' -S collierhealth-17.database.windows.net -d wardgeneral -A -Q "SELECT DB_NAME()"

# Multi-threaded scale workload: 16 threads x 100 iterations, quiet, with server stats
& '.\utilities\sqlsim\sqlsim.exe' -S collierhealth-17.database.windows.net -d wardgeneral -T $token -i .\workload.sql -n 16 -r 100 -q -querystats

Notes

-q quiet (metrics only), -v verbose, -json machine-readable, -o <file> tee output.
-R read-only intent (route to an HA secondary) — for the "Make it HA" beat.
-Q, -i, and -workload are mutually exclusive query sources.
Exit code 0 = success, 1 = error.

Full parameter reference lives next to the binary: utilities/sqlsim/sqlsim-usage.md.

sqlsim

来源信息

安装方式

检查来源文件

同仓库更多 Skills

同仓库更多 Skills

sqlsim — bundled SQL runner for the hyperscale-developer talk

Path (relative to the presentation root)

Live talk environment

Entra authentication (choose one)

Common commands

Notes

sqlsim — bundled SQL runner for the hyperscale-developer talk

Path (relative to the presentation root)

Live talk environment

Entra authentication (choose one)

Common commands

Notes