2017, Code and Software Engineering - Technology Performance Pulse

SQL Server 2017 Improved Resource Usage On Smaller Machines

SQL Server According to Bob

MARCH 18, 2018

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. Studying the code I found that the ‘default max worker threads’ calculation did not take into account the RAM on the system. For SQL Server 2017 CU4 the small environment threshold is 2GB.

Servers

Servers Best Practices Software Engineering Operating System

Autonomous Cloud Enablement aka Scaling NoOps via Self-Service

Dynatrace

FEBRUARY 6, 2020

We first brought our DevOps story to life at Perform 2017 when our CTO & Founder Bernd Greifeneder, DevOps Lead Anita Engleder and I went on stage. We talked about the cultural and process changes in order to follow through on Bernd’s requirement of “ 1 hour Code to Production !”.

Cloud

Cloud DevOps Engineering Speed

Watchman: monitoring dependency conflicts for Python library ecosystem

The Morning Paper

SEPTEMBER 20, 2020

Adding a direct dependency to pin a version, even when it’s not truly a direct dependency of the project (another code smell!). The authors backtested Watchman by replaying the evolution history of all libraries on PyPI from the 1st January 2017 to the 30th June 2019.

Monitoring

Monitoring Java C++ Strategy

World’s Top Web Performance Leaders To Watch

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. Rick Byers. Rick Byers. Most recently, he launched a fantastic new HTML5 Mastery… course.

Performance

Performance Education Google Website

SQL Server on Linux: An LLDB Debugging Tale

SQL Server According to Bob

JANUARY 29, 2017

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

Servers Programming Media Open Source

SQL Server on Linux: How is Delete-On-Close Handled

SQL Server According to Bob

JULY 31, 2018

I changed the code to call unlink after open completes preventing new access to the file. Bob Dorr – Principal Software Engineer SQL Server. 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.

Servers

Servers Software Engineering Systems Monitoring

Architectural Myopia

ACM Sigarch

FEBRUARY 23, 2018

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.

Architecture

Architecture Cache Hardware Virtualization

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

SQL Server According to Bob

JANUARY 28, 2018

SQL Server also supports XA based transactions but has no code in the SQL Server engine to engage in XA transactions. MSDTC can also be used as the XA TM if so desired (see example code at end of this post.). This means there are no DTC components available for SQL Server 2017 on Linux.

Servers

Servers Azure Engineering Java

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

SQL Server According to Bob

DECEMBER 18, 2018

Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be Microsoft SQL Server Database Engine Input/Output Requirements.

Servers

Servers Media Cache Storage

Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

SQL Server According to Bob

DECEMBER 31, 2018

The sample code is provided “as is” and any express or implied warranties, including the implied warranties of merchantability and fitness for a particular purpose, are disclaimed. .</param> Bob Dorr – Principal Software Engineer SQL Server. null)) { components.Dispose(); } base.Dispose(disposing); }.

Efficiency

Efficiency Code Servers Cache

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

SQL Server According to Bob

MAY 19, 2019

As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. The reduction effort started when we shipped SQL Server 2017 ( [link].) Engineering Rigor. There are a bunch of folks with compiler, linker, SQL Server code, testing and other disciplines who provided input.

IoT

IoT Servers Development Cache

PlanAlyzer: assessing threats to the validity of online experiments

The Morning Paper

NOVEMBER 21, 2019

And in your application code you would interact with PlanOut like this: my_exp = MyExperiment(userid=42) color = my_exp.get('button_color') text = my_exp.get('button_text'). Causal sufficiency errors. Allowing an unrecorded variable to bias treatment assignment§. Analysing PlanOut experiments at Facebook.

Programming

Programming Internet Internet Design

The Digital Twin: A Foundational Concept for Stateful Stream Processing

ScaleOut Software

MAY 4, 2018

Michigan) in 2002 for use in product life cycle management, it was recently popularized for IoT by Gartner in a 2017 report. Analytics methods can range from simple sequential code to machine learning algorithms or rules engines. The answer to this challenge may be found in the digital twin model.

Processing

Processing IoT Programming Software Engineering

The Digital Twin: A Foundational Concept for Stateful Stream Processing

ScaleOut Software

MAY 4, 2018

Michigan) in 2002 for use in product life cycle management, it was recently popularized for IoT by Gartner in a 2017 report. Analytics methods can range from simple sequential code to machine learning algorithms or rules engines. The answer to this challenge may be found in the digital twin model.

Processing

Processing IoT Programming Software Engineering

Technology Performance Pulse

SQL Server 2017 Improved Resource Usage On Smaller Machines

Autonomous Cloud Enablement aka Scaling NoOps via Self-Service

Trending Sources

Watchman: monitoring dependency conflicts for Python library ecosystem

World’s Top Web Performance Leaders To Watch

SQL Server on Linux: An LLDB Debugging Tale

SQL Server on Linux: How is Delete-On-Close Handled

Architectural Myopia

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

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

Viewing and Sorting XEvents Efficiently (Code Samples) – XEProfiler

SQL Server on IoT Edge and Developer Machines – Smaller Footprint

PlanAlyzer: assessing threats to the validity of online experiments

The Digital Twin: A Foundational Concept for Stateful Stream Processing

The Digital Twin: A Foundational Concept for Stateful Stream Processing

Stay Connected