J. Paul Reed

AUGUST 7, 2023

(It’s worth noting: the right end of the spectrum also covers the more… “exotic” action items, like “This was caused by a Windows-issue, so let’s migrate our entire self-run physical infrastructure to Linux and rewrite the entire code base.” In practice (and I’ve done this exercise with teams), this spectrum can provide useful insight.

Engineering 52

Engineering Hardware Games Infrastructure 52

SQL Performance

OCTOBER 9, 2019

In my examples I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. As an exercise, try solving this task with a pre-SQL Server 2017 compatible solution where you cannot use TRIM and TRANSLATE. EOMONTH has a second parameter.

C++ 111

C++ Database Servers Code 111

SQL Performance

JUNE 10, 2020

The relational model and the standard querying language that is based on it are supposed to deal only with the conceptual aspects of the data and leave the physical implementation details like storage, optimization, access and processing of the data to the database platform (the implementation ). Persistency.

C++ 93

C++ Database Servers Code 93

SQL Performance

JULY 1, 2021

Let's create a simple database with a few tables: CREATE DATABASE BadIdeas ; GO. Here is a query to help you track them down using the sys.columns catalog view, but you're on your own for any explicit references that might exist in your application code: SELECT [ Schema ] = s. USE BadIdeas ; GO. CREATE TABLE dbo.

C++ 58

C++ Database Servers Performance 58

All Things Distributed

SEPTEMBER 26, 2014

In October there will be an abundance of sessions, events, and coding activities focused on game and mobile app development. Topics include Introduction to AWS, Big Data, Compute & Networking, Architecture, Mobile & Gaming, Databases, Operations, Security, and more. What’s Happening at the AWS Loft. AWS Technical Bootcamps.

AWS 113

AWS Games Education Innovation 113

SQL Performance

JANUARY 11, 2021

We'd need to make it recompile, without adding hints to the query, turning on trace flags, or changing database settings. I've used sp_prepare less in my career than plan guides, and I wouldn't recommend using it for application code. (As How could we make sure the query made the right choice depending on the parameter?

Cache 59

Cache Tuning Database Performance 59

The Agile Manager

AUGUST 31, 2020

Decades of poor architecture guidelines and lax developer discipline resulted in the commercial-off-the-shelf components of an ERP becoming inseparable from the custom code built around it. Decades of upstream and downstream systems resulted in point-to-point and often database-level integrations to legacy systems.

Architecture 52

Architecture Code Strategy Programming 52

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. That is to ensure your database is encrypted at the file level. The process to enable this for a database is described in our documentation. What does encrypted mean at this point?

Servers 40

Servers Database Azure Cache 40

SQL Server According to Bob

FEBRUARY 10, 2019

This means we are reading database pages from the master, acquiring locks, and making calls to the domain controller (DC/KDC.). The lack of wait_info* events is revealing because if we are waiting for a database read, lock or preemptive, external call for more than 5 seconds an event would have been logged. wait_info*. Network Trace.

Servers 40

Servers Network Database Systems 40

The Agile Manager

SEPTEMBER 30, 2012

It's easy to assume that we're hiring competent developers who write high quality code, and most buyers don't know what to look for or how to look for technical quality. And there's no reason to accept technical specialization: we don't need to have mobile client developers as well as services developers and database developers.

Mobile 49

Mobile Code Java Software 49

Dynatrace

SEPTEMBER 20, 2019

Both use the same database back-end and app configuration. Let’s assume your team has just pushed new code and it passed pre-deployment testing. Step 5 — xMatters Slackbot pulls the on-call database. xMatters Slackbot pulls the on-call database. Step 1 — The Dynatrace Davis AI-engine identifies the root cause.

Systems 26

Systems Traffic DevOps Database 26

Percona

AUGUST 30, 2023

If a PostgreSQL user wants to change these values, they need to recompile the PostgreSQL from the source code. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope.

Database 99

Database Servers Open Source Tuning 99

Percona

AUGUST 8, 2023

Hardware considerations The first thing we have to consider here is the resources that the underlying host provides to the database. Global memory caches are static in size as they are defined solely by the configuration of the database itself. Does your traffic increase come with updated code changes that change the queries?

Traffic 87

Traffic Cache Monitoring Database 87

The Agile Manager

FEBRUARY 28, 2017

Tool 1: Dolly the Sheep Companies that are heavily rule-based - think insurance - eagerly moved their business rules into code. It was easy to move into code; it's just as easy to move it back into human-readable format. A clone of something extinct - our lost business knowledge - runs the risk of suffering severe defects.

Strategy 40

Strategy Java Code Systems 40

CSS Wizardry

NOVEMBER 3, 2020

I can see from the screenshot above that TTFB is my most stable metrics—no one page appears to have particularly expensive database queries or API calls on the back-end. The whole point of the exercise that follows is to allow me to move quickly, spotting patterns from afar, and not having to do any slow or meticulous work yet.

Speed 292

Speed Ecommerce Metrics Analytics 292

Dynatrace

DECEMBER 10, 2020

Change starts by thoroughly evaluating whether the current architecture, tools, and processes for configuration, infrastructure, code delivery pipelines, testing, and monitoring enable improved customer experience faster and with high quality or not. Constantly reinventing wheels with a “Not Invented Here” bias.

Strategy 177

Strategy Performance Logistics Monitoring 177

O'Reilly

JANUARY 17, 2023

Figuring out what kinds of problems are amenable to automation through code. So it behooves a software developer to spot what portions of human activity can be properly automated away through code, and then build that. Because if companies use code to automate business rules, they use ML/AI to automate decisions.

Tuning 130

Tuning Open Source AWS Software 130

Particular Software

SEPTEMBER 11, 2023

Now go rewrite all your code… we’ll wait…are you done yet? the mobile app) can be built using modern, cloud-based technology while still leveraging the tried-and-true code in the various legacy systems. It’s as if they’re saying, “Have you documented your system? Have you chosen a cloud provider? Do you have all the services in place?

