Remove 2016 Remove Azure Remove Software Engineering Remove Testing
article thumbnail

What Am I Working On (RDORR): SQL Server On Linux

SQL Server According to Bob

Before joining Microsoft in 1994 I worked at State Farm Insurance and spent several years in a testing group and later joined a team developing applications against SQL Server for OS/2. Then I cranked up the tests to high stress levels and they passed. That is exactly what I started doing in Mar 2016.

Servers 40
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

Testing shows that by using the Fua bit with the data, write request can reduce the I/O traffic by ~50% for a SQL Server, write-intensive workload. During my investigation, I traced, tested, reviewed, and instrumented the Linux kernel to understand the SQL Server I/O durability needs and associated impacts. Starting with the Linux 4.18

Servers 90
article thumbnail

How It Works: SQL Server DTC (MSDTC and XA Transactions)

SQL Server According to Bob

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. This means there are no DTC components available for SQL Server 2017 on Linux. Helpful References.

Servers 40