Remove 2017 Remove Code Remove Servers Remove Software Engineering
article thumbnail

SQL Server 2017 Improved Resource Usage On Smaller Machines

SQL Server According to Bob

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. For SQL Server 2017 CU4 the small environment threshold is 2GB.

Servers 40
article thumbnail

How It Works: SQL Server DTC (MSDTC and XA Transactions)

SQL Server According to Bob

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40
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: How is Delete-On-Close Handled

SQL Server According to Bob

Update Oct 2018 – SQL Server 2019 CTP 2.0. SQL Server 2019 changes the DELTE On CLOSE behavior used on Linux installations. I changed the code to call unlink after open completes preventing new access to the file. Bob Dorr – Principal Software Engineer SQL Server. Restart the VM.

Servers 40
article thumbnail

SQL Server on Linux: An LLDB Debugging Tale

SQL Server According to Bob

Taking a closer look at the log and stepping though the LLDB code I found the read failure occurring because the memory address could not be located in the tracked VM map. The change is now under review so it can be added back to the LLDB code base. FEB 1, 2017 UPDATE – CHANGE ACCEPTED. 8917’ (x86_64) was loaded.

Servers 40
article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

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
article thumbnail

World’s Top Web Performance Leaders To Watch

Rigor

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.

article thumbnail

Architectural Myopia

ACM Sigarch

Richard Thaler won the 2017 Nobel prize in Economics for his work on Behavioral Economics. According to the article “ When Women Stopped Coding “, the percent of women in Computer Science 30 years ago was nearly twice what it is now. Hence the lack of women in our field.