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.

Ir a la instalación Revisar archivos

Repositorio: microsoft/bobsql
Última actividad en el origen: 28 de julio de 2026 a las 22:44
Idioma detectado de SKILL.md: inglés
Estrellas: 325
Forks: 172

Opciones de instalación

De forma predeterminada está seleccionado el prompt que primero revisa el origen. Puedes cambiar a un comando directo o descargar una copia local.

Instalar con un asistente de IA

Copia este prompt en el asistente de IA que estés usando.

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.

Un comando directo omite el prompt de revisión. Revisa el origen antes de ejecutarlo.

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

El comando permanece en una sola línea. Desplázate horizontalmente para revisarlo antes de copiarlo.

¿Prefieres una copia local? Descarga los archivos que SkillsMP tiene disponibles ahora.

Revisa los archivos de origen

Lee SKILL.md y los archivos complementarios que muestra SkillsMP antes de decidir si quieres instalarlo.

SKILL.md

Instrucciones de origen · Vista previa de solo lectura

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

Ver en GitHub

Volver a la búsqueda Volver a la instalación

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

Ver todos los de este repositorio

sqlsim

Datos de origen

Opciones de instalación

Instalar con un asistente de IA

Revisa los archivos de origen

Más de este repositorio

Instalar con un asistente de IA

Más de este repositorio