I show how to piece together portions of SQL Server metadata to generate DBML (which is more useful than it sounds).
I wrote two tips around what you can do when a table that stores the same strings over and over again has grown to an unmanageable size: create a dimension table!
I talk about why every CTE I write starts with a semi-colon, and why you won't change my mind about it.
An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.
A recent documentation update raises questions about the love-it-or-hate-it READ UNCOMMITTED isolation level.
SQL Server 2017 Cumulative Update #29 is available, with 18 enhancements. The build number is 14.0.3436.1.
I recently sat down with long-time friend Kevin Kline, who grilled me a little about my new role at Stack Overflow, our industry in general, and why we sometimes stay in jobs we don't enjoy.
In this tip I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel.
In the second part of this series, I show two ways to shift expensive computations to write time.
I talk about progress in aggregating strings – both in the functionality offered by SQL Server and the quality of my own code samples.
In this tip I confirm that FORMAT is still a dog compared to even very complex expressions using CONCAT_WS, DATENAME, DATEPART, and CONVERT.
I was honored to be a guest on the most recent Mixed Extents podcast, along with my friend and colleague Andy Mallon, where we talked about patching SQL Server.
I harassed Erik Ejlskov Jensen enough to make me a universal command-line version of SqlQueryStress, and walk you through setting up a performance test between an Intel and M1 MacBook.
SQL Server 2019 Cumulative Update #15 is available, with 39 enhancements (35 public). The build number is 15.0.4198.2.
In this tip I show how indirect checkpoints can help improve performance and stability of more than just checkpoint operations themselves, and stifle some (but not all) problems. I conclude that you should proactively change this setting everywhere.
SQL Server 2017 Cumulative Update #28 is available, with 10 enhancements. The build number is 14.0.3430.2.
For T-SQL Tuesday #146, I talk about a couple of crazy ideas I had in my head about filtered indexes.
I show how I set up Azure SQL Edge in a Docker container on the new M1 MacBook.
See one way to use a queue table to spread out spiky, ad hoc deletes from a clustered columnstore index.
I recognize this year's recipient of my Community Influence of the Year award.
These functions aren't brand new, but they're in Azure SQL Database and Azure SQL Managed Instance, and they're coming to SQL Server 2022 soon.