Tsql
- January 23, 2019: Why You Shouldn't Use SELECT * In Production Systems (EVER!)
- January 18, 2019: Supercharge Your SQL Server Scalar Functions By Switching To Table Value Functions
- January 07, 2019: Profiler Is Dead, Long Live Extended Events
- January 03, 2019: SQL Server Removing Duplicates
- December 06, 2018: SQL Server Find Unused Data Files
- November 29, 2018: SQL Server Guide To NULL Handling
- May 21, 2018: SQL Server Debugging With RAISERROR Instead Of Print
- May 20, 2018: SQL Server Error Handling In Depth
- May 14, 2018: SQL Server Building On Calculations With APPLY
- May 01, 2018: SQL Server Advanced Aggregations Part 3 GROUPING/GROUPING_ID
- April 30, 2018: SQL Server Removing Outliers With Standard Deviation
- April 28, 2018: SQL Server Advanced Aggregations Part 2 ROLLUP and CUBE
- April 26, 2018: SQL Server Advanced Aggregations Part 1 Grouping Sets
- July 06, 2017: Upgrade Your SQL Server CASE Statements With IIF and CHOOSE
- July 05, 2017: SQL Server 2017+ How To Replace Multiple Characters In A Single Statement With TRANSLATE
- June 20, 2017: SQL Server 2017 Concatenation With STRING_AGG
- June 12, 2017: SQL Server 2017 Graph Data Features In Action
- June 06, 2017: SQL Server 2016 What's New With TSQL
- May 23, 2017: SQL Server Window Functions in Action
- May 08, 2017: Using The SQL Server Merge Statement
- May 07, 2017: SQL Server Dynamic Pivot
- May 06, 2017: Using JSON In SQL Server 2016
- May 04, 2017: SQL Server Pivot and Unpivot Explained