SQL Server According to Bob

MARCH 18, 2018

SQL Server is designed to scale across the spectrum of small machines to enterprise class servers. The changes made in SQL Server 2017 CU4 improve resource usage on smaller machines, such as a VM or Container used for testing and development. What Is A Small System? It is a best practice keep the setting above 128.

Servers 40

Servers Best Practices Software Engineering Operating System 40

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. SQL Server’s NewSequentialId () calls the Windows API UuidCreateSequential , which is limited in SQLPAL, prior to the CU 4 update. Question: What if I change the time of the system clock?

Servers 40

Servers Software Engineering Database Network 40

SQL Server According to Bob

DECEMBER 18, 2018

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. This means data can be stored in file system cache, non-stable media. ) Assume the database application opens the backup file, allowing file system caching (~_O_DIRECT.)

Servers 40

Servers Media Cache Software Engineering 40

SQL Server According to Bob

JULY 17, 2018

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 Bob Dorr – Principle SQL Server Software Engineer.

Servers 40

Servers Processing Software Engineering Traffic 40

SQL Server According to Bob

JULY 31, 2018

The unlink or remove syscall makes changes to the file system so searching for the file by name returns no entries and when the file descriptor is closed the file is deleted. Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

SQL Server According to Bob

JANUARY 28, 2018

Resource Manager – Database, File System, with ACID capabilities. Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). Once the connection to SQL Server is established the APP executes the odbc! Microsoft specific implementation for DTC using (OLE-TX).

Servers 40

Servers Azure Engineering Java 40

SQL Server According to Bob

JANUARY 29, 2017

We captured a core dump on a 2TB RAM system. The ELF header is limited to a 16 bit value or max of 0xFFFF and on the 2TB system the number of memory regions exceeded 65535 when the dump was captured. FEB 1, 2017 UPDATE – CHANGE ACCEPTED. Bob Dorr – Principal Software Engineer SQL Server.

Servers 40

Servers Programming Media Open Source 40