DZone

FEBRUARY 12, 2024

Poorly optimized queries can lead to slow response times and increased load on the database server, negatively impacting user experience and system performance. This article explores strategies to optimize complex MySQL queries for efficient data retrieval from large datasets, ensuring quick and reliable access to information.

Performance 161

Performance Database Strategy Efficiency 161

SQL Performance

SEPTEMBER 21, 2022

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. Querying the current session’s state of session options with the @@OPTIONS function.

Servers 122

Servers C++ Code Cache 122

SQL Performance

JULY 8, 2021

I want to talk about UI design choices that lead to data access patterns that are awkward to implement using SQL Server. It’s also a good way to not overwhelm the database servers … usually. Meanwhile, the search results are missing articles that only mention Algebra or Trigonometry. Sort By Column. Paged Results.

Design 92

Design Software Architecture Database Servers 92

Smashing Magazine

AUGUST 5, 2021

Frustrating Design Patterns: Disabled Buttons. Frustrating Design Patterns: Disabled Buttons. After all, as designers and developers, we want to make it more difficult for our users to make mistakes. We want to ensure that the input is perfectly correct before the data is even sent to the server. Part Of: Design Patterns.

Design 145

Design Transportation Code Systems 145

Smashing Magazine

MARCH 2, 2020

Inspired Design Decisions: Neville Brody Design Cannot Remain Neutral. Inspired Design Decisions: Neville Brody Design Cannot Remain Neutral. Local bands designed their own publicity and the mostly two-colour artwork was edgy and unpolished. Previously On “Inspired Design Decisions”. Andrew Clarke.

Design 102

Design Media Testing Entertainment 102

SQL Shack

OCTOBER 14, 2020

In this article, we will learn the SQL Server clustered index concept and some internal details. Indexes are the database objects that accelerate the performance of data accessing when are designed properly.

Servers 86

Servers Database Design Performance 86

SQL Shack

APRIL 21, 2021

This article will describe the effect of SQL Server foreign keys on query plans which are created by the query optimizer. Introduction Foreign keys are used to enforce the referential integrity between the data of the two tables and are frequently used in relational database designs.

Servers 71

Servers Database Design Performance 71

Smashing Magazine

MAY 16, 2022

Rethinking Server-Timing As A Critical Monitoring Tool. Rethinking Server-Timing As A Critical Monitoring Tool. In the world of HTTP Headers, there is one header that I believe deserves more air-time and that is the Server-Timing header. Setting Server-Timing. Sean Roberts. 2022-05-16T10:00:00+00:00.

Servers 93

Servers Monitoring Cache Network 93

Scalegrid

MARCH 8, 2024

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. Use the ‘–log-bin’ option to designate a base name for the binary log files.

Database 162

Database Strategy Servers Best Practices 162

SQL Shack

JUNE 25, 2021

In this article, we will focus on one major SQL Server performance issue that we may experience during heavy data insertion in a table. Introduction SQL Server allocates some memory from the operating system, and this is because it is designed to do all read and modification operations in memory instead of on disk.

Tuning 64

Tuning Servers Performance Operating System 64

Percona

APRIL 17, 2023

It is common to see a value of “ 0″ ( or sometimes “10” ) on database servers, telling the kernel to prefer to swap to memory for better response times. The swap issue is explained in the excellent article by Jeremy Cole at the Swap Insanity and NUMA Architecture.

Best Practices 52

Best Practices Design Tuning Database 52

SQL Shack

FEBRUARY 12, 2020

This is in continuation of the previous articles How to monitor internal data structures of SQL Server In-Memory database objects and SQL Server In-Memory database internal memory structure monitoring. This article describes the concepts of In-memory-optimization and design principles.

Servers 68

Servers Database Monitoring Design 68

Scalegrid

MARCH 28, 2024

Introduction Caching serves a dual purpose in web development – speeding up client requests and reducing server load. This article will explore how they handle data storage and scalability, perform in different scenarios, and, most importantly, how these factors influence your choice. Data transfer technology.

Cache 130

Cache Storage Scalability Architecture 130

Scalegrid

MAY 13, 2020

It can scale towards a multi-petabyte level data workload without a single issue, and it allows access to a cluster of powerful servers that will work together within a single SQL interface where you can view all of the data. Greenplum uses an MPP database design that can help you develop a scalable, high performance deployment.

Big Data 321

Big Data Database Artificial Intelligence Open Source 321

Dynatrace

JANUARY 17, 2024

But as a recent Forbes Tech Council article notes, using increasingly more AI and running more data computations comes with costs. Cloud-based AI enables organizations to run AI in the cloud without the hassle of managing, provisioning, or housing servers. Continuously monitor AI models’ performance.

Strategy 230

Strategy Artificial Intelligence Storage Cloud 230

Smashing Magazine

JUNE 26, 2019

What Web Designers Can Do To Speed Up Mobile Websites. What Web Designers Can Do To Speed Up Mobile Websites. I recently wrote a blog post for a web designer client about page speed and why it matters. However, their focus has always been on making a great-looking and effective design. Suzanne Scacca.

Website 110

Website Speed Mobile Design 110

SQL Performance

OCTOBER 7, 2020

For more background on these performance spools see my prior article. With those out of the way, this article is exclusively about Sorts and when they can rewind. The Sort operator’s rewind behaviour may seem strange, but it has been this way from (at least) SQL Server 2000 to SQL Server 2019 inclusive (as well as Azure SQL Database).

