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.

Jump to install Review files

Repository: microsoft/bobsql
Last source activity: July 28, 2026 at 22:44
Detected SKILL.md language: English
Stars: 325
Forks: 172

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with an AI assistant

Copy this prompt into the AI assistant you're using.

Follow https://skillsmp.com/skill-install/prompt.md to install only the Agent Skill at https://github.com/microsoft/bobsql/tree/master/hyperscale-developer/.github/skills/sqlsim.

A direct command skips the review prompt. Inspect the source before running it.

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

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

SKILL.md

Source instructions · Read-only preview

name: sqlsim
description: 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.

# 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 ```powershell # 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`.

View on GitHub

Back to search Back to installation

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

View all from this repository

sqlsim

Source facts

Install options

Install with an AI assistant

Review the source files

More from this repository

Install with an AI assistant

More from this repository