Alex Russell

AUGUST 30, 2021

Does Apple restrict, in any way, the ability of competing web browsers to deploy their own web browsing engines when running on Apple's operating system? Anyone who cares to download and fork the code can do so. This process can be messy and slow, but it never creates a political blockage for developing new capabilities for the web.

Engineering 98

Engineering Open Source Website Operating System 98

SQL Performance

MARCH 15, 2021

In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. Since SQL Server 2012 (and, to a much lesser extent, since SQL Server 2008), the most complete and flexible solution for monitoring events on a SQL Server instance has been Extended Events. Afraid of Extended Events?

Servers 64

Servers Azure Best Practices Monitoring 64

SQL Performance

MAY 1, 2020

I was a bit perplexed by this issue, since the system was certainly no slouch — plenty of cores, 3TB of memory, and XtremIO storage. Still, if you stack a bunch of high-transaction databases on there, checkpoint processing can get pretty sluggish. If you have instances running older versions like SQL Server 2008 R2 (I found one!),

C++ 58

C++ Database Servers Storage 58

John McCalpin

APRIL 2, 2020

The presentation discusses a family of simple performance models that I developed over the last 20 years — originally in support of processor and system design at SGI (1996-1999), IBM (1999-2005), and AMD (2006-2008), but more recently in support of system procurements at The Texas Advanced Computing Center (TACC) (2009-present).

Benchmarking 59

Benchmarking Performance Latency Architecture 59

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. The ReportServer and ReportServerTempDB databases are SQL Server databases and should be part of a regular backup process, just like other user databases. Unlike the system database tempdb, ReportServerTempDB is not recreated at startup. General Tuning.

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

SEPTEMBER 6, 2022

I happen to be using SQL Server 2019 CU16 but the details I’ll describe haven’t materially changed since partition level lock escalation was added to SQL Server 2008. System locks also count, but these are rarely held for long and aren’t associated with the user transaction. Let’s look at some examples using a fresh database.

Database 98

Database Storage Testing Servers 98

SQL Performance

MARCH 17, 2020

It comes set to SQL Server 2008 compatibility (level 100), but we will start with a more modern setting of SQL Server 2017 (level 140): ALTER DATABASE StackOverflow2013 SET COMPATIBILITY_LEVEL = 140 ; The tests were performed on my laptop using SQL Server 2019 CU 2. The Sort only has 19 rows to process, so it consumes only 1ms or so.

Servers 86

Servers Tuning Database Efficiency 86

Randon ASCII

FEBRUARY 25, 2018

Now we have a problem statement that we can reason about: why are large chunks of our code segment filled with zeroes? This command compares the code bytes in the crash dump (some of them are saved in the crash dump, just in case) against those on disk. In this case it said that 9322 bytes in the code in the crash dump were wrong.

Programming 79

Programming Hardware Cache Code 79

O'Reilly Software

OCTOBER 23, 2018

Technology systems are difficult to wrangle. Our systems grow in accidental complexity and complication over time. The product management team states what must be done to solve the problem, and the architect describes how to realize that vision in a system. To do so, we borrow metaphors from roles in other industries.

Strategy 100

Strategy Architecture Technology Technology 100

Brendan Gregg

SEPTEMBER 5, 2017

What follows are topics that may be of interest to anyone looking to migrate their systems and skillset: scan these to find topics that interest you. ## ZFS ZFS is available for Linux via the [zfsonlinux] and [OpenZFS] projects, and more recently was included in Canonical's Ubuntu Linux distribution: Ubuntu Xenial 16.04 LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

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. There are people behind the systems to which we're bound today. Why not put them back on the payroll?

Strategy 40

Strategy Java Code Systems 40

SQL Performance

APRIL 26, 2019

NOTE : This process is not officially supported by SentryOne. Do not expect the data to start flowing into the tables immediately; this will take time to make its way through the system. You will need to schedule this procedure to run on a time schedule that stays ahead of the SentryOne purge process.

Azure 40

Azure Database Metrics Servers 40

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. The process to enable this for a database is described in our documentation. And we state in the documentation the following regarding tempdb: Transparent Data Encryption and the tempdb System Database.

Servers 40

Servers Database Azure Cache 40

Smashing Magazine

AUGUST 20, 2021

However, unlike the early days of the web, static sites are no longer limited to developers working in a code editor. During the 90s, we saw two content management systems for static sites — Microsoft FrontPage in 1996 and Macromedia Dreamweaver in 1997. The benefit of doing this is the entire site’s source code can live in Git.

Ecommerce 139

Ecommerce Website Government Internet 139

O'Reilly

JULY 25, 2023

If you’re reading this, chances are you’ve played around with using AI tools like ChatGPT or GitHub Copilot to write code for you. So far I’ve read a gazillion blog posts about people’s experiences with these AI coding assistance tools. And if I switch tabs to view a paper from 2008, then a song from 2008 could start up.

Programming 98

Programming Code Design Benchmarking 98

SQL Server According to Bob

JANUARY 11, 2020

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities. 9501 x.x.x.100

Network 40

Network Servers Processing Software Engineering 40

O'Reilly

SEPTEMBER 19, 2023

” Each step has been a twist on “what if we could write code to interact with a tamper-resistant ledger in real-time?” Mental contortions led to code contortions led to frustration. Similarly, Monte Carlo simulations can help us spot trends and outliers in potential outcomes of a process.

Hardware 99

Hardware Storage Big Data Blockchain 99

The Netflix TechBlog

AUGUST 29, 2023

A brief history of IPC at Netflix Netflix was early to the cloud, particularly for large-scale companies: we began the migration in 2008, and by 2010, Netflix streaming was fully run on AWS. For Inter-Process Communication (IPC) between services, we needed the rich feature set that a mid-tier load balancer typically provides.

Traffic 220

Traffic Latency Cloud C++ 220