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. Bob Dorr – Principal Software Engineer SQL Server. The downside of using unlink or remove, and keeping the file descriptor open, is that the file becomes hidden. Restart the VM.

Servers 40

Servers Software Engineering Systems Monitoring 40

SQL Server According to Bob

JANUARY 29, 2017

FEB 1, 2017 UPDATE – CHANGE ACCEPTED. Bob Dorr – Principal Software Engineer SQL Server. This is really a neat experience and I can truly see our use of LLDB driving more advancements for everyone. This revision was automatically updated to reflect the committed changes.

Servers 40

Servers Programming Media Open Source 40

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

Rigor

SEPTEMBER 11, 2019

Rick is a software engineer on the Google Chrome team, “leading an effort to make the web just work for developers.” His keynote address from O’Reilly Fluent 2017, Reflecting on 20 years on the web , is a must-see. The future of HTTP/2 server push. Rick Byers. Rick Byers. Vitaly Friedman. Billy Hoffman.

Performance 89

Performance Education Google Website 89

ACM Sigarch

FEBRUARY 23, 2018

Richard Thaler won the 2017 Nobel prize in Economics for his work on Behavioral Economics. In industry, engineers (me included) sometimes attack a problem with the tools they have readily available rather than taking a step back and examining the issue at large.

Architecture 47

Architecture Cache Hardware Virtualization 47

SQL Server According to Bob

DECEMBER 11, 2017

SQL Server 2019 CTP2. SQL Server 2019 adds broad support for distributed transactions (both MSDTC/OLE-TX and XA) to SQL Server on Linux. You can establish and use transactions between Linux and Linux or Linux and Windows instances of SQL Server or your application. Configuring MSDTC for SQL Server on Linux: [link].

Servers 40

Servers Database Software Engineering Engineering 40

SQL Server According to Bob

MAY 19, 2019

SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. Description.

IoT 61

IoT Servers Development Cache 61

SQL Server According to Bob

DECEMBER 10, 2018

SQL Server Books Online documents Instant File Initialization and the associated security considerations. SQL Server performs the following API calls when creating or extending (growing) data and log files. If the file is a log file (LDF) SQL Server always writes a known pattern (other than zeros) to the allocated space.

Servers 40

Servers Speed Database Software Engineering 40

SQL Server According to Bob

DECEMBER 31, 2018

How It Works: XEvent Output and Visualization SQL Server Management Studio Provides–“XE Profiler” Use the SSMS XEvent Profiler. Using SQL Server Management Studio (SSMS) and storing the events in a table requires reading the events, streaming to table storage followed by an order by event sequence query. TSQL Sample Session.

Efficiency 40

Efficiency Code Servers Cache 40