~/talk

From the Classroom to the Boardroom – Azure SQL DB through Demos

on YouTube 49m
Talkat SQLBits 2023 · 2023-03-14..03-18· [databases]

speakers

name:Silvano Coriani
github:scoriani
name:Sanjay Mishra
links:none on file

resources

video:https://youtu.be/jx3aFXWdycM
slides:none on file

summary

Live demos show a local Azure SQL DB emulator, VS Code SQL projects (SDK style) and a CLI-first tool Data API Builder that turns tables into REST/GraphQL endpoints with AAD role tokens; JSON helpers (ISJSON, JSON_PATH_EXISTS, JSON_ARRAY) parse and map payloads into columns. CI/CD uses GitHub Actions to publish SQL projects. Hyperscale with serverless read replicas sustains peaks—observed ~22,000 TPS and ~40,000 batch requests per second—and temporal history uses an in-memory ingest table plus temporal history + columnstore for Power BI direct query offload to geo replicas.

AI-written summary · about

chapters (8)

  1. 0:00Classroom to boardroom
  2. 1:04Student dev with Azure SQL DB
  3. 6:47Building APIs with Data API Builder
  4. 18:08JSON in Azure SQL DB
  5. 24:12DevOps for SQL projects
  6. 33:46Scaling with Hyperscale and Serverless
  7. 41:09Analytics for boardroom
  8. 48:11Q&A

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.