Performance Resources

Enhancing SQL Server Security With AI-Driven Anomaly Detection

Learn how to detect, manage, and resolve orphaned users in SQL Server using advanced queries, best practices, and AI-driven security enhancements.

June 4, 2025

by Bhanuprakash Madupati

· 71,765 Views · 24 Likes

Master SQL Performance Optimization: Step-by-Step Techniques With Case Studies

Optimize SQL queries by using proper indexing, selecting necessary columns, optimizing joins, and minimizing subqueries to enhance database performance.

June 4, 2025

by Priyam Ganguly

· 3,244 Views · 2 Likes

OTel Me Why: The Case for OpenTelemetry Beyond the Shine

Someone asked me why I was so excited about OpenTelemetry. The reasons have more to do with it's innovation and utility than it's novelty.

June 4, 2025

by Leon Adato

· 1,151 Views · 3 Likes

Improving Cloud Data Warehouse Performance: Overcoming Bottlenecks With AWS and Third-Party Tools

Cloud data warehousing performance can be optimized with AWS tools and third-party solutions like Matillion, Fivetran, and Looker.

June 3, 2025

by Dilip Kumar Rachamalla

· 3,150 Views · 1 Like

Beyond Bytecode: Exploring the Relationship Between JVM, JIT, and Performance

JIT compilation boosts Java performance by converting bytecode to native code at runtime, optimizing execution while balancing startup speed.

June 3, 2025

by Ammar Husain

CORE

· 3,637 Views · 6 Likes

It Costs That Much Because Observability Takes Hours

People complain that vendors are charging money for services, which seems like a weird thing to do, since nobody wants to build it themselves, either.

June 3, 2025

by Leon Adato

· 1,622 Views · 1 Like

PostgreSQL Performance Tuning

PostgreSQL 17 brings several performance improvements and features for OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) workloads.

June 2, 2025

by Dr. Ibrar Ahmed

· 3,101 Views · 2 Likes

Observability Expenses: When ‘Pennies on the Dollar’ Add Up Quickly

At first blush, the cost of collecting, sending, and storing observability data seems like a pennies on the dollar proposition. But in truth, the costs can add up fast.

June 2, 2025

by Leon Adato

· 2,154 Views · 1 Like

Scaling Azure Microservices for Holiday Peak Traffic Using Automated CI/CD Pipelines and Cost Optimization

Automate Azure microservice scaling with CI/CD, AKS, and IaC for cost-effective, error-free holiday peak traffic handling.

May 30, 2025

by Prabhu Chinnasamy

· 5,869 Views · 52 Likes

Resolving Parameter Sensitivity With Parameter Sensitive Plan Optimization in SQL Server 2022

Learn how SQL Server 2022's Parameter Sensitive Plan Optimization (PSP) solves parameter sniffing by caching multiple execution plans for parameterized queries.

May 30, 2025

by arvind toorpu

CORE

· 4,010 Views · 3 Likes

What’s Got Me Interested in OpenTelemetry—And Pursuing Certification

OpenTelemetry is one of the most exciting new things to hit the monitoring and observability space in a while. Which is why I'm pursuing a certification in it now.

May 29, 2025

by Leon Adato

· 3,256 Views

Memory-Optimized Tables: Implementation Strategies for SQL Server

Through practical implementation guidance and real-world examples, learn how this in-memory technology can deliver 5- 30x performance improvements for OLTP workloads.

May 28, 2025

by arvind toorpu

CORE

· 4,861 Views · 4 Likes

Rust, WASM, and Edge: Next-Level Performance

Rust, WebAssembly, and Edge Computing might sound like buzzwords, but they actually solve real problems around speed and scalability.

May 23, 2025

by Muhammad Adnan

· 7,600 Views · 3 Likes

After 9 Years, Microsoft Fulfills This Windows Feature Request

Developers can now look under the hood at the component that allows a Linux environment to run within Windows.

May 23, 2025

by Megan Crouse

· 3,664 Views

Distributed Consensus: Paxos vs. Raft and Modern Implementations

In this post we'll explore the fundamentals of distributed consensus, compare Paxos and Raft, and examine recent implementations like Kafka Raft.

May 23, 2025

by narendra reddy sanikommu

· 5,705 Views · 2 Likes

Optimizing Software Performance for High-Impact Asset Management Systems

Performance isn’t optional in government tech. Event-driven caching with Rust cut latency by 65%, proving that architecture can drive impact.

May 23, 2025

by Abhishek Kumar

· 3,177 Views · 1 Like

Creating a Web Project: Caching for Performance Optimization

Caching boosts performance by cutting server load and speeding responses. This article covers key caching strategies to help optimize your project efficiently.

May 21, 2025

by Filipp Shcherbanich

CORE

· 6,434 Views · 4 Likes

Next-Gen IoT Performance Depends on Advanced Power Management ICs

Energy-efficient chips are essential for future connected devices, ensuring durability and extended operation in diverse settings.

May 20, 2025

by Emily Newton

· 3,786 Views

Manual Sharding in PostgreSQL: A Step-by-Step Implementation Guide

Implement manual PostgreSQL sharding with simple SQL routing functions and measure performance gains through benchmarking.

May 20, 2025

by Aditya Karnam Gururaj Rao

· 5,278 Views · 3 Likes

Parameters to Measure in Chaos Engineering Experiments

This journal outlines key parameters to measure in Chaos Engineering experiments, such as system performance, availability, fault tolerance, and user experience.

May 20, 2025

by Alex Kuriakose

· 2,767 Views · 1 Like

The Latest Performance Topics