SQL Server According to Bob

JUNE 3, 2016

SQL Server 2016 ‘It Just Runs Faster’ A bold statement that any SQL Server professional can stand behind with confidence. Try SQL Server 2016 Today. The SQL Server Development team tasked several individuals with scalability improvements and real world testing patterns. – [link].

Hardware 40

Hardware Software Engineering Transportation Scalability 40

SQL Server According to Bob

JUNE 3, 2016

Internally DBCC CHECK* uses a page scanning coordinator design (MultiObjectScanner.) SQL Server 2016 changes the internal design to (CheckScanner), applying no lock semantics and a design similar to those used with In-Memory Optimized (Hekaton) objects, allowing DBCC operations to scale far better than previous releases.

Hardware 40

Hardware Servers Cache Software Engineering 40

Percona

FEBRUARY 2, 2023

The only real limitation is that one can only publish tables from a read-write server such as the PRIMARY. PGDATA on an Ubuntu install /var/lib/postgresql/15/main/pg_replslot/pg3 └── state However, the caveat is that it requires a full server restart to the REPLICA, in addition to being promoted, before the logical slot is fully active.

Open Source 117

Open Source Games Tuning Servers 117

Alex Russell

MARCH 6, 2021

Back in 2016, I gave a talk outlining the causes and effects of the terrible performance of web apps built using popular tools on the fastest-growing device segment: low-end to mid-range Android phones. In 2016, Jio swept over the subcontinent like a monsoon dropping a torrent of 4G infrastructure and free data rather than rain.

Performance 127

Performance Network Mobile Metrics 127

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 103

Performance Latency Cache Virtualization 103

Percona

JANUARY 24, 2023

Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. Zstd can be chosen if the server load is not CPU bound because it can give us better compression at the expense of more CPU utilization.

Database 142

Database Benchmarking Open Source Latency 142

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 98

Programming Servers Database Open Source 98

SQL Server According to Bob

NOVEMBER 8, 2016

SQL Server 2016 Service Pack 1 (all SKUs) , in combination with Windows Server 2016 (All SKUs) or Windows 10 Client introduces non-volatile memory support for the tail of the log file (LDF) which can significantly increase transaction throughput. As the following diagram shows the SQL Server Log Cache is in memory.

Cache 40

Cache Servers Media Storage 40

SQL Server According to Bob

JULY 12, 2016

Trace flags 2562 and 2549 are documented in knowledgebase article: [link] and the blog post [link] highlights the SQL 2016 DBCC performance improvements. For SQL Server 2008, 2012 and 2014 the trace flag behavior remains the same. For SQL Server 2016 the trace flags are available but the behavior may be altered by the design changes.

Servers 40

Servers Design Engineering Database 40

SQL Performance

AUGUST 14, 2019

SQL Server 2016 introduces the batch-mode Window Aggregate operator, which removes the performance penalty part of the pitfall, but prior to SQL Server 2019 this operator is used only if you have a columnstore index present on the data. This would have resulted in quadratic, or N 2 , complexity.

Best Practices 108

Best Practices Servers Database Azure 108

SQL Performance

JUNE 9, 2021

With the first article on views, I want to start light, focusing on what a view is, using correct terminology, and compare design considerations of views with those of the previously discussed derived tables and CTEs. Like I did before, I’ll first focus on logical, or conceptual, aspects, and at a later point proceed to optimization aspects.

Database 140

Database Code Design Development 140

SQL Server According to Bob

JUNE 27, 2016

To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.

Servers 40

Servers Games Azure Testing 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 first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

O'Reilly

FEBRUARY 4, 2025

Suddenly, the user interface was made up of human-readable documents, shown in a browser with links that could in turn call programs on remote servers. Programs were designed and built by humans, not AI, but much of the work itself was done by special-purpose predecessors to todays general purpose AIs. No code became a buzzword.

Programming 145

Programming Google Infrastructure Internet 145

Smashing Magazine

JANUARY 15, 2019

In 2013, A List Apart published Sustainable Web Design by James Christie. So, apart from powering servers with renewable energy, what else can web developers do about climate change? This includes the work done by the server, the client and the intermediary communications networks that transmit data between the two.

Website Performance 78

Website Performance Website Energy Performance 78

Alex Russell

FEBRUARY 3, 2023

They did the opposite, doubling down, breathlessly announcing vapourware year after year to defer critical thinking about the fundamental errors in the design. "Server-Side Rendering", a.k.a. "SSR" " [ "islands" , "server components" , etc. ] The Steamed Hams of technology pitches.

Social Media 130

Social Media Website Technology Technology 130

Brendan Gregg

JULY 4, 2021

I summarized these topics and more as a plenary conference talk, including my own predictions (as a senior performance engineer) for the future of computing performance, with a focus on back-end servers.

Performance 52

Performance Latency Hardware Storage 52

Rigor

JANUARY 13, 2020

These are the bestsellers in the web performance field, including the good old Speed Up Your Site (2003) by Andy King; Steve Souders’ Even Faster Web Sites (2009) ; Ilya Grigorik’s High Performance Browser Networking (2013) ; Tammy Everts’ Time is Money (2016) ; and a handful of more recent publications. Responsive and Fast.

Performance 75

Performance Social Media Website Website Performance 75

SQL Server According to Bob

JANUARY 5, 2017

