Thoughts and experiences with SQL Server over 15 years.
Over the last two years, as I’ve been working more closely on our application database (a database with nearly 20 years of history), one simple question keeps coming up as I work on old scripts and prepare new changes. Should we use a DROP/CREATE or CREATE/ALTER pattern for Stored Procedures, Functions, Views, and Triggers? Because … Read more
Who doesn’t love sp_WhoIsActive? Nearly every single DBA talk I have attended in the last two years mentions as a “must have!” I do the same during my DBA Newbie talk at SQL Saturdays. About 18 months ago I came across this post by Tara Kizer and started logging activity every 30 seconds on most … Read more
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the month’s host. And although this is only the second actual post of this blog (fret ye not, there’s more on the way), I’m delighted to finally be participating more in the SQL community that has helped me … Read more
The Backstory As noted in the About page, I’ve worked at EnergyCAP for over 12 years (as of this post). We’re a leader in our industry… and have been for more than 35 years. But with any long-term history comes long-term technical debt, especially when not handled well team-to-team, year-to-year. For us one of the major … Read more