Voice of the DBA

Tag: VSLive

  • Heading Back to VS Live in March 2023

    I’m speaking at VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel a new place for me. I’m looking forward to seeing lots of friends at the show. I was in Redmond and Austin last year for the VS Live shows and I can’t wait to get back to Las Vegas.

    If you want to join me at fun show, register with the code Jones for $500 off the price.

    VS Live is a multi technology show. I always learn something interesting there from Brian Randall, Rocky Lhotka, Bob Ward, Andrew Brust or any of the other amazing speakers. There are lots of development sessions, both technical and soft skills, along with a few of us data people delivering talks on how to deal with the database and power your software.

    The schedule is up and it looks exciting. A wide variety of talks, including these two from me:

    • Architecting Zero Downtime Database Deployments
    • Adding Graph Structures to your SQL Server Database

    There are lots of talented speakers and great topics, so think about kicking off your 2023 development efforts by coming to  VS Live Las Vegas, Mar 19-24, 2023.

    Register with the code Jones for $500 off the price.

  • Join me at VS Live Las Vegas 2023

    I’m heading back to VS Live in March 2023 for the Las Vegas show. This time it’s at Planet Hollywood, which is a hotel I’ve never visited. I’m excited to go to a new place, and I’m looking forward to seeing lots of friends at the show.

    If you want to join me at fun show, register with the code Jones for $500 off the price.

    VS Live is a multi technology show. I always learn something interesting there from Brian Randall, Rocky Lhotka, Bob Ward, Andrew Brust or any of the other amazing speakers. There are lots of development sessions, both technical and soft skills, along with a few of us data people delivering talks on how to deal with the database and power your software.

    The schedule is up and it looks exciting. I have sessions I’m delivering:

    • Architecting Zero Downtime Database Deployments
    • Adding Graph Structures to your SQL Server Database

    There are lots of other great talks as well, so think about kicking off your 2023 development efforts by coming to  VS Live Las Vegas, Mar 19-24, 2023.

    Register with the code Jones for $500 off the price.

  • VS Live Microsoft HQ Slides and Code

    Thanks to everyone that attended my sessions today at VS Live. I have my slides and code available for download at the VS Live site and here.

    The Serverless Azure Database – PPT zip

    Adding Graph Structures to Your Database

  • VS Live Slides and Code

    Thanks to everyone that came to my talk at VS Live today.

    I’ve uploaded the slides to the blog. Here are the two decks:

    Code for the CI Talk is on my Github. You can git clone from here: https://github.com/way0utwest/usingcitopreventdbproblems.git

    The code is structured as:

    • 0 files are setup, numbered 04, 06, 08, and 10. These create objects, add the tsqlt framework and load some data.
    • 20_Standards.sql – Standards based tests
    • 30_logicerrors.sql – The logical CASE statement test
    • 40_tsqlt_sqlinjection – Catching SQL Injection issues with EXEC()
    • 50_preent_alter – I didn’t demo, but how to look for code you don’t want developers to run.
    • 61, 62 63 – Older separation of concerns testing for procs/functions. I haven’t tested this lately, but it should work.

    If you have questions, let me know.