Remove 2017 Remove Database Remove Software Remove Software Engineering
article thumbnail

SQL Server Linux: Distributed transactions requiring the Microsoft Distributed Transaction Coordinator service are not supported on SQL Server running on Linux. SQL Server to SQL Server distributed transactions are supported. – CLARIFIED!!!

SQL Server According to Bob

Current limitation: Engaging in a distributed transaction with SQL Server 2017 on Linux. SQL Server 2017 on Linux does not have distributed transaction support. However, SQL Server 2017 on Windows provides distributed transaction support allowing interactions with SQL Server 2019 on Linux. Try out this example.

Servers 40
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].) Remove the background task and aggressively reclaim database space during query execution.

IoT 61
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. β€œ. Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 90
article thumbnail

The Digital Twin: A Foundational Concept for Stateful Stream Processing

ScaleOut Software

Traditional stream-processing and complex event processing systems, such as Apache Storm and Software AG’s Apama , have focused on extracting interesting patterns from incoming data with stateless applications. Michigan) in 2002 for use in product life cycle management, it was recently popularized for IoT by Gartner in a 2017 report.

article thumbnail

SQL Server on Linux: CU4 – NewSequentialId() – Uuid

SQL Server According to Bob

Prior to SQL Server 2017 CU4 for Linux (Linux only) the generation of a sequential UUID may not function as expected. Conflict with existing data is unlikely but the new value may sort before those values stored in the database already. Bob Dorr – Principal Software Engineer SQL Server. secrets/instance_id file.

Servers 40
article thumbnail

The Digital Twin: A Foundational Concept for Stateful Stream Processing

ScaleOut Software

Traditional stream-processing and complex event processing systems, such as Apache Storm and Software AG’s Apama , have focused on extracting interesting patterns from incoming data with stateless applications. Michigan) in 2002 for use in product life cycle management, it was recently popularized for IoT by Gartner in a 2017 report.

article thumbnail

SQL Server Linux: fsync and Buffered I/O

SQL Server According to Bob

Assume the database application opens the backup file, allowing file system caching (~_O_DIRECT.) The sync was called by an application outside database application so the database application is unaware of the failure. Β· This issue does NOT impact SQL Server database, log and backup files.

Servers 40