Azure SQL Managed Instance Performance Considerations Tim Radney talks about how to decide whether a move to Azure SQL Database Managed Instance makes sense and, if so, which tier. Tim Radney ◆ February 26, 2020 4
SQL Server 2019 Cumulative Update #2 SQL Server 2019 Cumulative Update #2 is now available, with 134 fixes and improvements. Build # is 15.0.4013.40. Aaron Bertrand ◆ February 14, 2020 0
NULL complexities – Part 3, Missing standard features and T-SQL alternatives Itzik Ben-Gan discusses missing T-SQL features like the DISTINCT FROM predicate, the NULL treatment clause, and controlling how to order NULLs. Itzik Ben-Gan ◆ February 12, 2020 1
Fun with (columnstore) compression on a very large table – part 3 Aaron Bertrand continues his series on large table compression with results from row and page compression as well as a process involving scheduler manipulation. Aaron Bertrand ◆ February 3, 2020 1
