~/talks

Ajay Jagannathan

what they talk about

where they keep going back

on a stage with

all 5 in the filters

who talks about the same things

titleconferencedate
Hidden Gems in SQL Server 2022 Database EngineSQLBits 20242024-03-19
Demo-heavy tour of small fixes that deliver big wins: handsfree tempdb removes PFS/GAM/system-table latch contention so a single tempdb file runs with no…
Talk on
Data tiering using data Virtualization in SQLSQLBits 20242024-03-19
SQL Server shows a working data-virtualization stack: PolyBase V3 runs natively in the engine with a REST/S3 object-storage connector, supports Parquet/CSV…
Talk on
Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiSQLBits 20242024-03-19
Covers concrete engine features and demos: metadata versioning (Azure private preview) lets snapshot reads continue while ALTER TABLE runs by using…
Talk on
Making the SQL Query Processor Work for youSQLBits 20242024-03-19
Upgrading a database’s compatibility level 160 (SQL 2022) often reduces CPU and duration versus 130 without code changes, because the engine applies persisted…
Talk on
Analytics in SQL Server and Azure SQL DatabaseSQLBits 20232023-03-14
Covers concrete features and demos: in-memory OLTP plus clustered/nonclustered columnstore enable mixed transactional/analytical workloads; a simulated IoT…
Talk on
SQL Server 2022 - the most Azure-enabled SQL Server yetSQLBits 20232023-03-14
Managed Instance Link creates a DR/migration path that seeds on‑prem SQL Server 2022 to Azure Managed Instance, supports read replicas and planned…
Talk on
Next Level Scalability on SQL Server 2022SQLBits 20232023-03-14
SQL Server 2022 removes major tempdb choke points by turning GAM/SGAM update latches into shared latches so high-concurrency workloads stop producing the giant…
Talk on
Hidden Gems in SQL Server 2022 Database EngineSQLBits 20222022-03-08
Demo-heavy session that shows concrete fixes and numbers: handsfree tempdb removes most latch contention so a 25-thread stress test falls from 19–28s down to…
Talk on
Making the SQL Query Processor Work for youSQLBits 20222022-03-08
Upgrade to compatibility level 160 to get automatic QP innovations; SQL 2022 turns Query Store on by default for new databases and persists feedback there. Use…
Talk on
Data tiering using data Virtualization in SQLSQLBits 20222022-03-08
SQL Server uses PolyBase to query external files and databases without copying data, now shipping a native PolyBase V3 REST architecture in SQL Server 2022 and…
Talk on
Achieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiSQLBits 20222022-03-08
Shows concrete engine features: metadata versioning (allows DDL and snapshot reads to run concurrently, currently in Azure preview for ALTER TABLE), optimized…
Talk on
~/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.