Performance Resources

Share

Related resources for Performance

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
Advanced C# 13 and .NET 9 Features for Expert .NET Engineers11/22/2024 5:43:02 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
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'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<T> 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 "IS [NOT] DISTINCT FROM" 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#" 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'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'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#" 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 "SQL: Writing Efficient Queries." 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'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'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" 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" 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" 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" 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'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
Working with binary large objects (BLOBs)6/4/2024 9:48:07 AM. BLOBs (Binary Large Objects) efficiently store large files (images, videos) in databases. Saving/retrieving them involves managing memory usage for optimal performance. This article explores C# techni
Understanding Connection Pooling6/4/2024 9:46:23 AM. This article is to go in deep in dome key features in the ADO.NET 2 which was shipped with VS 2005. In this article I will go trough one of the key features which is the Connection Pooling.
How to Fulfill the Key Responsibilities of a Product Manager6/3/2024 9:36:43 AM. A Product Manager defines the product vision, creates roadmaps, manages the product backlog, and ensures alignment with business objectives. Key tasks include market research, gathering customer insig
Integrate Azure Load Testing with Function App6/3/2024 7:44:56 AM. This article provides a guide on combining Azure Load Testing services with Azure Function Apps to evaluate performance and scalability. It emphasizes automated testing, monitoring, and stress testing
Optimizing Performance and Cost Efficiency with Azure Autoscale6/3/2024 5:41:00 AM. Learn about Azure Autoscale, a feature that adjusts compute resources based on demand to maintain performance and cost-efficiency. Discover types of autoscale, key components, configuration methods, a
How to introduce AI technologies into a medium-sized office (May 2024)6/2/2024 9:59:26 AM. Introducing AI to a medium-sized office involves a strategic approach. Conduct a needs assessment, select appropriate AI applications, train staff, pilot the technology, ensure data security, assess c
Common Table Expression(CTE) in SQL Server5/30/2024 12:12:43 PM. Learn about CTE, a SQL Server 2005 feature replacing temp tables. Understand its efficiency over temp storage methods, essential syntax, and diverse applications in query optimization. Examples illust
Optimizing Performance with Dapper with .NET Core API 5/30/2024 9:56:30 AM. Learn Dapper best practices for optimal database interaction in .NET applications. Explore techniques like using output parameters and handling multiple result sets in stored procedures. Enhance effic
Optimize Big Data Performance with Broadcast Hash Join in PySpark5/29/2024 6:15:46 AM. Maximize your Big Data app's performance with PySpark's Broadcast Hash Join. Utilize distributed computing, parallel processing, and Spark's optimization techniques for efficient data proc
Log-Based vs. Pre-Aggregate in Data Analytics5/27/2024 11:48:19 AM. Log-Based vs. Pre-Aggregate in Data Analytics: Log-based analytics processes raw data entries sequentially, while pre-aggregate analytics aggregates data beforehand. Each approach offers unique benefi

Topics