DB Resources

Share

Related resources for DB

Bulk and Transactional Batch Operations with the Azure Cosmos DB .NET 12/30/2024 6:59:52 AM. Azure Cosmos DB provides Bulk and Transactional Batch Operations for efficient data management. Bulk Operations support high-throughput processing across multiple partition keys, while Transactional B
Bulk Insert Example with Two SQLite DB Files using .NET12/13/2024 5:06:10 AM. Learn how to merge two SQLite databases in C# using bulk insert/update. This method reads data from one DB and updates or inserts it into another, achieving efficient data merging.
Modern Featured Entity Framework With SQLite DB Example 12/11/2024 10:31:03 AM. Learn to build a .NET Core application using C# async/await and SQLite with Entity Framework. Implement CRUD operations, handle asynchronous tasks, and explore efficient database interaction using Vis
Connecting Angular Frontend to MongoDB via Express Backend12/8/2024 5:39:27 AM. Learn to connect MongoDB, Express, and Angular for full-stack development. Build a REST API backend with Express and Mongoose, and create a dynamic Angular frontend for CRUD operations. Simplify data
Goodbye Swagger: How .NET 9 is Redefining API Documentation12/6/2024 5:05:39 AM. Explore the changes in .NET 9 API documentation as Swagger is removed from templates. Learn about alternatives like Microsoft.AspNetCore.OpenApi, NSwag, and custom UIs to adapt workflows and ensure se
DbContext Register and Lifetime12/5/2024 6:22:08 PM. This article discusses DbContext and its lifetime
Optimizing Performance in Azure Cosmos DB: Best Practices11/29/2024 5:20:56 AM. Azure Cosmos DB optimization enhances performance, scalability, and cost-efficiency. Key practices include selecting the right partition key, customizing indexing, optimizing queries, tuning consisten
.NET with MONGO Database Code Example11/28/2024 8:22:04 AM. 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 seam
Comparison Between SQL and MongoDB Database11/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
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.
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

Topics