Related resources for Performance
  • SQL Server – Query Performance – Database Maintenance can Help1/15/2025 3:19:58 AM. To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual
  • What We Didn't Know About C# 131/14/2025 4:21:39 AM. Ziggy Rafiq shows us how to leverage C# 13's hidden gems, including advanced pattern matching and performance enhancements that allow for faster and more effective development.
  • Testing Speed of Modern External SSD Backup1/13/2025 6:02:25 AM. Discover how modern external SSDs perform in terms of speed and efficiency for data backups. This article explores key metrics like read/write speeds, real-world performance, and benchmarking tests.
  • Advanced C# 13 and .NET 9 Features for Expert .NET Engineers1/10/2025 10:20:34 AM. With this guide, you will learn about enhanced pattern matching, static abstract members, Native AOT, and much more in C# 13 and .NET 9. Written by Ziggy Rafiq, this is the best resource for experienc
  • Optimize Relationships Migrations Performance in ASP.NET Core MVC1/6/2025 10:00:24 AM. This article covers Entity Framework Core, query optimization, caching strategies, lazy and eager loading, and best practices to enhance your MVC application's efficiency.
  • Static Lambda in C# 12 : Performance Improvement1/2/2025 5:22:49 AM. This article explores Static Lambdas in C# 12, highlighting their performance benefits by preventing variable capture. Examples include sorting, filtering, parallel processing, and array operations, d
  • Memory Leakage and Solutions in React12/23/2024 5:25:29 AM. Memory leakage in React can lead to performance issues and application crashes. This article explores common causes of memory leaks, such as improper use of state, unmounted components, and event list
  • Enhancing Performance and Responsiveness Using Threading in C#12/23/2024 4:41:18 AM. Discover how to use threading in C# to make your applications faster and more responsive by running multiple tasks at the same time. Learn key concepts, practical examples, and best practices.
  • Next.js Vs ReactJs12/20/2024 8:39:32 PM. Next.js and React.js are both powerful tools for building web applications. React.js is a JavaScript library focused on UI components, while Next.js is a framework that enhances React with features li
  • Debouncing and Throttling12/20/2024 8:23:37 AM. Debouncing and throttling are techniques used to optimize event handling in web development. They help control the frequency of function calls triggered by events like scrolling or typing. Debouncing
  • Performance Optimization In .NET Core - Tips And Tricks To Improve Application Speed12/20/2024 4:30:21 AM. In this article, you will learn about Performance Optimization in .NET Core: Tips and tricks to improve application speed.
  • Unlocking Faster INSERT Operations in SQL Server with TABLOCK12/17/2024 6:48:30 AM. In this article learn how using the TABLOCK hint in SQL Server can significantly speed up INSERT operations by reducing logging overhead and enabling parallel insertions.
  • Enhancing Performance and Responsiveness Using Threading in C# 12/13/2024 10:24:18 AM. Discover how to use threading in C# to make your applications faster and more responsive by running multiple tasks at the same time.
  • INSERT INTO and SELECT INTO: Which is Better?12/6/2024 5:50:06 AM. In this article, we’ll explore the differences between these two methods, their impact on temporary tables, and practical recommendations for SQL developers, data engineers, and DBAs. Using examples f
  • Optimizing Performance in Azure Cosmos DB: Best Practices11/29/2024 5:20:56 AM. Azure Cosmos DB optimization enhances performance, scalability, and cost-efficiency. Key practices include selecting the right partition key, customizing indexing, optimizing queries, tuning consisten
  • High-Performance Apps Using C# Span<T>11/27/2024 11:35:46 AM. Often in application we come scenarios where we need to perform string manipulation operations. In such cases using string type take up huge memory as it is immutable. Instead Span can be used, which
  • How to Optimize Docker Images for Smaller, Faster Deployments11/18/2024 9:38:02 AM. Learn simple strategies to optimize Docker images, reduce their size, and speed up deployments with tips like lightweight bases, cleanup, and multi-stage builds.
  • Enhance SQL Server Stored Procedure Performance – Tuning Tips11/18/2024 3:51:42 AM. Covering indexes and filtered indexes in SQL optimize database performance by efficiently retrieving data for queries. Covering indexes include all needed columns, while filtered indexes target specif
  • Increase Application Performance using Task.Run in .NET Core11/15/2024 11:18:38 AM. Explore the power of Task.Run in .NET Core to efficiently handle background tasks like logging, report generation, and email sending, enhancing application performance and responsiveness without block
  • Understanding Distributed and Monolithic SQL Architectures11/5/2024 10:01:52 AM. In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance,
  • Increase UI Performance using Timeout Middleware in .NET Core11/4/2024 5:26:04 AM. Timeout Middleware in .NET Core is crucial for handling long-running requests by setting specific time limits for responses. It improves application reliability, manages resources efficiently, enhance
  • Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
  • KEYNOTE - Power of AI and Code Quality and Performance10/24/2024 4:13:34 AM. In this session, you will learn about the Power of AI and Code Quality and Performance.
  • Caching HTML Tags Using WebForms Core Technology10/22/2024 8:31:41 AM. In this article, we teach how to cache static HTML tags (header, footer, right and left menus, etc.) in the user&#39;s browser by using WebForms Core technology in the CodeBehind framework.
  • Using Span<T> To Improve Performance Of C# Code10/21/2024 10:13:00 AM. To enhance application performance, reducing IO calls and utilizing stack allocation is crucial. Leveraging value types and the Span&lt;T&gt; structure in C# allows efficient memory management and imp
  • Why In ASP.NET Core logging is often implemented as a singleton10/20/2024 9:31:50 AM. In ASP.NET Core, logging is often implemented as a singleton to ensure efficient resource usage, centralized management, and thread-safe logging across the application.
  • Understanding the Difference Between Cache and Persist in Pyspark10/16/2024 5:40:26 AM. Learn how they store data in memory and disk, their role in improving execution speed, and how to choose the right method for efficient data processing in PySpark.
  • How to Speed up Your JavaScript Code Performance10/8/2024 8:55:16 AM. This guide explores essential techniques to boost JavaScript code performance. Learn how to optimize loops, minimize DOM manipulations, leverage async functions, and use modern JavaScript features lik
  • What is Inline Arrays in C# 1210/7/2024 6:44:43 AM. C# 12 unveils a hidden gem - inline arrays. This article delves into these performance powerhouses, showcasing how they boost speed, simplify memory management, and enhance type safety. Discover their
  • IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. The &quot;IS [NOT] DISTINCT FROM&quot; operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
  • SQL Stored Procedure vs. Azure Data Factory Data Flow9/27/2024 7:32:23 AM. This article compares SQL Stored Procedures and Azure Data Factory (ADF) Data Flows for creating staging tables and migrating data to Dynamics 365 (D365). It examines their differences in execution ti
  • How C# Generics is different from Java Generics9/24/2024 11:29:42 AM. In this article, we explore the distinctive features of C# generics and how they enhance programming efficiency. We compare generics with non-generic types, focusing on benefits like type safety, code
  • Top 5 Performance Improvements in Angular 189/23/2024 4:21:54 AM. Learn about the latest optimization features, enhanced change detection, faster rendering, lazy loading, and other cutting-edge updates that make Angular 18 more powerful than ever!
  • A Comprehensive Guide to Migrating Azure Functions C# to C# 12 with .NET 8 Isolated9/21/2024 4:12:20 AM. Ziggy Rafiq shows how to leverage modern C# features, and how to optimize the performance and scalability of Azure Functions by migrating them to .NET 8 Isolated Processes.
  • Exploring the Performance Boosts in .NET 99/20/2024 4:22:58 AM. .NET 9 introduces key performance improvements, including Native AOT for faster startup times and reduced memory usage, optimized garbage collection, enhanced threading for multicore systems, and HTTP
  • PowerShell Memory Leak and Prevention9/16/2024 11:21:14 AM. This guide covers techniques for managing memory usage, troubleshooting leaks, and optimizing your scripts for better resource efficiency. Gain insights into effective memory leak prevention strategie
  • Optimizing Angular Route Guards for Performance and Security9/4/2024 6:13:15 AM. Angular route guards manage access control in your application, ensuring users only access authorized routes. To optimize performance and security, implement lazy loading with CanLoad, cache permissio
  • React Performance Unleashed: Tips and Tricks for Lightning-fast Apps8/25/2024 11:32:03 AM. React Performance Unleashed: Tips and Tricks for Lightning-fast Apps
  • Azure Synapse vs Microsoft Fabric Detailed Comparision8/21/2024 4:57:51 AM. This article provides an in-depth comparison between Azure Synapse and Microsoft Fabric, two powerful cloud-based data solutions, and explores their features, performance, and use cases, with a focus
  • Advanced gRPC Communication in .NET Core8/20/2024 7:27:56 AM. Explore advanced techniques for implementing microservices communication using gRPC in .NET Core. This article dives into high-performance, real-time communication patterns with practical code example
  • A brief introduction to ASP.NET Core using C#12 and .NET 88/18/2024 1:40:52 PM. A brief introduction to ASP.NET Core using C# 12 and .NET 8 by Ziggy Rafiq. This modern framework enables you to build cross-platform, high-performance web applications. To get started, discover key f
  • Optimizing JavaScript with Debouncing8/13/2024 5:47:14 AM. This guide delves into optimizing JavaScript performance using debouncing techniques, which help prevent excessive function calls during high-frequency events like scrolling or resizing.
  • async, await, ConfigureAwait(true/false) Asynchronous Programming in C#8/12/2024 9:34:42 AM. Explore asynchronous programming in C# with a focus on async and await keywords. Learn how to use ConfigureAwait(true/false) to manage context switching and avoid deadlocks.
  • Advanced .NET Core Microservices with MediatR8/9/2024 11:55:17 AM. Explore advanced .NET Core and MediatR techniques for building scalable microservices. Delve into patterns like CQRS and event sourcing, optimize performance with caching and load balancing, and embra
  • Optimizing Performance in Next.js8/8/2024 10:06:30 AM. Performance is crucial in web development, and Next.js offers several tools and strategies to ensure your application runs efficiently. This article covers essential techniques for optimizing performa
  • Exploring ValueTask in C#8/5/2024 11:34:24 AM. xploring ValueTask in C#&quot; delves into the intricacies of the ValueTask type introduced in C#. It compares ValueTask with Task, highlighting performance benefits and appropriate use cases.
  • Priciples of Scalable System Design8/5/2024 9:50:14 AM. The principles of scalable system design focus on creating architectures that can efficiently handle increasing loads. Key aspects include load balancing, fault tolerance, and performance optimization
  • LINQ Best Practices8/1/2024 6:25:23 AM. Discover essential LINQ best practices for writing efficient, readable, and maintainable code in C#. Learn tips on query and method syntax, performance optimization, and effective use of lambda expres
  • Improving Performance in Angular Applications8/1/2024 4:06:38 AM. Learn essential strategies to optimize Angular performance, including lazy loading, AOT compilation, efficient change detection, and more. Boost your Angular app&#39;s speed and efficiency with these
  • EF Core Query Tags: What They Are and How to Use Them7/29/2024 11:25:31 AM. Discover the power of EF Core Query Tags in optimizing and debugging your database queries. This guide explains what query tags are, their benefits, and how to implement them in your Entity Framework
  • Intermediate Code Optimizations in C#7/29/2024 11:24:13 AM. Intermediate code optimization in C# improves performance by refining Intermediate Language (IL) code. Techniques like inlining, loop optimizations, dead code elimination, and constant folding enhance
  • JavaScript Functions to Simplify Your Code7/26/2024 5:02:58 AM. Discover how to streamline your JavaScript code with our comprehensive tutorial on essential functions. Learn best practices, coding tips, and techniques to simplify your programming. Perfect for begi
  • SQL Performance (2), Optimized SELECT Query (B)7/25/2024 5:41:20 PM. This article discuss SQL performance on optimizing SELECT Query, Second Part.
  • Shifting to Zoneless in Angular 187/25/2024 12:09:34 PM. In this article, we will discover how to optimize your Angular applications for better efficiency and streamlined asynchronous operations, leveraging the latest framework advancements.
  • Understanding Table Partitioning in SQL7/24/2024 6:07:08 AM. Table partitioning is a technique in database design that divides large tables into smaller, manageable pieces called partitions. This approach improves query performance, enhances manageability, and
  • Performance Optimization in ADO.NET: Tips and Techniques7/23/2024 9:19:54 AM. Optimize ADO.NET performance by leveraging connection pooling to reduce overhead, using efficient command execution strategies such as stored procedures and batch processing, and retrieving data effec
  • Differences Between .NET 5, .NET 6, .NET 7, .NET 8, and .NET 97/23/2024 3:55:31 AM. key differences and advancements in .NET from versions 5 to 9, including performance enhancements, new language features, cloud-native support, and cross-platform capabilities, highlighting how each i
  • Exploring New Features in Next.js 157/22/2024 6:18:19 AM. In this article, we will learn that Next.js 15 introduces a suite of new features and improvements aimed at enhancing developer experience and application performance.
  • Optimizing LINQ Performance with Compiled Queries in .NET7/22/2024 6:16:04 AM. Compiled queries in LINQ (Language Integrated Query) are a powerful feature that can significantly improve the performance of your data access code, especially when dealing with repetitive queries.
  • Logging Patterns in ASP.NET Core 87/22/2024 4:56:21 AM. In this article, we will explore the essential logging patterns in ASP.NET Core 8 to enhance your application&#39;s observability. Learn about basic, structured, and exception logging, along with best
  • Understanding View Binding in Android7/22/2024 4:30:54 AM. View binding is a feature that makes it easier to write code that interacts with views. Once view binding is enabled in a module, it generates a binding class for each XML layout file present in that
  • Enhancing Performance and Safety with System.Threading.Lock in .NET 9 and C# 137/22/2024 2:26:10 AM. Explore the new System.Threading.Lock in .NET 9 and C# 13 for enhanced multithreading performance and safety. This article covers its benefits, compiler warnings for misuse, and best practices for loc
  • Breaking Down SQL Complexity7/21/2024 4:03:03 AM. Choosing between Common Table Expressions (CTEs) and subqueries in SQL Server depends on readability, maintainability, and performance. Subqueries are ideal for simpler, single-use cases, while CTEs e
  • Optimization of Loops in JavaScript7/19/2024 5:16:47 AM. Loop optimization is crucial in JavaScript for enhancing performance, particularly in applications requiring intensive computation or handling large data sets. By understanding and applying optimizati
  • Why Choose React in 20247/18/2024 9:36:57 AM. In this article, we will learn how React continues to evolve with cutting-edge features, making it the preferred choice for building dynamic and efficient user interfaces on the web.
  • Multithreading and Multiprocessing in Python7/18/2024 7:59:03 AM. Multithreading allows concurrent execution of multiple threads within a single process sharing the same memory space, while multiprocessing enables parallel execution of processes, each with its own m
  • String.Join vs Loops in C#7/17/2024 12:21:12 PM. String.Join vs. Loops: C#&quot; explores the efficiency and performance differences between using String.Join and traditional looping methods for string concatenation in C#.
  • Performance Optimization in .NET Core7/15/2024 11:22:56 AM. Discover essential techniques for performance optimization in .NET Core with this comprehensive guide. Learn best practices for code efficiency, resource management, and system optimization to enhance
  • Virtualization Isolation Enhancing Security and Performance7/12/2024 10:29:35 AM. Virtualization isolation enhances security and performance by separating virtual machines (VMs) and containers within a shared environment. This isolation ensures that each VM operates independently,
  • SQL: Writing Efficient Queries7/10/2024 12:27:40 AM. Learn how to optimize SQL queries for better performance with our guide on &quot;SQL: Writing Efficient Queries.&quot; Discover techniques for improving query speed, such as indexing strategies, query
  • Improve Your Code Quality and Performance using AI and GitHub Copilot7/8/2024 7:46:59 AM. This session will explore how AI and GitHub Copilot can be used as powerful allies in writing better code, ensuring that developers can focus on creative problem-solving while leaving the routine codi
  • Name a few techniques to optimize Reactjs app performance7/7/2024 8:27:52 AM. Optimizing React app performance involves leveraging techniques like React. memo, useMemo, and use callback to minimize unnecessary re-renders. Employing code splitting via dynamic imports with React.
  • What is Power Apps Delegation?7/3/2024 4:51:34 AM. Power Apps delegation is a concept that affects how Power Apps retrieves data from data sources. It optimizes performance by delegating data processing tasks to the data source, handling large dataset
  • Understanding Structs In C# with Example7/1/2024 6:26:12 AM. Structs in C# provide a lightweight alternative to classes, ideal for representing small, immutable data structures. Unlike classes, structs are value types stored on the stack, enhancing performance
  • Key Features of Angular Data Grid 6/28/2024 8:54:01 AM. Explore the robust capabilities of Angular Data Grid with essential features like high performance, seamless customization, advanced filtering, sorting options, efficient pagination, virtualization fo
  • Comparing Performance: Regex vs String Methods in C#6/27/2024 10:17:22 AM. In C#, developers choose between Regex and string methods for manipulating strings. String methods are faster and more readable for simple tasks, while Regex excels in handling complex patterns and ad
  • Data Skew Problem and Solution in PySpark6/26/2024 4:53:53 AM. Explore the nuances of handling data skew issues in PySpark with effective strategies and solutions. Discover how to optimize performance through smart partitioning, efficient shuffle operations, and
  • Entity Framework Performance Improvements with Code Examples6/23/2024 9:51:28 PM. Learn how to optimize Entity Framework performance with practical code examples. This guide covers essential techniques to enhance database efficiency, improve query performance, and eliminate bottlen
  • What is the React Strict Mode: Enhancing React Development6/22/2024 10:29:37 AM. React Strict Mode is a development tool in React that helps identify potential issues in an application by highlighting them early. It enforces best practices, improves performance, and ensures code q
  • OnPush Change Detection Strategy: Optimizing Angular Performance 6/21/2024 10:02:53 AM. Angular&#39;s OnPush change detection strategy optimizes performance by reducing unnecessary checks, only updating when input properties change or events occur. This approach, contrasting with the def
  • How Can We Achieve Code Spliting in React Js?6/21/2024 7:18:45 AM. In this article, I explain how to make React applications faster by loading only the code that&#39;s needed at the moment. I talk about using methods like dynamic import(), React.lazy, and Suspense to
  • Memory Management in SQL Server6/21/2024 6:46:44 AM. Memory management in SQL Server is crucial for optimizing database performance. This involves configuring memory allocation, managing the buffer pool, and tuning queries to ensure efficient use of res
  • Understanding Caching in Python6/18/2024 4:19:18 AM. Understanding Caching in Python&quot; explores the concepts and techniques of caching to optimize performance in Python applications. Learn how caching improves data retrieval speed, reduces computati
  • How To Convert Older C# Version to C# 12 With Example6/17/2024 5:33:27 AM. Many developers still use older versions of C# due to legacy codebases, corporate constraints, and familiarity with older language features. Upgrading can seem daunting, but modern versions of C# offe
  • Performance Optimization in ASP.NET MVC Applications6/15/2024 9:07:01 AM. Performance optimization in ASP.NET MVC involves techniques like efficient data access, using Entity Framework wisely, implementing caching, using async/await for non-blocking operations, minimizing V
  • Comparison Of Different SQL Query Responses Of SQL Server On Windows And Ubuntu Linux6/14/2024 10:41:29 AM. The article consists of some benchmark tests of SQL Server on different Operating Systems, the parameters considered are CPU Time, Elapsed Time and Total Execution Time.
  • Understanding Indexes in PostgreSQL6/13/2024 5:30:03 AM. Indexes are a fundamental aspect of database management systems (DBMS) like PostgreSQL. They enhance the performance of queries by allowing the database to find rows more efficiently.
  • WCF Performance Tuning6/12/2024 10:10:04 AM. WCF (Windows Communication Foundation) enables network distributed services with a service-oriented approach. Improving its performance involves selecting proper bindings, understanding throttling, op
  • Reduce Query Time-Out Issues with GraphQL and Hasura for Enterprises6/11/2024 12:02:22 PM. Explore how GraphQL and Hasura can significantly reduce query time-out issues in enterprise applications. By optimizing data fetching and improving API performance, these technologies enhance backend
  • SQL Query Execution Understanding Process and Performance6/11/2024 11:37:51 AM. Understanding the SQL query execution order—from FROM and JOIN to WHERE, GROUP BY, HAVING, SELECT, ORDER BY, and LIMIT/OFFSET—is crucial for optimizing queries. Key techniques include indexing, optimi
  • Building and Leading High-Performance Teams6/10/2024 9:01:31 AM. The capacity to create and manage high-performance teams is essential for any organization to succeed in the cutthroat business world of today. These teams not only have the capacity to produce outsta
  • Frozen Collections in .NET 86/10/2024 7:00:56 AM. Frozen Collections in .NET 8&quot; explores the introduction of frozen (immutable) collections in the latest .NET framework. These collections offer performance optimizations and enhanced memory manag
  • Improved Performance by STORED PROCEDURES6/8/2024 1:30:34 PM. Stored procedures in relational database management systems (RDBMS) encapsulate frequently used SQL statements for efficient execution. They offer dynamic SQL execution, return values via OUT keywords
  • Caching in ASP.Net6/7/2024 10:40:57 AM. Caching in ASP.NET enhances web application performance by storing page outputs, fragments, or data in memory. This guide covers the basics of caching, including page, fragment, and data caching techn
  • Memory Cache in C#6/7/2024 10:30:59 AM. Learn about optimizing web application performance through cache implementation. Understand various cache types like in-memory, persistent, and distributed caches. Explore methods to add, store, retri
  • Blockchain Efficiency with Solana Address Lookup Tables6/6/2024 11:43:06 AM. Explore Address Lookup Tables (ALTs) in Solana, enhancing blockchain efficiency by optimizing address management in transactions. Learn how ALTs streamline processes, reduce transaction size, and impr
  • Scaling with .NET: How to Build High-Performance Applications6/6/2024 11:29:51 AM. Scaling with .NET: How to Build High-Performance Applications&quot; explores strategies for optimizing .NET applications. Microservices, cloud computing, asynchronous programming, and performance test
  • ⏲️ Visual Time Spent - Time Tracking Extension For Coding In Visual Studio6/5/2024 8:10:58 AM. Visual Time Spent&quot; is a time-tracking extension for Visual Studio, enhancing coding productivity. It provides insights into coding habits, metrics, and performance, facilitating efficient time ma
  • Improve Web Performance Using Debouncing in React.js6/5/2024 5:03:16 AM. Debouncing is a programming technique used to improve performance by limiting how often a function, such as an event handler. In React.js, it&#39;s commonly applied to optimize tasks like search input
  • Building A Dashboard With ASP.NET Core And DotVVM6/4/2024 12:16:24 PM. This article explores designing a user data dashboard using ASP.NET Core and DotVVM. It covers the setup of tools like Visual Studio 2019 and PostgreSQL and explains creating a dashboard with CRUD ope