Aaron Bertrand announces the recipient of his second annual Community Influencer of the Year award.
2017
For this T-SQL Tuesday, I talk about a few of the difference makers in my career.
Tip : Overview of Database Engine Changes in SQL Server 2017
In this tip, I dig into some of the inner workings of resumable index rebuilds.
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.
Tip : Dealing with the single-character delimiter in STRING_SPLIT function
I illustrate why you should be very careful about oversizing varchar / nvarchar columns.
In this tip, I explain a simple trick to prevent accidental updates or deletes.
I recount the way I implemented database changes in a distributed SQL Server system a decade ago.
Tip : Performance Impact of SQL Server 2016 Row-Level Security
I show a "redundant" non-clustered index outperforming the clustered index with the same key.
I start a new series around disproving prevalent myths regarding SQL Server performance.
For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().
I show how to implement simple triggers that maintain trigram-type tables used for better supporting wildcard searches.
In an effort to make leading wildcard searches sargable, I play around with a trigram-type implementation in SQL Server.
I show that DISTINCT and GROUP BY are usually interchangeable, but there are cases where one performs better than the other.
For T-SQL Tuesday #86, I highlight a few of my favorite bugs and feature requests on Connect (RIP).
I start digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.