Talks

Presentation History

GitHub Repository of 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
  • 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
  • 2015-04-11 SQL Saturday #387 – Madison
  • 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-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-10-24 – Twin Cities Code Camp #19 (Fall 2015)
    • SQL Server 2016 – New Feature Preview
    • Repeat.
  • 2016-08-16 – Lightning Talks at PASSMN User Group Meeting

  • 2016-10-01 – SQL Saturday #557 – Minnesota
    • 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
  • 2017-04-08 – SQL Saturday #604 – Madison
    • 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

Leave a Reply

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