Related resources for DB
  • Events: Love Triangle in Integration Testing11/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 811/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 Autofac10/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 Core10/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 Server10/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 Server10/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 OpenAI10/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 DB10/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 Server10/4/2024 6:15:00 AM. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
  • Enhance Search with Azure SQL DB FAISS and Hugging Face Model10/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 Analysis10/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 19/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 Operators9/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 Operators9/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 Deployment9/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 Operators9/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 XUnit9/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 Fabric9/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 Conference9/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 Three9/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 Filters9/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 DBMS9/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 History9/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 Report9/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 METADATA8/12/2024 11:04:41 AM. In this article, you will learn about Oracle Package DBMS METADATA.
  • DbContext Register and Lifetime8/10/2024 1:56:09 PM. This article discusses DbContext and its lifetime
  • T-SQL Script for Purging Tables with Foreign Key References8/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 xUnit7/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 functions7/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 Server7/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 Tables7/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 Applications7/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 application7/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 .NET7/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 Server7/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 Types6/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 .NET6/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 20246/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 Core6/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 Configure6/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 Analytics6/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.16/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 Core6/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 Completely6/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 Windows6/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 Core6/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: 26/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 Automate6/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 DBMS6/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 Queries6/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 Operations6/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 Scenarios6/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 Operators6/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 Owner6/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 Application6/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#.net5/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 ODBC5/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 OLEDB5/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#.net5/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 OLEDB5/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 MongoDB5/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 Server5/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 DBMS5/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 DB5/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 Results5/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.05/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 Types5/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 Storage5/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 MVC5/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 MongoDB5/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 Framework5/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/Library5/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 Core5/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 MVC4/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 Framework4/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 & Optimization4/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 Atlas4/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 Usage4/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 OllyDbg4/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 Management4/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# Driver4/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 Computing4/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 AnalyticDB4/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 DB4/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