Resources No resource found - The Amazing Adventure of MongoDB QueriesFeb 09, 2024. This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, execution as detective work, utilizing the Aggregation Framework for complex queries.
- SQL Server Migration Strategy into Azure SQL PaaS DatabaseJan 30, 2024. 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, and tools.
- Azure Cosmos DB in C# DevelopmentJan 09, 2024. 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 mission-critical readiness, Azure Cosmos DB stands as a go-to choice for developers navigating the complexities.
- Azure Cosmos DB Interaction through PythonJan 02, 2024. This article speaks about the techniques to interact with Cosmos DB using Python. Azure Cosmos DB, a fully managed NoSQL and relational database for modern app development. Learn how to build a Python data layer using PythonSDK for Cosmos DB, covering CRUD operations.
- Consistency Levels in Azure Cosmos DB with an ExampleDec 27, 2023. 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.
- Reduction Consumed Storage in SQL DBDec 11, 2023. The simple way to reduce consumed DB storage on production app, with data migration and without dramatic changes in DAL (no additional services are required)
- CrateDB: Powering the Internet of ThingsDec 11, 2023. 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, and demonstrates CrateDB integration through code snippets.
- Exploring Logical and Physical Partitions in Azure Cosmos DBDec 03, 2023. Azure Cosmos DB, Microsoft's globally distributed, multi-model database service, operates on the foundation of logical and physical partitions. Let's delve into their nuances, accompanied by code snippets and examples, to elucidate their functionalities.
- Exploring MongoDB: Applications and Essential QueriesNov 30, 2023. 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.
- Time Series Databases: Understanding, Using, and ImplementingNov 28, 2023. 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 way for Time Series Databases (TSDBs).
- Azure Cosmos DB's NoSQL APINov 27, 2023. 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 platform supporting various NoSQL APIs, providing developers with diverse options tailored to specific data models. In this article, we'll explore the nuances of Azure Cosmos DB's NoSQL API, uncovering its features and advantages.
- Use Data API builder with Azure Cosmos DBNov 01, 2023. Use Data API builder with Azure Cosmos DB. The guide explains how to build a Data API using Azure Cosmos DB. It outlines steps such as creating a database container, adding a Book schema, obtaining the Cosmos DB connection string, creating a configuration file, and starting the Data API builder. The provided GraphQL query demonstrates querying the data. If you encounter any issues, please reach out for assistance.
- CRUD Stored Procedures in Azure Cosmos DBOct 26, 2023. In this article, we will learn how to create the stored procedures in the Azure Cosmos DB for inserting, reading, updating, and deleting the Azure Cosmos DB collection items.
- Explore and Test Cosmos DB Rest APIs with POSTMANOct 25, 2023. Explore and Test Cosmos DB Rest APIs with POSTMAN
- ASP.NET Core Web API For CRUD Operations With Cosmos DBSep 26, 2023. Creating a complete ASP.NET Core Web API for CRUD operations with a Cosmos Database is a multi-step process. In this tutorial, we'll create a sample application called "CSharpCornerArticles" to manage articles. We'll cover all the necessary steps, including setting up the Cosmos DB, creating the Web API, and implementing CRUD operations.
- Transferring Data from One Table to Another Across DatabasesSep 26, 2023. This article explores how to ingest data from a table in SalesData database to another table in the Data Warehouse database.
- OLE DB errors in Power BISep 19, 2023. This article helps you in understanding causes and solutions for common OLE DB errors in Power BI.
- ROOM VS MongoDB Realm Database in AndroidAug 21, 2023. This article will explain which database we prefer in the Android room or MongoDB.
- 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
- Simplifying CRUD Operations using Azure Cosmos DBJun 08, 2023. In this article describes about the CRUD operations using Azure Cosmos DB simplification end to end deployment.
- Getting Started with Azure Cosmos DB Account CreationMay 19, 2023. In this article describes about the creation of multi-modal Azure Cosmos DB account creation.
- ⚡Effortless Scalability: Discover the Power of Azure FunctionsMay 04, 2023. An Introduction to Serverless Computing
- Secure Resources Using Azure Managed IdentitiesApr 19, 2023. In this article, we will learn how to secure resources on azure platform without using any type of security key of connection string.
- CRUD Operations In ASP.NET Core Blazor Server with Azure Cosmos DB and C#Mar 06, 2023. In this article, we will learn how to create the Insert, Update, Delete, and Read operations in an ASP.NET Core Blazor Server App with Azure Cosmos DB and C#.
- Data Transformations At Scale Using Azure Cosmos DBMar 01, 2023. Azure Cosmos DB provides a powerful platform for data transformations at scale. By using features such as Change Feed, Stored Procedures, and Azure Functions, businesses can transform data quickly and accurately.
- 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.
- Implement Cascading Dropdown In ASP.NET Core MVC Application Using InMemory DBJan 05, 2023. In this article, we will discuss related to the cascading dropdown control generation with the help of Asp.Net Core MVC Application and InMemory Database.
- CRUD Operations In Azure Cosmos DB SQL API Using ASP.NET Core Web API C#Nov 28, 2022. In this article , we will learn how to make Insert, update, read, delete from Azure Cosmos DB SQL API Using ASP.NET Core API C#
- How To Recover Deleted Data In Azure SQL DatabaseOct 19, 2022. In this article, you will learn how to recover deleted data in azure sql database.
- ASP.NET Core 6.0 Blazor Server APP And Working With MySQL DBOct 12, 2022. In this article, we will see how to create a Stored Procedure in MySQL to search and bind the Customer details in our Blazor application using Service with search parameter.
- Learning Azure Cosmos DBAug 24, 2022. In this article, you will learn about Azure Cosmos DB.
- Get ConnectionString For SQL ServerAug 12, 2022. This article will discuss the ways to get ConnectionString from different sources.
- Sync Cached Data With Cosmos DB Using NCacheJun 16, 2022. From this article you will learn how to sync the data update in Cosmos DB with NCache using Azure Functions
- Fetch Previous Row Value With Lag Function And Without Lag FunctionJun 07, 2022. In this article, you will learn how to fetch previous row value with lag function and without lag function.
- Testing Azure Cosmos DB Locally Using A Docker Container ImageMay 12, 2022. When developing apps that consume Cosmos DB collections, the emulator is the weapon of choice. This article describes the steps to get it up and running using a Docker container image.
- Creating Azure Cosmos DB Resources From The Azure PortalApr 08, 2022. In this article, you will learn how to create Azure Cosmos DB resources from the Azure portal.
- Create An Azure Devops Pipeline To Continuously Integrate And Deploy .NET 6 REST API To Azure CloudFeb 07, 2022. Create An Azure Devops Pipeline To Continuously Integrate And Deploy .NET 6 REST API To Azure Cloud.
- Easy Way To Build Single Database In Azure SQL DatabaseJan 21, 2022. Easy way to build a single database in Azure SQL Database
- Essentials For .NETJan 11, 2022. In this article, you will learn about the essentials for .NET Platform.
- How To Do Live Data Refresh In Angular 11 Using SignalRJan 03, 2022. In this article, you will learn how to do live data refresh in angular 11 using SignalR.
- Angular 11 App To Do CRUD Operations On Azure Cosmos DB With .NET 5 REST APIDec 31, 2021. In the previous article, we will learn how to create a .NET 5 API that can do CRUD operations on Azure Cosmos DB using EF Core. We will continue this article to build an Angular 11 app to connect to the REST API and perform CRUD operations using the website.
- Create A .NET 5 App To Perform CRUD Operations On Azure Cosmos DB (SQL API) Using EF CoreDec 27, 2021. In this article, you will learn how to create a .NET 5 App to perform CRUD operations on Azure Cosmos DB (SQL API) using EF Core.
- Deploy .NET Core API To Azure Cloud And Secure It Using Facebook AuthenticationDec 14, 2021. In this article series, we will learn how to create a .NET Core API that can do CRUD operations on Azure Cosmos DB and then publish it to Azure Cloud. After that, we will secure the API with Easy Auth using Facebook as Identity Provider.
- Build And Publish A .Net Core API To Perform CRUD Operations On Azure Cosmos DB (SQL API)Dec 13, 2021. In this article, you will learn how to build and publish a .net core api to perform crud operations on azure cosmos db (SQL API) and secure it using facebook authentication.
- Live Charts Using Azure Cosmos DB, Azure Functions, SignalR And WPF - Part SixDec 03, 2021. This article series is aimed at teaching you how to use Cosmos DB trigger and HttpTrigger in an Azure function to create a serverless app that can broadcast the data to clients using SignalR. The client can be a desktop/web/mobile client. For this article, I will be using a simple desktop client created using WPF with Material Design.
- Live Charts Using Azure Cosmos DB, Azure Functions, SignalR And WPF - Part FiveDec 01, 2021. This article series is aimed at teaching you how to use Cosmos DB trigger and HttpTrigger in an Azure function to create a serverless app that can broadcast the data to clients using SignalR. The client can be a desktop/web/mobile client. For this article, I will be using a simple desktop client created using WPF with Material Design.
- Live Charts Using Azure Cosmos DB, Azure Functions, SignalR And WPF - Part FourNov 29, 2021. This article series is aimed at teaching you how to use Cosmos DB trigger and HttpTrigger in an Azure function to create a serverless app that can broadcast the data to clients using SignalR. The client can be a desktop/web/mobile client. For this article, I will be using a simple desktop client created using WPF with Material Design. To follow along please make sure you have an Azure account.
- Live Charts Using Azure Cosmos DB, Azure Functions, SignalR And WPF - Part ThreeNov 26, 2021. In this article, you will learn about live charts using Azure Cosmos DB, Azure functions, SignalR and WPF.
- Live Charts Using Azure Cosmos DB, Azure Functions, SignalR And WPF - Part TwoNov 25, 2021. This article series is aimed at teaching you how to use Cosmos DB trigger and HttpTrigger in an Azure function to create a serverless app that can broadcast the data to clients using SignalR. The client can be a desktop/web/mobile client.
- Live Charts Using Azure Cosmos DB, Azure Functions, SignalR And WPF - Part INov 23, 2021. This is part 1 of the article series. We will learn how to create a resource group and cosmos db here. This article is aimed at teaching you how to use Cosmos DB trigger and HttpTrigger in an Azure function to create a serverless app that can broadcast the data to clients using SignalR. The client can be a desktop/web/mobile client. For this article, I will be using a simple desktop client created using WPF with Material Design
- Insight.Database , .NET Micro ORM - Write Less Code In Data Access Layer Using Auto Interface ImplementationNov 07, 2021. In this article, you will learn about Insight.Database is a fast, lightweight, (and dare we say awesome) micro-orm for .NET. Auto Interface Implementation implements the interface for you automatically, and you can just call the method, with full type-safety and full performance of IL-generated code.
- Advanced Entity Framework Core: Extract data access layer with migrations to the library project and Execute migrations from the command lineOct 13, 2021. See code examples in this article:
Let's imagine you have a solution with many projects including a web application with the name "MiniService", which contains appsettings.json and a library project with DbContext and Migrations with any name f.e. "MiniService.Data". You most likely want to use the exact connection string in the appsettings.json used by the web app.
May be different cases when you will need to run migrations from the command line, for example, there is no 'Package Manager Console' in VS for Mac.
- How To Perform Azure Cross Container Transaction Operation In Cosmos DBOct 05, 2021. Azure cosmos db does not provide transaction operation across different container with different PartitionKey. In this article I am going make ACID behavior using .net core c#
- Easily Manage PostgreSQL Database Migrations With DBeaver And Redgate Flyway Aug 01, 2021. In this post, we will see how to manage PostgreSQL database with DBeaver community version and Flyway community version from Redgate.
- What Is Azure Cosmos DB Apr 22, 2021. In this article, you will learn about Azure Cosmos DB.
- Cursor In SQL Server With Syntax And ExampleJan 14, 2021. This article provides an explanation about how you can use and set up a basic cursor in SQL Server. many developers/programmers/people those who work with Microsoft SQL Server will have at least heard talk about the cursors. Even if any developers/programmers/people know on a basic level what SQL Server cursors do, they are not always certain when to use cursors and how to write the code to use cursors.
- Modern Architecture Shop - AutoscalerNov 10, 2020. Modern Architecture Shop is a clean-lightweight .NET and scalable application. Keep your eye on the Road Map (watch it on GitHub). The next version will contain a minimal feature set so that the user can add products to the basket and pay it. Recommendation service and all other AI services or features, I provide them later.
- Road To AZ-204 - Developing Solutions That Use Cosmos DB StorageNov 05, 2020. 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 alongside a practical example.
- Azure Cosmos DB - Store And Retrieve JSON Data Types Using SQL APIOct 26, 2020. In this article we will try to understand azure cosmos db service and advantages of using no SQL cosmos db storage. We would also be creating our first Cosmos db account and storing & retrieving json type data using SQL API
- Implement Stored Procedure, UDFs And Trigger In Cosmos DB Using ASP.NET Core Web ApplicationSep 09, 2020. In this example, we will demonstrate how to implement Cosmos DB related Server-side objects like Stored Procedure, Trigger, UDFs, etc in an Asp.Net Core Applications.
- Connect MS SQL And MySQL Database To Your .NET Core Web APIAug 10, 2020. connect to MS SQL and MySQL Database to your simple .NET Core Web API using package manager console by following simple steps
- Design And Implement A Graph Database In Azure Cosmos DBJul 22, 2020. In this article, we discuss the concept of a Graph Database and how we can create and operate in a Graph Database using Azure Portal.
- Azure Cosmos DB - SQL API Geo-Replication Using EF CoreJul 16, 2020. In this article, you will learn about Azure Cosmos DB - SQL API Geo-Replication using EF Core.
- Simplified Courier Tracking SystemJul 16, 2020. The system is used for daily activities, such as booking, nondelivery, out return, company details, hub rates, and pickup centers. It is very difficult to do this process manually. Hence it is recommended to computerize the process by developing the relative software as the world is turning into information and technology; computerization becomes a necessity in all walks of life. This process has divided into Admin, Customer, and Employee Logins. The admin will go into the Homepage and there are all the controller processes like customer, booking, cancellation. Tracking is also maintained. The customer will log in to form to view only Booking & Tracking, and her/his account information is stored. In Employee will login into a form that will display account information, and booking information is maintained. Finally, these details are stored in the Database. This project is implemented in Visual studio 2008 in a C# .NET Windows application and Back End in SQL Server 2005.
- Top 10 Most Popular Articles Of Cosmos DBJul 16, 2020. This article lists the top 10 most-read articles of the Cosmos DB category.
- How To Build Server Side Objects Like UDF, Stored Procedure, & Trigger In Cosmos DBJul 13, 2020. In this article, we will discuss the UDF, Stored Procedures, and Triggers in Cosmos DB.
- Azure Cosmos DB - SQL API Using EF CoreJul 06, 2020. In this article, you will learn about Azure Cosmos DB - SQL API Using EF Core.
- How To Design And Query Data In Cosmos DBJul 02, 2020. In this article, we will discuss document design and structure in Cosmos DB. We also discuss the different query types that can be required to retrieve data from Cosmos DB.
- An Overview Of Cosmos DB - Start From ScratchJun 22, 2020. In this article, we will discuss the NoSQL database. Along with this, we also discuss Cosmos DB and how to create it using Azure Portal.
- Update Data Into Azure Cosmos DB Using Power AutomateJun 08, 2020. In this article, you will learn how to update data into Azure Cosmos DB using Power Automate.
- DotVVM CRUD Application With Entity Framework And Cosmos DBJun 04, 2020. In this article, you will learn about the DotVVM CRUD application with Entity Framework and Cosmos DB.
- Delete Data From Azure Cosmos DB Using Power AutomateJun 01, 2020. In this article you will learn how to delete data from Azure Cosmos DB using Power Automate.
- Read Data From Azure Cosmos DB Using Power AutomateMay 26, 2020. In this article you will learn how to read data from Azure Cosmos DB using Power Automate.
- Insert Data Into Azure Cosmos DB Using Power AutomateMay 18, 2020. In this article you will learn how to insert data into Azure Cosmos DB using Power Automate.
- EFCore Implementation Using .NET coreApr 22, 2020. In this article, you will learn about EFCore Implementation using .Net core.
- Simple Scaffolding CRUD Operations in ASP.NET Core Using EF Core DB First ApproachApr 12, 2020. In this article, we will perform simple Scaffold CRUD operations in ASP.NET Core using EF Core
- Inserting Data into SQL Server Database Using ASP.NET Core 3 Razor PagesMar 17, 2020. In this article, you will learn how to insert data into SQL Server Database using ASP.NET Core 3 Razor Pages.
- Create A Free Cosmos DB SQL API Account With Multi Write RegionsMar 17, 2020. In this post, we will discuss about the features of newly introduced free tier Cosmos DB account.
- Exception Handling In SQL ServerMar 16, 2020. In this article, you will learn about exception handling in SQL Server.
- Create A Database Project From Existing SQL Database Dec 08, 2019. In this post, we will see how to create a database project from existing SQL database. We will modify the project by adding a table into the project and add seed data through post deployment script. We will later deploy this project to SQL server as new database.
- Working With Mongo DB Using .Net CoreNov 18, 2019. In this article, I'm going to show you how to deal with Mongo Database using .Net Core.
- HammerDB for Azure SQL DB Nov 15, 2019. In this article, we see how to configure HammerDB for Azure. HammerDB is open source available with a Windows distribution or Linux.
- Build a Table API with Python and Azure Cosmos DBNov 14, 2019. In this article, we will learn about how to use Python and Azure Cosmos DB Table API to build an app by cloning an example from Github.
- Combine SQL-DB And MongoDB In Same Blazor App Nov 10, 2019. In this post, we will see how to combine SQL DB and MongoDB in same Blazor app. We will create two entities for City and Employee. City will be saved in MongoDB and Employee will be saved in SQL DB. We will get City name from MongoDB and saved in SQL DB along with other employee data.
- How To Track Database Changes in SQL serverOct 21, 2019. This article talks about tracking database changes in SQL Server
- Easy Way To Become An F# Programmer For C# DevelopersOct 16, 2019. In this article, you will learn about an easy way to become an F# programmer for C# developers.
- Moving To Azure SQL DB ServerlessSep 20, 2019. In this article, you will learn how to move to Azure SQL DB Serverless.
- Creating Your First Cosmos DB DatabaseAug 23, 2019. In this article, I will show you how to create your first Cosmos DB database using the Azure portal.
- Preserve Conversation To Cosmos DB Using Azure Bot Framework SDK V4Aug 15, 2019. In this article, we will learn how to store the conversation to Azure Cosmos DB with Bot Framework SDK v4.
- Real-time Angular 8 Application with SignalR and Cosmos DBAug 13, 2019. In this post, we will create a real-time application in SignalR with ASP.NET Core as backend and Angular 8 as frontend. We will use Cosmos DB to save and retrieve the data. We will create a fully functioned employee application to illustrate the real-time features.
- Entity Framework Core And Cosmos DB With BlazorJul 29, 2019. In this article, we will learn how to get started with Entity Framework Core and Cosmos Db with Blazor. We will create a demo application as well for better understanding.
- What Are NoSQL DatabasesJul 28, 2019. 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 article answers the question: What is a NoSQL database?
- Understanding Partitioning And Partition Key In Azure Cosmos DBJul 25, 2019. In this article, you will learn about partitioning and Partition Keys in Azure Cosmos DB.
- What Is A Document DatabaseJul 24, 2019. A document database is a NoSQL database. This article explains what a document Db is and what are the most popular document databases.
- What Is A Column Store DatabaseJul 23, 2019. Column Store Databases store the data in columns rather than rows. In this article, let's understand what column databases are and what are the most popular column store DBMS.
- Azure SQL DB Failover Group Orphaned UsersJul 21, 2019. In this article, you will learn about Azure SQL DB Failover Group Orphaned Users.
- Deep Dive Into Azure Cosmos DBJul 12, 2019. In this article, you learn about Azure Cosmos DB and how to perform CRUD operations there.
- Most Popular Graph DatabasesJul 01, 2019. Graph databases, or Graph DBMS, are growing in popularity. Neo4j is the most popular graph database. This article lists the most popular graph databases.
- Introduction To Azure Cosmos DB Table APIJun 19, 2019. This article will provide a short introduction to Database Systems and Azure Cosmos DB Table API with a code sample.
- Angular 8 App With Cosmos DB And Azure FunctionsJun 08, 2019. In this post, we will see how to create an Azure Function in Visual Studio and we will create separate Azure Functions for each CRUD action with Cosmos DB. Later, we will use these functions as REST API service in an Angular 8 application. We will also see how to create an Angular 8 application using Angular CLI step by step.