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 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...
Tip : Phase out CONTEXT_INFO() in SQL Server 2016 with SESSION_CONTEXT()
I highlight three Connect items that will address some pretty important shortcomings in SQL Server statistics.
For this T-SQL Tuesday, I treat some of the most memorable data modeling sins from over the years.
Tip : Advanced JSON Techniques in SQL Server 2016 – Part 2