Session recaps from SQL Saturday 673 in Denver — personal branding, NoSQL, knowledge sharing, Extended Events, and data constraints. Plus: no duck from Idera.
Brent Ozar's Group By SSMS shortcuts session is free and mind-expanding. Here are the shortcuts that stuck with me and why they matter for daily DBA work.
In 2017, Microsoft cozying up to Linux seemed like a punchline. SQL Server on Linux, WSL, Azure running Linux servers — here's how that looked from the DBA seat.
When storage goes sideways and you need to run DBCC checks across a lot of databases fast, here's a cursor-based script that targets databases under a size threshold.
Keeping up with SQL, DevOps, Python, and C# while working full time is a real juggling act. Here's how I think about it without losing my mind.
When reporting logins block nightly jobs and you've exhausted the polite options, here's a stored procedure approach: disable the login and kill the sessions.
Session recaps from SQL Saturday 584 in Colorado Springs — stats, transaction logs, DevOps for DBAs, data virtualization, and VLF management. Plus: I won SQL Toolbelt.
A military aviator's distinction between procedure and technique maps surprisingly well onto IT documentation. One is a standard you follow; the other is how you get there. You need both — but in the right balance.
A 2016 career retrospective and a look at what I want to accomplish in 2017 — SQL development, PowerShell, ITIL, community involvement, and the certification question.
Trust is the currency of being a great IT professional. Here's how to build it, what destroys it fast, and how to recover when you've lost it.