Want to become a Vibe Coder? Join Vibe Coding Training here
x
C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Tags
No tag found
Content Filter
Articles
Videos
Blogs
Resources
News
Forums
Interviews
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Dashrath Hapani(16)
John Godel(11)
Ayush Gupta(8)
Aradhana Tripathi(5)
Tharunkumar Magudeeswaran(4)
Bimalshi Jayarathna(2)
Jay Krishna Reddy (2)
Jignesh Kumar(2)
Mahesh Chand(2)
Kapil Singh Kumawat(2)
Abiola David(2)
Ashish Bhatnagar(2)
Micheal Xavier A (1)
Divyansh Gupta(1)
Sarathlal Saseendran(1)
Lokendra Singh(1)
Ziggy Rafiq(1)
Sangeetha S(1)
Deepak Tewatia(1)
Nitin Pandit(1)
Sarthak Varshney(1)
Sagar Rane(1)
Tural Suleymani(1)
Jochen Bartlau(1)
Vishal Yelve(1)
Maria Joshua Roy(1)
Sridharan D(1)
Sudhir Vaghela(1)
Mark Pelf(1)
Mukesh Sagar(1)
Pavan Nalluri(1)
Mohammad Hasan Hosseini(1)
Siddhesh Chavan(1)
Sardar Mudassar Ali Khan (1)
Rikam Palkar(1)
Vipul Malhotra(1)
Satyaprakash Samantaray(1)
Monica Rathbun(1)
Muhammad Imran Ansari(1)
Jayraj Chhaya(1)
Anup Hosur(1)
Rijwan Ansari(1)
Sanjay Kumar(1)
Subarta Ray(1)
Morteza Mousavi(1)
Wilson Mok(1)
Vijay Kumari(1)
Jaimin Shethiya(1)
Nandan Hegde(1)
Ricardo Pena(1)
Satheesh Elumalai(1)
Shenbagapandiyan P(1)
Amit Mohanty(1)
Jayeshkumar Sahani(1)
Resources
No resource found
.NET Base Class Library(BCL)
Jun 28, 2025.
The most commonly used .NET Base Class Library (BCL) namespaces: System and System.IO
Understanding SESSION_CONTEXT in SQL Server
Jun 26, 2025.
This article explains SQL Server's SESSION_CONTEXT, a session-scoped key-value store introduced in 2016, useful for securely passing metadata like User ID or flags between procedures, triggers, and applications.
Mastering LINQ in C#
Jun 25, 2025.
Language Integrated Query (LINQ) is a game-changer in C#. It brings SQL-like data querying capabilities directly into your C# code, making data manipulation more intuitive, type-safe, and readable.
Basic SQL Queries for Database Testing
Jun 23, 2025.
Learn essential SQL queries used in database testing. This guide covers SELECT, JOIN, WHERE, and more—ideal for QA testers and beginners ensuring data accuracy and integrity in applications.
How to Collaboratively Work with SQL Server 2025, Visual Studio Code, and GitHub Copilot (Step-by-Step Guide)
Jun 21, 2025.
This article walks you through how to collaboratively work using SQL Server 2025, Visual Studio Code (VS Code), and GitHub Copilot. With clear steps and screenshots, this guide helps beginners and professionals enhance productivity and collaboration in database development.
Database Testing: A Complete Guide
Jun 19, 2025.
Database Testing ensures data accuracy, integrity, and performance by validating schemas, procedures, and operations. This guide covers types, tools, scenarios, and best practices for robust, high-quality data-driven applications.
What is DBT (Data Build Tool)?
Jun 19, 2025.
Learn how DBT (Data Build Tool) transforms raw data using SQL, enabling version control, testing, and documentation to bring software engineering best practices into modern, scalable, and reliable data workflows.
Understanding Select vs SelectMany in LINQ
Jun 19, 2025.
In this article, we are going to learn about the importance of LINQ features of select and SelectMany and the difference between them.
Health Checks in .NET 8 Web API: A Comprehensive Guide
Jun 18, 2025.
Ensure your ASP.NET Web API’s reliability with .NET 8 health checks—monitor SQL Server, external APIs, and network connectivity using JSON-formatted diagnostics for proactive monitoring, easier debugging, and improved application resilience.
FirstOrDefault vs. SingleOrDefault in LINQ: Key Differences and Use Cases
Jun 16, 2025.
In this article, we'll dive into the key differences between FirstOrDefault and SingleOrDefault, examining their behaviours, ideal use cases, and guidance on when to use each one. By the end, you'll gain a better understanding of how to utilize these methods to optimize data queries in your C# applications.
SQL vs NoSQL: Making the Right Database Choice for Your Application
Jun 12, 2025.
Learn the core differences between SQL and NoSQL databases. Explore their advantages, disadvantages, top database options, and when to use each. A must-read for software developers and DBAs making architectural decisions.
Types of Classes in C# with Examples | Concrete, Static, Abstract, Sealed, and More
Jun 12, 2025.
Learn all the types of classes in C# with clear examples and use cases. Understand when to use abstract, static, sealed, generic, and partial classes in .NET Framework.
Table Sharding in SQL: Types, Examples, and Best Practices
Jun 10, 2025.
Table sharding improves database scalability and performance by splitting large tables into smaller, distributed shards. It enhances speed, fault tolerance, and cost-efficiency—ideal for growing applications with heavy data loads.
Database Fragmentation: Understanding, Managing, and Mitigating
Jun 06, 2025.
Learn how to detect, manage, and resolve SQL Server fragmentation with live examples. Improve query performance, reduce I/O overhead, and optimize indexes and heaps using proven best practices and tools.
Horizontal vs Vertical Partitioning in SQL
Jun 04, 2025.
Horizontal and vertical partitioning are techniques in SQL to improve performance and manage large datasets. Learn how each method works, their use cases, and how they impact database design.
Transforming Data Insights with Snowflake's LLM Functions – PART 2
Jun 04, 2025.
Snowflake Cortex LLM functions like TRANSLATE and SUMMARIZE, enabling powerful in-database AI for multilingual translation and concise text summaries, thereby enhancing data analytics without the need for external tools or APIs.
Building a Clean ASP.NET Core API with C# 13, EF Core, and DDD
Jun 02, 2025.
The guide is written by Ziggy Rafiq and follows real-world architecture and testing best practices to provide a clean, scalable REST API using ASP.NET Core, C# 13, EF Core, and MS SQL.
Understanding DBCC Commands in SQL Server: Use Cases and Importance
May 31, 2025.
Learn the essentials of DBCC commands in SQL Server—powerful tools for monitoring, maintaining, and troubleshooting databases. Mastering them ensures performance optimization, deadlock resolution, and proactive database health checks.
Django Web Framework Model Class with Example
May 29, 2025.
Learn how Django's Model class works with simple examples. Understand how to define data structures, interact with databases, and build dynamic web apps using Django ORM in Python.
SQL Server Transaction Locks: Identification & Resolution
May 28, 2025.
Learn how SQL Server transaction locks ensure data integrity, identify locking issues using DMVs and Activity Monitor, and explore strategies like query optimization, isolation levels, and deadlock resolution for better performance.
PLINQ vs LINQ: Use Cases, and Performance Insights in C#
May 25, 2025.
Discover the key differences between LINQ and PLINQ in C#, including their syntax, execution models, performance benchmarks, use cases, and when to choose parallelism for processing large datasets efficiently.
How to Install and Configure SQL Server 2025 in Windows
May 22, 2025.
This articlee walks you through installing SQL Server 2025 on Windows, from system requirements to setup and configuration. Learn how to enable features, set authentication modes, and ensure your server runs smoothly ideal for beginners and advanced users alike.
Event-Driven CQRS with C# 14 and the SQL Outbox Pattern
May 15, 2025.
Learn how to implement a reliable event-driven CQRS microservice using the SQL Outbox Pattern with C# 14. Ensure strong consistency, transactional event publishing, and fail-safe asynchronous processing for scalable distributed systems.
.NET Aspire Integrations (SQL Server Integration in Aspire Applications)
May 14, 2025.
In this chapter, you'll learn how to integrate SQL Server into your .NET Aspire applications with minimal configuration and maximum flexibility.
Real-Time Data Retrieval from APIs Using SSIS
May 14, 2025.
This article explains how to integrate APIs with SQL Server Integration Services (SSIS) to automate data retrieval using HTTP requests. It covers API setup, SSIS package creation, and script task configuration.
Microsoft Fabric Warehouse Integration in VS Code for Devs
May 13, 2025.
Experience seamless development with Microsoft Fabric and VS Code integration. Write, debug, and manage SQL queries directly in your editor, connect to Fabric Warehouse, and boost productivity with real-time data access.
Advanced ETL from OLTP Databases to a Data Warehouse with C# 14
May 12, 2025.
Build scalable and efficient ETL pipelines using C# 14 and .NET 9. Leverage Dapper, SQL Server, Azure Synapse, and cloud integration for seamless data extraction, transformation, and loading to data warehouses and lakes.
What’s New in Grafana 12.0
May 08, 2025.
Explore Grafana 12.0's new features like Git Sync, dynamic dashboards, and enhanced drilldowns. Perfect for beginners seeking practical insights.
Build & Deploy Azure Function Using C# and Integration with Azure SQL
May 05, 2025.
This article walks you through creating the function, connecting to SQL, and deploying it to Azure perfect for developers looking to build serverless apps with database support.
NoSQL vs. SQL: Which One to Use
May 02, 2025.
Explore the key differences between SQL and NoSQL databases, including structure, scalability, use cases, and performance.
Vibe Coding with AI: Using Prompt Engineering to Build a Full C# Database Solution
May 02, 2025.
Discover how to harness the power of AI and prompt engineering to build a complete C# database solution.
Advanced C# Database Tricks for Power Users
May 01, 2025.
Explore advanced C# database techniques using ADO.NET, Entity Framework Core, and Dapper.
Artificial Intelligence and Education: Shaping the Future of Learning
Apr 28, 2025.
Discover how Artificial Intelligence is transforming education by enabling personalized learning, smart classrooms, and intelligent tutoring.
How to Convert a DataTable to a List of Objects in C#
Apr 27, 2025.
Learn how to convert a DataTable to a List<T> in C#. Explore manual, reflection-based, and LINQ methods for better performance, type safety, and cleaner code. Improve maintainability in modern C# applications.
ScopedValueChanger<T> - A very helpful Generic Helper Class to Temporary Change Values
Apr 25, 2025.
This article explores the ScopedValueChanger<T> class, a utility designed to manage temporary value modifications with automatic restoration. Implementing the IDisposable interface ensures that changes made within a scoped context are reversed, maintaining application state integrity.
Advanced Database Programming with C# 14 and Microsoft SQL Server
Apr 24, 2025.
As of C# 14, Microsoft continues to evolve the language to provide more expressive, safe, and performant coding patterns.
SQL Server CLR Integration and SSIS Automation with C#
Apr 24, 2025.
Learn how to enhance SQL Server functionality using CLR integration and automate SSIS packages with C#.
Understanding Change Data Capture (CDC) and Its Types
Apr 23, 2025.
In this article we are going to learn about the CDC and types of CDC approaches. It helps keep data in sync without causing a heavy load on the database.
Order of Execution in LINQ Queries
Apr 22, 2025.
This article explains the difference between deferred and immediate execution, outlines the execution order, and shares best practices to write efficient and optimized LINQ queries for real-world applications.
Singleton Pattern in C# 14: A Deep Dive with a Real-World Example
Apr 21, 2025.
In software architecture, there are scenarios where only a single instance of a class should exist throughout the lifetime of an application.
Execution Process of SQL Queries vs Stored Procedures
Apr 21, 2025.
Dive deep into the internal execution process of SQL Server queries with this one-of-a-kind article comparing normal SQL queries and stored procedures.
LINQ in C# Tutorial for Beginners: 101 C# LINQ Operations
Apr 17, 2025.
Learn LINQ in C# with 101 essential operations for beginners. Simple examples of filtering, sorting, and joining data to make your code better and faster. Perfect for new C# developers.
Learn Class Components - React
Apr 15, 2025.
this article is basic about class component and its functionality based
.NET 8 - System.Linq.Dynamic.Core – using SQL LIKE
Apr 11, 2025.
System.Linq.Dynamic.Core library does not support SQL LIKE, and I added support for it. Added SQL LIKE support to the System.Linq.Dynamic.Core in .NET 8 using a custom patch. Enables dynamic SQL pattern matching in EF8 projects where built-in LIKE functionality was missing.
Create Foreign Keys Dynamically in SQL Server Database
Apr 10, 2025.
Create the referential integrity constraint i.e. Foreign key dynamically in SQL Server database. This script dynamically adds foreign keys to all tables with a CompanyID column by scanning the database, ensuring they reference the Company table—ideal for retrofitting relational integrity.
C# 14: Exploring New Language Features for Modern .NET Development
Apr 02, 2025.
In this article, I explore the most important features introduced in C# 14.0, including primary constructors in classes, collection expressions, enhanced pattern matching, and required members. I walk through how each of these additions simplifies code, improves performance, and promotes safer, more expressive development.
Azure Synapse Analytics Serverless and Dedicated SQL Pools
Apr 02, 2025.
This article explains in detail about what Azure Synapse Analytics is and a brief comparison of the different SQL runtime environments it provisions.
Mitigate OWASP A03:2021 – Injection Web Security Tips
Apr 01, 2025.
?Injection attacks, such as SQL Injection and Cross-Site Scripting (XSS), exploit vulnerabilities where untrusted data is improperly handled, leading to unauthorized command execution or data access. Mitigation strategies include input validation, parameterized queries, and adhering to secure coding practices to enhance web application security.
Exploring PLINQ (Parallel LINQ) for Parallel Processing
Mar 29, 2025.
PLINQ (Parallel LINQ) is a powerful feature in .NET that enables parallel processing of queries to improve performance on multi-core processors.
New LINQ Features in .NET 9
Mar 29, 2025.
Discover the latest LINQ features in .NET 9 that enhance query performance, simplify data manipulation, and introduce new methods for better efficiency.
Understanding Numeric Functions in SQL
Mar 27, 2025.
SQL numeric functions simplify mathematical operations like rounding, power calculations, and random value generation. Functions like ABS(), CEILING(), FLOOR(), ROUND(), SQRT(), MOD(), and LOG() help with financial calculations, data analysis, and scientific computing.
Creating DataFrames in PySpark Using Fabric Notebook
Mar 27, 2025.
This article walks through defining schemas, specifying column names, and using SQL-like DDL in a Fabric Notebook. Explore StructType, StructField, and various ways to display and verify DataFrame content efficiently.
Understanding Conversion Functions in SQL
Mar 27, 2025.
SQL conversion functions like CAST(), CONVERT(), TRY_CAST(), TRY_CONVERT(), and FORMAT() help change data types, format values, and handle errors efficiently.
Explanation of Date and Time Functions in SQL
Mar 26, 2025.
SQL date and time functions help efficiently manipulate and retrieve date-related information. Common functions include GETDATE() for the current timestamp, DATEADD() for adding time intervals, DATEDIFF() for date differences, FORMAT() for formatting, and EOMONTH() for month-end dates.
Mastering SQL String Functions
Mar 25, 2025.
SQL string functions help manipulate and process text data efficiently. This guide covers key functions like UPPER(), LOWER(), LEN(), LEFT(), RIGHT(), SUBSTRING(), REPLACE(), CONCAT(), LTRIM(), RTRIM(), CHARINDEX(), REVERSE(), and FORMAT(), demonstrating their usage with examples to improve query performance and readability.
Understanding System-Versioned Tables in SQL
Mar 25, 2025.
System-versioned tables in SQL automatically track data changes, maintaining historical records for auditing and recovery. They consist of a main table (current data) and a history table (past records).
Prevent Accidental Data Deletion with Two Simple Strategies
Mar 25, 2025.
Recently, I came across several discussions on Communities where users shared their experiences with accidental data deletion.
Automating SCD Type 4 in Azure SQL Database with Azure Data Factory
Mar 24, 2025.
Learn how to automate Slowly Changing Dimension (SCD) Type 4 implementation in Azure SQL Database using Azure Data Factory.
Understanding Parameter Sniffing in SQL Server
Mar 24, 2025.
In SQL Server and other relational database systems, query execution performance is critical for handling large datasets efficiently. One common yet sometimes problematic optimization technique is Parameter Sniffing. While it can improve query performance.
Evolution of Web Scraping: Insights from John Godel on the Enhanced HtmlFetcher Class
Mar 24, 2025.
In the ever-evolving landscape of web development, efficiently retrieving and parsing web data has become crucial. Recently, I had the opportunity to delve into a sophisticated yet efficient C# class that achieves this goal: the HtmlFetcher class.
Understanding Scalar Functions in SQL
Mar 21, 2025.
This article explores common functions like LEN(), UPPER(), LOWER(), ROUND(), GETDATE(), ABS(), SQRT(), SUBSTRING(), and REPLACE(), along with advanced usage, computations, and custom scalar functions for efficient queries.
Understanding Aggregate Functions in SQL
Mar 21, 2025.
SQL aggregate functions help perform calculations on multiple rows, returning a single result. This article covers COUNT(), SUM(), AVG(), MIN(), MAX(), and advanced uses like GROUP BY, HAVING, CASE, PARTITION BY, and DISTINCT.
SQL Tag Library in Java Server Page
Mar 21, 2025.
JSTL SQL tags are used to access databases and are designed for low-volume Web-based applications.? JSTL SQL tags facilitate database interactions in JSP pages, enabling data source setup, query execution, updates, and transactions through tags like <sql:setDataSource>, <sql:query>, <sql:update>, and <sql: transaction>
Understanding SQL Execution Plans
Mar 20, 2025.
An SQL execution plan outlines how a database executes a query, detailing operations like table scans, index seeks, and joins. Analyzing these plans is essential for optimizing query performance.
Understanding SQL CTE (Common Table Expression)
Mar 19, 2025.
A Common Table Expression (CTE) in SQL is a temporary result set that improves query readability and performance. CTEs simplify complex queries, support recursive operations, and help with aggregation and multi-step calculations.
Understanding Expressions in C#: Dynamic Code and Query Generation
Mar 19, 2025.
Expressions in C# allow dynamic query generation, runtime compilation, and code transformation using Expression Trees. They are widely used in LINQ, ORM frameworks like Entity Framework, and reflection to optimize performance and enable flexible, data-driven logic.
Explicit Loading in ASP.NET Core Web API
Mar 18, 2025.
Explicit Loading in ASP.NET Core Web API is a technique used to manually retrieve related data from the database when needed, using LoadAsync() on navigation properties. Unlike eager loading (Include()) or lazy loading, explicit loading provides better control over database queries, improving performance and efficiency. It is useful when related data is conditionally required.
A Simpler Way to Initialize Objects
Mar 18, 2025.
With the release of C# 12, Primary Constructors were introduced to simplify class and struct initialization. This feature allows parameters to be declared directly in the class or struct definition, eliminating the need for boilerplate code and improving readability.
Learn C#: Refactor Code
Mar 18, 2025.
Refactoring in C# enhances code readability, maintainability, and performance by eliminating redundancy, utilizing LINQ, extracting methods, applying null-coalescing operators, and implementing async/await patterns.
Select vs SelectMany in C# LINQ
Mar 17, 2025.
In C# LINQ, Select transforms each element of a collection individually, maintaining the original structure, while SelectMany flattens nested collections into a single sequence, combining all sub-elements.
Implementing SCD Type 4 in Azure SQL Database: A Step-by-Step Guide
Mar 16, 2025.
Learn how to implement SCD Type 4 in Azure SQL Database using a structured approach with staging, dimension, and history tables. This guide covers real-world use cases, SQL implementation, and execution scenarios for efficient historical data management.
Understanding Decorators in Python
Mar 12, 2025.
Decorators in Python are powerful tools that modify the behavior of functions or classes without changing their code. They enable code reusability, logging, authentication, and more.
React Tutorial For Beginners - Working on Class Components in React
Mar 05, 2025.
Learn how to work with class components in React in this beginner-friendly tutorial. Understand the React component lifecycle, manage state and props, and explore best practices for building interactive UIs.
Setting Up Microsoft Entra Service Principal for Azure RBAC and Connecting to Fabric SQL Database
Mar 03, 2025.
This article explains creating a Service Principal, assigning role-based access, and securely authenticating to the database, ensuring seamless integration and enhanced security in your Azure environment.
Automate Email Sending Using SSIS Script Task
Feb 28, 2025.
This article is about Automate Email Sending Using SSIS Script Task
Eliminating Unnecessary DELETE Operations
Feb 28, 2025.
SQL Server performance issues often stem from easy fix bottle necks that can be fixed with the right tuning strategies. This short blog will focus on the DELETE statement.
Azure SQL Database: Scalable & Secure Cloud Solution
Feb 26, 2025.
Azure SQL Database is a fully managed cloud database service by Microsoft, offering high availability, scalability, security, AI-driven performance tuning, automated backups, threat protection, and seamless integration with Azure services.
Boost SQL Server Performance with Memory-Optimized Tables
Feb 25, 2025.
Memory-optimized table variables in SQL Server provide a powerful way to enhance query performance by leveraging In-Memory OLTP. Unlike traditional table variables, they reduce disk I/O and improve execution speed.
Getting Started with EF Core: Part 1
Feb 24, 2025.
Entity Framework Core (EF Core) is a powerful ORM for .NET applications, simplifying database interactions. In this comprehensive guide (Part 1), we’ll cover the basics, including setup, configuration, and the code-first approach.
Entity Framework Core 9: Ultimate Performance Tuning & Best Practice
Feb 21, 2025.
Entity Framework is a versatile and powerful ORM, but its performance depends on how it’s used. By following these best practices and leveraging the new features in .NET 9, you can build high-performance applications that scale efficiently.
Detailed Explanation of Use of Private Class vs Private Method
Feb 19, 2025.
A private class and a private method serve different purposes in object-oriented programming. A private class is restricted to its containing class, ensuring encapsulation, while a private method is used within a class to perform internal operations.
Various Methods to Count Occurrences of Each Number in Array or List
Feb 17, 2025.
In this article, I'll show you different ways to count how often a number appears in C#. We'll look at methods like LINQ, Dictionary, GroupBy, and Parallel.ForEach, and see which ones work best for small and large datasets.
Power of Dapper in .Net Core
Feb 16, 2025.
Dapper is a high-performance micro ORM for .NET Core, known for its speed and efficiency in database access. It simplifies SQL execution, object mapping, and data retrieval while maintaining flexibility.
Explaining Aggregate Functions in SQL
Feb 14, 2025.
Learn about SQL Aggregate Functions like SUM, COUNT, AVG, MIN, and MAX. These functions help perform calculations on grouped data, such as finding totals, averages, and minimum or maximum values, making data analysis more efficient.
Databricks Unity Catalog: Mastering Metastore and Namespace
Feb 10, 2025.
Databricks Unity Catalog provides a unified governance layer with a three-level namespace (Catalog, Schema, Table) for efficient data organization, access control, and sharing across workspaces, improving security and collaboration.
Getting Started with dbt (Data Build Tool) in Microsoft Fabric
Feb 10, 2025.
In this article, we will learn how to get started with DBT (Data Build Tool) in Microsoft Fabric for efficient data transformation and modeling.
Building a Number Guessing Game in Java
Feb 10, 2025.
Learn how to create a number guessing game in Java. This beginner-friendly project covers random number generation, user input handling, loops, and conditionals, with enhancements like difficulty levels and input validation.
Explain SSIS Designer for Newbies
Feb 07, 2025.
Learn how to create and manage SSIS packages using SSIS Designer in SQL Server Data Tools (SSDT). Explore key components like Control Flow, Data Flow, Parameters, Event Handlers, Package Explorer, and Connection Managers.
Class Fixture xUnit in .NET Core Test Project
Feb 06, 2025.
This article explains how to implement Class Fixtures in an xUnit test project, manage shared test contexts, and use dependency injection for better test organization and performance.
Reduce NULL Storage in SQL Server with Sparse Columns
Feb 05, 2025.
SQL Server Sparse Columns optimize storage by not allocating space for NULL values, improving efficiency. They support filtered indexes and column sets for dynamic queries but add a 4-byte overhead for non-NULL values, requiring careful use.
Set up dbt for Fabric SQL Database
Feb 04, 2025.
Learn how to set up and use the dbt-sqlserver adapter for Microsoft Fabric SQL Database to transform data, run models, and validate results using dbt’s SQL-based transformation framework.
A Better .NET SQL Builder: KnightMoves.SqlObjects
Feb 04, 2025.
KnightMoves.SqlObjects is a .NET SQL builder that is built entirely on objects, making it orders of magnitude more powerful and feature-rich than any string manipulating SQL builder could ever be. If you use SQL in your .NET application with ORMs like Dapper, for example, this library is for you.
Unlocking the Power of SQL for ETL
Feb 03, 2025.
SQL is crucial in ETL processes, enabling data extraction, transformation, and loading into databases, data warehouses, or lakes. It helps in real-time analytics, reporting, and machine learning, making it essential for data engineers.
ETL Pipeline using Microsoft SQL Server Integration Services
Jan 31, 2025.
This article is about building ETL (Extraction, Transformation and Loading) pipeline using SQL Server Integration Services (SSIS).
Installing and Using GitHub Copilot in Azure Data Studio
Jan 31, 2025.
Azure Data Studio helps manage databases and write SQL queries. With GitHub Copilot, it auto-suggests code completions, making complex SQL tasks easier, including writing queries, using JOINs, and generating reports efficiently.
Exploring Snowflake SQL New Capabilities Using SELECT Statement
Jan 29, 2025.
Learn how to leverage new features for efficient data querying, optimization, and advanced analytics in Snowflake’s cloud data platform. Perfect for data professionals.
Stopwatch for Performance Monitoring in .NET Core Applications
Jan 27, 2025.
Stopwatch helps to identify the performance of your applications. Explore the use of the Stopwatch class in .NET Core for performance monitoring in distributed systems. Learn its advantages, benchmarks, best practices, and advanced alternatives for high-throughput applications.
The Java.NET Package
Jan 25, 2025.
The Java.NET package provides classes for implementing networking functionality in Java. It supports TCP, UDP, and HTTP protocols, enabling tasks like creating sockets, managing URLs, sending/receiving data, and handling network connections.
How to Fix Recovery Pending State in MS SQL Server Database
Jan 24, 2025.
Learn about the causes of SQL Server's "Recovery Pending" state, methods to resolve it, and preventive measures. Explore manual fixes, recovery tools, and best practices to ensure database integrity.
Understanding Precision in SQL Server Calculations
Jan 24, 2025.
Learn why SQL Server calculations can produce different results depending on the approach used. Discover how single-step and multiple-step calculations handle precision and rounding, and how to achieve consistent outcomes with explicit rounding.