TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About Serv
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Naveen Kumar (14)
CSharp TV (8)
George (4)
Devesh Omar (4)
Aradhana Tripathi (3)
Amit Mohanty (3)
Sarthak Varshney (3)
Sangeetha S (3)
Sanjay Kumar (3)
Babita (2)
Gowtham K (2)
Vinodh Kumar (2)
Mohamed Shifan (2)
Gowtham Cp (2)
Monish Bansal (2)
Ck Nitin (1)
Jaimin Shethiya (1)
Ganesan C (1)
Pradeep Sahoo (1)
Raveena Attri (1)
Manoj Kalla (1)
Mohamed Azarudeen Z (1)
Rajeev Paliwal (1)
Najath Risni (1)
Santosh Karanam (1)
Praveen Sreeram (1)
Rama Dabburi (1)
Chethan N (1)
Poonam Beniwal (1)
Jignesh Kumar (1)
Rajkumar Jain (1)
Abiola David (1)
Jefferson S. Motta (1)
Kirtesh Shah (1)
Vinoth Xavier (1)
Manikandan Murugesan (1)
Jin Necesario (1)
Jaydeep Patil (1)
Tuhin Paul (1)
Meet Shah (1)
Datta Sai Krishna (1)
Kanchana Jayathilake (1)
Tural Suleymani (1)
Sardar Mudassar Ali Khan (1)
Mayooran Navamany (1)
Kaveendra Dhilhan (1)
Jalpa Dhola (1)
Pranshu Singhal (1)
Mohammad Rabie (1)
Debasis Saha (1)
Hadshana Kamalanathan (1)
Basant Kumar (1)
Vipul Malhotra (1)
Deepak Middha (1)
Jochen Bartlau (1)
Onkar Sharma (1)
Ibrahim Ersoy (1)
Gopal C. Bala (1)
Related resources for Serv
No resource found
What Developers Should Know about Observability
12/21/2024 4:27:18 PM.
In this video, we will explore modern observability and instrumentation approaches, focusing on the Pillars of Observability - “Metrics, Logs, Traces”
Next.js Vs ReactJs
12/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
How to Launch Your First EC2 Instance
12/20/2024 9:12:14 AM.
Launching your first AWS EC2 instance introduces you to cloud computing. It involves choosing an AMI, selecting instance types, configuring security groups, and setting up key pairs. Use the AWS Free
Create FTP Task in SQL Server Integration Services
12/19/2024 11:18:54 AM.
Learn how to create and configure an FTP Task in SQL Server Integration Services (SSIS). This task simplifies automated file transfers using the FTP protocol, making it essential for ETL processes.
How to Install Nginx on EC2 AWS
12/18/2024 10:09:52 AM.
Deploy Nginx on an AWS EC2 instance to serve as a powerful web server, reverse proxy, load balancer, and HTTP cache. This guide provides a step-by-step process for setting up Nginx on EC2, including i
Unlocking Faster INSERT Operations in SQL Server with TABLOCK
12/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.
Unit Testing in .NET Core with xUnit
12/16/2024 11:34:13 AM.
One of the main aspects of software testing that a developer can manage themselves is unit testing. It is employed to test your code's tiniest elements. Unit tests are used to verify that your cod
SQL Server ACID Properties
12/16/2024 8:24:34 AM.
Understanding SQL Server ACID(Atomicity, Consistency, Isolation, Durability) Properties. This article explains ACID properties—Atomicity, Consistency, Isolation, and Durability—highlighting their impo
Azure AD B2C as an Identity Provider for Blazor Applications
12/16/2024 7:04:28 AM.
From this article, you will learn how to integrate Azure AD B2C as an identity provider for a Blazor application. This article explains integrating Azure AD B2C with a Blazor server application, cover
SQS Message Polling using C#
12/15/2024 5:49:24 AM.
This article explores integrating Amazon Simple Queue Service (SQS) with C# applications, covering essential concepts like long polling, receiving messages, and using the AWS SDK for .NET.
Git GUI Clients (3-1), GitHub Server
12/13/2024 5:45:19 PM.
This article will briefly describe GitHub Server basic functionalities. This article is part of a series on Git GUI Clients. Focusing on GitHub Server, it delves into its major functionalities, guidin
Overview of Azure App Service Environment V3 - ASE V3
12/13/2024 7:31:17 AM.
In this article, we will learn about what is Azure App Service Environment V3, The basics of ASE V3, and how to create ASE V3 infrastructure using Terraforem
Using SignalR for Real-Time Communication in Blazor Applications
12/10/2024 9:10:45 AM.
SignalR enables real-time communication in Blazor applications, providing instant updates and efficient data transfer. This article explores its integration in Blazor Server and WebAssembly, including
Automating Table Creation using SSIS
12/10/2024 8:44:47 AM.
In this article, we will see how to create a database table in SQL Server using the SSIS package. Learn how to create a database table in SQL Server using an SSIS package. Follow step-by-step instruct
Understanding Triggers in SQL Server
12/9/2024 7:29:47 AM.
SQL Server triggers are automated procedures executed on DML/DDL events. This guide explores trigger types, real-world examples, and implementations for logging, validation, and restriction in SQL Ser
Token Caching in .NET 8 with Microsoft Entra ID
12/7/2024 3:22:18 AM.
Learn how to optimize .NET 8 web apps with token caching using Microsoft Entra ID. Discover in-memory and distributed caching strategies to boost performance, reduce latency, and improve scalability i
How to Install Node.js on AWS EC2 and Check Services Status
12/7/2024 3:04:42 AM.
Learn how to install Node.js on an AWS EC2 instance with this step-by-step guide. We’ll walk you through setting up an EC2 instance, installing Node.js, and verifying the installation. Additionally, y
Unit Test (2) --- TSQLT
12/7/2024 2:51:50 AM.
This article will discuss TSQLT Unit Test.
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
Deploying a Web Application Using NGINX on Alibaba Cloud
12/6/2024 5:25:43 AM.
Learn how to deploy a web application using NGINX on Alibaba Cloud with updated console steps, covering ECS setup, NGINX configuration, security, and optimization.
ASP.NET Core CRUD using Dapper, .NET 8 using SQL Server
12/5/2024 7:18:42 AM.
Learn to build a CRUD (Create, Retrieve, Update, Delete) application in ASP.NET Core MVC using .NET 8 and Dapper ORM. This guide covers creating models, repositories, controllers, and Razor views with
Create Worker Service and Deploy as Windows Service .NET Core
12/4/2024 5:01:25 AM.
In this article, we will learn how to create a .NET Worker Service in Visual Studio, configure it as a Windows Service, and manage it using commands for seamless background task execution.
Alibaba Cloud IMS: End-to-End Media Management Solution
12/3/2024 6:32:39 AM.
Explore Alibaba Cloud IMS, a powerful media service for content collection, processing, production, and delivery with advanced AI-driven workflows.
Integration of an LDAP server in servicenow
12/1/2024 5:58:17 AM.
In this article, we will learn how to enhance authentication, streamline user provisioning, and connect ServiceNow to directory services like Active Directory for seamless access control.
What is a CTE, and How Do You Write a CTE in SQL Server?
11/29/2024 8:23:30 AM.
A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into ma
How to Configure Azure Cloud Backup Service to Windows 11
11/28/2024 9:39:46 AM.
This article guides you through configuring Azure Cloud Backup Service on Windows 11. It covers the entire process from creating a resource in the Azure portal to setting up backup with the MARS agent
Learning SEQUENCE in SQL Server
11/28/2024 6:02:51 AM.
A SEQUENCE in SQL Server is a user-defined object that generates a sequence of numeric values in a specified order. Unlike identity columns, SEQUENCE objects are independent of tables, offering flexib
Minimal Web API With .NET 9
11/27/2024 11:10:40 AM.
In this article, you will learn about RESTFul Minimal Web API with .NET 6 and .NET 7. REST APIs use the REST architecture style to provide standardized resource access using HTTP verbs. Minimal APIs
Explaining CTE in SQL Server
11/27/2024 8:21:27 AM.
Common Table Expressions (CTEs) in SQL simplify complex queries by creating temporary result sets. They can be used in SELECT, INSERT, UPDATE, and DELETE statements, supporting scenarios like hierarch
Renaming a Database in SQL Server
11/27/2024 5:11:47 AM.
Renaming a database in SQL Server is vital for tasks like aligning naming conventions, testing, or version control. It involves setting the database to single-user mode, ensuring no active connections
Rank Functions in SQL server
11/26/2024 6:44:08 AM.
In this article, we will learn about Rank functions in SQL Server, like RANK(), DENSE_RANK(), ROW_NUMBER(), and NTILE(), are used to assign rankings to rows within a result set.
JSON Data Handling in SQL Server
11/26/2024 4:58:34 AM.
SQL Server supports JSON for managing semi-structured data. You can store JSON in NVARCHAR(MAX) columns, parse it with JSON_VALUE, JSON_QUERY, and OPENJSON, and modify it using JSON_MODIFY.
Yet another framework
11/25/2024 11:46:45 AM.
In this video, you will learn about missing patterns from the perspective of MVC.
Azure Storage Account Vs Azure Data Lake Service Gen 2
11/25/2024 8:15:25 AM.
Azure Data Lake Storage Gen2 (ADLS Gen2) is a highly scalable and analytics-optimized storage solution in Azure, offering hierarchical namespace, big data processing capabilities, and Secure File Tran
Alibaba Cloud ECS: Features, Benefits, and Service Architecture
11/25/2024 5:58:24 AM.
Learn about Alibaba Cloud ECS, its features, benefits, and scalable architecture. Discover how it simplifies cloud computing for businesses of all sizes.
New Features in SQL Server 2025: A Guide for Data Engineers
11/24/2024 5:46:37 AM.
SQL Server 2025 introduces advanced AI integration, vector support, and performance upgrades like optimized locking and enhanced columnstore indexing. New features include JSON data type, regular expr
Data Cleansing in SQL Server
11/24/2024 5:13:36 AM.
Learn the essentials of Data Cleansing in SQL Server to enhance data quality and reliability. This guide covers techniques like removing duplicates, handling null values, standardizing formats, and tr
Exploring SQL Databases in Microsoft Fabric
11/22/2024 11:29:28 AM.
Microsoft Fabric now integrates SQL databases, bridging transactional and analytical workloads in a unified platform. It enables cloud-native data storage in OneLake, supporting Parquet and Delta form
Comparison Between SQL and MongoDB Database
11/22/2024 5:23:46 AM.
SQL and NoSQL(MONGO) DB Comparison. This article compares MS SQL Server and MongoDB, highlighting their development, data models, schemas, performance, and query mechanisms, aiding in understanding th
User-Defined Functions in SQL Server
11/21/2024 5:14:12 AM.
SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single valu
Setup .NET Core on Windows Server with IIS Migration
11/21/2024 4:53:48 AM.
This guide covers the installation of software required for .NET Core on Windows Server and the process of configuring IIS for hosting .NET Core applications.
Events: Love Triangle in Integration Testing
11/20/2024 6:30:48 AM.
This video will delve into the main problems of not creating integration tests that check whether the application works fine, showing different alternatives with their pros and cons.
Apache Kafka with Dapr Bindings in .NET
11/20/2024 4:30:36 AM.
This content provides an in-depth overview of integrating Apache Kafka with Dapr Bindings for building distributed event-driven applications. It explains the key concepts of Apache Kafka, Dapr, and Da
Temporary Tables vs Table Variables in SQL Server Explained
11/19/2024 10:49:20 AM.
This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Unlocking the Power of the SELECT Feature in SQL Server
11/18/2024 12:04:57 PM.
This article explores the basics of the SQL Server SELECT statement, demonstrating how to query data from tables using practical examples. Learn how to fetch specific columns, improve query performanc
How to Install Ubuntu Server on VMware ESXi Using VMware Client Browser
11/18/2024 11:07:48 AM.
This guide explains how to install Ubuntu Server on VMware ESXi using the web client. It covers steps like creating a virtual machine, selecting storage, uploading the Ubuntu ISO, configuring network
Enhance SQL Server Stored Procedure Performance – Tuning Tips
11/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
Install and Enable IIS Express on Windows 11
11/16/2024 10:18:05 AM.
Learn how to install and enable IIS Express on Windows 10/11. Follow simple steps to download, install, and activate IIS Express for hosting web applications on your system.
Amazon OpenSearch Service Setup with Kibana
11/15/2024 9:48:13 AM.
Amazon OpenSearch Service enables real-time search, monitoring, and analysis of business data. It integrates with AWS services like CloudWatch Logs and Lambda for log aggregation, with Kibana for data
🚀 Amazon Bedrock Agents for Efficient Automation 🌟
11/14/2024 11:35:26 AM.
Unlock the power of Amazon Bedrock Agents with this comprehensive guide. Learn how to master efficient automation, streamline workflows, and optimize your cloud-based processes like a pro using AWS to
Azure Data Factory PRESERVE HIERARCHY Copy Behaviour
11/14/2024 9:41:42 AM.
In this video, I covered how to use the Preserve Hierarchy in Azure Data Factory Copy Behaviour.
Deploying ASP.NET Core 9 Application on IIS
11/14/2024 8:33:56 AM.
Learn how to publish ASP.NET Core 9 applications on IIS. This guide covers key steps such as setting the correct target framework, configuring IIS settings, handling common errors like 503, and using
Micro-Service Architecture in Devops
11/13/2024 11:35:44 AM.
Microservice architecture in DevOps focuses on developing and deploying applications as a collection of small, independent services. It enhances scalability, flexibility, and continuous integration/co
Understanding Keyed Services in .NET 8
11/13/2024 9:12:24 AM.
Keyed Services in .NET 8 enhance dependency injection by allowing multiple implementations of an interface to be registered with unique keys. This enables flexible dependency resolution, ideal for tai
Converting HTML to PDF or Image in C# Using wkhtmltopdf
11/13/2024 9:02:59 AM.
This guide explains generating PDFs and images from HTML using wkhtmltopdf in C#. With wkhtmltopdf's Webkit-based engine, convert HTML content, including complex CSS and JavaScript, into high-qual
🚀 Unlock Your Coding Potential with Amazon Q: AWS’s New AI Coding Assistant! 🚀
11/13/2024 7:02:38 AM.
If you are looking to enhance your coding workflow, check out Amazon Q. This AI-Powered coding assistant helps simplify coding with features like Code Understanding, Code Generation, Refactoring and T
Beginner's Guide to CRUD Operations in .NET Core 8 Web API
11/12/2024 7:30:14 AM.
This guide walks you through creating a .NET Core 8 Web API for managing employee data with full CRUD operations. Using Entity Framework Core, you’ll define models, connect to a SQL database, create e
Explaning AWS Lambda Function
11/12/2024 7:11:04 AM.
AWS Lambda is a service that computes the code without any server. It doesn't need any server running, so It is said to be serverless computer. The code is executed based on the response of events
RxJS Operator Essentials: Map, Tap, Filter, and More
11/12/2024 5:15:13 AM.
This article explores key RxJS operators in Angular, like map, tap, filter, take, and takeLast. You'll learn how each operator manipulates data streams to handle emitted values, log information, a
An Introduction to Microsoft Fabric Fundamentals
11/12/2024 5:13:49 AM.
Learn the core concepts, including Fabric architecture, data lake integration, and analytics capabilities, designed to streamline data management and empower insights across organizations.
SSRS (4) --- SQL Server Database Project in Visual Studio
11/11/2024 8:37:33 PM.
This article is to discuss: SQL Server Database Project in Visual Studio
SSRS (1) --- Server Setup: SSIS, SSAS, and SSRS
11/11/2024 8:31:56 PM.
This article is to discuss SSRS (1) --- Server Setup, SSIS, SSAS, and SSRS
Azure Logic App
11/10/2024 7:04:51 AM.
In this article, we will learn about Azure Logic Apps, which is a cloud-based service that enables users to create automated workflows and integrate applications, data, and services across the cloud a
Creating Interactive Charts with Chart.js and TypeScript
11/10/2024 6:08:34 AM.
To create a responsive chart in a TypeScript application, use Chart.js—a popular library for data visualization. Set up your TypeScript project, install Chart.js and its types, and configure Webpack f
Simplifying Multi-Cloud Observability
11/6/2024 11:31:54 AM.
This video highlights the essential role of standardized, vendor-agnostic approaches in ensuring scalability and usability in modern monitoring practices.
Create Azure App Service via PowerShell 7
11/5/2024 10:05:05 AM.
In this guide, learn how to create an Azure App Service using PowerShell 7. We'll cover the essential steps, including setting up your environment, configuring your app service plan, and deploying
Exploring the New T-SQL Enhancements in SQL Server 2022
11/5/2024 5:39:41 AM.
In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
Handling Transient Failures in .NET 8 With Polly
11/5/2024 4:30:31 AM.
This article discusses implementing a retry mechanism for handling transient faults in service interactions. It defines transient faults, such as temporary network issues or resource exhaustion, and e
Managing Exchange Online with Exchange 2019
11/2/2024 4:13:52 AM.
In this article, we will learn how to integrate on-premises infrastructure with cloud-based Exchange services for seamless administration, enhanced security, and efficient mail flow control.
Understanding API Gateways in Microservices
11/1/2024 5:34:50 AM.
The API Gateway pattern centralizes client requests, managing authentication, logging, rate limiting, and load balancing, optimizing resilience and scalability in complex microservice architectures th
Dependency Injection & EF Migrations in ASP.NET MVC with Autofac
10/30/2024 8:29:43 AM.
This article demonstrates how to implement Dependency Injection (DI) using Autofac in an ASP.NET MVC application and integrate Entity Framework for database operations, including migrations.
BIT Functions New T-SQL Enhancements in SQL Server
10/30/2024 5:58:33 AM.
In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
Securing Remote Access to SQL Server
10/30/2024 5:39:48 AM.
Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
Windowing Enhancements New T-SQL Enhancement in SQL Server
10/29/2024 6:29:27 AM.
SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
Data Reliability and Availability with Microsoft Fabric Mirroring
10/29/2024 4:05:52 AM.
Mirroring in Microsoft Fabric enhances data reliability and availability by creating redundant copies of data across multiple locations. This ensures high availability, fault tolerance, and rapid disa
Create a Model with Database Table in .NET 8 using EF Core
10/28/2024 7:16:12 AM.
This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection str
Efficient Data Handling in SQL Server with Table-Valued Parameters
10/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.
Server-Driven UI: Building Dynamic React Applications
10/25/2024 11:44:23 AM.
This video will explore how SDUI, combined with React, empowers teams to build flexible, maintainable, and quickly adaptable applications that deliver exceptional user experiences.
Speedy Microservices: Build and Deploy in 30 min with Copilot & Devprime
10/25/2024 11:40:16 AM.
In this video, you will learn how Copilot & Devprime revolutionize your Dev Experience.
TRIM Function New T-SQL Enhancements in SQL Server
10/25/2024 10:44:09 AM.
The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
Understanding ARC in Email Authentication
10/25/2024 9:03:52 AM.
Email authentication is crucial for preventing spoofing and phishing attacks, and ensuring secure communication. Authenticated Received Chain (ARC) helps mitigate failures caused by message modificati
GENERATE_SERIES Function New T-SQL Enhancements in SQL Server
10/25/2024 6:06:40 AM.
The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
Understanding the Role of Servers in Modern Networking
10/25/2024 4:56:40 AM.
Servers play a crucial role in modern networking by managing data storage, processing, and communications across networks. From web hosting and cloud computing to secure data transfer, servers enable
Enhancing Forms with React Server Components
10/24/2024 11:49:57 AM.
In this video, we explore the application of React Server Components (RSC) to elevate the functionality and efficiency of forms.
Create a Data Visualization Adaptive Card Extension
10/24/2024 7:03:25 AM.
Creating a Data Visualization Adaptive Card Extension (ACE) for SharePoint Online using the SharePoint Framework (SPFx) involves building a custom ACE component to display visual data in the form of c
Enhancing Microservices with Kafka: A Distributed Messaging Solution
10/23/2024 8:17:59 AM.
In this video, we will explore how to effectively bridge various pods and JVMs while considering key factors such as scalability, resilience, high availability, and performance for intensive applicati
Introduction to Power BI: A Beginner's Guide
10/22/2024 9:31:36 AM.
Power BI is a powerful business analytics tool from Microsoft designed for data visualization and sharing insights across organizations. This beginner-friendly guide covers its key components, includi
Caching HTML Tags Using WebForms Core Technology
10/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.
Serialization and DeSerialization in C#
10/21/2024 10:18:19 AM.
Serialization is the process of converting an object into a storable format, such as XML, JSON, or binary, while deserialization restores it to its original form. Common types include XML, JSON, Binar
Learn AngularJS From Beginning: Service - Part Three
10/21/2024 9:48:47 AM.
This article explores AngularJS services, emphasizing their role in organizing and sharing code through dependency injection. It covers creating custom services using the factory, service, and provide
Activate Server-Side Encryption for Azure Disks with Customer Keys
10/21/2024 6:21:07 AM.
Azure Disk Storage offers server-side encryption (SSE) with customer-managed keys, allowing users to control encryption for managed disks. By utilizing Azure Key Vault, users can manage access and enh
Troubleshooting 404 or 500 Error After Deploying Vue 3 App to IIS
10/21/2024 6:06:12 AM.
Facing a 404 or 500 error after deploying a Vue 3 application to IIS? This guide helps troubleshoot common issues, from configuring the web.config file to resolving routing problems with Vue Router
Azure service bus queue with .net core and python
10/20/2024 9:30:13 AM.
This article demonstrates how to implement Azure Service Bus queues using both .NET Core and Python. It covers creating a message sender with a web API in .NET Core and a receiver using a console app.
Check Constraint in SQL Server 2012
10/16/2024 9:55:46 AM.
A Check Constraint in SQL Server enforces Domain Integrity by ensuring valid values for specific table columns. It restricts invalid data entries, rejects values that don't meet set conditions, an
STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server
10/16/2024 9:01:22 AM.
The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of ea
Gitea - an Open Source, Self Hosted GitHub Alternative
10/16/2024 4:51:49 AM.
Gitea is a lightweight, self-hosted Git server that offers features similar to GitHub, including issue tracking, pull requests, and a web-based interface. It's ideal for organizations needing data
Least and Greatest New T-SQL Enhancements in SQL Server
10/15/2024 11:42:36 AM.
Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
How To Delete Duplicate Rows From A Table In SQL Server
10/12/2024 5:29:23 AM.
This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the o
Get All Instances of SQL Server in C#
10/11/2024 12:29:27 PM.
If you're writing a Database Manager application or simply want to retrieve all the instances,this trick might come in handy.
Integration And Server Broadcast With SignalR 2
10/11/2024 12:29:10 PM.
Discover how to implement real-time communication in your applications using SignalR 2. This guide covers the integration of SignalR for server broadcast functionality, enabling seamless data transfer