SQL Server According to Bob
FEBRUARY 22, 2018
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.
SQL Server According to Bob
DECEMBER 18, 2018
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.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
SQL Server According to Bob
JULY 17, 2018
systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 The simple answer is the first entry (85829) is not what you are used to on a Windows system as sqlservr.exe and does not listen for TDS traffic or open database files.
SQL Server According to Bob
DECEMBER 18, 2018
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.
SQL Server According to Bob
JANUARY 28, 2018
Resource Manager – Database, File System, with ACID capabilities. This means there are no DTC components available for SQL Server 2017 on Linux. Microsoft specific implementation for DTC using (OLE-TX). X/Open Standard for TM to RM communications and behavior. Transaction Monitor/Manager – Coordinator. Microsoft MSDTC protocol.
SQL Server According to Bob
DECEMBER 11, 2017
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.
SQL Server According to Bob
MAY 19, 2019
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.
Expert insights. Personalized for you.
40 
Let's personalize your content