The Recording
The Panelists
- Kevin Feasel
- Mike Chrestensen
Notes: Questions and Topics
AWS to Bare Metal
The first item of the episode (after I spent way too long talking about my green screen change) was an article that looked back at the past two years after a migration from AWS back to an on-premises data center. I think the Q&A format was a good one and the author has some interesting answers to questions people had at the time, as well as a look back at the true costs and savings. I’m not surprised that they saved a pretty significant amount of money, especially because it seemed like their primary use case was running Elastic Kubernetes Service rather than many platform-as-a-service offerings.
SQL Server and Automatic Indexing of Foreign Key Constraints
The second topic was this Greg Low blog post (via Brent Ozar’s newsletter), asking if it makes sense to add indexes to foreign key constraints. Greg’s answer is a good one and covers the situations in which it does make sense, as well as situations in which it would not make sense for there to be an index. Greg then offers a hypothetical bit of syntax that would cover automatic creation of an index with a foreign key unless you specify otherwise.
Believing What You See
Greg had another thoughtful blog post that I wanted to cover, this time around images and credulity. Greg points out a real-world event—and then Anders, in chat, lets us know that this kind of thing still happens and an incident occurred not even 6 weeks prior in Charlotte—but people automatically discounted the real-life image because of the deluge of AI generated images out there. I did a bit of riffing on older techniques for image manipulation (airbrushing, image staging, Photoshop) and also talked a bit about how modern phones are beginning to cause real problems as evidence in legal proceedings because of built-in tools that manipulate the image, like taking people out of the background of an image.
Tilting with Tuples
Finally, I gave a shout out to Louis Davidson, who is starting a new podcast. The most important reason I did this was because Louis pronounces “tuple” correctly, and that goes a long way toward an endorsement.