Resources   No resource found

• How Developers Are Using Vector Databases Beyond RAG ApplicationsMay 29, 2026. Explore how vector databases transcend RAG, powering AI agents, recommendations, fraud detection, and more. Unlock semantic search and intelligent retrieval.
• Vector Databases Explained – Why They Are Important for AI ApplicationsMay 20, 2026. Unlock the power of AI with vector databases! Learn how they revolutionize semantic search, AI memory, and RAG, enabling intelligent applications. #AI #VectorDB
• Vector Databases Explained for .NET Developers – Pinecone vs Weaviate vs ChromaDBMay 20, 2026. Explore vector databases for .NET! Compare Pinecone, Weaviate, & ChromaDB for AI apps like chatbots, RAG, & semantic search. Boost your AI skills now!
• The New Stack: AI Agents + MCP + RAG + Vector Databases ExplainedMay 15, 2026. Unlock the power of AI! Explore AI Agents, MCP, RAG & Vector Databases. Build intelligent apps for reasoning, automation & real-world tasks. #AIStack
• Difference Between SQL and NoSQL Databases with Examples?Mar 25, 2026. Explore SQL vs NoSQL databases: understand key differences, use cases, and advantages for modern web applications. Choose the right database for scalability!
• How to Implement Vector Databases Like Pinecone or Weaviate in AI Applications?Mar 18, 2026. Learn how to use vector databases like Pinecone & Weaviate to enhance AI applications. Store data as embeddings for smarter search & recommendations.
• Can Relational Databases Scale Horizontally Like NoSQL Databases?Mar 11, 2026. Can relational databases scale horizontally like NoSQL systems? Learn how SQL databases scale using sharding, replication, and distributed architectures.
• How do developers choose between relational and NoSQL databases for applications?Mar 11, 2026. Explore the key differences between relational (SQL) and NoSQL databases. Learn how to choose the right database for your application's needs, considering scalability, consistency, and data structure. Make informed decisions for optimal performance!
• What role do vector databases play in modern AI application architecture?Mar 10, 2026. Explore vector databases: the core of modern AI. Learn how they power semantic search, RAG, and multimodal AI by enabling fast, contextual data retrieval.
• How to Optimize SQL Queries for Large Databases EffectivelyFeb 20, 2026. Boost database performance! This guide covers SQL query optimization techniques for large databases, including indexing, joins, and execution plan analysis.
• Vector Databases Explained: How AI Understands Meaning Instead of WordsJan 28, 2026. Uncover vector databases: the secret tech enabling AI to grasp meaning, not just words. Explore how they power chatbots, RAG, and semantic search. A must-know for AI developers!
• Scaling Databases for Read-Heavy Applications: Challenges, Trade-offs, and Practical SolutionsJan 12, 2026. Scale read-heavy apps effectively! Explore challenges, trade-offs, & solutions like caching, read replicas, & sharding. Boost performance & user experience.
• Introduction to Normalization — How to Design Better Databases | SQL ServerNov 25, 2025. Master database normalization! Learn to design efficient, scalable databases by eliminating redundancy and anomalies. Real-world examples and SQL included.
• SQL Server Data Federation (Split Big Tables Across Databases but Query as One)Nov 21, 2025. Scale SQL Server databases by splitting large tables across multiple physical databases while querying them as one. Improve performance, isolation, and flexibility.
• Implementing Change Data Capture (CDC) and Syncing Two Databases (SQL Server + .NET)Nov 17, 2025. Implement real-time data synchronization between SQL Server databases using Change Data Capture (CDC) and .NET. Includes code, architecture, and best practices.
• Integrating Vector Databases (like Pinecone) in ASP.NET Core SearchNov 14, 2025. Implement semantic search in ASP.NET Core using Pinecone, OpenAI embeddings, and SQL Server. Enhance your apps with vector search for superior relevance and speed.
• In-Depth Look at Advanced Authentication and Connection Strings for SQL Server and Databases (Part II)Oct 22, 2025. Master SQL Server connections in C# .NET! This guide dives deep into connection strings, covering essential properties like Data Source, Initial Catalog, User ID, Password, Integrated Security, and Encrypt. Learn best practices for secure authentication, including Windows Authentication, Azure AD Managed Identity, and secure credential storage. Optimize your database connections for performance and security with practical examples and recommendations.
• Vector Databases vs Relational Databases: Understanding, Implementation, and Use CasesSep 11, 2025. Explore the key differences between relational databases (RDBMS) and vector databases (Vector DBs). Learn about their unique features, implementation examples using Python (SQLite, Ollama, ChromaDB), and ideal use cases. Discover how RDBMS excels in structured data and transactions, while Vector DBs empower AI-driven semantic search and recommendations. Understand the importance of numeric vectors and embeddings for Vector DBs and how a hybrid approach can benefit enterprises.
• Oracle: Driving Global Innovation in Databases and CloudAug 20, 2025. Oracle has evolved from being just a database company to becoming a comprehensive cloud and enterprise technology provider. With a strong focus on innovation, security, and performance, Oracle continues to power the digital backbone of many organizations worldwide.
• Advanced ETL from OLTP Databases to a Data Warehouse with C# 14May 12, 2025. Build scalable and efficient ETL pipelines using C# 14 and .NET 9. Leverage Dapper, SQL Server, Azure Synapse, and cloud integration for seamless data extraction, transformation, and loading to data warehouses and lakes.
• Leveraging Databases with .NET 9 in Financial ApplicationsApr 25, 2025. .NET 9 enhances financial app development with improved performance, minimal APIs, and better cloud-native support. Paired with SQL Server, PostgreSQL, or MongoDB, it enables scalable, secure, and data-intensive fintech solutions.
• Database Dictionary (3) --- Loop Databases and Servers by AIJan 07, 2025. This article will discuss to loop databases and servers
• Exploring SQL Databases in Microsoft FabricNov 22, 2024. Microsoft Fabric now integrates SQL databases, bridging transactional and analytical workloads in a unified platform. It enables cloud-native data storage in OneLake, supporting Parquet and Delta formats.
• Exclude Exchange Databases from Auto-Provisioning in New DAG - Exchange 2019Oct 09, 2024. 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 can be useful when expanding storage capacity for archiving without affecting the placement of new primary mailboxes.
• Beyond Search: How Vector Databases Are Reshaping TechnologyApr 11, 2024. Vector databases are transforming how we interact with information by enabling meaning-based rather than keyword-based operations. They convert unstructured data into mathematical representations that capture semantic relationships, allowing organizations to build more intuitive products, understand user intent, and create entirely new capabilities from recommendation systems to anomaly detection. While technical challenges exist in implementation and scaling, the shift from exact matching to semantic understanding represents a fundamental change in how technology processes information - one that adapts to human thinking rather than forcing humans to adapt to machines.
• Repository Pattern with Multiple Databases in C# and .NETMar 01, 2024. Implementing the Repository Pattern with multiple databases in C# and .NET requires strategic abstraction, database-specific implementations, entity mapping, and transaction management. Explore challenges and best practices for efficient data access.
• Creating Persistent Volumes in Docker for Databases Feb 29, 2024. 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 environments with reliable storage solutions.
• Multi-Tenancy with Separate Databases Approach in .NET CoreDec 14, 2023. 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
• MongoDB and ACID Reliable Data Transactions with NoSQL Databases Oct 30, 2023. This article explains what ACID compliance means for database management systems and how MongoDB, a popular NoSQL database, supports ACID transactions.
• NoSQL Databases for ASP.NET Core Web APIsSep 22, 2023. 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, including installation, data integration, and advanced customization options.
• Vector databases for Azure Open AI Embeddings StorageAug 22, 2023. This article will cover Vector Databases for Azure Open AI Embeddings Storage.
• Synchronizing Databases Using Microsoft Sync FrameworkApr 12, 2023. In this article, you will learn how to synchronise Databases Using Microsoft Sync Framework.
• What Are Object-Oriented Databases And Their AdvantagesSep 05, 2019. In this article, you will learn what object-oriented databases are what are their advantages.
• What are the Most Popular Relational Databases (2023)Jul 12, 2019. 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 world.
• Connect MS SQL, MongoDB And MySQL Databases From Same MVC App Using Dependency Injection Mar 25, 2019. 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.
• Most Popular Databases In The World (2023)Jan 05, 2019. Do you wonder which database is the most popular database in the world? This article lists world’s most popular databases and their rankings.
• Working With Databases In MongoDBOct 28, 2018. 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.
• Querying Azure SQL Databases In Databricks Spark ClusterAug 27, 2018. 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.
• Cloud Databases In Azure - Part ThreeOct 24, 2017. 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 TwoOct 16, 2017. 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 OneOct 11, 2017. 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. PaaS side of Microsoft Azure.
• Quick Note On Azure And Azure SQL Databases For Cloud BeginnersMay 30, 2017. This article gives beginners a background on Cloud, Azure and Azure SQL database fitness in terms of cloud
• Sitecore XP1 On Azure - Create Mongo DB Databases For xDB FeaturesMar 22, 2017. This article elaborates on Sitecore XP1 on Azure - create Mongo DB databases for xDB features.
• Learning SQLite Databases In Xamarin For AndroidFeb 19, 2017. In this article. you will learn about using SQLite Databases in Xamarin for Android.
• Create Azure SQL Databases And Connect To The Local SystemJan 09, 2017. In this article you will learn how to create Azure SQL Databases and connect to the local system.
• Mobile Local Databases In Xamarin.Forms Using SQLiteDec 27, 2016. In this article, you will learn about Mobile Local Databases in Xamarin.Forms using SQLite.
• SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part TwoDec 12, 2016. This second part of this article presents you with some more of the important queries that you can use to query SharePoint content databases.
• SharePoint 2013 - Important SQL Queries On SharePoint Content Databases - Part OneDec 08, 2016. This article presents you with some of the important queries that you can use to query SharePoint content databases.
• Merge Two SQLite Databases In Windows Runtime AppsMay 13, 2016. In this article, we will learn how to merge two SQLite databases in Windows Runtime Apps.
• Connecting Databases Using ADO.NET In VB.NETJan 22, 2016. In this article you will learn how to connect databases using ADO.NET in VB.NET.
• List Versioning Settings Values Are Stored in Content Databases in SharePoint 2010Aug 17, 2015. In this article you will learn how to List Versioning Settings Values are Stored in Content Databases in SharePoint 2010.
• Exploring System Databases in SQL ServerJul 21, 2015. This article explains the types of databases, their purpose, what are all the things stored in those databases and so on.
• Seed Databases in EntityFrameworkJun 20, 2015. 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 development and deployment, enhancing efficiency in EF projects.
• How to Dismount and Mount SharePoint 2010 Content Databases For SQL Server MoveMar 05, 2015. This article explains how to move some of the content databases to another SQL server and attach it back to SharePoint using a PowerShell script.
• Working With SQLite Databases and Data Backup in AndroidFeb 24, 2015. This article illustrates the basics of saving data in the SQLite database and a glance of Data backup in Android systems.
• How to Join Two Tables From Different Databases Using Entity FrameworkSep 22, 2014. 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.
• How to Attach Databases in SQL ServerJul 23, 2013. Let’s see how to attach a database or multiple databases in SQL Server.
• Getting the Name of the Server and Databases in SQL ServerMar 18, 2013. In this article, I would like to show how to get the name of the server and databases in SQL Server.
• SharePoint Read Only Databases and me as a DeveloperApr 15, 2011. While working with SharePoint 2010 or SharePoint 2007, there are some scenarios where you want to take your content database of your web application to a read only state.
• How to Upload Images to Databases or How to Store Images to DatabaseFeb 26, 2011. How to upload images to databases or how to store images to database
• How to Display data from External Databases in Share pointAug 16, 2010. Here I am showing you how to display a data from external database in Share point using SharePoint designer.
• Get Autoclose and Autoshrink Values for the Databases in Sql ServerJul 04, 2010. In this article you will learn how to Get autoclose and autoshrink values for the databases in sql server.
• Working with Oracle Databases using ADO.NET Mar 23, 2010.
• Accessing Excel Databases using ADO.NET Mar 23, 2010. In this article I will explain about Accessing Excel Databases using ADO.NET.
• Working with Sybase Databases using ADO.NET Mar 21, 2010. In this article I will explain about working with Sybase Databases using ADO.NET.
• Accessing Text File Databases in ADO.NET Mar 18, 2010. In this article I will explain about Accessing Text File Databases in ADO.NET.
• Distributed Databases in SQL ServerNov 20, 2007. 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.
• Populate SQL Servers and Databases dynamically in C#May 27, 2004. 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.
• Implementing AI Memory Systems in C# Using Vector DatabasesJun 08, 2026. Learn how to implement AI memory systems in C# using vector databases. Discover embeddings, semantic search, memory architectures, and best practices for building intelligent AI applications.
• How to Fix SQL Server Allocation Errors and Recover Corrupted DatabasesApr 23, 2026. Fix SQL Server allocation errors and recover corrupted databases using DBCC CHECKDB or a professional SQL repair tool. Learn to detect and prevent these errors.
• What is AI-Ready Data Modernization? How Azure Accelerate is Changing Enterprise DatabasesApr 23, 2026. Unlock the power of AI! Learn about AI-ready data modernization, Azure Accelerate for Databases, and how to transform your data for AI success. Drive better outcomes!
• What is Normalization vs Denormalization in Databases?Apr 20, 2026. Explore database normalization vs. denormalization! Learn how to optimize data structure, improve performance, and ensure data integrity. Find the right balance!
• How to Store and Query Embeddings Using Vector DatabasesApr 15, 2026. Learn how to use vector databases to store and query embeddings for AI applications. Unlock semantic search and RAG pipelines for intelligent systems.
• What Is Big Data and How Does It Differ From Traditional Databases?Apr 07, 2026. Explore Big Data vs. traditional databases! Understand their key differences in data types, volume, processing, and scalability to make informed tech choices.
• How to Implement Long-Term Memory in AI Agents Using Vector Databases?Mar 18, 2026. Equip AI agents with long-term memory using vector databases! Learn how to store, retrieve, and utilize past data for personalized and intelligent AI responses.
• How to Handle Data Consistency in Distributed Databases?Mar 18, 2026. Master data consistency in distributed databases! Learn about strong vs. eventual consistency, CAP theorem, and strategies for reliable systems. #databases
• How Can Developers Manage Schema Changes Safely in Production Databases?Mar 13, 2026. Learn how to safely manage database schema changes in production! Discover strategies, tools, and best practices for reliable deployments and minimal downtime.
• Is NoSQL Faster Than Relational Databases?Mar 11, 2026. Is NoSQL faster than relational databases? Learn how SQL and NoSQL databases differ in performance, scalability, architecture, and real world workloads.
• What Are the Different Types of NoSQL Databases?Mar 11, 2026. Learn the four main types of NoSQL databases including document, key value, column family, and graph databases. Understand their architecture, use cases, and real world examples.
• ACID vs BASE in DatabasesMar 11, 2026. Learn the difference between ACID and BASE consistency models in databases. Understand how SQL and NoSQL systems handle transactions, consistency, and scalability.
• How to Choose Between Relational and NoSQL DatabasesMar 11, 2026. Explore the key differences between relational (SQL) and NoSQL databases. Learn how to choose the right database for your application's needs, considering scalability, consistency, and data structure. Optimize your application architecture!
• What techniques improve data consistency in distributed databases?Mar 11, 2026. Explore techniques for ensuring data consistency in distributed databases. Learn about replication, transactions, consensus, and conflict resolution strategies.
• How to implement semantic search in applications using vector databases?Mar 09, 2026. Unlock semantic search! Learn how vector databases and AI embeddings revolutionize information retrieval, enabling context-aware results beyond keyword matching.
• How to Create an AI-Powered Search System Using Vector DatabasesMar 06, 2026. Build intelligent search with AI! Learn how vector databases and embeddings enable semantic search, improving relevance and user experience. Scale knowledge retrieval.
• What Is the Difference Between SQL and NoSQL Databases?Feb 18, 2026. Explore the key differences between SQL and NoSQL databases. Understand their structures, scalability, consistency models, and best use cases for modern applications.
• MongoDB Architecture Explained: Databases, Collections, and DocumentsJan 29, 2026. Unlock MongoDB's architecture! Explore databases, collections, & documents for efficient data storage. Master BSON, data flow, & real-world examples. #MongoDB
• SQL Server 2025: Features, Enhancements, and What It Means for Modern DatabasesDec 15, 2025. SQL Server 2025 is the latest evolution of Microsoft’s enterprise database platform, designed to deliver smarter performance, stronger security, and more reliable data management. With advanced query intelligence, improved backup and restore capabilities, enhanced attach and detach database stability, and better transaction log handling, SQL Server 2025 simplifies complex DBA tasks.
• Microsoft Fabric Brings an AI-Powered Unified Data Estate for All DatabasesNov 19, 2025. Microsoft Fabric unifies data with AI, simplifying architecture and accelerating insights. SQL Server 2025, Azure DocumentDB, and HorizonDB enhance AI readiness.
• Data Synchronization Between Cloud and On-Prem SQL DatabasesNov 12, 2025. Synchronize on-prem SQL with cloud databases (Azure SQL, RDS). Explore strategies: SQL Replication, Azure Data Sync, custom APIs. Ensure data consistency!
• 🧩 Integrating SQL Server with Excel and Access Databases: A Complete Step-by-Step GuideNov 08, 2025. Connect SQL Server with Excel & Access for seamless data workflows! Learn to import/export, query directly, and create linked servers. Boost reporting & automation.
• AI Agents in Practice: Working with DatabasesOct 22, 2025. Unlock the power of AI agents with enterprise databases! This article provides a practical blueprint for securely integrating AI agents with production-grade RDBMS like PostgreSQL and SQL Server. Learn how to navigate contracts, governance, and auditability with patterns that ensure compliance and prevent incidents. Discover robust architectures, read/write patterns, and security measures for dependable AI-database collaboration.
• How to Optimize SQL Queries for Faster Execution in Large DatabasesSep 23, 2025. This article reveals practical techniques like indexing, efficient joins, and smart WHERE clauses to dramatically reduce execution time. Learn how to analyze execution plans, leverage partitioning and caching, and optimize subqueries for peak performance.
• SQL: The Language of DatabasesSep 18, 2025. This article provides a comprehensive overview of SQL, the standard language for relational databases. Learn core features, basic commands (CREATE, INSERT, SELECT, UPDATE, DELETE), and why SQL is essential for web development, data analytics, and business intelligence. Master SQL for efficient data management and a valuable skill in today's tech landscape.
• Blockchain vs. Traditional Databases: What’s the Real Difference?Jul 07, 2025. Learn the key differences between blockchain and traditional databases. This developer-focused guide compares performance, trust models, use cases, and more.
• Is PostgreSQL the Future of Databases?Oct 16, 2024. 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 today's evolving landscape.
• 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.
• In-Memory Databases- Unit Testing With C#, EFCore and XUnitSep 18, 2024. 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 installing necessary NuGet packages, configuring DbContext, writing tests, and initializing test data.
• Exploring PostgreSQL: The Powerhouse of Open-Source DatabasesJun 07, 2024. 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, extensibility, and support for JSON and geospatial data, PostgreSQL ensures high performance, scalability, and data integrity.
• 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).
• 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.