databases Resources

Share

Related resources for databases

Is PostgreSQL the Future of Databases?10/16/2024 5:00:45 AM. This article explores whether PostgreSQL is the future of databases, highlighting its advantages in scalability, performance, and innovation. Discover how it compares to other database systems in toda
Exclude Exchange Databases from Auto-Provisioning in New DAG - Exchange 201910/10/2024 3:49:52 AM. In a multi-DAG Exchange environment, there are often scenarios where we want to ensure that primary mailboxes remain on a specific DAG, while a new DAG is reserved solely for archive mailboxes. This c
How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
Understanding Database Sharding in Programming9/24/2024 5:41:14 AM. 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 manageme
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
SQL Server on Azure VMs vs Managed Instance vs SQL Database8/12/2024 11:18:45 AM. Based on the type of the cloud service each Relational azure service use and different aspects formulated the differences and uses cases when to use each database solution.
What are Azure Resources and Resource Groups8/2/2024 6:21:11 AM. Azure Resources are individual cloud services like virtual machines, app services, and storage accounts. Each resource serves a specific purpose, such as data storage or application hosting. Azure Res
Design A High Availability Application With Azure App Service7/29/2024 8:32:55 AM. This article outlines creating a high-availability app using Azure PaaS, focusing on scalability and performance. It covers defining availability metrics (uptime, MTTR, MTBF, RTO, RPO), designing faul
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
Differences Between Azure Monitor and Azure Application Insights6/28/2024 8:43:53 AM. Azure Monitor and Azure Application Insights are powerful Microsoft Azure services for monitoring and analyzing applications and infrastructure. Azure Monitor offers comprehensive monitoring for infra
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.
What Are Object-Oriented Databases And Their Advantages6/12/2024 10:23:20 AM. In this article, you will learn what object-oriented databases are what are their advantages.
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
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,
Exploring PostgreSQL: The Powerhouse of Open-Source Databases6/7/2024 4:30:18 AM. PostgreSQL, often hailed as the powerhouse of open-source databases, is a robust and versatile relational database management system. Known for its advanced features, such as ACID compliance, extensib
Seed Databases in EntityFramework4/29/2024 9:58:30 AM. Seeding databases in Entity Framework simplifies initial data setup. Utilize migrations and DbContext to seed essential data, ensuring a consistent database state. This approach streamlines developmen
Zero To Hero In MS SQL Server - Part One4/19/2024 10:51:18 AM. This is part one of Zero To Hero Series in MS SQL Server. This is mainly focused for beginners who are into MS SQL Server and also for experienced who want to fresh up for interviews and daily technic
Multi-Tenancy with Separate Databases Approach in .NET Core4/8/2024 5:44:25 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
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.
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
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
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
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
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
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.
MongoDB and ACID Reliable Data Transactions with NoSQL Databases 10/30/2023 8:39:15 AM. This article explains what ACID compliance means for database management systems and how MongoDB, a popular NoSQL database, supports ACID transactions.
Transferring Data from One Table to Another Across Databases9/26/2023 6:24:41 PM. This article explores how to ingest data from a table in SalesData database to another table in the Data Warehouse database.
NoSQL Databases for ASP.NET Core Web APIs9/22/2023 6:12:13 AM. Microsoft Power BI empowers developers to craft highly customizable visuals using Vega and Vega-Lite's declarative JSON syntax. Create custom visuals in Power BI with our step-by-step guide, inclu
Web API Testing with xUnit, NUnit, MSTest in ASP.NET Core9/1/2023 8:20:13 AM. writing unit tests, integration tests, and end-to-end tests for a Web API using xUnit testing framework in ASP.NET Core. Keep in mind that I won't be able to provide you with actual working code,
Data in High Dimensions: Unveiling the Potential of Vector Databases8/30/2023 10:51:05 AM. Unlock the potential of high-dimensional data with vector databases. Discover how these specialized databases revolutionize image recognition, recommendation systems, and natural language processing.
Vector databases for Azure Open AI Embeddings Storage8/22/2023 9:25:14 AM. This article will cover Vector Databases for Azure Open AI Embeddings Storage.
How To Set Up And Start With MongoDB8/22/2023 6:45:21 AM. In this article, we will learn How to set up and starts with MongoDB in Windows Operating System.
Working With Databases In MongoDB8/22/2023 6:43:20 AM. In this article, we will learn about Database in MongoDB. If you are new to MongoDB then I would recommend you to go through the previous article in this series.
Need Of Polyglot Persistence8/21/2023 9:43:26 AM. Polyglot Persistence refers to the practice of using multiple database systems, each optimized for a specific type of data storage and retrieval, within a single application or system architecture. Th
Strategic Alert and Security Configuration8/21/2023 5:47:49 AM. Today I ran into something on a client-server that unfortunately I see too often. The DBA goes through the trouble of configuring and setting up alerts/operators but doesn’t really understand what th
Types of Databases8/10/2023 7:09:16 AM. There are multiple types of databases, such as relational database management systems, object databases, graph databases, network databases, and document db. In this article, we discuss the types of D
Most Popular Graph Databases8/10/2023 6:57:58 AM. Graph databases, or Graph DBMS, are growing in popularity. Neo4j is the most popular graph database. This article lists the most popular graph databases.
Extended Security Updates No More Freebies8/9/2023 10:57:19 AM. As data professionals, we should always strive to keep our systems updated and patched to ensure proper security of our environments. Microsoft has moved away from releasing service packs to releasing
Understanding Fragmentation In Distributed Databases8/9/2023 9:13:24 AM. Fragmentation in distributed databases refers to the division of a database into smaller parts or fragments that are stored on different computers or nodes within a network. This division is done to e
Configure A Windows Service For MongoDB8/9/2023 6:22:29 AM. In this article, we will learn how to configure a Windows Service for MongoDB.
What is a Relational Database (RDBMS)8/3/2023 5:39:53 AM. Relational databases represent data in a tabular form consisting of rows and columns. In this article, we'll learn the basics of relational database management systems (RDBMS) and how data is repr
Aggregation Pipeline In MongoDB8/2/2023 6:17:54 AM. In this article, you will learn about Aggregation Pipeline in MongoDB.
What Are NoSQL Databases8/1/2023 10:01:23 AM. NoSQL databases are the databases that do not use SQL as their primary data access language. Graph database, network database, object database, and document databases are common NoSQL databases. This
Introduction To DBMS8/1/2023 6:06:05 AM. A Database Management System (DBMS) is a software tool that enables users to create, manipulate, and manage databases. It acts as an intermediary between the user and the database, providing an organi
Delete Operation In MonGoDB Using Robo 3T7/31/2023 11:32:29 AM. In this article, we will learn how to delete the data from MongoDB using Robo 3T. We will learn from the basics because I have written this article focusing on the beginners. In my previous article, w
What Is The Difference Between Relational And Non-Relational Database7/27/2023 10:15:20 AM. Relational databases and non-relational databases, also known as NoSQL databases, represent two fundamentally different approaches to storing and organizing data. Understanding the key differences bet
Connection Strings for All Databases7/27/2023 4:40:45 AM. This article shows step by step different ways to get connection strings for all types of databases. The article is written for all type of users, beginners, intermediate, experienced
Rockin’ The Code World with dotNetDave ft. Barret Blake Ep. 774/20/2023 6:19:45 AM. Join us with Barret Blake for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
Synchronizing Databases Using Microsoft Sync Framework4/12/2023 10:07:01 AM. In this article, you will learn how to synchronise Databases Using Microsoft Sync Framework.
Rockin’ The Code World with dotNetDave ft. Milan Jovanovic Ep. 763/22/2023 2:49:42 PM. Join us with Milan Jovanovic for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
What are the Most Popular Relational Databases (2023)3/20/2023 12:53:14 AM. Relational database management systems are the most popular form of database management systems (DBMS) that includes Oracle, SQL Server, MySQL, and DB2. Here is a list of the most popular RDBMS in the
How To Execute SQL Statements From Command Prompt3/7/2023 5:16:48 AM. Here we discuss SQL and how to execute SQL statements in a command prompt.
Copy Table Data Across Databases2/28/2023 7:01:20 AM. In this section we will copy table data within the database or across two databases.
Rockin’ The Code World with dotNetDave ft. Clark Sell Ep. 732/13/2023 1:31:28 PM. Join us with Clark Sell for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
DATABASEPROPERTYEX Function in SQL Server2/13/2023 5:11:03 AM. In this article, I would like to show how to extract the metadata about a database in SQL Server.
How To Compare Two Databases, Find Differences And Update Using Visual Studio2/10/2023 7:01:44 AM. In this article, you will learn how to compare Two databases, find differences and update using SQL server database project in Visual Studio.
Compare the Schemas of two Databases2/10/2023 6:52:33 AM. In this simple project without even writing a single line of code, now I'll show you how easy it is, compare the schemas of two databases and make them identical with a few steps.
Rockin’ The Code World with dotNetDave ft. Mark Brown Ep. 721/25/2023 10:26:18 AM. Join us with Mark Brown for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
Rockin’ The Code World with dotNetDave ft. Robert Bogue Ep. 711/9/2023 8:18:14 AM. Join us with Robert Bogue for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
Introduction To MongoDB - Part One12/18/2022 4:18:50 PM. This article is basically an introductory article which will demonstrate how to start MongoDB
Rockin’ The Code World with dotNetDave ft. Shay Rojansky Ep. 7012/12/2022 5:50:49 PM. Join us with Shay Rojansky for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
Rockin’ The Code World with dotNetDave ft. Jeremy Likness Ep. 586/19/2022 5:38:17 AM. Join us with Jeremy Likness for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
Rockin’ The Code World with dotNetDave ft. Jirí Cincura Ep. 576/9/2022 7:33:44 AM. Join us with Jirí Cincura for Rockin' The Code World with dotNetDave - a weekly show to learn & live Q&A focused on .NET and other programming technologies.
Handling Data Load Types In Staging Database2/8/2022 4:48:55 AM. One of the fundamental aspects to consider when creating Data Warehouses is the consolidation of data from different sources, whether they are systems or different areas.
Azure AD Authentication For Azure SQL Server Managed Databases8/10/2021 12:55:31 PM. In this article, you will learn about Azure AD Authentication for Azure SQL Server Managed Databases.
Getting Started With MongoDB For Beginners4/22/2021 2:04:51 PM. MongoDB has been developed since 2007 by MongoDB. This company was then working on a Cloud computing system, widely distributed data computing, similar to the service Google's Google App Engine. I
Backup BizTalk Server Databases to Azure blob storage3/8/2021 4:53:20 AM. In this video, we will discuss the new feature "Backup to Azure Blob Storage" which is added in BizTalk 2020.
Connected Data using Graph Databases1/7/2021 5:28:41 AM. The fifth session of Women in Tech Virtual Conference by Karin Wolok.
How to Join Two Tables From Different Databases Using Entity Framework11/11/2020 9:20:12 AM. This article explains how to join two different tables from two different databases, or we may say how to join two tables from two different contexts, in Entity Framework.
Connecting Databases Using ADO.NET In VB.NET11/3/2020 1:20:50 AM. In this article you will learn how to connect databases using ADO.NET in VB.NET.
Accessing Text File Databases in ADO.NET 11/2/2020 9:26:24 AM. In this article I will explain about Accessing Text File Databases in ADO.NET.
Create a SQL Server Database dynamically in C#11/2/2020 5:33:02 AM. In this article, I’ll show you how to create a new SQL Server database and its objects such as table, stored procedures, views and add and view data. I’ll also show you how to change database table sc
Populate SQL Servers and Databases dynamically in C#11/1/2020 11:16:14 PM. The attached source code is a class that provides methods to populate an array with the available SQL Server and databases on your network dynamically.
Accessing Excel Databases using ADO.NET 10/30/2020 2:06:12 AM. In this article I will explain about Accessing Excel Databases using ADO.NET.
Backup and recovering system databases10/28/2020 4:52:29 AM. In this article, I will cover how to backup and recover system databases.
Mapping Objects to Relational Databases10/28/2020 2:45:52 AM. The application generates C# Class files for each table in a relational database. I have used Mysql and ODBC.NET for this project. The application only supports MySQL right now.
Sensitive Data Exposure9/4/2020 7:39:58 AM. In this article, you will learn about Sensitive Data Exposure.
Working With SQLite Databases and Data Backup in Android3/27/2020 2:46:52 AM. This article illustrates the basics of saving data in the SQLite database and a glance of Data backup in Android systems.
Fixing Corrupted Databases2/28/2020 9:26:49 AM. I shared my personal experience on how can we fix corrupted databases using a third party product called stellar.
Performing CRUD Operations In Azure SQL Database2/24/2020 9:02:26 AM. In this article, i am going to explain about how to performing CRUD operations in Azure SQL Databases.
Pragmatic Introduction To Views In Databases12/24/2019 9:53:26 AM. Views are database objects. Mostly docs discuss syntax and limitations regarding views. In this article we'll see some scenarios where views can help us.
Introduction To Databases10/11/2019 1:07:43 AM. This article is for students and newcomers to understand basics and types of databases and their history.
Distributed Databases in SQL Server7/10/2019 6:27:35 AM. In this article, I will cover on distribution of SQL queries where each system manages a single copy of data, and uses distributed transaction mechanisms to access local and remote data.
Connect MS SQL, MongoDB And MySQL Databases From Same MVC App Using Dependency Injection 3/26/2019 12:03:43 AM. In this post, we will see how to connect MS SQL, MongoDB, and MySQL databases from the same MVC application. We will use dependency injection with Unity package to achieve this.
Quick Start With Azure Cosmos DB - Day Five2/18/2019 1:15:57 AM. In this article, we will see how we can execute SQL queries on JSON documents and get filtered results.
Quick Start With Azure Cosmos DB - Day Two2/18/2019 1:11:15 AM. In my previous article, we have seen the structure of Cosmos DB, signed up azure free account for 30 days and created Cosmos DB account using Azure Portal.. today, we will see how we can create docume
Introduction to NoSQL Concept12/25/2018 11:54:51 PM. This article introduces the NoSQL concept. There are many NoSQL databases available like MongoDB, Elastic Search and Hadoop and so on.
What Are The Advantages And Usage Of Apache Cassandra Database12/21/2018 2:36:17 PM. This article reviews basics of Apache Cassandra and its advantages and usages. Apache Cassandra is the easiest truly big-data database that can scale and replicate data globally in a master-less confi
DataTypes In MongoDB11/26/2018 10:36:20 AM. In this article, we will learn about the Datatypes and its usage in the MongoDB. As we already know, MongoDB stores data in BSON format. BSON stands for the Binary-encoded format of JSON. Using BSON,
Creating Your First MongoDB Atlas Cluster11/20/2018 10:21:25 AM. MongoDB Atlas is an online no-sql database that allows you to run a MongoDB database as a service. Running MongoDB as a service means that you no longer need to host your own servers or manage upgrade
Normalization In Databases10/4/2018 12:59:42 AM. Sometimes the database design that looks Ok at first sight may have some hidden problems. One such kind of problem is Non-Atomic Values. This means that the value that stored in a single column in the
DBCC CLONEDATABASE And Query Store8/29/2018 5:55:44 PM. Anyway, by now, you probably have seen documentation on Query Store and DBCC Clonedatabase. Query Store, introduced in SQL Server 2016, is considered the “black box” or “flight recorder” of queries. I
Essential Features Of TablePlus - The Best GUI Tool To Manage Relational Databases5/25/2018 10:08:35 AM. TablePlus helps you to be more efficient while working with multiple relational databases. You can connect to the server, create a new database, manipulate and save your data at a fast speed, high-end
How To Survive As A Lone DBA5/17/2018 11:46:58 PM. Database administrators have enormous responsibility whether they manage one or hundreds of servers. Monica Rathbun tells us how she survived as the Lone DBA for 56 database servers for over a decade.
Continue With Learning Indexes In MongoDB3/8/2018 9:53:51 AM. This is the continuation of exploring the Indexes on MongoDB. We will be discussing various MongoDB indexes which we can perform on our data.
Cloud Databases In Azure - Part Three10/25/2017 3:53:04 PM. This is the third article in the “Azure Cloud Databases” articles series, which is in continuation of the previous two articles.
Cloud Databases In Azure - Part Two10/16/2017 9:56:36 AM. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
Cloud Databases In Azure - Part One10/11/2017 12:06:57 PM. In my previous articles on Azure, I have explained about the IaaS features of Azure i.e. creating Virtual Machines, databases etc. In this article, we will see the Introduction of Cloud Databases i.e.
Frequent Pattern And Market Basket Implementation9/9/2017 12:38:12 PM. Frequent pattern mining is about the item sets and sequences which appear in a data set.
Getting Started With MongoDB9/5/2017 2:23:26 AM. MongoDB is an open-source/cross platform (Windows, Linux, etc) document database that is NoSql in JSON format database. A NoSQL database means it does not have any relationships (non-relational databa

Topics