jemiller jemiller

Niner since 2012


  • Indexing Fundamentals for Microsoft SQL Server

    Good video. Thanks for it. It was helpful. I've always wondered whether it's good enough to have one index on FirstName and another LastName or whether it's necessary to have a single index containing both columns. So, it was good to find out about how that works for sure. Also, it was good to confirm that foreign keys should pretty much always be indexed. Previously, ORMs such as EF didn't add indexes for foreign keys automatically, but, I noticed that the current version does.

  • Information Rich Programming with F# 3.0

    This is pretty cool. I'm wondering if the type provider feature will eventually carry over to C# as well. I wonder what that would mean for something like Entity Framework.