Servers 106

Servers Cache Azure Performance 106

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. Redis Server: 5.07, x86/64. MongoDB server: 4.4.2, BangDB server: 2.0.0, Author & founder of BangDB. About YCSB. YugabyteDB:2.5.0,

Benchmarking 308

Benchmarking Latency C++ Database 308

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. You will still have to maintain your operating system, SQL Server and databases just like you would in an on-premises scenario.

Azure 72

Azure Virtualization Servers Storage 72

SQL Shack

JULY 2, 2019

Index strategies overview This article is about techniques for optimizing the SQL Server indexes strategy. It is an appendix of the SQL index overview and strategy article in which I covered different areas like what indexes actually do, how to create them, and I briefly mentioned some index design guidelines.

Strategy 51

Strategy Servers Design Performance 51

Smashing Magazine

SEPTEMBER 5, 2019

Inspired Design Decisions: Alexey Brodovitch. Inspired Design Decisions: Alexey Brodovitch. Before writing Art Direction for the Web , I began to study Alexey Brodovitch when I became fascinated by editorial and magazine design. This book will make a fabulous addition to your design collection. Andrew Clarke.

Design 79

Design Media Website Development 79

Smashing Magazine

JULY 18, 2022

If you think that static rendering is limited to generic, public content that is the same for every user of your website, you should definitely read this article. Segmented Rendering is a new pattern for the Jamstack that lets you personalize content statically, without any sort of client-side rendering or per-request Server-Side Rendering.

Cache 115

Cache Website Energy Servers 115

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. This article will cover many areas that database administrators need to be aware of in order to properly license, recover, and tune a Reporting Services installation.

Tuning 67

Tuning Servers Database Best Practices 67

O'Reilly Software

DECEMBER 28, 2017

Learn how to properly design RESTful APIs communication with clients, accounting for request structure, authentication, and caching. This series of articles shows you how to derive an easy-to-use, robust, efficient API to serve users on the web or on mobile devices. We are using the principles of RESTful architecture over HTTP.

Servers 83

Servers Cache Mobile Architecture 83

SQL Shack

OCTOBER 29, 2020

In this article, we will uncover some secrets about the SQL Server tempdb database. Tempdb is a system database and it is used for various internal and user operations. Besides this, the tempdb has many unique characteristics, unlike the other databases.

Database 63

Database Servers Systems Design 63

SQL Shack

AUGUST 8, 2019

This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups. Introduction SQL Server Always On is a flexible design solution to provide high availability (HA) and disaster recovery (DR).

Availability 55

Availability Servers Design 55

Dynatrace

JULY 11, 2023

What the software has been designed to log is what we get. When exploiting the vulnerability, attackers can gain remote code injection capabilities in the MOVEit server and modify or steal sensitive data from its database. The problem with the IIS server access logs was the headers. Just ask your Dynatrace account rep.

Database 166

Database Government Games Servers 166

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward.

Servers 63

Servers Database Testing Efficiency 63

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. Or even on a plane.

Performance 110

Performance Latency Cache Virtualization 110

CSS Wizardry

MAY 31, 2019

A classic example is jQuery, that we might link to like so: There are a number of perceived benefits to doing this, but my aim later in this article is to either debunk these claims, or show how other costs vastly outweigh them. I won’t go into too much detail in this post, because I have a whole article. It’s convenient.

Cache 274

Cache Latency Infrastructure Website 274

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. Compared to MySQL 5.7,

Servers 109

Servers Storage Database Open Source 109

Scalegrid

JANUARY 8, 2024

This article delves into the specifics of how AI optimizes cloud efficiency, ensures scalability, and reinforces security, providing a glimpse at its transformative role without giving away extensive details. Meeting Business Demands with Hybrid Cloud A range of business demands can be met by the design of hybrid cloud solutions.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Dynatrace

NOVEMBER 23, 2020

Kubernetes Dashboard as a part of a comprehensive monitoring solution This article introduces the key building blocks to consider when designing your Kubernetes monitoring solution. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 163

Virtualization Infrastructure Monitoring Cloud 163

Percona

AUGUST 22, 2023

This blog article will examine shared attributes of high availability (HA) and fault tolerance (FT). For example, in a server cluster, multiple servers are used to host the same application so that if one server fails, the application can continue to run on the other servers. there cannot be high availability.

Availability 78

Availability Hardware Open Source Database 78

The Netflix TechBlog

JUNE 25, 2021

Browsing your accessible clusters in different environments and regions Schema Designer Writing CREATE TABLE statements can be an intimidating experience for new Cassandra users. So to help lower the intimidation factor, we built a schema designer that lets users drag and drop their way to a new table. The server is a Node.js

Metrics 152

Metrics Best Practices Strategy Design 152

Scalegrid

JANUARY 12, 2024

This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure. These include popular technologies such as web servers and web applications, along with advanced solutions like distributed data stores and containerized microservices.

Cloud 130

Cloud Virtualization Storage Efficiency 130

The Netflix TechBlog

APRIL 20, 2020

The TLS protocol is designed to provide a secure channel between two peers by providing tools and methods to achieve the above properties. handshake was not designed to protect the integrity of the entire handshake. now requires only one round trip, with a simplified design and with all weak and vulnerable algorithms removed.

Network 237

Network Media Transportation Traffic 237