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

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. 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 1, 2020

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!), And none of these FlushCache messages were ever paired with the 15 second I/O warnings in the error log.

C++ 58

C++ Database Servers Storage 58

Dynatrace

JULY 24, 2023

We will also explore the evolution of DevOps automation and the significance of data-driven answers in unlocking streamlined, automated DevOps and SRE processes. Business process automation Business process automation is the foundation for improving operational efficiency. The absence of these details hampers decision-making.

DevOps 222

DevOps Traffic Efficiency Servers 222

Dynatrace

SEPTEMBER 26, 2019

Over the last few years we’ve talked a lot about how at Dynatrace we have changed our development processes in order to deploy new feature releases with every sprint, as well as providing a fast-lane to production that allows us to deploy important updates to our customers within an hour. Dynatrace news. I have a new idea.

Education 35

Education Programming Processing DevOps 35

SQL Performance

APRIL 26, 2019

NOTE : This process is not officially supported by SentryOne. You will need to schedule this procedure to run on a time schedule that stays ahead of the SentryOne purge process. Because the purge process in SentryOne can vary based on metric, you could end up with rows in your copy that do not contain all 4 counters for a time period.

Azure 40

Azure Database Metrics Servers 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. The operating model: processes and how your company conducts its business.

Strategy 100

Strategy Architecture Technology Technology 100

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. I then verified my findings in the source code. First, let’s explain the mystery in more detail. The –y parameter is the symbol path.

Servers 40

Servers Database Azure Cache 40

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

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

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

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

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

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

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

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." 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

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

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

The new column store engine and query processing technology could increase query performance up to 100X and the new In-memory OLTP engine can process 1.25million batches/sec on a single 4 socket server, which is more than 3X of SQL 2014. “ – Rohan Kumar, Director of SQL Software Engineering. Table of Contents.

Hardware 40

Hardware Software Engineering Transportation Scalability 40

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

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

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. I remember going through this with CSS.

Google 40

Google Website Hardware Games 40

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

The Agile Manager

JUNE 29, 2008

This content is derived from material presented in a ThoughtWorks-sponsored webcast in June 2008. For example, a team that infrequently performs its build manually today will not be able to cope with a build that automatically fires with each code commit and fails if code quality levels are below a specified threshold.

Code 45

Code Availability Processing Performance 45