Database

Content
People

Sort By Search Results

Create a Model with Database Table in .NET 8 using EF CoreOct 28, 2024. This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection string, and use migrations to manage your database schema.
How to Decide Between Relational Database and NoSQL Databases?Sep 30, 2024. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, making them ideal for applications requiring data integrity.
Understanding Database Sharding in ProgrammingSep 24, 2024. Learn how sharding improves scalability and performance in distributed databases, key strategies for partitioning data, best practices for shard key selection, and techniques to optimize data management.
Learn Database Mail in SQL ServerAug 29, 2024. Database Mail in SQL Server is a robust feature that enables sending emails via an SMTP server without relying on MAPI clients like Outlook. It offers secure SSL encryption, asynchronous processing, extensive logging, and seamless integration with SQL Server Agent, making it ideal for automated email notifications and alerts.
Vector Database Internals: In a Layman's PerspectiveAug 29, 2024. A vector database stores and manages data as vectors—lists of numbers representing features of items. It excels in handling unstructured data like images and text by using vector embeddings generated by AI. This allows for efficient similarity searches, real-time analysis, and scalable performance.
SSRS (4) --- SQL Server Database Project in Visual StudioAug 25, 2024. This article is to discuss: SQL Server Database Project in Visual Studio
Store Java Errors in Database with Dynamic Error-Based LoggingAug 23, 2024. It covers setting up logging frameworks, capturing runtime errors, and ensuring data persistence for effective error management and tracking. Ideal for improving application reliability and diagnostics.
Learn to Shrink a Microsoft SQL Server Database Programatically Aug 20, 2024. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause data fragmentation and impact performance. Use commands like DBCC SHRINKDATABASE cautiously in C#.
How to Retrieve and Display Database Records in Java Using JTableAug 13, 2024. Learn how to retrieve and display database records in Java using JTable with this step-by-step guide. Explore Java Swing for creating a graphical user interface, JDBC for database connectivity, and SQL queries for fetching data.
ASP.NET C# Display Bootstrap Bar Chart from Database ValuesJul 22, 2024. Create a stored procedure in SQL to fetch monthly audit data and display it in an ASP.NET application. Use Visual Studio to create a master page with jQuery and Flot libraries. Serialize the data to JSON in the code-behind, then plot it in a bar chart on a content page.
Connecting to a MySQL Database Over LAN Using SQL WorkbenchJul 22, 2024. Learn how to connect to a MySQL database over a local area network (LAN) using SQL Workbench. This guide covers finding the IP address of the MySQL server, configuring it for remote access, setting up firewall rules, and establishing a connection from a client machine.
PostgreSQL Database Backup and Restore using pgAdminJul 12, 2024. This article provides a step-by-step guide on how to backup and restore a PostgreSQL database using the pgAdmin GUI. It covers the prerequisites, the detailed process of creating backups, and restoring data from backup files, ensuring your data is safely managed and recoverable in case of issues
Using EF Core to Scaffold DbContext and Models from Existing Database TablesJul 12, 2024. In this article, we will see how using Scaffolding we can generate database context (DbContext) class for database and model of entities in that database's table. We will be using MS SQL Server as data source and use EF Core framework.
Database Objects Related to Table in Database - Transact SQL QueryJun 29, 2024. The SQL query retrieves distinct object names and their types from SYSCOMMENTS and SYSOBJECTS system tables, categorizing objects by their XTYPE values ('P' for procedure, 'V' for view, 'TR' for trigger). It filters results containing 'table_name' in their definitions, providing insights into database object metadata.
How To Connect Database in ASP.NET MVC using C# with ADO.NETJun 17, 2024. Learn how to integrate SQL Server with your MVC application, configure connection strings, and perform CRUD operations. Ideal for developers seeking to enhance their data access techniques in ASP.NET.
Integrating Azure SQL Database with Azure FunctionsJun 17, 2024. Azure SQL Server is a fully managed database service by Microsoft Azure, offering scalability, high availability, and robust security features. It integrates seamlessly with Azure Functions for building scalable applications.
DuckDB: The Powerful Embedded Database for AnalyticsJun 16, 2024. DuckDB is a high-performance, embedded database designed specifically for data analytics. It offers in-memory processing, SQL support, and columnar storage, making it ideal for analytical queries and data warehousing.
Automate MySQL Database Updates with Cron Jobs in Node.jsJun 13, 2024. Learn how to automate MySQL database updates using cron jobs in Node.js with this comprehensive step-by-step guide. Discover how to schedule tasks, write automated scripts, and maintain your database efficiently.
Best Practices For Effective Database Design In SQL ServerMay 28, 2024. In this article, we will be exploring the best practices for effective database design in SQL Server. Creating an SQL Server database involves best practices like understanding requirements, normalization, choosing data types, indexing, and security.
Automatic Tuning Enhances SQL Server Database PerformanceMay 20, 2024. Automatic Tuning in SQL Server combines various intelligent features and techniques to continuously monitor, analyze, and optimize database performance and reduce management overhead. In this article, we will explore the what, why, and how to create automatic tuning in SQL Server Database.
Dynamic Mapping Database result to Entity TMay 20, 2024. This article provides logic for Mapping the SQL Result to C# Class. This code snippet demonstrates the dynamic mapping of SQL result columns to C# properties, converting SNAKE_CASE SQL column names to PascalCase C# properties using MapToList for DbDataReader to object mapping.
Understanding ACID: The Foundation of Database TransactionsMay 17, 2024. In the domain of database management, ACID (Atomicity, Consistency, Isolation, Durability) principles assure transaction reliability. This article delves into ACID's history, necessity, evolution, constraints, and SQL implementations' demonstrations.
De-Normalization in SQL: Enhancing Database PerformanceMay 16, 2024. De-normalization in SQL, born from the limitations of normalization, optimizes database performance by strategically reintroducing redundancy. Balancing performance gains with data integrity remains crucial in evolving applications.
Understanding the Layers of Database Management SystemsApr 21, 2024. Unlocking the Power of Three-Tier Architecture: A Comprehensive Guide to Understanding and Implementing Database Management Systems. Dive deep into the layers of presentation, application, and data management, unraveling the intricacies of this widely adopted architectural model.
Connecting SQLite Database to Mobile App with Flutter and DartApr 04, 2024. To integrate an SQLite database into your Flutter mobile app, follow these steps: Add dependencies, create a database helper class for CRUD operations, use it in your app, handle async operations, and test.
Seamless Database Integration with C#Mar 26, 2024. Efficiently integrating databases with C# applications is crucial for managing data seamlessly. Explore various approaches like ADO.NET, Entity Framework Core, and Dapper along with best practices for successful integration.
How to Read or View Exchange Database EDB File ProgrammaticallyFeb 28, 2024. 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.
Resolving Database Reconnection Challenges in .NET with PollyFeb 13, 2024. 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, simulating temporary database disconnection.
How to Backup/Restore MongoDB Database and CollectionsFeb 11, 2024. Backing up and restoring a MongoDB database and collection with command definition explanation and example as well.
Supported File Types for Data Ingestion into KQL Database in FabricFeb 06, 2024. 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 is not supported. See how to ingest & transform data using Data Factory.
Automated Deployment of SQL Server Database through Azure DevopsFeb 06, 2024. 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 pipeline for deployment.
SQL Joins for Efficient Database QueriesFeb 05, 2024. 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 retrieval.
Optimize SQL Database PerformanceFeb 01, 2024. "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. for optimize SQL database performance, ensuring faster queries, reduced resource consumption, and improved overall database responsiveness.
Redis as Primary Database in .NET 8 Web APIJan 31, 2024. 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 database. Follow step-by-step instructions to set up Redis in a container and use it with .NET 8 Web API.
Working with SQL Lite Database in Asp.NET Core Web API Jan 21, 2024. 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 separate server process and operates directly on the client's device
Connecting Postgres Database to Mobile App with Flutter and DartJan 03, 2024. Postgres Database to connect with your mobile app using Flutter and Dart
Efficient API Development Database Operations in ASP.NET Core Web Using Dapper and Stored Procedures Dec 26, 2023. 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, this combination elevates the API development process, enhancing performance and maintainability. Leveraging these tools empowers developers to create robust, high-performing applications while simplifying database access and management.
How to create a Microsoft Azure SQL Database in serverless compute tier from the Azure PortalDec 03, 2023. This article focuses on the swift creation of a serverless Azure SQL Database via the Azure Portal.
Optimizing Database Access in .NETNov 10, 2023. 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 apps run smoothly and respond quickly, enhancing the user experience.
Mastering Database Management with Azure SQL DatabaseNov 02, 2023. Mastering Database Management with Azure SQL Database.
Solution: Mail not queued. Database Mail is stoppedOct 11, 2023. Database Mail is a feature in SQL Server that allows you to send email messages from the SQL Server database engine. It can be a crucial tool for alerting and notifications within a database system. However, sometimes, Database Mail might stop working due to various reasons such as configuration issues, service failures, or network problems.
Database Recovery (1-1): Restore a Table from a Backup Database through Restore/ExportSep 19, 2023. This article is to discuss how to recover one table from a backup file
Connecting MySQL Database to Mobile App with Flutter and DartSep 11, 2023. MySQL Database to connect with your mobile app using Flutter and Dart
Creating a WEB API POST Method to Retrieve Data from SQL Database using ASP.NET MVC ApplicationAug 23, 2023. In this article, I have explained how to create a WEB API POST method to retrieve data from SQL database using Asp.net MVC Application.
ROOM VS MongoDB Realm Database in AndroidAug 21, 2023. This article will explain which database we prefer in the Android room or MongoDB.
Implementing AJAX for Editing Data and Updating the Database in ASP.NET MVCAug 07, 2023. Implementing AJAX for editing data and updating the database in ASP.NET MVC allows you to enhance the user experience and responsiveness of your web application. AJAX (Asynchronous JavaScript and XML) enables seamless data retrieval and updates without requiring a full page reload, resulting in faster and more interactive user interactions.
Hive Database Integration In FlutterJul 26, 2023. Generally, when we are building a mobile application, we need to store some data locally in the mobile device. At that point, the Hive database comes into play. In this article, we are going to see how you can create a local database in Flutter using the Hive database.
How to get items from a database into a Tkinter Listbox?Jul 18, 2023. In this article we will discuss how to get items from a database into a Tkinter Listbox.
Dynamic Menu Creation Using Oracle Database Jul 03, 2023. In this article, I am going to share with you how to create dynamic menu in #Asp.Net using the oracle database.
How to Access Amazon RDS for PostgreSQL Database Using PythonJun 30, 2023. In this article, you will learn how to access Amazon RDS for PostgreSQL database using Python.
Guid vs. Sequential Integers: A Great Debate in Database DesignJun 23, 2023. Explore the debate between Guids and sequential integers as primary keys in relational databases, weighing the pros and cons for optimal design choices.
How to Create Azure SQL Server Database in the Microsoft Azure Portal?Jun 22, 2023. Step by step details to create azure sql database server in the Microsoft Azure Portal
Entity Framework 7 – Database First – Using EFCorePowerToolsJun 06, 2023. Tutorial on EF7 – Database First approach using GUI tools EFCorePowerTools
How to Connect to Azure SQL Database in the Azure Data Studio?Jun 05, 2023. Step by step process to connect to Azure SQL Database in the Azure Data Studio
Entity Framework 7 – Database First – Using CLIJun 02, 2023. Tutorial on EF7 – Database First approach using Command Line (CLI)
Entity Framework Core: A Guide to Database Access in .NET CoreMay 23, 2023. Entity Framework Core: A guide to database access in .NET Core
Setup Oracle Database Pod in Kubernetes Cluster using YAML fileMay 23, 2023. Setup Free Oracle Database in pod to perform DB operation with in Kubernetes cluster.
Mastering Azure Database for PostgreSQLMay 15, 2023. In this article describes about the usage of Azure Database for PostgreSQL Server.
Exploring The Services Of Azure Database For MySQL ServerMay 12, 2023. In this article describes about the Azure Database for MYSQL Server in detail.
Demystifying Azure SQL Database Service: Quick Start Comprehensive GuideMay 10, 2023. In this article describes about how to create and deploy Azure SQL Database service.
Run EF Core Database Operations in BackgroundMay 02, 2023. This article will teach you to implement generic pattern in C# which helps you to perform any type of operations in the background using SOLID principles, Specially EF core database operations.
Fetch MySQL Data Using Database Connector in MuleSoftApr 27, 2023. In this article, you will learn how to get MySQL data using Database Connector in MuleSoft.
Retrieve Data From Database Based On Conditions In MuleSoftApr 27, 2023. I this article, you will learn how to retrieve data from database based on conditions using database connector in MuleSoft.
Copy Azure Database To Local Server In SSMS 19Apr 11, 2023. In this article, I will explain how you can copy your azure cloud database into your local server using SQL Server Management Studio 19. SSMS provides us export data tier option to copy the database.
Introduction to Azure Database for MySQLMar 23, 2023. In this article, you will learn about Azure Database For MySQL.
Streamlining Database Management using Managed SQL Server Database ServicesMar 10, 2023. Managed SQL Server Database Services refer to a type of cloud-based database management solution that enables businesses to offload the management of their SQL Server databases to a third-party provider.
Getting Started With Azure Database ServiceMar 06, 2023. In this article, you will learn about Azure Database Service. Azure SQL Database is a fully-managed, relational database service offered by Microsoft as part of their Azure cloud computing platform.
How To Connect To Azure SQL Database With MuleSoftFeb 28, 2023. In this article, you will learn how to connect to Azure SQL Server database with MuleSoft SQL database connector.
Capture And Store SQL Server Database Integrity History Using DBCC CHECKDBFeb 24, 2023. To capture and store the SQL Server database integrity history using DBCC CHECKDB.
Designing A Multi-Region Web Application Solution With A Private Endpoint Database In Microsoft AzureFeb 13, 2023. In this article, you will learn how to design a multi-region web application solution with a private endpoint database in microsoft azure.
Decoding Database Sharding: A Comprehensive OverviewFeb 06, 2023. Database sharding is a technique used to horizontally partition large databases into smaller, more manageable pieces called "shards." Each shard contains a subset of the data, and together they form the complete dataset. Sharding is employed to distribute the database load across multiple servers, allowing for improved performance and scalability. This overview provides insights into the concept of database sharding and its significance in handling massive amounts of data efficiently.
How To Setup And Install PostgreSQL Database LocallyJan 25, 2023. This article demonstrates step by step approach on how to install and setup PostgreSQL db locally on windows machine.
Create Database Script With Table Data In SQL ServerJan 05, 2023. In this article, you will learn how to create database script with table data in SQL server.
Database Recovery (1): Clone Database From One Instance To Another In SQL ServerDec 26, 2022. In this article,you will learn how to clone database or tables from one instance to another in SQL Server.
How To Bring Database Online From Suspect Mode In SQL ServerOct 27, 2022. In this article, we have mentioned few points to Bring Database Online from Suspect Mode in SQL Server.
Create Database Connection Using ADO.NETOct 21, 2022. In this article, you will learn how to create Database Connection using ADO.NET - C#.
Search A String Entire Database (SQL Server)Oct 20, 2022. Searching a string in all the tables available in the SQL Server database
AWS Database ServicesOct 18, 2022. AWS Database different Services with usage.
Entity Framework Core 6 With Database FirstSep 26, 2022. In this article, you will learn about Entity Framework Core 6 With Database First.
CURD Azure SQL Database Dapper And Repository Pattern Using ASP.NET Core 6 MVCSep 14, 2022. In this article, will learn CURD (Create, Update, Read and Delete) operation which common for all the applications. Here will understand Azure SQL Database, Dapper Micro-ORM (Object Relation Mapper) along with repository pattern using ASP.NET Core 6 MVC.
How To Create Azure SQL Database Using Azure PortalAug 30, 2022. Azure SQL Database is a relational database as a service (DaaS) based on the latest stable version of the Microsoft SQL Server database engine.
Write Unit Tests For Database Related Business CodeAug 21, 2022. This article introduce some ways to write unit tests for database related business code.
How To Restore SQL Server Database BackupAug 18, 2022. In this article, you will learn how to restore SQL Server Database Backup using two methods.
How to Take SQL Server Database Backup Jul 24, 2022. In this article, you will learn how to download Database backups using two methods.
How To Rename Database Objects In SQL ServerJul 13, 2022. In this article, you will learn how to rename database objects in SQL Server.
How To Use Stored Procedure By Getting Database Connection Using DbContext In RepositoryJul 09, 2022. Sometimes we need to create API/s and perform custom operation with database where we can perform create, insert, update and delete on entity/ties or table/s according to our requirement. Then we can use Store Procedure.
How To Restore Same Database With Different Names In SQL ServerJun 29, 2022. This tutorial will show you the steps to restore the same database with different names in SQL Server
Configuring A Failover Group For A Production Database In AzureJun 15, 2022. In this article, you will learn how to configure a failover group for a production database in azure.
How To Use Azure SQL Database In Power BI ReportsJun 10, 2022. In this article, you will learn how to Use Azure SQL Database in Power BI Reports.
How To Configure SMTP O365 Migration Using TLS 1.2 For SQL Database MailJun 07, 2022. This article will explain to you how exactly you need to configure TLS 1.2 as a default protocol and setup SMTP O365 migration using SQL 2012 Database mail and above versions for Windows Server 2012 and above Common SMTP exceptions we usually faced : The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2. Exception Message: Cannot send mails to mail server. (Failure sending mail.). )Just follow the steps -
Replication In Distributed Real Time Database SystemMay 13, 2022. Replication Techniques for increasing the performance of Distributed Real Time Database System.
Migrating a SQL IaaS Database To Azure SQL Using DMA (Data Migration Assistant)May 11, 2022. In this article, you will learn how to migrate a SQL IaaS Database to Azure SQL using DMA (Data Migration Assistant).
How To Restore A SQL Server Database From A BackupApr 28, 2022. In this article, you will learn how to restore a sql server database from a backup.
Working With MySQL Database In Google Cloud PlatformApr 14, 2022. In this article, we will learn how to create MySQL Database and use gcloud CLI to create databases, tables, and run queries on database objects.
Create Azure SQL Server And DTU Based SQL Database With TDE State Enabled Using PowerShell ScriptApr 04, 2022. This article is focused on creating an Azure SQL Server to a newly created Resource Group and then creating a SQL Database of Basic Edition with DTU capacity with its TDE (Transparent Data Encryption) state as Enabled using PowerShell commands
Create A Transactionally Consistent Clone Of A Database In Azure SQL DatabaseMar 26, 2022. In this article, you will learn how to create a transactionally consistent clone of a database in Azure SQL database.
Lake Database In Azure Synapse AnalyticsMar 21, 2022. In this article, you will learn about lake database in azure synapse analytics.
Create SQL Server Database With Pre-Defined SchemaMar 17, 2022. In this article, you will learn how to create Database with Pre-Defined Schema like Tables, Stored Procedures, Functions, Views.
Connecting To Azure SQL Database With Active Directory - Universal With MFAMar 02, 2022. In this article, you will learn how to connect to Azure SQL Database with Active Directory - Universal With MFA.
Copy Database From One Azure subscription to AnotherFeb 24, 2022. Copy Database from one Azure subscription to Another Azure Subscription

1 - 100 of 1273

OUR TRAINING