SQL Server According to Bob

DECEMBER 26, 2017

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40

Servers Software Engineering Engineering Availability 40

Rigor

SEPTEMBER 11, 2019

Reading time 16 min Whether you’re a web performance expert, an evangelist for the culture of performance, a web engineer incorporating performance into your process, or someone new to the web performance entirely, you probably identify as curious, excited about new ideas, and always learning. Rick Byers.

Performance 89

Performance Education Google Website 89

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. Server B may be generating uuids that sort before those from Server A.

Servers 40

Servers Software Engineering Database Network 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 The Linux, sqlservr, WATCHDOG can perform a similar role.

Servers 40

Servers Processing Software Engineering Traffic 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. SQL Server does NOT do this, in fact I made sure SQL Server on Linux does not allow this to occur. This issue does NOT impact SQL Server database, log and backup files.

Servers 40

Servers Media Cache Software Engineering 40

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). DtcGetTransactionManager contacts the host, performing a remote registry access to determine the connection and proxy information. Once the connection to SQL Server is established the APP executes the odbc!

Servers 40

Servers Azure Engineering Java 40

SQL Server According to Bob

JULY 31, 2018

Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. Only currently open file descriptors may continue to perform reads, writes and fstat activities. Bob Dorr – Principal Software Engineer SQL Server. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40