Last March I moved from 22 years in SQL Server support to the SQL Server development team, working on SQL Server on Linux project and reporting to Slava Oks. As Slava highlights in his recent blog post , he also contacted me in early 2015 to assist with supportability of SQL Server on Linux. Image Formats.

Servers 40

Servers Operating System C++ Software Engineering 40

SQL Performance

APRIL 20, 2021

This is the third in a five-part series taking a deep dive into the way SQL Server row mode parallel plans start executing. A reminder of the plan ( click to enlarge ): This is the first point in the process so far that an in-flight execution plan is available (SQL Server 2016 SP1 onward) in sys.dm_exec_query_statistics_xml.

C++ 98

C++ Processing Servers Cache 98

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory.

Performance 52

Performance Latency Cache Virtualization 52

SQL Performance

MAY 1, 2019

The summary rows for heap tables without indexes are the same in both documents (no changes for SQL Server 2016): An explicit TABLOCK hint is not the only way to meet the requirement for table-level locking. The inputs to this calculation are: The version of SQL Server. Target table row size. The Data Size Calculation.

Servers 47

Servers Database Testing Performance 47

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. Servers down or server health issues [APM]. Ultimately, the key to surviving a peak event is to have very good CDN cache designs.

Website 74

Website Cache Traffic Ecommerce 74

MachMetrics

JUNE 30, 2021

from wpostats, 2016 ). The factors that impact on LCP: Slow origin server response times Render-blocking JavaScript and CSS on page load Page Resource load times User side page rendering. Factors that impact on CLS: loading ads without a designated room. Role of web servers in page load time –.

Cache 78

Cache Speed Google Website 78

CSS - Tricks

APRIL 1, 2021

It begins with retrieving the HTML from the server and converting this into the Document Object Model (DOM). KB for desktops and 902 KB for mobile devices from 2016 to 2021. Ideally, that’s something you or a designer would do when initially making the assets. In fact, the median data transfer for images is 948.1

Cache 94

Cache Social Media Media Website 94

Alex Russell

MARCH 31, 2022

Every technical challenge in this design space is paired with an even more daunting governance problem. These privacy requirements put challenging constraints on the design of a shared cache. But the completeness constraint is far from our only design challenge. and SFTP -ing one's dependencies to the server are gone.

Cache 89

Cache Government Traffic Network 89

Smashing Magazine

JULY 6, 2021

With Luminary’s 21 years of experience in the digital space, my experience of 17 years in the CMS space as well as our focus on Headless since 2016, here are my two cents on what you should look out for. Things To Consider When Choosing A Headless CMS. Microservices architecture. Omnichannel. For content authors.

Cache 145

Cache Website Mobile Google 145

SQL Performance

APRIL 8, 2019

These AMD EPYC processors have a number of advantages for SQL Server workloads, as I will explain in this article. This 14nm first-generation AMD EPYC 7551 processor has 32 cores and 64 threads, and it works in one or two-socket servers. This makes it a good choice for many SQL Server workloads, especially DW workloads.

Azure 42

Azure Virtualization Storage Benchmarking 42

Alex Russell

MAY 9, 2022

Design: Performance is the gap between Figma mockups and the user experience of products for many, but not all , users. The extent to which a product performs well, the higher its likelihood of behaving in accordance to the approved design spec. miAi3020A9G #perfmatters 1 10:04 AM · Jul 7, 2016.

Performance 99

Performance Latency Metrics Engineering 99

Smashing Magazine

JANUARY 21, 2019

An API is the communication channel for an application to load data from the server. The term “component” is often used to refer both to functionality and design. Note : Brad Frost’s “ Atomic Design ” is a great methodology for identifying these common patterns and building a reusable design system. Large preview ).

Social Media 73

Social Media Database Media Website 73

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process.

Open Source 52

Open Source Servers Storage Scalability 52

Alex Russell

OCTOBER 22, 2017

Late-loading JavaScript can cause “server-side rendered” pages to fail in infuriating ways. The server sends it as a stream of bytes and when the browser encounters each of the sub-resources referenced in the document, it requests them. The true median device from 2016 sold at about ~$200 unlocked.

Performance 74

Performance Network Benchmarking Mobile 74

SQL Performance

SEPTEMBER 2, 2021

SQL Server 2016 brought us STRING_SPLIT , a native function that eliminates the need for many of the custom solutions we’ve needed before. I’ve written several articles about this function (and STRING_AGG, which arrived in SQL Server 2017) since this post was written: Performance Surprises and Assumptions : STRING_SPLIT().

C++ 46

C++ Servers Testing Performance 46

Enprowess

SEPTEMBER 28, 2021

React lacks MVC design. React developers introduced Inferno in 2016 as an experiment to examine whether or not a library can improve the battery, performance, and UX of mobile apps. You will get add-ons like server-side rendering, routing and more. The DOM structure is surrounded by Inferno for browser/server edits.

Open Source 52

Open Source Mobile Development Entertainment 52

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 265

Cache Latency Strategy Servers 265

Dynatrace

OCTOBER 28, 2021

In 2010, Netflix introduced a technology to switch production software instances off at random — like setting a monkey loose in a server room — to test how the cloud handled its services. Intelligence from chaos testing funnels back to developers who can implement design changes that make software more durable and improve production quality.

Engineering 264

Engineering Entertainment Cloud Infrastructure 264