Adrian Cockcroft

DECEMBER 8, 2020

Imported from a Blogger post I wrote in 2008. Code shared on GitHub For some reason I seem to find time to write code in R when I’m on an airplane. The last two trips I made resulted in significant enhancements and debugging of the code for my headroom plot. The set of data is now split into ranges and color coded.

C++ 52

C++ Code 52

The Agile Manager

JUNE 30, 2020

A lot of this is a function of the fact that despite the dot-com bust and the 2008 financial crisis, the first two decades of the 2000s have been characterized by overall global economic growth. Is the code written to a degree of simplicity that it is comprehensively testable, and easily maintainable by other developers?

Government 52

Government Healthcare Programming Software 52

SQL Performance

MARCH 15, 2021

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? It is high time we all ditch Profiler and embrace the present.

Servers 64

Servers Azure Best Practices Monitoring 64

Testsigma

FEBRUARY 9, 2022

The simplest of them is that open-source projects are those whose source code is available to read and reuse in other projects. You can just navigate to their repository, open the files, analyze the code, change according to yourself and reuse it as per your requirement. . Contribution to open-source is not equal to coding.

Open Source 52

Open Source Code Software Software 52

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. In 2008, Sun Microsystems acquired MySQL AB, and then, in 2010, Oracle bought Sun Microsystems. What is MariaDB? release based on MySQL 5.5,

Open Source 52

Open Source Servers Storage Scalability 52

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. Notice the lack of a check at 1250 due to the code quirk I mentioned. The code in HeapDataSetSession::EscalateLocks next calls sqlmin!IsEscalationPossible

Database 98

Database Storage Testing Servers 98

SQL Server According to Bob

JUNE 3, 2016

“SQL Server 2016 running on the same hardware as SQL Server 2014, 2012, 2008, 2008 R2 or 2005 uses fewer resources and executes a wide range of workloads faster. For example, the improved compression capabilities applied to AlwaysOn are being tested and evaluated for use by the Backup/Restore code line. Table of Contents.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

Sutter's Mill

SEPTEMBER 24, 2010

5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007). 6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 13 The Many Faces of Deadlock (Aug 2008).

Programming 41

Programming Website Scalability Code 41

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

Sutter's Mill

AUGUST 27, 2010

5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007). 6 Use Lock Hierarchies to Avoid Deadlock (Jan 2008). Feb 2008). 8 Going Superlinear (Mar 2008). 9 Super Linearity and the Bigger Machine (Apr 2008). 10 Interrupt Politely (May 2008). 13 The Many Faces of Deadlock (Aug 2008).

Website 40

Website Scalability Code Design 40

Sutter's Mill

JULY 12, 2010

From the article: … Active objects dramatically improve our ability to reason about our thread’s code and operation by giving us higher-level abstractions and idioms that raise the semantic level of our program and let us express our intent more directly. 5 Avoid Calling Unknown Code While Inside a Critical Section (Dec 2007).

C++ 40

C++ Java Website Programming 40

SQL Performance

MAY 1, 2020

If you have instances running older versions like SQL Server 2008 R2 (I found one!), You could also not be lazy like me, and run the code in Powershell instead of a CMS query window, where you could easily filter out databases given any number of properties before ever hitting compile-time issues.

C++ 58

C++ Database Servers Storage 58

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 code may be easier to read and understand than the recursive CTE.

Servers 86

Servers Tuning Database Storage 86

Dean Hume

APRIL 24, 2018

CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). I already had Google Analytics installed, so I added the following code to each page. Unfortunately, this also means that the more the CPU usage correlates to power consumption.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). I already had Google Analytics installed, so I added the following code to each page. Unfortunately, this also means that the more the CPU usage correlates to power consumption.

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). I already had Google Analytics installed, so I added the following code to each page. Unfortunately, this also means that the more the CPU usage correlates to power consumption.

Energy 40

Energy Cache Traffic Website 40

All Things Distributed

MAY 8, 2012

Using the AWS Toolkit for Visual Studio , you can now deploy your.NET applications to AWS Elastic Beanstalk directly from your Visual Studio environment without changing any code. Amazon RDS currently supports SQL Server 2008 R2 and plans to add support for SQL Server 2012 later this year.

Cloud 116

Cloud Development AWS Servers 116

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

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

Randon ASCII

FEBRUARY 11, 2018

In hindsight it’s obvious that these zombies were caused by a trivial user-space coding bug. If you do care – if you want to wait for the process to quit – WaitForSingleObject(hProcess, INFINITE); – or query its exit code – GetExitCodeProcess(hProcess, &exitCode); – then you need to remember to close the handles after that.

Processing 72

Processing Programming Code Systems 72

SQL Performance

