database Resources

Share

Related resources for database

Events: Love Triangle in Integration Testing11/20/2024 6:30:48 AM. This video will delve into the main problems of not creating integration tests that check whether the application works fine, showing different alternatives with their pros and cons.
SSRS (4) --- SQL Server Database Project in Visual Studio11/11/2024 8:37:33 PM. This article is to discuss: SQL Server Database Project in Visual Studio
Database Dictionary (1) --- Schema11/11/2024 8:15:04 PM. This article will discuss the database schema.
Understanding Distributed and Monolithic SQL Architectures11/5/2024 10:01:52 AM. In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance,
Creating Azure SQL Database with Tables11/4/2024 4:59:13 AM. In this video, I demo how to create Azure SQL database, create and insert records into the table, and query the data.
Implement a RAG Solution Using Azure SQL Database11/1/2024 11:03:43 PM. In this brief video I walk you through the components of retrieval augmented generation (RAG). I talk about embeddings and vectors and even show you how they are created. Finally, I'll show you
Create a Model with Database Table in .NET 8 using EF Core10/28/2024 7:16:12 AM. 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 str
Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
Manage Azure SQL Roles with Azure Data Studio10/26/2024 5:43:14 AM. Azure SQL Database is a managed cloud database service enabling secure, scalable applications. With Azure Data Studio, a free, cross-platform tool, database admins can view and manage user roles and p
Redis: RedisString and RedisJSON10/23/2024 8:19:31 AM. RedisString has long been the basic and most common data type in Redis. Recently, RedisJSON has gained popularity as a module that allows you to store, query, and manipulate JSON data natively.
Getting Started with Databrick Dataset10/19/2024 3:05:37 PM. This article dives into how to use databricks preloaded datasets. Databricks Datasets provide ready-to-use, real-world data built into the Databricks platform, enabling users to easily access, analyze
Databricks: Provision and Analyze Azure SQL Database Table10/16/2024 7:38:47 AM. In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.
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
Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
Write Data from Fabric Dataflow Gen2 to Azure SQL Database10/15/2024 5:16:17 AM. In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.
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
Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)10/8/2024 8:54:22 AM. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
Passing Connection String Dynamically While Using a Model First Approach10/8/2024 3:57:28 AM. We'll discuss the importance of dynamic configuration for database connections, demonstrate effective techniques for setting up runtime connection strings, and highlight best practices for managin
Read Multiple PARQUET Files from GCS to Azure SQL Database using Azure Data Factory10/7/2024 4:56:25 AM. In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.
Real-World Expression Trees: Dynamic Filtering in C# with Minimal API10/6/2024 7:51:48 AM. This article explores the practical use of expression trees in C# by building an ASP.NET Core web API with dynamic filtering functionality. It demonstrates how to construct flexible queries using expr
Generate or find Connection String from Visual Studio10/3/2024 11:44:59 AM. This guide covers various methods, including using the Connection String Builder, accessing app.config and web.config files, and integrating with SQL Server and Entity Framework. Mastering connection
Creating Stored Procedures with Managed Code10/3/2024 11:41:01 AM. This article demonstrates how to create a stored procedure in Microsoft SQL Server 2005 using managed code in C#. It details the process of setting up a SQL Server project in Visual Studio, writing th
How to Use a Cursor in SQL?10/3/2024 11:08:13 AM. A cursor in SQL is a database object that allows row-by-row processing of query results. It enables you to iterate through a result set, perform operations on each row, and manage data more efficientl
Database, Data Warehouse, and Data Lake: A Comparative Analysis10/2/2024 4:49:26 AM. Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
Types of Keys in SQL10/1/2024 6:09:16 AM. In SQL, keys play a crucial role in maintaining data integrity and defining relationships between tables. Common types include the Primary Key, which uniquely identifies records; the Foreign Key, link
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
How to Send Mail Using SQL Server: Part 39/27/2024 10:16:21 AM. In this third installment of our series, "How to Send Mail Using SQL Server," we delve into the configuration and implementation of Database Mail. Learn how to set up SMTP settings, create m
Inserting Form Data Into DataBase Using Stored Procedure In ASP.NET C#9/27/2024 10:10:24 AM. Learn how to insert form data into a database using stored procedures in ASP.NET with C#. This guide covers setting up a form, handling user input, creating a stored procedure, and securely inserting
Getting Started with Azure SQL Database – A Beginners Guide9/27/2024 7:19:23 AM. A quick introduction to Azure SQL Database that showcases some key offerings and highlights the flexibility and scalability that comes with it.
Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse9/26/2024 9:45:47 AM. In this Definitive Guide to Mirror Azure SQL Database in Fabric Warehouse episode, I am going to walk you through how to -- Enabling System Assigned Managed Identity required to publish data to Fabr
Create Dynamic Pivot Table Using Store Procedure9/25/2024 6:58:27 AM. Learn how to create a dynamic pivot table using a stored procedure in SQL. This guide covers transforming rows into columns dynamically, automating pivot table creation, and efficiently querying large
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
Check Disk Space Utilization by Tables in SQL Server Database9/23/2024 8:53:17 AM. In this guide, learn how to effectively check disk space utilization by tables in a SQL Server database. We’ll cover essential SQL queries and techniques to analyze table sizes, identify storage usage
Advanced ADF: Integrate Multiple Category of Files Leveraging FILTER and other Activities9/23/2024 6:37:08 AM. In this episode, I am going to walk you through how to integrate multiple category of files in ADLS Gen2 to Azure SQL Database via Azure Data Factory data pipeline activities focusing on filter and o
Database Backup With Compression in SQL Server9/20/2024 9:18:22 AM. This article explains how to perform database backup compression in SQL Server 2012 using SQL Server Management Studio or a Transact-SQL statement. It provides a step-by-step guide to visually create
How to Keep SQL Server Table Columns in Sync9/19/2024 4:29:35 AM. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
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
Create Backup and Restore Database in SQL Server9/18/2024 9:01:35 AM. This tutorial covers essential techniques for backing up your databases, restoring them when needed, and ensuring data safety. Master these skills to safeguard your SQL Server environment effectively.
Data Virtualization from Azure Blob Storage in Azure SQL Database9/16/2024 5:17:34 AM. This solution enables Azure SQL Database to directly access and read files from Azure Blob Storage using External REST Endpoints, bypassing the need for physical data loading. It leverages database-sc
CRUD Operations Using Knockout in MVC Application- Part 19/12/2024 12:14:23 PM. This article covers implementing CRUD operations in MVC applications using Knockout.js. It details how to set up models, repositories, and controllers, demonstrating how to manage items through add, u
Introduction To Entity Framework Core9/12/2024 5:45:08 AM. Explore the basics of Entity Framework Core in this introduction. Learn how EF Core simplifies data access in .NET Core applications through Object-Relational Mapping (ORM).
CRUD Operation Using Repository Unit Of Work Pattern9/12/2024 5:44:14 AM. Create an ASP.NET MVC project in Visual Studio 2013, add a class library, and set up a SQL Server database. Implement Entity Framework with an EDMX model, then use the Repository pattern for CRUD oper
Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode9/12/2024 5:10:58 AM. This article explains how to configure a Data Gateway for an On-Premise SQL Server Database using Power BI's Recommended Mode. It covers the installation steps, including downloading and setting u
Database Mail Configuration in SQL Server 20089/10/2024 10:16:49 AM. Learn how to configure Database Mail in SQL Server 2008 with this guide. Discover step-by-step instructions for setting up email profiles, configuring SMTP settings, and managing mail settings using S
Using Oracle Connection String In Windows Form9/9/2024 11:32:56 AM. This guide covers setting up the connection string, configuring your .NET application, and managing database interactions through ADO.NET. Ideal for developers working with Oracle and C#.
Entity Framework Core Code-First Approach with Seed Data9/9/2024 7:11:51 AM. It will be beneficial to beginners who are struggling with Entity Framework Core and Creating Code-First Approach. The EF-Core Code-First approach involves creating domain classes first and then gener
Relations between Dataset in DBMS9/6/2024 12:45:34 PM. A relationship in DBMS links two or more data sets. This article explores types of relationships: one-to-one, one-to-many, and many-to-many, and their implementations in databases.
Export Data From Database Table to Excel File in ASP.Net MVC9/5/2024 10:55:56 AM. Exporting data from a database to Excel in ASP.NET MVC involves creating a database, setting up a model, and designing a view. Use SqlConnection and SqlDataAdapter to fetch data and Microsoft.Office.I
Temporary Tables vs Table Variable in SQL Server9/5/2024 7:20:02 AM. In this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. Temporary tables come in two types: Local (prefixed with "#", accessible only to the current con
Database Mail in SQL Server 2008R29/4/2024 8:38:30 AM. Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure e
Configure SQL Server Database Mail for Sending Emails9/4/2024 7:01:19 AM. This guide covers the step-by-step process for setting up Database Mail, including creating and managing mail accounts, profiles, and ensuring your SQL Server can successfully send email notifications
Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
ADF: Provision Snowflake Database Table in Azure SQL DB and Create Power BI Report9/2/2024 7:08:05 AM. In this data engineering and data analysis episode, I covered how to provision single snowflake database table in azure sql database and then use Power BI desktop to connect to the data to create Powe
Learn Database Mail in SQL Server8/29/2024 10:53:40 AM. 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, e
Vector Database Internals: In a Layman's Perspective8/29/2024 5:50:04 AM. 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
Understanding SQL Triggers: A Practical Guide with a New Example8/28/2024 8:38:05 AM. Discover how triggers can automate tasks, enforce business rules, and maintain data integrity in your database. Perfect for both beginners and experienced developers looking to deepen their SQL skills
Implementation Ajax Calls in ASP.NET Core MVC 8/27/2024 7:03:37 AM. Learn how to build a dynamic fleet management system using AJAX in ASP.NET MVC with SQLite as the database provider. This tutorial guides you through creating, managing, and displaying vehicle data in
New in Fabric Warehouse SQL: TRUNCATE8/27/2024 6:07:38 AM. The SQL TRUNCATE command, newly introduced in Fabric Warehouse, offers an efficient way to delete all rows from a table without logging individual row deletions.
Learn about Different Type of Triggers in Oracle8/23/2024 8:02:40 AM. In this article, you will learn about different type of triggers in Oracle.
Store Java Errors in Database with Dynamic Error-Based Logging8/23/2024 4:49:27 AM. 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 diagnosti
Real-Time Pageview Tracking With .NET Core8/21/2024 5:28:26 AM. Learn how to implement real-time pageview tracking in your .NET Core application. This guide covers setting up live monitoring of website traffic, capturing pageview metrics, and integrating real-time
Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements8/21/2024 4:49:45 AM. In this new episode, I demonstrated how to Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements.
Why You Should Learn Azure Cosmos DB?8/20/2024 12:26:01 PM. Discover why learning Azure Cosmos DB is essential for modern data management. With its global distribution, scalability, and multi-model capabilities, Cosmos DB offers unmatched performance and high
Learn to Shrink a Microsoft SQL Server Database Programatically 8/20/2024 4:59:45 AM. 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
How to Retrieve and Display Database Records in Java Using JTable8/13/2024 5:22:08 AM. 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 SQ
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.
Difference Between Primary Key and Unique Key in SQL8/12/2024 9:38:24 AM. Primary Key and Unique Key are essential in relational databases for data integrity. A Primary Key uniquely identifies each row and cannot be NULL, while a Unique Key ensures column values are unique
Entity Framework (2), With .Net MVC, Database-First8/10/2024 2:06:31 PM. This article will be Entity Framework with .Net MVC, Database-First approach,
Entity Framework (5), With .Net Core MVC, Database-First8/10/2024 2:05:43 PM. This article will describe Entity Framework with .Net Core MVC, Database-First approach,
Entity Framework (7), With .NET WPF, Database-First8/10/2024 2:05:14 PM. This article describe to develop a WPF app with entity framework, database first approach.
Entity Framework (10), With .Net WebForms, Database-First8/10/2024 2:04:27 PM. This article will to discuss Entity Framework With .Net WebForms, Database-First approach.
How Do We Create Custom APIs with Next.js?8/8/2024 5:25:24 AM. Next.js allows you to create custom APIs with API routes defined in the pages/api directory. You can handle various HTTP methods (GET, POST, PUT, DELETE), use query parameters, connect to databases (e
Azure Data Factory: Clean and Transform Multiple Data using Dataflow8/8/2024 4:14:34 AM. In this Data Engineering episode, I covered how to use Azure Data Factory Dataflow to read, appends multiple CSV files from ADLS Gen2, clean and transform the data and sink to the Azure SQL Database f
VIEW in SQL with example8/6/2024 4:57:26 AM. SQL Views act as virtual tables based on predefined queries, streamlining data access and management. They eliminate the need to rewrite complex joins or aggregations in your applications. Views enhan
Implement CI/CD for SQL Server with Visual Studio and Azure DevOps8/2/2024 8:44:29 AM. Implementing Continuous Integration and Continuous Deployment (CI/CD) for SQL Server databases ensures that database changes are automatically built, tested, and deployed to various environments.
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
Basics of Working With Windows Azure Table Storage8/2/2024 5:08:21 AM. Learn how to efficiently store and manage large datasets in the cloud, explore key features, and get practical tips for data organization, querying, and performance optimization in Azure Table Storage
Understanding ROW_NUMBER() in SQL Window Functions8/2/2024 4:46:39 AM. ROW_NUMBER() is a window function in SQL that assigns a unique number to each row within a partition of a result set. It’s useful for ranking, removing duplicates, pagination, and selecting the top N
Count(*) vs Count(1) in SQL8/1/2024 4:11:33 AM. When counting rows in SQL databases, both `COUNT(*)` and `COUNT(1)` are used, but there is no performance difference between them. Modern databases optimize both functions similarly. Prioritize code r
ASP.NET Core Web API With Oracle Database And Dapper7/31/2024 4:04:02 AM. This guide explores the creation of a Web API using ASP.NET Core, integrating with an Oracle Database through the Dapper ORM. Learn how to set up a robust backend service, implement CRUD operations, a
EF Core Query Tags: What They Are and How to Use Them7/29/2024 11:25:31 AM. Discover the power of EF Core Query Tags in optimizing and debugging your database queries. This guide explains what query tags are, their benefits, and how to implement them in your Entity Framework
Training a Small Language Model AI Using Text Files, C#, and SQL Database7/29/2024 10:57:22 AM. This article guides you through training a small language model AI using text files, C#, and an SQL database. It covers preparing text data, setting up an SQL database, tokenizing data with C#, and q
@@ROWCOUNT in SQL Server7/29/2024 9:28:40 AM. @@ROWCOUNT is a SQL Server function used to retrieve the number of rows affected by the last executed statement. It provides valuable insights for data manipulation and validation processes, helping t
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
BigQuery to Azure SQL Database using Azure Synapse Analytics7/26/2024 5:29:48 AM. In this video, I covered how to use Azure Synapse Analytics to integrate data from Google Big Query to Azure SQL Database.
Database First Approach in .NET Core7/25/2024 7:54:49 AM. Discover the Database First Approach in .NET Core with our comprehensive guide. Learn how to efficiently integrate databases into your application using Entity Framework Core, design robust data model
Connection with SQL and queries.7/24/2024 8:08:46 AM. Explore the essentials of connecting to SQL databases and executing efficient queries. Learn about various SQL commands, database management techniques, query optimization strategies, and best practic
Transactions in ADO.NET: Ensuring Data Integrity7/23/2024 8:18:17 AM. In database management, transactions are essential to ensure data integrity and consistency. A transaction is a sequence of operations performed as a single logical unit of work
LINQ to ADO.NET: Enhancing Data Access with Modern Querying7/23/2024 3:46:30 AM. In the evolving world of .NET, querying databases has traditionally been done using ADO.NET, which provides a robust set of classes for data access. However, the introduction of Language Integrated Qu
Using DataAdapters and DataSets in .NET7/22/2024 10:06:58 AM. In .NET, working with databases often involves handling disconnected data scenarios where data is fetched, manipulated, and then updated back to the database. Two essential components for managing suc
Executing Commands with ADO.NET7/22/2024 10:02:34 AM. Explore how to use ADO.NET’s SqlCommand class for executing SQL queries and stored procedures in .NET applications. This guide covers setting up SqlConnection, using methods like ExecuteNonQuery, Exec
Connecting to a MySQL Database Over LAN Using SQL Workbench7/22/2024 8:18:50 AM. 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
Getting Started with ADO.NET7/22/2024 8:14:00 AM. ADO.NET (ActiveX Data Objects . NET) is a set of classes in the .NET Framework that provides access to data sources such as SQL Server, Oracle, and other databases. It is a part of the larger .NET eco
Detailed Explanation of Procedure and Function in SQL Server7/22/2024 6:22:57 AM. Stored procedures are precompiled sets of one or more SQL statements that can be executed together. Functions in SQL Server are essential database objects that contain a series of SQL statements and p
ASP.NET C# Display Bootstrap Bar Chart from Database Values7/22/2024 5:58:27 AM. 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 J
Understanding the SQL Query Execution Order7/22/2024 4:41:19 AM. SQL (Structured Query Language) is essential for interacting with relational databases, and mastering its intricacies can significantly enhance your data querying skills. One of the fundamental aspect
After Business Rules in ServiceNow: Scenarios and Best Practices7/22/2024 3:49:40 AM. After Business Rules in ServiceNow execute after a database operation, enabling actions that depend on the successful completion of the initial operation. Common scenarios include audit logging, trigg
Practical approach to EF Core with Scalar functions7/21/2024 6:32:25 PM. Learn how to implement and migrate scalar SQL functions in an ASP.NET Core application using Entity Framework Core. This guide covers creating a scalar function to calculate total unit prices, integra
Dynamically Creating a Table in SQL Server from Information Schema7/19/2024 11:01:55 AM. This SQL script dynamically creates a table in SQL Server by utilizing INFORMATION_SCHEMA and system views. It constructs the table definition, including columns, data types, constraints, and default
SharePoint 2010 Internals - Timer Jobs7/18/2024 3:18:51 PM. SharePoint Timer Jobs are essential for running background tasks in a SharePoint Farm. They operate as a Windows service (OWSTimer.exe) and can be customized for specific needs. Understanding their lo

Topics