~/talks

Bob Pusateri

what they talk about

where they keep going back

on a stage with

never shared a talk

who talks about the same things

titleconferencedate
Relational or Non-Relational? Choosing the Best Database for the TaskSQLBits 20242024-03-19
Compares relational versus non-relational with concrete examples: a URL redirection system built on Cosmos DB using the document model and userID as partition…
Talk on
Maximizing Database Performance With Isolation LevelsSQLBits 20242024-03-19
Shows isolation levels on SQL Server and Azure SQL DB using a 41,437-row ZIP code demo, Extended Events and dbcc user options to prove behavior. WITH (NOLOCK)…
Talk on
Relational or Non-Relational? Choosing the Best Database for the TaskSQLBits 20242024-03-19
Compares relational vs non-relational with concrete rules and examples: shows a working URL-redirect implemented in Azure Cosmos DB, explains partitioning on a…
Talk on
Maximizing Database Performance With Isolation LevelsSQLBits 20222022-03-08
Covers SQL Server and Azure SQL isolation levels with concrete demos: a 41,437-row ZIP code table, 5,000 updates repeatedly moving rows while another session…
Talk on
Relational or Non-Relational? Choosing the Best Database for the TaskSQLBits 20222022-03-08
Compares relational ACID tradeoffs with NoSQL BASE and shows concrete choices: uses Azure Cosmos DB document model to build a URL redirection service (zombocom…
Talk on
Relational or Non-Relational? Choosing the Best Database for the TaskSQLBits 20222022-03-08
Clear rule set: use relational when you need strict ACID transactions and normalized data; avoid relational for logs, images, large text or BLOBs and instead…
Talk on
Relational or Non-Relational? Choosing the Best Database for the TaskSQLBits 20192019-02-27
Compares relational rules (normal forms, ACID) against NoSQL tradeoffs with concrete guidance: avoid storing logs, images or huge free text in RDBMS; avoid…
Talk on
Maximizing Database Performance With Isolation LevelsSQLBits 20192019-02-27
Walks through concrete tests on SQL Server and Azure SQL Database using a 41,437-row US ZIP table, extended events, sys.dm_tran_locks and ALTER DATABASE…
Talk on
Relational or Non-Relational? Choosing the Best Database for the TaskSQLBits 20192019-02-27
Compares relational vs non-relational with concrete rules: a redirect service is implemented in Azure Cosmos DB using the document model and userId partition…
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.