Remove 2017 Remove Azure Remove Software Engineering Remove Systems
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]. For example, Azure SQL Database Edge can already use TSQL Predict Machine Learning (ML) and Column Storage. The reduction effort started when we shipped SQL Server 2017 ( [link].) Partitioning allows SQL Server to scale to the largest systems with record-setting performance.

IoT 61
article thumbnail

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

SQL Server According to Bob

Durability: β€œIn database systems , durability is the ACID property which guarantees transactions that have committed will survive permanently. For example, if a flight booking reports that a seat has successfully been booked, then the seat will remain booked even if the system crashes.” – [link]. 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

Resource Manager – Database, File System, with ACID capabilities. This means there are no DTC components available for SQL Server 2017 on Linux. 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. Helpful References.

Servers 40