Remove 2017 Remove Azure Remove Code Remove Software Engineering
article thumbnail

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

SQL Server According to Bob

SQL Server will ship Azure SQL Database Edge: [link]. As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. Engineering Rigor. SQL Server 2017.

IoT 61
article thumbnail

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

SQL Server According to Bob

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90
article thumbnail

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

SQL Server According to Bob

SQL Server also supports XA based transactions but has no code in the SQL Server engine to engage in XA transactions. MSDTC can also be used as the XA TM if so desired (see example code at end of this post.). This means there are no DTC components available for SQL Server 2017 on Linux. Helpful References.

Servers 40