Hi, I’m Landon. I work with databases, write code, and teach tech. These are my notes from the journey—practical lessons, unexpected discoveries, and a little life along the way.
FROM THE BLOG
The Incident Recently I received word that one of our Azure Data Factory pipelines was experiencing significant latency. At the heart of this pipeline is an Azure SQL Managed Instance that is used as a staging tier. I…
Read articleThe Problem We recently migrated the underlying “ReportServer” and “ReportServerTempDB” databases of our SQL Server Reporting Services (SSRS) environment to a newer instance. Everything worked fine and there were no…
Read articleI recently purchased a new HomePod mini to extend music into an unreached corner of the house. Having used multiple of the full size ones in the past, I pretty much knew what to expect and didn’t give setup a second…
Read articleBackground Everyone knows that it’s a good idea to regularly run integrity checks on your databases (you are doing that right?). What may be less obvious is that it’s generally recommended with AlwaysOn Availability…
Read articleThe Problem I encountered an issue lately where one particular service account kept losing access on a development instance. Since the login and user were present I went to one of the usual culprits, orphaned users. I…
Read articleIn This Article TLDR Macs are a pleasant place to spend 40+ hours in your work week, and totally workable for those with Microsoft-centric jobs. Let me give you a jump start on how to make it work. The Background I’m…
Read articleThe Problem One of the initiatives I’ve been working toward with my team this year is automating as much of our SQL Server patching as possible. Over time our environment has become increasingly complex, and while…
Read articleBackground My colleague and I were recently looking for ways to improve our production Availabiity Group nodes. These are beefy machines with a large amount of memory, and things like buffer cache scans can be lengthy.…
Read articleI’m so happy to share with you a little project that I’ve been working on! Growing up, I always had a love for computers and an insatiable desire to learn about them, but there weren’t many resources available. It’s my…
Read article