For this month's T-SQL Tuesday, Steve Jones asks us to talk about problems we've solved using window functions.

For T-SQL Tuesday #158, I talk about a couple of justifiable worst practices.

For T-SQL Tuesday #156, I talk about the qualities I expect in T-SQL code before I consider it "production quality."

For October's T-SQL Tuesday, Steve Jones asks us to talk about ways we've used dynamic SQL to solve problems.

For this month's T-SQL Tuesday, I talk about the community event that had the most profound impact on my career and, more importantly, my life.

My first technical job was taking horse bets at an off-track bar when I was 17.

For T-SQL Tuesday #146, I talk about a couple of crazy ideas I had in my head about filtered indexes.

For this month's T-SQL Tuesday, I talk about the scripts I use to keep a local system with all kinds of oddball metadata scenarios.

For this month's T-SQL Tuesday, TJay Belt asks us to talk about how we manage work/life balance.

For this month's T-SQL Tuesday, I talk about my two least favorite data types: money and datetimeoffset.

For this month's T-SQL Tuesday I talk about a few distractions I enjoy when not slinging T-SQL.

This month's T-SQL Tuesday is about what we've learned from presenting. I give an embarrassing account about how I learned to be prepared and not go off script.

This month's T-SQL Tuesday is about how we are dealing with the madness that is 2020.

Rob Volk asks us to share our favorite analogies that help explain database-related concepts to less technical folk.

This month, Elizabeth Noble asks us to talk about things we have automated (or want to automate). I talk about a project I just started, called GetAllTheErrorLogs.

For this month's T-SQL Tuesday, Kerry Tyler asks us to talk about something that went wrong. I had plenty to choose from, and went way back to ~2002 for this short story.

For this month's T-SQL Tuesday, let's talk about something you're more likely to hear from a carpenter: Measure twice, cut once.

This month, Jess Pomfret hosts T-SQL Tuesday, and asks us to talk about our own personal life hacks that make our day easier.

For this month's T-SQL Tuesday, I talk a little bit about how I make my imposter syndrome feel less like imposter syndrome.

For this month's T-SQL Tuesday, I talk about an opportunity earlier this year to significantly change my career trajectory.

For this month's T-SQL Tuesday, I talk about an incident where I've changed my mind about something I was previously pretty stubborn about.

I show that, in some cases, INSTEAD OF triggers can be better for performance than AFTER triggers.

For this T-SQL Tuesday, I talk about my methods for metadata discovery in new versions of SQL Server.

I give some scattered thoughts about how I have contributed to the SQL Server community throughout my career.

I recap a grand total of FIFTY entries in this month's T-SQL Tuesday. A lot of interesting submissions!

For my T-SQL Tuesday entry, I show off my hockey and football card collection, license plates from all over the world, and a very special collection of "Everything Happens to Aaron" books.

For this month's T-SQL Tuesday, I would love to hear about something you are passionate about, outside of the SQL Server or tech community.

For this T-SQL Tuesday, I talk about a few of the difference makers in my career.

For this T-SQL Tuesday, I describe a few of my experiences from the 2000s, from both sides of interviews.

For T-SQL Tuesday #92, I show one trick I use to prevent errant DML from running in production.

I recount the way I implemented database changes in a distributed SQL Server system a decade ago.

For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().

For T-SQL Tuesday #86, I highlight a few of my favorite bugs and feature requests on Connect (RIP).

For both T-SQL Tuesday and #BackToBasics, I provide information about SQL Server backups, and why your restores can be just as important.

I submit a wish list item for the 80th T-SQL Tuesday: CREATE OR REPLACE, a cleaner way to deploy objects without losing permissions.

For this T-SQL Tuesday, I talk about a feature long missing from SQL Server: The ability for Developer Edition to act like Standard.

For T-SQL Tuesday #78, I take a look at whether RID Lookups are faster than key Lookups, with a small battery of fairly simple duration tests.

For this T-SQL Tuesday, I treat some of the most memorable data modeling sins from over the years.

For this T-SQL Tuesday, I talk about a few of the limitations of Always Encrypted.

I look at the tempting All Features With Defaults installation choice for this T-SQL Tuesday.

For T-SQL Tuesday #67, I describe a new way to track backup and restore operations using Extended Events in SQL Server 2016.

For T-SQL Tuesday, I discuss undocumented trace flags that provide additional diagnostics to troubleshoot slow backup or restore operations.

For T-SQL Tuesday< #65, I give a little detail on something I learned this week about altering a column from NOT NULL to NULL.

I follow up on a question from a triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.

I use a T-SQL Tuesday theme to demonstrate a use case for the SQL_VARIANT data type that you may not have considered: Conditional ORDER BY.

This month's T-SQL Tuesday is about assumptions in SQL Server.

I describe a way to use ALTER SCHEMA … TRANSFER to refresh data with minimal disruption.

For this month's T-SQL Tuesday, I talk about UTC, DST, and offsets.