Related resources for database
  • A Comprehensive Guide to Entity Framework Core in .NET 83/17/2024 8:41:25 AM. Explore the comprehensive guide to Entity Framework Core in .NET 8, enriched with the latest features of C# 10. Authored by Ziggy Rafiq, this detailed overview covers everything from basic concepts to
  • TINYINT Data Type in SQL and Its C# Equivalent3/16/2024 10:35:58 AM. Understanding data types is crucial for effective data manipulation and storage. In this article, we will learn about TINYINT in SQL efficient storage for small integers. In C#, use byte or sbyte for
  • Querying Azure SQL Databases In Databricks Spark Cluster3/13/2024 8:44:48 AM. We will see the entire steps for creating an Azure Databricks Spark Cluster and querying data from Azure SQL DB using JDBC driver. Later we will save one table data from SQL to a CSV file.
  • Implementing Common Audit Fields With EF Core’s Shadow Property3/11/2024 9:25:16 AM. Implement audit fields in EF Core using shadow properties for efficient tracking of entity modifications. Utilize Entity Framework's built-in functionality to automatically update created and modi
  • GraphQL In .NET Web API With Entity Framework Core - Part One3/11/2024 9:22:06 AM. In this article, we will learn about the step-by-step implementation of GraphQL in a Web API using ASP.NET Core, including database setup, scaffolding, configuration, repository creation, and GraphQL
  • Benefits of Temporary Tables over Table Variables in SQL Server3/10/2024 8:15:37 AM. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handl
  • Entity Framework Core 5.0 - An Introduction To What's New 3/7/2024 11:26:50 AM. Discover the latest features in Entity Framework Core 5.0, including improved performance, enhanced LINQ capabilities, migration enhancements, and streamlined database schema management.
  • New Features Of Entity Framework Core 2.03/7/2024 8:53:53 AM. Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This art
  • Entity Framework Core Triggers In Action (Unofficial Package)3/7/2024 8:44:28 AM. This article shows you how to work with database triggers in Entity Framework Core using a third-party library and Entity Framework Core Triggers with this unofficial package, enhancing database opera
  • Remote Access Of The Database Using SQL Server 3/7/2024 8:36:49 AM. Remote access to SQL Server databases enables users to connect to and manage databases from a location outside the physical server. It involves configuring network settings, security measures like aut
  • How To Secure PII Data In SQL Server Using .NET Assembly3/6/2024 10:46:18 AM. In this article, we will learn PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number, etc. When you are working with financial
  • Practical Introduction to Entity Framework: Day 63/6/2024 10:40:13 AM. In this article, you will Explore Day 6 of our Practical Introduction to Entity Framework series, diving deeper into database integration. Learn essential concepts, including object-relational mapping
  • Practical Introduction To Entity Framework: Day 53/6/2024 10:39:36 AM. Day 5 of our practical introduction to Entity Framework delves deeper into database management with advanced concepts like relationships and efficient CRUD operations. Explore Entity Framework Core fo
  • Practical Introduction To Entity Framework: Day 13/6/2024 10:29:58 AM. In this article, we will discover the fundamentals of Entity Framework in this practical introduction. Learn about ORM concepts, database operations, and CRUD operations through hands-on examples.
  • Selecting the Ideal Tools for Database Documentation3/6/2024 5:56:14 AM. In this article, we will explore database documentation tools for efficient database management. Choose software that streamlines data modeling, schema documentation, and metadata organization, enhanc
  • Importing Access Database into SQL Server 20123/5/2024 10:40:07 AM. Destructuring simplifies value extraction from objects/arrays. React's event handling enables dynamic responses to user interactions, crucial for interactive UIs. Components manage state/props, fa
  • How to Enable Remote Connections in SQL Server 20053/5/2024 10:39:30 AM. This article provides guidance on enabling remote connections in SQL Server 2005, addressing the common error message encountered when attempting a remote connection. It outlines the security precauti
  • SQL Server Effective Database Tune up and Maintenance3/4/2024 11:31:33 AM. This document provides essential tips for effectively maintaining a production database, aimed particularly at developers who may not be professional database administrators. It covers topics such as
  • Improving SQL Performance Using Covering Indexes3/4/2024 11:29:49 AM. In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
  • Repository Pattern with Multiple Databases in C# and .NET3/1/2024 4:10:35 AM. Implementing the Repository Pattern with multiple databases in C# and .NET requires strategic abstraction, database-specific implementations, entity mapping, and transaction management. Explore challe
  • How to search the data from the associated external content type in SharePoint 20102/29/2024 10:36:46 AM. In this article, we will be seeing how to search the data from the associated external content type. Searching data from associated external content types in SharePoint 2010. Learn to create ECTs, and
  • Creating Persistent Volumes in Docker for Databases 2/29/2024 8:59:55 AM. Learn the best practices and step-by-step implementation guide for creating persistent volumes in Docker tailored for databases. Ensure data integrity and availability in Dockerized database environme
  • Build ASP.NET Core API Using Existing Database2/28/2024 10:16:53 AM. I’m sharing a short overview of Asp.NET Core. The journey of .NET Core started with the purpose of Microsoft to build a common .NET base library that provides a common foundation to all its platforms.
  • How to Read or View Exchange Database EDB File Programmatically2/28/2024 6:03:51 AM. Explore methods to Read or View the Exchange Database EDB File Programmatically. Know how to use this Exchange Server Managed API to View or Read Exchange EDB files.
  • CRUP Operation with Dapper Using ASP.NET Core2/27/2024 10:41:54 AM. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
  • How to Create CSV File from Excel Spreadsheet 2/27/2024 4:16:16 AM. Explore methods to Create CSV File from Excel Spreadsheet. Get the best solutions to carte or save CSV files from Excel Spreadsheet in easy steps.
  • Get In Touch With Document DB From Azure Cosmos DB2/22/2024 4:41:24 AM. This article introduces readers to the new features Microsoft unveiled at Build 2017, particularly focusing on Azure Cosmos DB. It explains Cosmos DB as a globally distributed, multi-model database se
  • Azure Document DB CRUD Operation2/21/2024 11:38:53 AM. This article explains how to create documents into SQL (DocumentDB) API. Before starting, we need to understand what is documentDb and how it works. SQL (DocumentDb) API is one of API comes under Azur
  • Blazor - Connect With Oracle Database In Amazon RDS2/21/2024 11:32:58 AM. We will see how to create an Oracle database instance in Amazon RDS (AWS Relational Database Service) and we will connect Oracle database from Blazor application. We will use an Employee details Singl
  • Trigger Creation: Set Action on Customer Record Create/Update2/21/2024 11:08:31 AM. Learn to automate database actions by creating triggers. Choose the trigger name and action type. Execute actions when customer records are created or updated. Enhance database functionality and effic
  • Blazor - Create SPA With Azure Database For MariaDB Server2/21/2024 8:27:24 AM. We will create a MariaDB database service in Azure and connect MariaDB in a Single Page Blazor application. Azure Database for MariaDB is a relational database service in the Microsoft cloud. Azure Da
  • Tips to Launch Your SQL Mission2/20/2024 11:34:01 AM. This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep i
  • Deploying A Blazor Application On Azure2/19/2024 10:00:19 AM. This comprehensive guide walks through the process of deploying an ASP.NET Core-hosted Blazor application on Azure, covering steps from creating an SQL database server to publishing the application.
  • Operational Data Stores (ODS) in Business Intelligence2/19/2024 7:07:50 AM. This comprehensive article introduces operational data stores (ODS) and their significance in modern data-driven businesses.It covers fundamental principles, distinguishing ODS from other data storage
  • Working With a BindingNavigator Control in Windows Form2/16/2024 6:49:53 AM. This guide demonstrates implementing a BindingNavigator control in a Windows Forms application, enabling navigation through database records. It outlines steps to create a database, insert records, an
  • SQL Server Migration Strategy into Azure SQL PaaS Database2/16/2024 3:47:43 AM. This article outlines a strategic approach to migrating SQL database workloads from on-premises to Azure cloud services. It covers the high-level migration roadmap, choosing the right migration path,
  • CRUD Operation in Power Platform with Canvas App2/15/2024 8:55:01 AM. Learn how to perform CURD operations in Power Platform with Canvas App. Explore creating, reading, updating, and deleting data seamlessly. Enhance your app development skills and efficiently manage da
  • Mastering Test-Driven Development with ASP.NET Core2/14/2024 8:19:52 AM. Test-Driven Development (TDD) is a methodology in software development that emphasizes writing tests before writing the actual implementation code. The code is thoroughly tested and meets the specifie
  • Databinding with DataGridView in ADO.NET2/14/2024 8:08:49 AM. Databinding with DataGridView in ADO.NET utilizes SqlDataAdapter to fetch data from a database, DataSet for storing it, and binds DataGridView for display in Windows Forms. It streamlines data present
  • How to Bind a BindingNavigator with a DataGridView in Windows Forms2/14/2024 4:19:39 AM. This article provides a detailed guide on binding a BindingNavigator with a DataGridView control in a Windows Form Application. It includes steps for creating a database, inserting records, setting up
  • Resolving Database Reconnection Challenges in .NET with Polly2/13/2024 12:04:18 PM. This content provides an overview and detailed implementation guide of utilizing the Polly library for connection retry in .NET applications. It demonstrates creating an Employee class and table, simu
  • Analysis of T-SQL and PL/SQL2/12/2024 4:03:24 AM. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for effici
  • How to Backup/Restore MongoDB Database and Collections2/11/2024 9:32:02 AM. Backing up and restoring a MongoDB database and collection with command definition explanation and example as well.
  • Difference Between Raw SQL and Dapper 2/8/2024 8:55:42 AM. Explore the trade-offs between using raw SQL queries and leveraging Dapper, a micro-ORM for database access in C# development. Delve into performance, code maintainability, and efficiency to make info
  • Create ASP.NET Web App With SQL Database In Azure2/7/2024 4:50:27 AM. In this article, you will learn to create an ASP.NET web app with SQL Database on Azure! Prerequisites include a Microsoft Azure Account and Visual Studio 2013/2015. Follow the steps to create a SQL D
  • Supported File Types for Data Ingestion into KQL Database in Fabric2/6/2024 10:04:20 AM. This article is about Understanding the Supported File Types for Data Ingestion into the KQL Database in Fabric Real-time Analytics. Supported file types include JSON, CSV, XML, & Text. Note: XLSX
  • Top 10 Most Used SQL Queries2/6/2024 6:39:43 AM. In this article you will learn about the top 10 most used SQL Queries. SQL Server is an interface which helps to communicate with the system’s database using queries.
  • Automated Deployment of SQL Server Database through Azure Devops2/6/2024 4:04:30 AM. Explore an automated deployment solution for SQL Server databases using Azure DevOps. This guide details the setup of a self-hosted agent, granting necessary server access, and configuring a release p
  • Data Vault Design in Azure SQL - Read PII with Customer Keys2/5/2024 11:00:54 AM. Data Vault design in Azure SQL - Utilizing Customer keys to read PII information in databases. Ensuring data security in the cloud era is crucial, especially with the rise in data attacks. Protecting
  • 🖥️ How to Create an Web App in Microsoft Azure?2/5/2024 9:42:03 AM. In this article, we will see how to create a web app in Microsoft Azure in step by step. Azure Web App, a fully managed PaaS from Microsoft Azure, simplifies web app deployment. Learn how to create an
  • SQL Joins for Efficient Database Queries2/5/2024 5:54:13 AM. Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data
  • Optimize SQL Database Performance2/1/2024 8:40:21 AM. "Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases
  • Redis as Primary Database in .NET 8 Web API1/31/2024 9:51:42 AM. In this article, we are going to use Redis as our primary database for our ASP.NET Core Web API project in .NET 8. Learn about Redis, its data types, and the pros and cons of using it as a primary dat
  • Optimizing Performance in C# Entity Framework1/24/2024 8:19:10 AM. Optimize the performance of your C# Entity Framework application with these strategic best practices. From lazy loading and eager loading to caching and database tuning, ensure efficient data access.
  • Caching Strategies Blueprint: Accelerate Data Retrieval Performance1/24/2024 6:47:14 AM. This article explores the significance of caching in software development, emphasizing its role in enhancing data retrieval efficiency. It covers caching principles, trade-offs, cache hierarchy, hits
  • Working with SQL Lite Database in Asp.NET Core Web API 1/21/2024 1:32:23 PM. SQLite is a self-contained, serverless, and zero-configuration relational database management system (RDBMS). It is a lightweight, open-source, and embedded database engine that does not require a sep
  • Partitioning in PostgreSQL: What, Why, and How1/11/2024 4:44:32 AM. PostgreSQL partitioning enhances database management by dividing large tables into smaller, manageable partitions. Learn the benefits and types (range, list, hash, composite) for efficient data organi
  • Azure Cosmos DB in C# Development1/9/2024 7:27:12 AM. Azure Cosmos DB is not just an AI database; it's a comprehensive solution for various applications, including web, mobile, gaming, and IoT. With guaranteed speed, simplified development, and missi
  • What is WebSQL?1/4/2024 11:55:46 AM. Explore the fundamentals of WebSQL, a deprecated but once widely used client-side storage solution for web applications. Learn its basics, from setting up a database to CRUD operations with SQL.
  • Safely Changing the Instance Name of SQL Server1/4/2024 5:24:47 AM. Changing the instance name of a SQL Server involves several steps and should be done with caution. Secure process for changing the instance name of SQL Server. This guide ensures a smooth transition,
  • Connecting Postgres Database to Mobile App with Flutter and Dart1/3/2024 9:18:11 AM. Postgres Database to connect with your mobile app using Flutter and Dart
  • Connecting MySQL Database to Mobile App with Flutter and Dart1/3/2024 7:20:56 AM. MySQL Database to connect with your mobile app using Flutter and Dart
  • Truncate All Table Data in MSSQL1/2/2024 10:49:45 AM. In this article we will learn about how to truncate all tables in a SQL Server database using dynamic SQL. Exercise caution, as this operation deletes all data without the possibility of rollback. Lea
  • Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET1/1/2024 7:47:53 AM. Mastering PostgreSQL CRUD Operations in .NET 8 with ADO.NET: Best Practices and Code Examples
  • Upload Text File .txt and .log12/29/2023 9:10:26 AM. This Article is used to upload Text .txt/.log file in the Database. How to upload colon-delimited files into a database using ASPX. With a straightforward interface and code, efficiently read, split,
  • Efficient API Development Database Operations in ASP.NET Core Web Using Dapper and Stored Procedures 12/27/2023 4:28:51 PM. Employing Dapper in ASP.NET Core for database operations brings a streamlined approach to handling data, ensuring efficient and straightforward interactions. When complemented with stored procedures,
  • Consistency Levels in Azure Cosmos DB with an Example12/27/2023 8:15:56 AM. In this article, we will learn about the Azure Cosmos DB multiple consistency levels, including strong, boundless, session, consistent prefix, and eventual, with an example and scenario.
  • How To Create a WCF Service12/26/2023 8:48:44 AM. How can I create a WCF service that manages employee details while interacting with an SQL database, including the necessary SQL table script for employee information storage?
  • API Development Using Dapper and Microsoft Asp.NET Core Web API 12/24/2023 4:38:11 PM. ASP.NET Core is a powerful framework for building web applications, and "Dapper" is a popular micro ORM (Object-Relational Mapping) that works well with ASP.NET Core for database operations.
  • How to Use MongoDB Atlas with MongoDB Compass12/20/2023 10:11:12 AM. How to use MongoDB atlas with MongoDB compass, how to use cloud database with MongoDB. Learn how to use MongoDB Atlas, a fully managed cloud database, and MongoDB Compass, a powerful GUI for database
  • Schemas in PostgreSQL12/20/2023 5:56:28 AM. Understanding Schemas in PostgreSQL. Explore the power of PostgreSQL's schemas—logical groupings of database objects. Learn how to create, manage, and leverage schemas for effective data organizat
  • MySQL: Unveiling its Versatility and Robustness for Diverse Use Cases12/20/2023 4:10:36 AM. Explore MySQL's diverse use cases in web applications, e-commerce, CMS, data warehousing, telecommunications, and finance. Dive into its key features, architecture, and crucial queries for efficie
  • Multi-Tenancy with Separate Databases Approach in .NET Core12/15/2023 5:13:24 AM. In this article, we will learn how to implement a separate database approach of multi-tenancy in the .Net Core application and how to provide a dynamic connection string to DbContext
  • Data Pipeline to Copy Data from Azure SQL Database to Fabric Data Warehouse12/13/2023 5:03:20 AM. Moving data in-between and across different technologies is one of the jobs of data engineers. In this new video, I demoed how to create data pipeline to copy data from Azure SQL Database to Fabric Da
  • CrateDB: Powering the Internet of Things12/11/2023 6:06:56 AM. CrateDB, an open-source distributed SQL database, is spotlighted for its efficacy in handling IoT complexities. This article explores use cases, including time-series data, analytics, and scalability,
  • Generate Database Script with Table Data From SQL Server12/6/2023 9:21:33 AM. In this article, I will describe how to generate a database script for a table with all it's data, views, stored procedures, constraints, and login credentials.
  • Ingest Excel Data to Azure SQL Database using SSMS GUI12/6/2023 5:30:32 AM. This video shows how to easily ingest Excel data to the Azure SQL Database using the SQL Server Management Studio Graphical User Interface
  • Join vs. Except and Intersect in SQL12/6/2023 4:57:35 AM. SQL Improvement Performance Tips & Tricks. Explore SQL data retrieval methods with JOIN, EXCEPT, and INTERSECT keywords. JOIN combines rows from multiple tables based on a related column, while EX
  • How to create a Microsoft Azure SQL Database in serverless compute tier from the Azure Portal12/3/2023 1:28:43 PM. This article focuses on the swift creation of a serverless Azure SQL Database via the Azure Portal.
  • What Is Sharding?12/1/2023 6:30:55 AM. Sharding, a strategic database architecture, distributes data across multiple servers to enhance speed and reduce strain on a single server. Common in large-scale systems, sharding improves performanc
  • String Constants in PostgreSQL12/1/2023 4:49:37 AM. Delve into PostgreSQL's handling of string constants, which is essential for managing text data. Explore their syntax, handling of special characters, and their versatile use in variable assignmen
  • Understanding Window Functions in PostgreSQL11/30/2023 11:06:19 AM. In this article, we will learn how to use window functions in PostgreSQL, what are the different types of window functions, and how to write window function queries with examples.
  • Exploring MongoDB: Applications and Essential Queries11/30/2023 10:36:04 AM. In this article, we will explore MongoDB and delve into its applications, accompanied by an in-depth look at some of the most commonly used MongoDB queries.
  • How to Use Inheritance in PostgreSQL?11/29/2023 5:14:32 AM. PostgreSQL, a robust database system, introduces the concept of inheritance, enriching data organization. This article delves into utilizing PostgreSQL's inheritance for modeling hierarchical data
  • Time Series Databases: Understanding, Using, and Implementing11/28/2023 9:56:25 AM. In our era of data dominance, managing and analyzing time-sensitive information is pivotal, especially in finance, IoT, and healthcare. Traditional databases grapple with time-stamped data, paving the
  • How to Convert a Month Number to Month Name in PostgreSQL11/28/2023 7:10:54 AM. Learn how to convert a month number to a month name in PostgreSQL using the versatile to_char function. Explore format strings like 'Month' and 'Mon' for full and abbreviated names.
  • Manually Install MySQL on Windows Without MySQL Installer11/27/2023 12:00:18 PM. The article details manual installation steps for MySQL on Windows, emphasizing configuration options via option files, service installation methods, and password management, offering insights into cu
  • Azure Cosmos DB's NoSQL API11/27/2023 8:04:35 AM. NoSQL databases have revolutionized data storage by offering enhanced flexibility and scalability compared to traditional relational databases. Among these, Azure Cosmos DB stands out as a robust plat
  • Concurrency Control in DBMS11/26/2023 5:55:32 AM. A crucial component of database management systems (DBMS) that ensures data integrity and consistency in multi-user situations is concurrency control.
  • Retrieve Data From Database in ASP.Net Web API11/22/2023 6:45:38 AM. This article explains how to retrieve data from the database in the ASP. NET Web API.
  • Fabric Data Warehouse: Save as Table and Analyze Result Functionalities11/22/2023 3:53:08 AM. In this article, we'll delve into the Microsoft Fabric Data Warehouse features: Save as Table and Analyze Result. These functionalities offer users and analysts several advantages in terms of data
  • Working with OleDb Data Adapters11/20/2023 2:55:24 PM. This step by step article guides you to create your database applications using OleDb Data Adapters in VS.NET.
  • Create An HTML Form And Insert Data Into The Database Using PHP11/20/2023 5:49:00 AM. This article shows how we can create a SIGN UP form and store the entered data into our database (mysql) using PHP.
  • Inserting 1 Million Dummy Product Data into SQL Server Using Bogus Package11/17/2023 7:36:39 AM. When working with databases, populating them with substantial amounts of data for testing or demonstration purposes is crucial. The Bogus package in C# provides a convenient way to generate fake data,
  • Create Database and Ingest Data into KQL Table in Microsoft Fabric11/16/2023 10:41:55 AM. This video shows how to Create Database and Ingest Data into KQL Table in Microsoft Fabric.
  • Optimizing Database Access in .NET11/10/2023 7:04:46 PM. Optimizing database access in .NET involves picking the best tools, improving queries, managing connections efficiently, using caching, and monitoring performance. By doing this, you ensure your .NET
  • Fetch Data from Azure Data Explorer of the Kusto Microsoft Fabric Database in Excel11/7/2023 5:19:43 AM. In this video, I demo how to fetch data from azure data explorer of the kusto Microsoft Fabric database in Excel.
  • What is SQL Server Management Studio (SSMS)11/7/2023 4:14:32 AM. SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database ob
  • Mastering Database Management with Azure SQL Database11/2/2023 7:29:16 AM. Mastering Database Management with Azure SQL Database.
  • Improving SQL Table Data Performance11/1/2023 12:11:56 PM. This article discusses strategies and best practices for optimizing SQL table data performance. Topics covered include indexing, normalization, partitioning, data types, query design, monitoring, hard