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.

Zur Installation springen Dateien prüfen

Repository: microsoft/bobsql
Letzte Quellaktivität: 28. Juli 2026 um 22:44
Erkannte Sprache von SKILL.md: Englisch
Sterne: 325
Forks: 172

Installationsoptionen

Standardmäßig ist der Prompt ausgewählt, der zuerst die Quelle prüft. Sie können zu einem direkten Befehl wechseln oder eine lokale Kopie herunterladen.

Mit einem KI-Assistenten installieren

Diesen Prompt kopieren und in den verwendeten KI-Assistenten einfügen.

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.

Ein direkter Befehl überspringt den Prüf-Prompt. Prüfen Sie die Quelle, bevor Sie ihn ausführen.

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

Der Befehl bleibt in einer Zeile. Scrollen Sie horizontal, um ihn vor dem Kopieren vollständig zu prüfen.

Sie bevorzugen eine lokale Kopie? Laden Sie die Dateien herunter, die SkillsMP derzeit vorliegen.

Quelldateien prüfen

Lesen Sie SKILL.md und alle von SkillsMP angezeigten Begleitdateien, bevor Sie sich für eine Installation entscheiden.

SKILL.md

Quellanweisungen · Schreibgeschützte Vorschau

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

Auf GitHub ansehen

Zurück zur Suche Zurück zur 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

Alle aus diesem Repository ansehen

sqlsim

Quellinformationen

Installationsoptionen

Mit einem KI-Assistenten installieren

Quelldateien prüfen

Mehr aus diesem Repository

Mit einem KI-Assistenten installieren

Mehr aus diesem Repository