AUGUST 27, 2019

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. This is the second generation EPYC server processor that uses the same Zen 2 architecture as the AMD Ryzen 3000 Series desktop processors. Figure 4: AMD EPYC Roadmap.

Servers 52

Servers Benchmarking Architecture Virtualization 52

Alex Russell

AUGUST 30, 2021

Anyone who cares to download and fork the code can do so. From 2008 to 2013, the Chrome project was based on WebKit, and a growing team of Chrome engineers began to contribute heavily "upstream." The signal to parties who might contribute code for these features could scarcely be clearer: your patch is unlikely to be accepted.

Engineering 98

Engineering Open Source Website Operating System 98

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. To tune for a slow report, that usually means you need to create indexes for that specific report or tune the code within the report. In the early days of SSRS, a requirement was to also install and configure Internet Information Services (IIS).

Tuning 67

Tuning Servers Database Best Practices 67

SQL Performance

MAY 29, 2019

It can be activated from SQL Server 2008 to 2014 inclusive using documented trace flag 610. The FastLoadContext code path adds support for minimally-logged and concurrent bulk load on: Empty and non-empty clustered b-tree indexes. There are two main code paths that can set DMLRequestSort to true for index inserts. The sqllang!CUpdUtil::FOptimizeInsert

Cache 64

Cache Testing Servers Code 64

SQL Performance

OCTOBER 29, 2019

Borrowing and adapting code from a previous post, Examining the Performance Impact of an Adhoc Workload , we will first create two stored procedures. ORDER BY [ Short Query Text ] ; The query_hash was added in SQL Server 2008, and is based on the tree of the logical operators generated by the Query Optimizer for the statement text.

C++ 74

C++ Database Servers Tuning 74

Tim Kadlec

JULY 31, 2013

When he first gave the presentation in 2008, he was working at this massive company called Yahoo! And so it’s important to continually invest in stability, in strong infrastructure, in stable code, so that we have that strong platform to stand on as the next thing happens. That was 2008.

Google 40

Google Website Availability Games 40

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

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

SQL Performance

APRIL 26, 2019

I used a block of code from existing SentryOne procedures to determine the rollup table for each counter. I could have hard-coded the current names of the tables, however, by using the SentryOne method, it should be forward compatible with any changes to the built-in rollup processes. Procedure: dbo.Custom_ExportDataForDTUCalculator.

Azure 40

Azure Database Metrics Servers 40

Dynatrace

SEPTEMBER 26, 2019

We talked about how we’re investing in better tooling to automatically scan code as part of the build process, e.g. using tools like Sonar and Barbara said, “Hey, what about this blog post you wanted to write? As far as I remember, Atlassian’s JIRA had already been used back when I started at Dynatrace in 2008. I have a new idea.

Education 35

Education Programming DevOps Processing 35

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. I used the k command to dump out the call stack to see where in the code it hit this API call (not the full stack but enough to see the story). I then verified my findings in the source code.

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. Piecing together a website using a WYSIWYG editor and seeing the code it generated was a fascinating and educational experience that sparked an initial interest in web design. Editing a blog post in MovableType 2.0

Ecommerce 139

Ecommerce Website Government Internet 139

The Agile Manager

OCTOBER 31, 2013

The other is that it is primarily concerned with compliance with protocols, procedures or regulations, such as ITIL or Sarbanes-Oxley or even coding and architectural standards. As the financial crisis hit in 2008, it became glaringly obvious that few bank directors had any detailed understanding of either banking or risk.)

Government 58

Government Strategy Technology Technology 58

Brendan Gregg

SEPTEMBER 5, 2017

It uses a Solaris Porting Layer (SPL) to provide a Solaris-kernel interface on Linux, so that unmodified ZFS code can execute. There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). LTS (April 2016).

Virtualization 76

Virtualization AWS Engineering Hardware 76

Tim Kadlec

DECEMBER 2, 2008

The intent behind CSSDOC is to provide a standardized way of commenting CSS making use of the very well known DocBlock way of commenting source-code. DocBlock is a very common form of documenting source code in programming that has proven to be very popular for both PHP and Javascript.

Programming 40

Programming Code Availability Testing 40

O'Reilly Software

OCTOBER 23, 2018

In 2008 or so, when data scientist emerged as a job title, it was widely ridiculed as a nonjob: the thought that people who just worked with data could be scientists, or employ the rigors of their time-honored methods, was literally laughable in many circles. To do so, we borrow metaphors from roles in other industries.

Strategy 100

Strategy Architecture Technology Technology 100

Sutter's Mill

AUGUST 13, 2023

1:00 Intro and roadmap for the talk 2:28 1. cppfront recap 2:35 – green-field experiments are great; but cppfront is about refreshing C++ itself 3:28 – “when I say compatibility.

C++ 89

C++ Efficiency Design Virtualization 89