SQL Server 2016 : In-Memory OLTP Enhancements
I list out the changes to In-Memory OLTP ("Hekaton") that will make the feature even more appealing in SQL Server 2016.
Monthly Archive: November 2015
SQL Server 2012 Service Pack 3 is available!
SQL Server has released SQL Server 2012 Service Pack 3. You can download here and see some other details here. Build number is 11.0.6020.0 37 fixes (see the full list in KB #3072779) SP3...
Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT()
Tip : Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT()
Please help improve SQL Server statistics!
I highlight three Connect items that will address some pretty important shortcomings in SQL Server statistics.
T-SQL Tuesday #72 : Models Gone Wild!
For this T-SQL Tuesday, I treat some of the most memorable data modeling sins from over the years.
Advanced JSON Techniques in SQL Server 2016 – Part 2
Tip : Advanced JSON Techniques in SQL Server 2016 – Part 2