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 para a instalação Revisar arquivos

Repositório: microsoft/bobsql
Última atividade na origem: 28 de julho de 2026 às 22:44
Idioma detectado do SKILL.md: inglês
Estrelas: 325
Forks: 172

Opções de instalação

Por padrão, está selecionado o prompt que primeiro revisa a origem. Você pode mudar para um comando direto ou baixar uma cópia local.

Instalar com um assistente de IA

Copie este prompt para o assistente de IA que você usa.

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.

Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.

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

O comando permanece em uma só linha. Role horizontalmente para revisá-lo antes de copiar.

Prefere uma cópia local? Baixe os arquivos disponíveis atualmente no SkillsMP.

Revise os arquivos de origem

Leia o SKILL.md e os arquivos complementares exibidos pelo SkillsMP antes de decidir se vai instalar.

SKILL.md

Instruções da origem · Visualização somente leitura

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 no GitHub

Voltar à pesquisa Voltar à instalação

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 todas deste repositório

sqlsim

Informações da origem

Opções de instalação

Instalar com um assistente de IA

Revise os arquivos de origem

Mais deste repositório

Instalar com um assistente de IA

Mais deste repositório