Jorriss.com

Blog

  • Serverless in a Conference?

    Serverless in a Conference?

    I just spent the last few days in Austin for a conference on Serverless computing. If you don’t know, Serverless is the horrific marketing term for Functions as a Service. It’s basically a way to run code in the cloud where the server and runtime is managed for you’re only charged for the time the…


  • Visual Studio Database Projects and the Problem with Reference Data (Part Two)

    Visual Studio Database Projects and the Problem with Reference Data (Part Two)

    In my previous post, I discussed the difficulties of saving reference data in a Visual Studio Database Project. In this post, I’ll go over the architecture of one way this problem can be solved. While doing some research on this topic I ran across this StackOverflow question “How do you store static data in your…


  • Visual Studio Database Projects and the Problem With Reference Data (Part One)

    Visual Studio Database Projects and the Problem With Reference Data (Part One)

    I’ll be honest. I wasn’t a fan of Visual Studio Database Projects. I still believe that designing databases using a data modeling tool like ER/Studio or ERwin is the very best way to build a database. But after taking a hard look at the Database Project project template I’ve changed my tune. There are some…


  • Tech Conference Attendee Bill of Rights

    Tech Conference Attendee Bill of Rights

    I have the opportunity to attend and speak at conferences pretty frequently. But it wasn’t always that way. It wasn’t too long ago that I was only able to attend a conference every other year. So when I was able to get away to a conference it was a pretty big deal. I tried to get…


  • Changing T4 Template Background Colors in Visual Studio

    Changing T4 Template Background Colors in Visual Studio

    T4 is a templating engine inside of Visual Studio that lets you generate, well, text. Since T4 has no editor goodies in Visual Studio the Tangible T4 Editor is a good way to get some of the goodies back. But if you’re using the “dark” theme in Visual Studio the Tangible T4 Editor needs a color change.…


  • A Podcast Is Born

    A Podcast Is Born

    It started with a simple statement, “We should record this.” I made that statement said during a dotNet Miami after party. The after party always has interesting discussions about programming, projects, and life. The next month I made a recording of the dotNet Miami after party hoping I could get some usable audio. What I got was interesting…


  • Why You Absolutely Need Alternate Keys: A Unique Constraint Story

    Why You Absolutely Need Alternate Keys: A Unique Constraint Story

    Although often forgotten, alternate keys are an essential part of  database design especially if you’re using surrogate keys. Alternate keys protect your database from duplicate data and can even speed up your application. For the past few years I’ve been presenting on the top database design mistakes that I’ve seen “in the wild”. One of those “mistakes”…


  • Checkpoint: Three Years Later

    Checkpoint: Three Years Later

    It kinda snuck up on me. I’ve got so much going on I forgot all about it. There was so much going on: client deliverables, kids birthdays, presentations, conferences, even freaking accounting…life was happening. Three years ago, I was laid off from my job of almost twelve years. I try not to think about it…


  • Summit 2013 In Review: The Good

    Summit 2013 In Review: The Good

    The PASS Summit had a lot to live up to. I’ve heard so much about the Summit from my fellow PASS members I fully expected it to be located in the Land of Oz, staffed by the Kermit the Frog and the Muppets, and the speakers carried lightsabers while moving you to tears by just…


  • Summit 2013 In Review: Overview

    Summit 2013 In Review: Overview

    Recently, I had the opportunity to attend the PASS Summit in Charlotte, North Carolina. I’ve made attempts the past few years but I’ve never been able to put a trip together for one reason or another. This was my first PASS Summit which some have described as the Super Bowl of SQL Server conferences. The…