Tip : Changes to SQL Server CXPACKET Wait Types

Tip : SQL Server DateTime Best Practices

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

Tip : More on Resumable Online Index Rebuilds in SQL Server 2017

Tip : Virtual Log File Monitoring in SQL Server 2017

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 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

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.

I start digging deeper into the performance of string concatenation methods STRING_AGG and FOR XML PATH.