Browse my presentations from user groups, SQL Saturdays, conferences and other events. Select a presentation to see its abstract, where it has been presented, and a download. Presentations are available on GitHub, and you can also view my sessions on
. If you have questions or want a session for your event, please reach out!
How to Migrate from SQL Server to Postgres
Moving a database is more than moving data. Learn how to translate data types, tables, keys, indexes, queries, views, procedures, functions and triggers to Postgres.
Leadership Essentials for Data Teams
Core leadership principles plus tips for personality conflicts, missing requirements, enforcing standards and fostering growth on scattered, diverse data teams.
Silent but Deadly — Hidden SQL Performance Assassins
Find the code habits that quietly hurt performance on any platform, including improper selection criteria, inefficient joins, implicit conversions and procedural processing, and what to do instead.
A Practical Guide to Set-Based Queries
Learn what set-based queries are, how to spot inefficient procedural processing, and how to rewrite it as efficient set-based code.
An Enterprise Data Architecture Framework
A framework for turning disparate sources into an operational data store that serves as the single dependable source of truth, with Raw, Refined and Published data zones.
SQL Team Six: How to Build Effective Teams
Lessons from highly effective teams like SEAL Team Six: chain of command, cohesion, standard operating procedures, training, mission objectives and after-action analysis.
A Postgres Developer’s Snowflake Survival Guide
Put your Postgres experience to work: Snowflake’s unique features, what it shares with Postgres, and where the two differ.
Discover the Power of Window Functions
Solve running totals, interval operations, gaps and islands, and aggregates without losing detail using set-based window functions.
Defining What’s Normal: The Basics of Database Normalization
Review normalization principles, see their impact on performance and data integrity, and learn when it’s OK to break the rules and denormalize.
How to Give a Technical Presentation
How to pull your material together, deliver it so your audience can follow along, and handle the issues that cause presenters stress.
Data Governance Begins with Data Architecture
Proper data governance is proactive, and in healthcare it’s critical. See why it begins with data architecture before systems are designed or purchased.
XML Xtreme!
Query XML documents as a data source alongside SQL Server tables, optimize those queries, and handle incomplete or missing data.
“There Be Whales Here!” — Big Data in SQL Server
Big Data doesn’t require Hadoop or NoSQL. See how SQL Server handles large volumes through proper data models, table design, tuning and T-SQL techniques.
Tally Ho! — Explore the Varied Uses of Tally Tables
Use tally tables to “loop” through records in a set-based manner and turn your loops and cursors into efficient set-based operations.
The Lost Science of Set Theory
Review set theory and relational algebra and how they turn cursors, loops and other procedural habits into efficient set-based operations.
Discover the Hidden Mysteries of Common Table Expressions
What CTEs are, what they are not, and how they work, including where they improve clarity and performance and where they quietly hurt it.
T-SQL Tips & Tricks
Make T-SQL do what you really want with CTEs, ROW_NUMBER and other features that make your queries and stored procedures more efficient.
Looking for a speaker? See the full list of events on Sessionize or contact me.