T-SQL enhancements in SQL Server 2022
Exploring some of the more useful T-SQL enhancement coming with SQL Server 2022
View config values with GetDebugView
Use GetDebugView to view all configuration values
EF Find vs First performance
Comparing the performance of Entity Framework's Find and First methods
Keyset Pagination (vs Offset pagination)
Exploring keyset pagination in SQL Server
Multiple statements in a for loop
A for loop can contain multiple statements in the iterator section
Destructing a Dictionary record into a Tuple
A Dictionary key-value pair can be destructed into a Tuple
Lambda vs local function performance
Exploring the performance of a lambda function vs a local function
Visual Studio layouts
Customizing and switching between Visual Studio layouts