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 DB
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Prashanth Chindam (6)
Naveen Kumar (4)
Vishal Joshi (4)
CSharp TV (3)
Rohini Parade (3)
Sarthak Varshney (3)
Abiola David (3)
George (3)
Mrunali Sawant (3)
Shweta Lodha (2)
Muhammad Imran Ansari (2)
Jignesh Trivedi (2)
Shilpa Tanwar (2)
Chetan Sanghani (2)
Yogeshkumar Hadiya (2)
Ayush Gupta (2)
Sandeep Singh Shekhawat (2)
Omar Rodriguez (1)
Sardar Mudassar Ali Khan (1)
Mayooran Navamany (1)
Nitin Pandit (1)
Abhimanyu K Vatsa (1)
Shiv Sharma (1)
Arpit Shrivastava (1)
Mithilesh Kumar (1)
Nidhi Kumari (1)
Jamil Moughal (1)
Rupenkumar Anjaria (1)
Jefferson S. Motta (1)
Sateesh Arveti (1)
Mukesh Kumar (1)
Tural Suleymani (1)
Darshan Adakane (1)
Madhavi Wani (1)
Vijai Anand Ramalingam (1)
Ajay Kumar (1)
Vijay Yadav (1)
Sreenath Kappoor (1)
Hari Lakkakula (1)
Sigar Dave (1)
Gajendra Jangid (1)
Saurabh Prajapati (1)
Lokendra Singh (1)
Farhan Ahmed (1)
Surya Ghimire (1)
Harshad M (1)
Habibul Rehman (1)
Virender Verma (1)
Harshit Pandey (1)
Sibeesh Venu (1)
Ehsan Sajjad (1)
Rinki (1)
Allani Saikumar (1)
Rahul Kumar Saxena (1)
Thiago Vivas (1)
Jobin S (1)
Munesh Sharma (1)
Kaviya Balasubramanian (1)
Chethan N (1)
Anubhav Chaudhary (1)
Vikas Singh (1)
Anoop Kumar Sharma (1)
Jaimin Shethiya (1)
Ajay Yadav (1)
Divyansh Gupta (1)
Shirsendu Nandi (1)
Sarathlal Saseendran (1)
Shervin Cyril (1)
Edinbiro James (1)
Related resources for DB
No resource found
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.
Creating a CQRS Architecture in .NET Core 8
11/4/2024 7:29:08 AM.
This guide outlines a practical implementation of the CQRS (Command Query Responsibility Segregation) architecture using C# and MediatR, emphasizing the separation of read and write operations for bet
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.
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
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
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
Mastering SQL Query Generation with Azure OpenAI
10/9/2024 6:07:40 AM.
Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how
Exploring Aggregate Functions in Azure Cosmos DB
10/7/2024 4:43:48 AM.
Aggregate functions in Cosmos DB allow efficient data summarization and analysis across multiple documents. They perform calculations such as AVG, COUNT, SUM, MAX, and MIN to retrieve meaningful insig
IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server
10/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
Enhance Search with Azure SQL DB FAISS and Hugging Face Model
10/3/2024 6:32:45 AM.
In this article, learn how to enhance search capabilities by integrating Azure SQL Database, FAISS, and Hugging Face models. We’ll walk through querying data, generating embeddings using the 'all-
Database, Data Warehouse, and Data Lake: A Comparative Analysis
10/2/2024 4:49:26 AM.
Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
Explaning Joins in Azure Cosmos DB
9/30/2024 8:45:05 AM.
Azure Cosmos DB enables seamless querying using SQL-like syntax, allowing joins within JSON documents. This feature facilitates data retrieval from arrays and nested objects within a single container,
Nested Collection Models in MVC to Add Multiple Phone Numbers - Part 1
9/27/2024 10:08:34 AM.
This article explains how to create an MVC application using the Nested Model concept, allowing users to add or remove multiple phone numbers for an employee. It covers database setup, model creation,
Learn MongoDB Evaluation Operators
9/24/2024 7:19:02 AM.
MongoDB's evaluation operators enable advanced query operations, allowing for dynamic data retrieval beyond simple comparisons. Key operators include $regex for regular expression matching, $mod f
Explaning MongoDB Logical Operators
9/24/2024 6:30:42 AM.
In MongoDB, logical operators are essential for constructing complex queries by combining multiple conditions. Key operators include $and (for all conditions), $or (for any condition), $not (to negate
What is the Notify Function in Power Apps?
9/23/2024 5:09:43 AM.
The Notify function in Power Apps displays messages to users, providing instant feedback on their actions. It supports various notification types, such as success, error, warning, and information, hel
Node.js App with User Authentication and Docker Deployment
9/22/2024 12:09:32 PM.
Learn how to create a Node.js app with registration, login, and a dashboard. This guide covers MongoDB integration and Docker deployment for efficient web development.
MongoDB Comparison Operators
9/20/2024 7:46:04 AM.
Learn how to use MongoDB comparison operators like $eq, $ne, $gt, $lt, and more in this comprehensive guide. Master querying and filtering data with practical examples and best practices for efficient
In-Memory Databases- Unit Testing With C#, EFCore and XUnit
9/18/2024 12:13:03 PM.
Learn to unit test EF Core repositories using an in-memory database with C# and xUnit. This approach simulates database operations without overhead, ensuring fast and isolated tests. Set up involves i
Configure and Create DTB Model for Microsoft Fabric
9/17/2024 11:15:42 AM.
This end-to-end video shows how to configure and build DTB model in the DTB cloud focusing on Microsoft Fabric.
A New Era of .NET Development with MongoDB - Software Architecture Conference
9/16/2024 11:10:36 AM.
In this video, you'll learn how MongoDB is improving the .NET/C# developer experience with the MongoDB Provider for Entity Framework Core (EFCore), alongside other integrations like Microsoft Sema
Entity Framework In MVC - Part Three
9/12/2024 12:12:57 PM.
This article explains the Code First approach in MVC using Entity Framework. It covers creating a new database from domain classes, reverse engineering an existing database to generate POCO classes, a
Entity Framework Core Feature - Global Query Filters
9/12/2024 5:59:39 AM.
Learn how to implement Global Query Filters in Entity Framework to apply automatic filters at the model level. This feature is commonly used for scenarios like soft delete and multi-tenancy, ensuring
Relations between Dataset in DBMS
9/6/2024 12:45:34 PM.
A relationship in DBMS links two or more data sets. This article explores types of relationships: one-to-one, one-to-many, and many-to-many, and their implementations in databases.
Introduction to SQL Server & Its History
9/2/2024 7:10:06 AM.
Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
ADF: Provision Snowflake Database Table in Azure SQL DB and Create Power BI Report
9/2/2024 7:08:05 AM.
In this data engineering and data analysis episode, I covered how to provision single snowflake database table in azure sql database and then use Power BI desktop to connect to the data to create Powe
What Is IndexedDb And How To Use It?
9/2/2024 5:08:43 AM.
IndexedDB is a NoSQL database API provided by browsers for managing large amounts of structured data. It allows developers to store and retrieve data, supporting offline capabilities in web applicatio
Why You Should Learn Azure Cosmos DB?
8/20/2024 12:26:01 PM.
Discover why learning Azure Cosmos DB is essential for modern data management. With its global distribution, scalability, and multi-model capabilities, Cosmos DB offers unmatched performance and high
Learn to Shrink a Microsoft SQL Server Database Programatically
8/20/2024 4:59:45 AM.
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
Overview Of Oracle Package DBMS METADATA
8/12/2024 11:04:41 AM.
In this article, you will learn about Oracle Package DBMS METADATA.
DbContext Register and Lifetime
8/10/2024 1:56:09 PM.
This article discusses DbContext and its lifetime
T-SQL Script for Purging Tables with Foreign Key References
8/2/2024 8:42:15 AM.
This article provides a comprehensive T-SQL script for purging tables in SQL Server, including those with foreign key references, ensuring data integrity and correct order of operations. Ideal for SQL
How to Handling File Uploads in Next.js?
8/2/2024 4:33:07 AM.
Handling file uploads in Next.js involves creating an API endpoint to receive and process the files and a client-side component to manage file selection and submission. This guide provides a comprehen
CRUD Operations Unit Testing In ASP.NET Core Web API With xUnit
7/30/2024 5:54:17 AM.
This article will demonstrate how to write Unit Test Cases for CRUD operations in Asp.Net Core Web API with the xUnit project. In this demonstration, we will write the Unit Test Cases for CRUD (CREATE
How to Implement Role-Based Access Control in Next.js?
7/24/2024 9:39:14 AM.
Implement Role-Based Access Control (RBAC) in a Next.js app to manage user permissions and restrict access based on roles. Define roles in your database, assign them during registration, and use Highe
Handling Exceptions in ADO.NET Best Practices for Error Handling
7/24/2024 4:39:42 AM.
When working with ADO.NET for data access in .NET applications, effective exception handling is crucial to ensure the stability and reliability of your applications. This article will explore common e
Practical approach to EF Core with Scalar functions
7/21/2024 6:32:25 PM.
Learn how to implement and migrate scalar SQL functions in an ASP.NET Core application using Entity Framework Core. This guide covers creating a scalar function to calculate total unit prices, integra
Database Recovery (1-2): Recover Deleted Table Data "without Backup" in SQL Server
7/13/2024 2:09:49 PM.
This article will discuss Recover Deleted Table Data "without Backup" in SQL Server.
Using EF Core to Scaffold DbContext and Models from Existing Database Tables
7/12/2024 8:14:08 PM.
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
Azure Cosmos DB for Modern Applications
7/10/2024 1:59:24 PM.
Dive into Azure Cosmos DB with our comprehensive guide tailored for modern applications. Explore its scalable NoSQL capabilities, global distribution, multi-model support, and robust partitioning stra
How to connect to MongoDB locally using .NET console application
7/10/2024 11:04:23 AM.
Learn how to establish a local connection to MongoDB using a .NET console application. This tutorial guides you through setting up MongoDB, configuring your .NET environment, writing code to connect t
Implementing MongoDB with .NET
7/8/2024 7:45:54 PM.
Learn to implement CRUD operations, manage data efficiently, and leverage the power of MongoDB's NoSQL capabilities alongside the robust .NET framework for scalable backend development.
MongoDB Filters With .NET Using MongoDB.Driver
7/5/2024 6:55:18 AM.
Learn how to leverage MongoDB.Driver in .NET and C# for efficient data filtering. This guide focuses on implementing MongoDB operations directly within a .NET 8 Web API project, skipping higher-level
How to Seed Identity in SQL Server
7/3/2024 11:52:20 AM.
Discover SQL Server's IDENTITY columns for automatic unique number generation. Learn to create tables with IDENTITY, insert data without specifying IDs, seed values with DBCC CHECKIDENT, manage ex
SQL Command Types
6/28/2024 9:08:22 AM.
SQL, or Structured Query Language, is essential for managing data in relational databases (RDBMS). It enables tasks like retrieving, updating, inserting, and deleting data. SQL commands are categorize
Understanding CQRS Design Pattern
6/27/2024 5:05:00 AM.
The CQRS (Command Query Responsibility Segregation) pattern separates the operations for reading and writing data in software architecture. It enhances scalability by segregating commands (writes) and
Implementing MongoDB with .NET
6/26/2024 6:35:29 AM.
Learn essential techniques for data persistence, leveraging MongoDB's document-oriented structure, implementing CRUD operations with C#, and optimizing performance using the MongoDB .NET driver.
Microsoft Forms: New Features in 2024
6/26/2024 4:58:19 AM.
Microsoft Forms has introduced powerful updates in 2024, including real-time data sync with Excel, a Practice Mode for learning reinforcement, a new Forms app for easy survey creation, and the ability
Caching Strategies in Angular and .NET Core
6/24/2024 5:49:09 AM.
Caching enhances web application performance and scalability. In Angular, use HTTP interceptors, service workers, local storage, or IndexedDB for client-side caching. In .NET Core, leverage in-memory
Installtion Mongo DB in Ubnutu Enviroments and Configure
6/19/2024 11:58:47 AM.
Install MongoDB on Ubuntu by updating packages, adding GPG key, configuring repository, and installing MongoDB. Manage MongoDB services, start, reload, check status, and interact using Mongosh. Uninst
DuckDB: The Powerful Embedded Database for Analytics
6/16/2024 8:32:17 AM.
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
Upload And Display Image In ASP.NET Core 3.1
6/11/2024 12:08:38 PM.
Learn to upload & display images in ASP.NET Core using Image Tag Helper & IFormFile. Set cache-busting with unique URLs. Create models, views, & controller actions. Utilize Entity Framewor
Oracle Stored Procedure Output Parameters with Dapper in ASP.NET Core
6/11/2024 11:41:47 AM.
This article provides a detailed guide to integrating Oracle stored procedures with ASP.NET Core using Dapper, focusing on handling output parameters, which can often be a challenging aspect of databa
Comprehend MongoDB TTL Index Completely
6/11/2024 10:02:49 AM.
This article explores MongoDB's TTL (Time to Live) indexes, a feature for automatically deleting documents from a collection after a specified time. TTL indexes are crucial for managing transient
Database Options in Google Cloud Platform (GCP)
6/11/2024 9:07:16 AM.
GCP offers diverse database services tailored for various needs, from relational databases like Cloud SQL and AlloyDB for structured data to NoSQL options like Firestore and Cloud Bigtable for large,
Mongo DB Authentication and Authorization on Windows
6/10/2024 11:55:01 AM.
Dive deep into the world of MongoDB authentication. Whether you're a beginner or an experienced developer, this comprehensive guide will teach you everything you need to know about securing your M
Mastering Azure Cosmos DB with ASP.NET Core
6/10/2024 5:37:42 AM.
Azure Cosmos DB is a robust and flexible database service that offers global distribution, high availability, and multi-model support. While it comes with some complexity and cost considerations, its
Exploring Cosmos DB - Azure Essentials Series - Ep: 2
6/10/2024 5:11:47 AM.
In this episode, we'll explore the features, capabilities, and real-world use cases of Cosmos DB, and discover how it enables developers to build highly responsive and scalable applications with e
Read Data From Azure Cosmos DB Using Power Automate
6/6/2024 11:30:10 AM.
In this article you will learn how to read data from Azure Cosmos DB using Power Automate.
What Are The Twelve Codd's Principles In DBMS
6/5/2024 10:50:53 AM.
Edgar F. Codd's twelve rules define relational database management systems (RDBMS), ensuring data integrity and consistency. These guidelines aid in robust database design and management, facilita
Filters in MDX Queries
6/4/2024 12:51:29 PM.
This article, explains the power of MDX queries with precise filtering! This guide dives into filtering techniques to control the data you see in your multidimensional analyses.
Implementing Repository Pattern And Dependency Injection In ADO.NET Using Generics In C#
6/4/2024 9:49:21 AM.
Learn how to implement design patterns in an object-oriented paradigm to create generic solutions. This guide covers a practical example where a web application interacts with a database using the rep
MongoDB Cheat Sheet: Essential Commands and Operations
6/4/2024 6:02:45 AM.
The MongoDB Cheat Sheet is your go-to guide for essential commands and operations. Covering installation, setup, CRUD operations, indexing, aggregation, data modeling, and more, it simplifies database
Mongo DB Indexing Strategies with Real-time Scenarios
6/3/2024 9:45:25 AM.
MongoDB, a scalable NoSQL Database, uses indexing to optimize query performance. Indexing involves creating data structures to expedite data retrieval operations on collections, enhancing efficiency.
MongoDB Random VS Sample VS Sample Rate Operators
6/3/2024 9:35:25 AM.
Explore MongoDB's random, sample, and sample rate operators for efficient data retrieval. Learn how to leverage these operators to retrieve subsets of data from your MongoDB databases, optimizing
Best Practices and Role of a Product Owner
6/3/2024 4:35:08 AM.
The Unsung Hero" delves into the pivotal role of a Product Owner in Agile projects. Explore best practices in stakeholder management, backlog grooming, and iterative development, emphasizing the
Understanding Azure Cosmos DB Consistency Levels Using a Shopping Cart Application
6/1/2024 8:52:03 AM.
Explore Azure Cosmos DB's consistency levels through a shopping cart application to understand how different settings impact data integrity, availability, and latency. Learn the trade-offs between
Creating & Retrieving records from M.S.Access-2007 using Oledb in C#.net
5/31/2024 10:05:52 AM.
Discover how to interact with Microsoft Access 2007 using C# and OleDb. Create and retrieve records seamlessly, employing ADO.NET for efficient database connectivity and manipulation within your C# ap
Creating & Retrieving Records from Ms-Access 03 using Oledb in C#
5/31/2024 10:04:05 AM.
Learn how to efficiently create and retrieve records from an MS Access 2003 database using OLEDB in C#. This guide covers setting up the OLEDB connection, executing SQL commands, and handling data ope
Inserting & Retrieving records from MS Access 2007 using ODBC
5/30/2024 12:11:36 PM.
This article shows development of a windows application for performing insert, search, update, delete operations & navigation of MS Access 2007 records using ODBC connection.
Inserting & Retrieving records from MS Excel 2003 using OLEDB
5/30/2024 12:11:07 PM.
Develop a C#.Net Windows app to manage records in MS Excel. Use OleDb Connection for data access. Features include insertion, searching, updating records. Utilize DataGridView, TextBoxes, and Buttons
Inserting & Retrieving records from M.S.Excel-2007 using oledb in C#.net
5/30/2024 12:10:29 PM.
This guide covers how to insert and retrieve records from Microsoft Excel 2007 using OLEDB in C#.NET. It explains setting up OLEDB connections, executing SQL commands for data manipulation, and handli
Inserting images into MS Access file using OLEDB
5/30/2024 12:09:34 PM.
Learn how to insert images into an MS Access database using OLEDB. This guide covers the steps to store images as OLE objects in Access tables, ensuring proper data integration. Understand the necessa
Master GeoSpatial Queries in MongoDB
5/29/2024 10:03:16 AM.
Mastering geospatial queries in MongoDB empowers efficient handling of location-based data. Leveraging features like GeoJSON, GeoNear, and GeoWithin, developers can perform precise searches, analyze s
Understanding GeoSpatial Indexing in MongoDB 🌍🔍
5/29/2024 5:36:33 AM.
This article explores the concept of GeoSpatial indexing in MongoDB, covering its creation process, significance, and real-time examples, all explained in simple language.
Best Practices For Effective Database Design In SQL Server
5/28/2024 4:55:08 AM.
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, normaliza
Entity and Entity Relationships in DBMS
5/21/2024 5:21:30 AM.
An Entity-Relationship (ER) model visually represents data and relationships in a business domain, aiding database design. It simplifies understanding of complex databases and enhances communication b
Azure Data Factory to Ingest Data From ADLS Gen 2 to Azure Cosmos DB
5/21/2024 4:52:00 AM.
This video shows how to use Azure Data Factory Data Pipeline to Ingest Data from ADLS Gen 2 to Azure Cosmos DB.
Dotnet Core, EF Core Store Procedure With Multiple Results
5/20/2024 6:33:57 AM.
Entity Framework Core coupled with stored procedures for SQL database data retrieval encounters a constraint: consistent return of all columns required for DbQuery<T> properties. This alternativ
Working With Change Tracking Proxy in Entity Framework 6.0
5/17/2024 10:21:30 AM.
In this article, you will learn about Proxy Objects, ObjectStateManager, and EntityState to leverage advanced tracking features for data manipulation and performance optimization in your .NET applicat
Entity Framework: DbComparisonExpression Requires Arguments With Comparable Types
5/16/2024 5:44:07 AM.
The "DbComparisonExpression Requires Arguments With Comparable Types" error in Entity Framework indicates a type mismatch in a query comparison. It occurs when attempting to compare two valu
Road To AZ-204 - Developing Solutions That Use Cosmos DB Storage
5/10/2024 8:54:01 AM.
This article's intention is to explain the main skills measured in this sub-topic of the AZ-204 Certification. Cosmos DB is the main component that will have their fundamentals explained here alon
CRUD Operations Using Entity Framework 5.0 Code First Approach in MVC
5/9/2024 11:56:39 AM.
Perform CRUD operations in MVC using Entity Framework 5.0's Code First approach. Define entity classes, utilize DbContext and LINQ for data access, and generate views and controllers with scaffold
Building CRUD Operations in .NET Core 8 with MongoDB
5/9/2024 4:48:33 AM.
Learn to create CRUD operations in .NET Core 8 Minimal API with MongoDB via Entity Framework Core. Build RESTful endpoints for seamless data interaction, leveraging ASP.NET Core's capabilities for
Stored Procedures With Entity Framework
5/8/2024 9:54:50 AM.
Stored procedures in Entity Framework offer a way to execute database logic from within your .NET application. Utilize EF's capabilities to map and execute stored procedures efficiently, enhancing
Enable Ratings in SharePoint List/Library
5/6/2024 11:24:03 AM.
Learn how to enhance user engagement and feedback in SharePoint by enabling ratings on your lists and libraries. Empower users to rate and provide feedback on content, boosting collaboration and user
Inject a DbContext Instance Into BackgroundService in .NET Core
5/5/2024 8:28:55 AM.
In this article, Learn how to inject and use a DbContext instance within a BackgroundService in .NET Core. Utilize dependency injection to access database operations from a background task, ensuring p
Create Facebook App using ASP.NET MVC
4/30/2024 11:03:42 AM.
Learn to integrate a Facebook app with your ASP.NET MVC project using Visual Studio 2012 and MVC 4 template. Follow step-by-step instructions to set up SSL, register as a developer, configure app set
Code First Migrations With Entity Framework
4/30/2024 9:39:59 AM.
This article will provide answers to the following questions relevant to relationships in Entity Framework: whether or not to create a database, how to add / remove a field from an existing table, how
SQL Server Fundamentals: Design, Queries & Optimization
4/29/2024 10:52:37 AM.
This article serves as a comprehensive guide to SQL Server fundamentals, database design principles, querying with Transact-SQL, stored procedures, and optimization techniques. Through real-time examp
Getting Started Wth MongoDb Atlas
4/26/2024 12:00:41 PM.
Learn how to get started with MongoDB Atlas, a cloud-based database service that offers a scalable and flexible solution for managing NoSQL databases. Explore data modeling, cluster configuration, and
SQL Temporary Tables: Syntax, Types, and Usage
4/25/2024 11:22:20 AM.
SQL temporary tables are session-specific tables used to store interim results during query processing. They're created and destroyed within a session, offering a scratchpad for complex queries or
Applied Reverse Engineering With OllyDbg
4/23/2024 8:25:53 AM.
This paper explores executable cracking using OllyDbg, focusing on reverse engineering without source code. It emphasizes Assembly Programming and tools like OllyDbg and CFF Explorer. Methods include
Understanding OLTP and OLAP for Effective Data Management
4/19/2024 6:03:17 AM.
This article explores OLTP and OLAP, two crucial systems for data management. OLTP handles real-time transactions, while OLAP analyzes historical data to uncover valuable insights. Learn how they work
Select Query With Logical Operator in a Mongo Database Using C# Driver
4/18/2024 1:28:05 PM.
Learn how to perform select queries in MongoDB using C# driver. Explore JSON-style object representation, conditional operators, insertion, and retrieval of data. Connect to MongoDB, serialize and des
Building Scalable Applications with Alibaba Cloud Serverless Computing
4/18/2024 4:13:40 AM.
This article guides setting up serverless architecture on Alibaba Cloud, configuring Object Storage Service, ApsaraDB for MongoDB, and Function Compute.
Harnessing the Power of Big Data with Alibaba Cloud AnalyticDB
4/17/2024 6:28:24 AM.
Learn how Alibaba Cloud AnalyticDB empowers businesses to harness the power of big data analytics, with high performance, scalability, and cost-effectiveness.
Combine SQL-DB And MongoDB In Same Blazor App
4/16/2024 5:38:10 AM.
In this post, we will see how to combine SQL DB and MongoDB in same Blazor app. We will create two entities for City and Employee. City will be saved in MongoDB and Employee will be saved in SQL DB. W
Upload And Download Files From Blob Storage Using C#
4/15/2024 11:47:42 AM.
Learn to upload and download files programmatically to Azure Blob storage using C#. Understand creating Azure storage accounts, containers. Step-by-step guide to access Azure storage with code snippet
Build a Table API with Python and Azure Cosmos DB
4/15/2024 11:43:19 AM.
Develop a robust Table API using Python and Azure Cosmos DB. Leverage the power of NoSQL with Azure's scalable database solution. Manage JSON data efficiently, perform CRUD operations, and optimiz