TECHNOLOGIES
NEWS
VIDEOS
FORUMS
Trainings
BOOKS
Live
MORE
INTERVIEWS
EVENTS
JOBS
LEARN
CAREER
MEMBERS
BLOGS
CHALLENGES
CERTIFICATIONS
Bounties
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
Content
People
Search
Any Word
Exact Word
Content Filter
Articles
Videos
Blogs
Resources
News
Forums
Interviews
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Nidhi Sharma(14)
John Godel(7)
Niharika Gupta(5)
Mahesh Chand(4)
Aarav Patel(3)
Vipin Mittal(3)
Sangeetha S(3)
Emanuel Martins(3)
Ananya Desai(2)
Sandhiya Priya(2)
Carl Walker(2)
Darshan Adakane(2)
Ng Cheehou(2)
Naveen Kumar(2)
Aman Gupta(2)
Vaishali Vishwakarma(2)
Raghunath Bhukan(1)
Rohit Gupta(1)
Tanuj (1)
Saurav Kumar(1)
Varun Setia(1)
Keshaw Kumar Thakur(1)
Ajay Narkhedkar(1)
Maria Prince(1)
Vishal Gami(1)
Rajesh Gami(1)
Vinoth Xavier(1)
Divyansh Gupta(1)
Sardar Mudassar Ali Khan (1)
Micheal Xavier A (1)
Ck Nitin(1)
Riya Patel(1)
Dashrath Hapani(1)
Rishima (1)
Tafida B(1)
Kartik (1)
Bimalshi Jayarathna(1)
Tharunkumar Magudeeswaran(1)
Rijwan Ansari(1)
Mark Pelf(1)
Praveen Sreeram(1)
Nandan Hegde(1)
Mayooran Navamany(1)
Rajeev Paliwal(1)
Gurpreet Arora(1)
Siddhesh Chavan(1)
Vinodh Kumar(1)
George (1)
Jefferson S. Motta(1)
Reena Bhalerao(1)
Sreenath Kappoor(1)
Velladurai (1)
Habibul Rehman(1)
Lokendra Singh(1)
Harshit Pandey(1)
Rinki (1)
Allani Saikumar(1)
Ayush Gupta(1)
Latest First
Oldest First
Most Viewed
Sort By
Search Results
No search result found
How to Implement Database Connection Pooling in High-Traffic Applications
Mar 17, 2026.
Boost app performance! Learn database connection pooling for high-traffic apps. Reduce latency, improve scalability, and handle concurrent requests efficiently.
How to Design a Scalable Database Schema for Multi-Tenant Applications
Mar 17, 2026.
Master multi-tenant database design! Learn schema strategies, indexing, and scalability techniques for SaaS applications. Ensure data isolation and performance.
What Is Database Sharding and When Should Developers Use It?
Mar 16, 2026.
Explore database sharding: a powerful technique for scaling databases by distributing data across multiple servers. Improve performance and handle high traffic efficiently.
Difference Between Relational Database and NoSQL
Mar 11, 2026.
Learn the complete difference between relational databases and NoSQL databases including architecture, scalability, performance, use cases, and real world examples. A detailed guide for developers and architects.
When To Use a Relational Database Instead of NoSQL?
Mar 11, 2026.
Learn when to use relational databases instead of NoSQL databases. This guide explains architecture, consistency, transactions, and real world use cases for choosing SQL databases.
How to optimize database queries for high-performance applications?
Mar 09, 2026.
Boost app speed! Learn to optimize database queries with indexing, caching, and schema design. Reduce server load and enhance user experience. Essential tips inside!
What is database partitioning and when should developers use it?
Mar 09, 2026.
Database partitioning boosts performance by dividing large tables into smaller, manageable partitions. Learn when and how to use this technique for scalability.
How to analyze and fix slow database queries in production environments?
Mar 09, 2026.
Troubleshoot slow database queries in production. Learn to analyze execution plans, optimize indexes, and implement caching for peak performance. Keep your app fast!
How to Implement Database Indexing Strategies for Faster Queries
Mar 06, 2026.
Boost database performance! Learn indexing strategies (single, composite, full-text) to speed up queries, improve scalability, and enhance user experience. Optimize your database now!
What Is Database Replication and How Does It Improve Availability?
Mar 06, 2026.
Explore database replication: Enhance availability, reliability, and performance by copying data across multiple servers. Learn about types, benefits, and challenges.
How to Optimize Database Performance in High-Traffic Applications
Mar 06, 2026.
Boost app speed! Optimize database performance for high-traffic applications. Learn indexing, caching, replication & more for scalable, reliable systems.
What Are the Best Practices for Designing Scalable Database Schemas?
Mar 06, 2026.
Master scalable database schema design! Learn best practices for normalization, indexing, partitioning, and relationships to build high-performance applications.
How to Optimize Database Queries for Large-Scale Applications?
Mar 05, 2026.
Optimize database queries for large-scale apps! Learn indexing, caching, and more to boost performance, reduce server load, and ensure scalability.
What Is Connection Pooling and How Does It Improve Database Performance?
Mar 05, 2026.
Boost database performance with connection pooling! Learn how reusing connections reduces overhead, improves response times, and enhances application scalability. A must-read for developers!
How to Design a Scalable Database Schema for Growing Applications
Mar 05, 2026.
Learn to design scalable database schemas for growing applications! Master normalization, indexing, partitioning, and sharding for optimal performance and maintainability.
What Is Database Sharding and When Should You Use It?
Mar 03, 2026.
Database sharding horizontally scales databases, improving performance and availability. Learn when and how to use it for high-traffic systems. A must-read!
Different Types of Database Providers in ASP.NET Core
Feb 27, 2026.
Explore the different types of database providers in ASP.NET Core including EF Core, SQL Server, PostgreSQL, MySQL, SQLite, MongoDB, Cosmos DB, Dapper, and ADO.NET. Learn how to choose the right provider with real-world coding examples and best practices for scalable, high-performance applications.
How to Fix “Cannot Drop Database Because It Is Currently in Use” in SQL Server
Feb 27, 2026.
Learn how to fix the "Cannot drop database because it is currently in use" error in SQL Server. This guide provides a step-by-step solution, safe scripts, and best practices for database deletion. Ensure a smooth and error-free database management process.
How to Improve SQL Server Performance with Database Indexing
Feb 26, 2026.
Boost SQL Server performance with database indexing! Learn about clustered, non-clustered, and composite indexes, plus implementation and maintenance tips for optimal speed.
How to Fix Slow Database Queries in Production Environment?
Feb 25, 2026.
Boost app performance! This guide provides a structured approach to identify, analyze, and fix slow SQL queries in production. Optimize your database now!
How to Troubleshoot and Fix SQL Database Stuck in Restoring State?
Feb 22, 2026.
Is your SQL database stuck in restoring state? This guide provides troubleshooting steps, including using WITH RECOVERY, dropping & restoring, and backup integrity checks. Learn to fix it!
What Are the Best Database Optimization Techniques?
Feb 19, 2026.
Boost database performance! Explore indexing, query optimization, caching, partitioning, and more. Ensure speed and scalability for your applications.
How to Set Up Automated Database Backups in Production?
Feb 13, 2026.
Protect production data with automated database backups! Learn to configure full, incremental, & differential backups, RTO/RPO, storage, encryption, & testing.
What Is an AI Database Agent and How to Build One Securely Using OpenClaw
Feb 10, 2026.
What an AI agent that talks to your database is, and how to build one using OpenClaw with secure database access, query validation, and structured AI outputs.
How to Fix Slow Database Queries After Recent Data Migration
Feb 06, 2026.
Database slow after migration? This guide provides a step-by-step approach to diagnose and fix performance issues. Optimize indexes, queries, and configurations!
Comprehensive Guide to SQLITE database in android development
Feb 05, 2026.
Master Android's SQLite database for efficient data persistence! Learn core components, CRUD operations, and schema design. Explore modern alternatives like Room.
MongoDB vs MySQL: Which Database Should You Choose and Why
Feb 03, 2026.
Explore MongoDB vs MySQL: a detailed comparison to help you choose the right database for your project. Understand data models, scalability, and use cases.
The Gödel Autonomous Memory Fabric DB Layer: The Database Substrate That Makes Continual-Learning Agents Safe, Auditable, and Scalable
Feb 02, 2026.
Gödel Memory Fabric: A governed database layer for autonomous AI agents. Ensures safe, auditable, and scalable continual learning by managing memory lifecycle.
How to Perform Zero-Downtime Database Migrations
Feb 02, 2026.
Achieve zero-downtime database migrations! Learn how to avoid downtime with backward-compatible changes, gradual rollouts, and careful monitoring. Keep your app running!
How to Design Database Migrations That Never Need Rollback
Feb 02, 2026.
Eliminate database migration nightmares! Learn proven strategies for designing forward-compatible, rollback-free migrations. Reduce downtime and ensure data integrity.
Why Does Database Backup Take Longer as Data Grows?
Jan 28, 2026.
Database backups slow down as data grows due to increased read/write, compression, and network transfer. Learn why and how to adapt your backup strategy!
Why Does Database Disk Space Keep Increasing Even After Deleting Data?
Jan 27, 2026.
Database disk full even after deleting data? Learn why! Discover the hidden reasons behind persistent storage growth and how to reclaim valuable space.
Handling Concurrent Database Access in .NET: Understanding Locks, Transactions, and Optimistic Concurrency
Jan 16, 2026.
Master .NET database concurrency! Learn to handle simultaneous access with locks, transactions, and optimistic concurrency. Prevent data conflicts and ensure data integrity using practical examples.
Simple Demo Of Vector Database With Qdrant — Image Search
Jan 07, 2026.
Build image search for e-commerce using Qdrant! This demo uses CLIP & ResNet50 for semantic & visual similarity, enabling a powerful hybrid approach.
Simple Demo Of Vector Database With Qdrant — Semantic Search
Dec 29, 2025.
Explore vector databases like Qdrant for semantic search. Learn how to use AI embeddings to match user intent with the right services, boosting website traffic.
FastAPI with PostgreSQL: Simple API and Database Integration
Dec 28, 2025.
Build a FastAPI application connected to PostgreSQL, demonstrating database function calls via API endpoints. Learn safe interactions, parameterized queries, and error handling. This guide provides a practical pattern for database-backed FastAPI applications.
SQL Server cannot Open Database File (Error 5171/5172) – How to Repair MDF/NDF File
Dec 29, 2025.
Resolve SQL Server errors 5171 and 5172, which occur when the database cannot open the MDF file. Learn to repair corrupted MDF/LDF files using DBCC CHECKDB and transaction log rebuilding.
Configuring EF Core Database Connections in ASP.NET Core
Dec 17, 2025.
A complete guide to configuring database connections in ASP.NET Core using EF Core. Learn how to use IDesignTimeDbContextFactory, configure DbContext in Program.cs/Startup.cs, and use the OnConfiguring fallback method for design-time and runtime scenarios.
Entity Framework Core – Database First Approach
Dec 14, 2025.
This article provides a complete and descriptive explanation of the Entity Framework Core Database First approach. It explains how EF Core generates entity classes and DbContext from an existing database, how scaffolding works, how relationships, views, and stored procedures are handled, and how to safely manage schema changes using re-scaffolding and partial classes. Written in simple language, this guide is ideal for beginners and professional .NET developers working with legacy or enterprise databases using Entity Framework Core.
SQL Server Database Mail Setup and SMTP Configuration Guide
Dec 04, 2025.
Configure SQL Server Database Mail with this beginner-friendly guide! Learn to set up SMTP, create profiles, and send test emails for seamless notifications. Perfect for new developers!
Essential Database Optimization Tips for High-Performance Applications
Dec 02, 2025.
Boost application performance with essential database optimization tips! Learn SQL Server & ASP.NET Core strategies for faster queries, indexing, and caching. Ensure a reliable, scalable database.
Using AI to Suggest Database Indexing Strategies in SQL Server: Intelligent Optimization for High-Performance Applications
Nov 11, 2025.
Optimize SQL Server with AI! Automate database indexing, reduce query latency, and ensure peak performance. Learn to build intelligent, self-learning systems.
📊 Building a Centralized Reporting Database Using Linked Servers in SQL Server
Nov 08, 2025.
Centralize SQL Server reporting! Learn to build a reporting database using Linked Servers. Query across servers, unify data, and simplify analytics in real-time.
Implementing Database Audit Logging Using Triggers in Oracle
Nov 06, 2025.
Implement robust audit logging in ASP.NET with Oracle using database triggers. Track CRUD operations, user actions, and data changes for compliance and security.
🧾 Dynamic ActiveX Report Using Database in Angular
Oct 24, 2025.
Modernize legacy reporting! Learn to integrate dynamic ActiveX reports from SQL databases into Angular apps using a .NET backend. Generate PDFs and more!
🔐 Advanced Authentication Types For SQL Server and Other Database Systems
Oct 22, 2025.
Secure your SQL Server and databases with robust authentication! Explore SQL Authentication, Windows Authentication, and Azure AD, each offering unique security features. Learn best practices for password management, centralized identity control, and cloud-based access. Choose the right method based on your infrastructure, security needs, and whether you're on-premise, in the cloud, or hybrid.
How to Recover a SQL Server Database in Emergency Mode (Step-by-Step)
Oct 15, 2025.
Learn how to recover a SQL Server database stuck in EMERGENCY mode with this step-by-step guide. Discover how to diagnose corruption using DBCC CHECKDB, repair the database, and restore it to a normal operational state. We cover manual emergency mode activation, single-user mode, and the crucial REPAIR_ALLOW_DATA_LOSS option.
Understanding Database Migration Service (DMS)
Oct 07, 2025.
Unlock seamless database migration with DMS! This comprehensive guide explores Database Migration Service (DMS), a powerful tool for migrating databases with minimal downtime. Learn about its key features, benefits, use cases, and best practices. Discover how DMS simplifies cloud adoption, database modernization, and disaster recovery, enabling businesses to focus on innovation and growth. Migrate securely and efficiently across diverse platforms.
What happens when you restart MySQL (WAMP’s database service)?
Oct 03, 2025.
Learn about dropped connections, aborted queries, and the potential for MyISAM table corruption. Discover safer alternatives like health checks, off-peak scheduling, and MySQL configuration tuning to avoid frequent restarts and ensure data integrity. Minimize downtime and prevent application errors!
How to Connect ASP.NET Core MVC with Database using EF Core (DB-First)
Sep 11, 2025.
Unlock the power of database connectivity in ASP.NET Core MVC with EF Core's DB-First approach! This article simplifies connecting your application to SQL Server, offering a step-by-step walkthrough from project setup to data retrieval. Learn to scaffold models, register DbContext, and leverage LINQ for efficient database interactions, avoiding raw SQL.
🚀 Top 30 Proven Ways to Optimize SQL Server Database Performance (with Examples)
Sep 09, 2025.
Unlock peak SQL Server performance! This guide delivers 30 proven techniques with practical examples to optimize your database. Learn how to speed up slow queries, improve indexing, refine schema design, and implement caching strategies. From data types to execution plans, master the art of SQL Server tuning for scalable and efficient applications. Boost your database performance today!
What is a Vector Database in Data Science?
Sep 10, 2025.
Unlock the power of AI with vector databases! This article explains what vector databases are, why they're crucial for modern data science, and how they enable semantic search, recommendation systems, and more. Discover real-world use cases, popular tools like Pinecone and Weaviate, benefits, and challenges.
Best Practices for Database Optimization in Web Development
Sep 10, 2025.
Optimize your web development database for speed and efficiency! Learn best practices for indexing, query optimization, data normalization, and caching. Discover how to choose the right data types, monitor performance, partition large tables, and maintain backups for a faster, more reliable application. Improve user experience and reduce server load with these essential techniques.
How Database Engineers and DBAs Can Use Generative AI to Boost Productivity
Aug 20, 2025.
How Database Engineers and DBAs Can Use Generative AI to Boost Productivity
Smart Query Caching in C#: Auto-Invalidate on Database Changes
Aug 20, 2025.
Learn how to keep your cache fresh using SqlDependency, version-stamps, event-driven invalidation, and Redis Pub/Sub in C#, ensuring high performance, consistency, and scalability across applications.
MongoDB: Flexible NoSQL Database for Modern Applications
Aug 19, 2025.
MongoDB is a popular open-source NoSQL database that uses a flexible document-oriented model with BSON format, offering scalability, sharding, replication, and easy integration for modern web and mobile apps.
Evolution of Database Systems
Jul 31, 2025.
This article traces the evolution of databases from flat files to AI-driven metadata systems, highlighting how intelligent architectures are transforming data discoverability, governance, and operational efficiency in modern platforms.
🚀 Automating SQL Server Database Backups and Remote Table Sync
Jul 11, 2025.
This SQL stored procedure automates local database backups and replicates all tables to a remote server with suffixes, ensuring disaster recovery, reporting, and schema sync—no manual table handling required.
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.
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.
.NET core MAUI with SQLite Database Login Page example
May 24, 2025.
Learn to build a basic MAUI app with SQLite integration, featuring login and registration pages. This article includes creating a SQLiteHelper class and implementing database logic in Visual Studio 2022.
Storing Event Streams in a Database Using Cosmos DB with C#
May 03, 2025.
This article covers real-time data ingestion, NoSQL storage design, and integration with event-driven architectures—ideal for developers building scalable and responsive cloud applications with .NET and Azure.
Advanced C# Database Tricks into a Practical Solution
May 02, 2025.
This project demonstrates an advanced C# database architecture combining EF Core, Dapper, and ADO.NET to achieve optimal performance, flexibility, and maintainability—complete with clean architecture, logging, and benchmarks.
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.
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.
Abstract Factory Pattern for Database Access in C# 14
Apr 21, 2025.
This article covers creating flexible, maintainable code for handling multiple databases, while leveraging modern C# features for clean architecture and scalability.
Updating an Object in the Local Database in MAUI .NET 9 [GamesCatalog] - Part 11
Apr 03, 2025.
Learn how to retrieve and update game statuses in a local database using MAUI .NET 9. Implement async functions in GameRepo and GameService, manage game status, and enhance UI interactions efficiently.
Adding Objects to a Local Database in MAUI .NET 9 [GamesCatalog] - Part 10
Apr 02, 2025.
Learn how to store game reviews in a local SQLite database using MAUI .NET 9. This guide covers setting up repositories, handling images, adding games, and implementing dependency injection for seamless functionality.
Setting Up and Using a Local SQLite Database in MAUI .NET 9 [GamesCatalog] - Part 9
Mar 31, 2025.
This article covers database integration, CRUD operations, and best practices for storing data locally in a cross-platform mobile application. Follow along to enhance your MAUI app with efficient data management.
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.
Dynamic Database Web API in .NET 9: Clean Architecture & MediatR for Flexibility
Mar 17, 2025.
A Web API should support multiple database options such as SQL Server, PostgreSQL, MySQL, and SQLite without major code changes. In this article, we will build a .NET 9 Web API using Clean Architecture, Domain-Driven Design (DDD), and MediatR, while implementing dynamic database selection using Entity Framework Core (EF Core).
SQL Server – Query Performance – Database Maintenance can Help
Jan 14, 2025.
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 or automatic execution for optimal results.
Azure SQL Database - Configure Job using Elastic Agents
Jan 07, 2025.
This article covers setting up Elastic Job agents, creating jobs, and automating tasks across multiple databases. Streamline database management, schedule tasks efficiently, and enhance performance with Elastic Database Jobs.
SQLite Database with .NET Example
Dec 10, 2024.
SQLite is a lightweight, file-based relational database ideal for small web, mobile, and .NET applications. This guide demonstrates SQLite integration, CRUD operations, and database handling using C#.
.NET with MONGO Database Code Example
Nov 28, 2024.
Learn MongoDB integration with .NET, from setup to CRUD operations. Discover its advantages, like cross-platform flexibility, high-speed data handling, and robust security, with code examples for seamless database interaction.
Renaming a Database in SQL Server
Nov 27, 2024.
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, using the ALTER DATABASE command, and managing dependencies.
CI/CD of MSFT Fabric Database via Azure DevOps
Nov 22, 2024.
Learn how to set up a CI/CD pipeline for Microsoft Fabric Database using Azure DevOps. This guide covers automated deployment, integration, and management of databases in a seamless DevOps workflow.
Create a Model with Database Table in .NET 8 using EF Core
Oct 28, 2024.
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 string, and use migrations to manage your database schema.
How to Decide Between Relational Database and NoSQL Databases?
Sep 30, 2024.
Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, making them ideal for applications requiring data integrity.
Understanding Database Sharding in Programming
Sep 24, 2024.
Learn how sharding improves scalability and performance in distributed databases, key strategies for partitioning data, best practices for shard key selection, and techniques to optimize data management.
Learn Database Mail in SQL Server
Aug 29, 2024.
Database Mail in SQL Server is a robust feature that enables sending emails via an SMTP server without relying on MAPI clients like Outlook. It offers secure SSL encryption, asynchronous processing, extensive logging, and seamless integration with SQL Server Agent, making it ideal for automated email notifications and alerts.
Vector Database Internals: In a Layman's Perspective
Aug 29, 2024.
A vector database stores and manages data as vectors—lists of numbers representing features of items. It excels in handling unstructured data like images and text by using vector embeddings generated by AI. This allows for efficient similarity searches, real-time analysis, and scalable performance.
SSRS (4) --- SQL Server Database Project in Visual Studio
Aug 25, 2024.
This article is to discuss: SQL Server Database Project in Visual Studio
Store Java Errors in Database with Dynamic Error-Based Logging
Aug 23, 2024.
It covers setting up logging frameworks, capturing runtime errors, and ensuring data persistence for effective error management and tracking. Ideal for improving application reliability and diagnostics.
Learn to Shrink a Microsoft SQL Server Database Programatically
Aug 20, 2024.
Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause data fragmentation and impact performance. Use commands like DBCC SHRINKDATABASE cautiously in C#.
How to Retrieve and Display Database Records in Java Using JTable
Aug 13, 2024.
Learn how to retrieve and display database records in Java using JTable with this step-by-step guide. Explore Java Swing for creating a graphical user interface, JDBC for database connectivity, and SQL queries for fetching data.
ASP.NET C# Display Bootstrap Bar Chart from Database Values
Jul 22, 2024.
Create a stored procedure in SQL to fetch monthly audit data and display it in an ASP.NET application. Use Visual Studio to create a master page with jQuery and Flot libraries. Serialize the data to JSON in the code-behind, then plot it in a bar chart on a content page.
Connecting to a MySQL Database Over LAN Using SQL Workbench
Jul 22, 2024.
Learn how to connect to a MySQL database over a local area network (LAN) using SQL Workbench. This guide covers finding the IP address of the MySQL server, configuring it for remote access, setting up firewall rules, and establishing a connection from a client machine.
PostgreSQL Database Backup and Restore using pgAdmin
Jul 12, 2024.
This article provides a step-by-step guide on how to backup and restore a PostgreSQL database using the pgAdmin GUI. It covers the prerequisites, the detailed process of creating backups, and restoring data from backup files, ensuring your data is safely managed and recoverable in case of issues
Using EF Core to Scaffold DbContext and Models from Existing Database Tables
Jul 12, 2024.
In this article, we will see how using Scaffolding we can generate database context (DbContext) class for database and model of entities in that database's table. We will be using MS SQL Server as data source and use EF Core framework.
Database Objects Related to Table in Database - Transact SQL Query
Jun 29, 2024.
The SQL query retrieves distinct object names and their types from SYSCOMMENTS and SYSOBJECTS system tables, categorizing objects by their XTYPE values ('P' for procedure, 'V' for view, 'TR' for trigger). It filters results containing 'table_name' in their definitions, providing insights into database object metadata.
How To Connect Database in ASP.NET MVC using C# with ADO.NET
Jun 17, 2024.
Learn how to integrate SQL Server with your MVC application, configure connection strings, and perform CRUD operations. Ideal for developers seeking to enhance their data access techniques in ASP.NET.
Integrating Azure SQL Database with Azure Functions
Jun 17, 2024.
Azure SQL Server is a fully managed database service by Microsoft Azure, offering scalability, high availability, and robust security features. It integrates seamlessly with Azure Functions for building scalable applications.
DuckDB: The Powerful Embedded Database for Analytics
Jun 16, 2024.
DuckDB is a high-performance, embedded database designed specifically for data analytics. It offers in-memory processing, SQL support, and columnar storage, making it ideal for analytical queries and data warehousing.
Automate MySQL Database Updates with Cron Jobs in Node.js
Jun 13, 2024.
Learn how to automate MySQL database updates using cron jobs in Node.js with this comprehensive step-by-step guide. Discover how to schedule tasks, write automated scripts, and maintain your database efficiently.
Best Practices For Effective Database Design In SQL Server
May 28, 2024.
In this article, we will be exploring the best practices for effective database design in SQL Server. Creating an SQL Server database involves best practices like understanding requirements, normalization, choosing data types, indexing, and security.
Automatic Tuning Enhances SQL Server Database Performance
May 20, 2024.
Automatic Tuning in SQL Server combines various intelligent features and techniques to continuously monitor, analyze, and optimize database performance and reduce management overhead. In this article, we will explore the what, why, and how to create automatic tuning in SQL Server Database.
Dynamic Mapping Database result to Entity T
May 20, 2024.
This article provides logic for Mapping the SQL Result to C# Class. This code snippet demonstrates the dynamic mapping of SQL result columns to C# properties, converting SNAKE_CASE SQL column names to PascalCase C# properties using MapToList for DbDataReader to object mapping.
Understanding ACID: The Foundation of Database Transactions
May 17, 2024.
In the domain of database management, ACID (Atomicity, Consistency, Isolation, Durability) principles assure transaction reliability. This article delves into ACID's history, necessity, evolution, constraints, and SQL implementations' demonstrations.
1
-
100
of
1419
<<
1
2
3
4
5
>>
Search
OUR TRAINING
Discovery to Delivery
Employing the latest technologies, Over-C's capabilities include web and mobile development, software and database architecting as well as visual and UX design.