~/talk

Tidy Space, Tidy Mind; How to Better Manage SQL Environments Across Cloud Providers

Talkat SQLBits 2022 · 2022-03-08..03-12· [databases]
name:Lior Asta
links:none on file
slides:none on file

Explains how a single monitoring pipeline across Azure, AWS and GCP surfaces the actual money drains: collects query telemetry from SQL Server, Oracle, MySQL, Postgres, Snowflake, DB2 and MongoDB, computes an impact score to rank optimization candidates, and links straight to the instance and SQL text for tuning. Detects zombie VMs and unused disks, recommends and automates resize actions, and reports projected savings; a new cross‑database “query insight” page ships in about one to two months.

AI-written summary · about

  1. 0:00Tidy space cloud management
  2. 3:17Cloud migration goals challenges
  3. 5:48Economic resource reduction
  4. 8:17Cloud skills expertise gaps
  5. 9:20Multi-platform DB complexity
  6. 10:24Cloud performance tuning cost
  7. 12:54Cost cleanup zombie resources
  8. 15:24Slow SQL queries across clouds
  9. 18:42Azure SQL architecture monitoring
  10. 23:23Azure SQL capacity alerts
  11. 24:26Monitoring multiple DBs with Foglight
  12. 27:47Proactive query performance
  13. 28:53Cross-DB query impact
  14. 31:01Optimizing queries for cost
  15. 33:09Tools for zombie VMs resizing
  16. 37:50Automate unused resource cleanup
  17. 39:14Defining zombie VMs
  18. 41:21Resizing VMs for cost
  19. 42:04Summary cloud transition tips
~/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.