SQL Server According to Bob

JUNE 22, 2016

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Instead the design of CMemThread was updated.

Servers 40

Servers Azure Software Engineering Design 40

SQL Server According to Bob

JUNE 27, 2016

During this same timeframe my peers were releasing our providers natively, portions of.NET, sqlcmd, bcp and the numbers in the Azure VM world are showing Linux as a valuable asset. That is exactly what I started doing in Mar 2016. For example, we were designing how to capture a crash dump.

Servers 40

Servers Games Azure Software Engineering 40

SQL Server According to Bob

JANUARY 28, 2018

SQLJDBC uses a slightly different design but again the SQL Server service does not change. There is a technique that can be used with SQL Server (Windows, Azure or Linux) to support some DTC capabilities. Note: SQL Server Azure does not support DTC. However, this technique can be used with SQL Server Azure as well.

Servers 40

Servers Azure Engineering Java 40