2017 : Community Influencer of the Year
Aaron Bertrand announces the recipient of his second annual Community Influencer of the Year award.
Aaron Bertrand announces the recipient of his second annual Community Influencer of the Year award.
Tip : Changes to SQL Server CXPACKET Wait Types
Tip : SQL Server DateTime Best Practices
For this T-SQL Tuesday, I talk about a few of the difference makers in my career.
Here are the slide decks and sample code from my three sessions at SQLintersection, as well as a bit of a recap.
Tip : Overview of Database Engine Changes in SQL Server 2017
I share slides and samples from the dataMinds Connect conference this week in Ghent, Belgium.
I share slides, demos, and thoughts from my latest SQLSaturday adventure in Utrecht.
Tip : More on Resumable Online Index Rebuilds in SQL Server 2017
I share slides and demos from two T-SQL sessions at SQLSaturday #667 in Oslo, Norway.
For this T-SQL Tuesday, I describe a few of my experiences from the 2000s, from both sides of interviews.
Tip : Virtual Log File Monitoring in SQL Server 2017
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.
This week John Martin and I represented SentryOne at SQLGrillen in Lingen, Germany. Here are my slides and samples.
I share slide decks and other materials from my presentations at SQLintersection in Orlando.
Tip : Safeguard to Avoid Costly Mistakes for UPDATE or DELETE Statements in SQL Server Management Studio
I recount the way I implemented database changes in a distributed SQL Server system a decade ago.
I share slide decks and samples from Friday sessions at SQLBits in Telford, UK.
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.
I explain the ups and downs of a cohesive, consolidated, version-agnostic Books Online for SQL Server.
Tip : Auditing Who Changed Temporal Table Data in SQL Server
For T-SQL Tuesday #87, I talk about two shiny new toys in SQL Server: STRING_SPLIT() and STRING_AGG().
Tip : Managing Temporal Table History in SQL Server 2016
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.
Tip : Benefits of SCHEMABINDING in SQL Server
Tip : More on Recovering Access to a SQL Server Instance
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.