Talks

Summary

I’ve presented at a variety of paid and free conferences, focusing on SQL Server related content. Reviews highlight my enthusiasm, energy, and passion.

Talk Debut Last Count
XML vs JSON – Battle Royale 2017-04-08
SQL Saturday #604 – Madison		 2018-04-07
SQL Saturday #724 – Madison		 2
Clean up your campsite!
(Database Code Refactoring)		 2017-08-08
That Conference 2017		 2019-04-27
Minnebar 14		 5
SQL Server 2016 – New Feature Preview 2015-10-10
SQL Saturday #453 – Minnesota		 2016-10-01
SQL Saturday #557 – Minnesota		 3
Open Up the Clubhouse!
(Women in Tech)		 2015-08-07
That Conference 2015		 1
Pseudo-Constants in SQL 2014-10-25
SQL Saturday #332 – Minnesota		 2015-04-11
SQL Saturday #387 – Madison		 2

Inquiries

Please contact me if you’re interested in having me speak at your event.

Note that I will not speak at a conference without an effective Code of Conduct and I will not serve on any all-white-male panels at a paid conference.

Materials

GitHub Repository of Session Materials

Full Presentation History

  • 2019-04-27 – Minnebar 14

  • 2019-04-16 – PASSMN Monthly Meeting
  • 2019-04-06 – SQLSaturday #842 – Madison

  • 2019-03-23 – SQLSaturday #835 – Chicago

  • 2018-10-06 – SQLSaturday #796 – Minnesota

  • 2018-04-07 – SQL Saturday #724 – Madison

  • 2017-08-08 – That Conference 2017
    • Clean up your campsite!
    • Refactoring Monolith Database Stored Procedures
    • Your campsite is a mess. There are “totally safe to burn” plastic wrappers melted in last night’s ashes. The roasting sticks are coated with dirt-encrusted marshmallow goo. And some sort of animal went through the trash bag you left out. (Oops.)
    • We get it. Move fast and break things. Just ship it! But what’s left a giant stored procedure with cursors, temp tables, and mystery calculations. It’s a big black box that nobody wants to touch. Let’s fix that. We’ll open the lid on an example monolith and do major surgery. What’s left will perform better, be easier to understand, encourage code reuse, and be easier to test.
    • You might even begin to like writing SQL.
    • (This talk is geared to developers using Microsoft SQL Server, but many of its principles apply to any RDBMS.)
    • Session Materials
  • 2017-04-08 – SQL Saturday #604 – Madison

    • “Keep doing what you’re doing. Your energy and passion are great!”
    • XML vs JSON – Battle Royale
    • Shiny new touch bar MacBook Pro under one arm, JSON strolls in with a coffee from that new place with the ethically sourced beans. Grizzled XML looks up from an old ThinkPad and grunts, remembering that the stained company mug on the cluttered desk had been empty for some time. JSON was sure to be assigned the new web features while XML would be spending another week on those legacy third party integrations…
    • SQL Server 2016 brings JSON support, but does that mean XML is old news? Which has more features? Do they matter? Which is faster?
    • We’ll review the many similarities and highlight some important differences between SQL Server 2016’s XML and JSON support. You’ll leave equipped to make the right choice for your environment.
    • Session Materials
  • 2016-10-01 – SQL Saturday #557 – Minnesota
    • “Very interesting.” “Nice presentation style.”
    • SQL Server 2016 – New Feature Preview (Updated)
    • SQL Server 2016 is here. Curious what all the hype is about?
    • We’ll take a stroll down memory lane to remind us how far we’ve come and then explore some of the brand new features.
    • Time travel with Temporal Tables. Watch the gears turn with Live Query Statistics. Go shopping in the Query Store. And impress your developer friends with some freshly minted JSON.
    • Maybe we’ll even figure out how to bottle up that new version smell.
    • Session Materials
  • 2016-08-16 – Lightning Talks at PASSMN User Group Meeting

  • 2015-10-24 – Twin Cities Code Camp #19 (Fall 2015)
    • SQL Server 2016 – New Feature Preview
    • Repeat.
  • 2015-10-10 – SQL Saturday #453 – Minnesota
    • SQL Server 2016 – New Feature Preview
    • Be the first on the block to try the shiny new features coming in SQL Server 2016.
    • We’ll review how you can get up and running with the SQL Server 2016 Community Technology Preview and play with all of the new toys.
    • Time travel with Temporal Tables. Watch the gears turn with Live Query Statistics. Go shopping in the Query Store. And impress your developer friends with some freshly minted JSON.
    • Maybe we’ll even figure out how to bottle up that new version smell.
    • Session Materials
  • 2015-08-07 That Conference 2015
    • Open Up the Clubhouse
    • Boys, there’s something important we need to talk about. Girls don’t have cooties. It’s time to take down the “No Gurlz Allowed” sign. This clubhouse is big enough for all of us, and we’ll all have a better time if we learn to play nicely together.
    • The percentage of women in technology has fallen steadily since the early 80s. 92% of Stack Overflow survey respondents identified as a male. Girls are discouraged from technology at a young age, and those who make it through are often driven out by an unwelcoming technical community. There are the obvious examples of sickening death threats against those in the gaming industry, but the daily grind of subtle undermining of women’s competencies also takes its toll.
    • Teams perform better with diverse viewpoints, so it’s in all of our best interests to solve this problem. And of course it’s just the right thing to do.
    • We’ll explore some of the challenges women face in technology communities, review ways we can all help improve our environment, and discuss efforts to bring more women into technology led by groups like Girl Develop It.
    • Session Materials
  • 2015-04-11 SQL Saturday #387 – Madison

  • 2014-10-25 SQL Saturday #332 – Minnesota
    • Pseudo-Constants in SQL
    • You know you’ve done it. Maybe it was the lucky number 7. Maybe it was an enigmatic X. Maybe you smooshed some words together in ALLCAPS. That should be easier to spot, right? Because some day you might need to change it—in every stored procedure, function, and view.
    • Magic numbers, codes, identifiers, constants, enumerations. Whatever you call them, all applications have them. Sure it’s quick and easy to sprinkle the values throughout your code, but that breeds mistakes, rigidity, and obfuscation. There has to be a better way!
    • Other languages give us real constants and enums—with IntelliSense and compilation-level enforcement. Well guess what– SQL Server does too, sort of. Join us and learn to write clearer, easier to maintain code without sacrificing performance.
    • Session Materials
  • 2014-09-16 PASSMN User Group

    • Correlated Concatenation with XML
    • Since SQL Server 2005, a popular method for concatenating values across multiple rows has been to use the built-in XML functions. Of course they work well for the simple case involving a single field, but with one small trick, they can be used to make multiple, correlated lists based on different fields.
    • Session Materials

Leave a Reply

Your email address will not be published. Required fields are marked *