Cloud 126

Cloud Systems Azure Airlines 126

The Agile Manager

NOVEMBER 26, 2008

User Interface, middle tier, server side, database, specialists in things like ERP systems) or by component (e.g., This means that lots of development tasks may be flagged as “complete” but they’re complete only by assertion of a developer, not by “fact” of somebody who has exercised the code from end-to-end. The QA tester?

Code 40

Code Servers Engineering Programming 40

Dynatrace

APRIL 21, 2022

Using high-fidelity metrics, logs, code-level tracing, and a dynamic topology map of your applications, Davis can identify the precise root cause and prioritize its business impact. Too much data requested from a database. Instead, it remains up to human experts to correlate and analyze the data in time-consuming war rooms.

Azure 187

Azure Monitoring Virtualization Metrics 187

O'Reilly

OCTOBER 19, 2021

If you peek under the hood of an ML-powered application, these days you will often find a repository of Python code. Let’s start by considering the job of a non-ML software engineer: writing traditional software deals with well-defined, narrowly-scoped inputs, which the engineer can exhaustively and cleanly model in the code.

DevOps 138

DevOps Software Engineering Infrastructure Open Source 138

SQL Performance

NOVEMBER 30, 2021

For each database that has pages in the buffer pool, there is a hash list of pages, in page ID order, that’s quickly searchable to determine whether a page is already in memory or whether a physical read has to be performed. And the more pages in memory for a database, the longer the scan would take. ) ; GO.

Efficiency 54

Efficiency Servers Database Cache 54

Dynatrace

JUNE 1, 2021

Causes can run the gamut — from coding errors to database slowdowns to hosting or network performance issues. Millions of lines of code comprise these apps, and they include hundreds of interconnected digital services and open-source solutions , and run in containerized environments hosted across multiple cloud services.

Monitoring 148

Monitoring Mobile Social Media Artificial Intelligence 148

Adrian Cockcroft

NOVEMBER 11, 2019

There are many possible failure modes, and each exercises a different aspect of resilience. Following the value chain from the business perspective, the first team is the product managers and developers who specify and build the unique code that makes up the business logic of the system. that are used across multiple applications.

Latency 52

Latency Engineering Systems Hardware 52

Adrian Cockcroft

NOVEMBER 11, 2019

There are many possible failure modes, and each exercises a different aspect of resilience. Following the value chain from the business perspective, the first team is the product managers and developers who specify and build the unique code that makes up the business logic of the system. that are used across multiple applications.

Latency 53

Latency Engineering Systems Hardware 53

SQL Performance

SEPTEMBER 25, 2020

So I wrote some PowerShell code to step through a procedure to see which other tokens were identified. Open Visual Studio Code (or your favorite PowerShell IDE) and save a new file called Test1.ps1. Copy this code, save, and then run or debug: # need to extract this DLL from latest sqlpackage; place it in same folder. # [link].

Code 42

Code C++ Database Servers 42

The Morning Paper

AUGUST 27, 2019

I am so pleased to see a database systems paper addressing the concerns of the application developer! A example class of application invariants is database integrity constraints. See Coordination avoidance in database systems for more details. Interactive checks for coordination avoidance Whittaker & Hellerstein et al.,

Programming 59

Programming Processing Database Systems 59

O'Reilly Software

MARCH 7, 2018

In addition to that, software is increasingly dependent on other software to provide its functionality, be it WebServices, HTTP APIs, databases, or even external devices such as sensors. HTTP, TCP, FTP, MQTT, JMS), databases (i.e., But each implementation is doing it differently, which makes interoperability hard. of ( Invoice.

Transportation 72

Transportation Java Programming Architecture 72

Strategic Tech

DECEMBER 12, 2019

We have to specify with great precision in code exactly what our business rules are, and the computer will apply them exactly as we tell it to. Defining Aggregate Boundaries Deciding that specific business operations should succeed or fail together sounds like a simple requirements gathering exercise. database transactions.

Healthcare 10

Healthcare Software Architecture Database Software 10

The Netflix TechBlog

MARCH 6, 2019

in Atlas , Netflix’s in-memory dimensional time series database. We parallelize rerun jobs with Titus , Netflix’s container management platform, which allows us to exercise many hundreds of replay files in minutes. MezzFS collects metrics on data throughput, download efficiency, resource usage, etc.

Media 214

Media Storage Processing Cache 214