database Resources

Share

Related resources for database

Entity Framework Code First Example4/24/2024 1:24:22 PM. Explore an Entity Framework Code First example to understand database modeling in C#. This tutorial demonstrates object-relational mapping (ORM) techniques, using .NET Framework to create entity class
Data Annotations and Code First Migration in Entity Framework4/24/2024 1:18:51 PM. Explore the seamless integration of Data Annotations and Code First Migration within the Entity Framework. Learn how to leverage annotations to define data models and relationships, and master the art
Mapping TVFs Using Entity Framework Database First4/24/2024 7:43:49 AM. Map table-valued functions (TVFs) in Entity Framework Database First by importing them as function imports. Utilize EDM Designer to create complex types for TVF results, enhancing data retrieval and m
What Is There In SQL Server Integrated Services (SSIS) Toolbox?4/24/2024 5:55:45 AM. This comprehensive overview of SQL Server Integration Services (SSIS) delves into its toolbox, encompassing Control Flow, Data Flow, Variables and Parameters, Event Handlers, Package Explorer, and Con
What is SQL Server Integration Services?4/24/2024 5:21:49 AM. SQL Server Integration Services (SSIS) is a robust data integration platform within Microsoft SQL Server, enabling seamless data extraction, transformation, loading, and management tasks efficiently.
How To Convert List <DataTable> Into DataSet4/23/2024 11:15:59 AM. Retrieve employee details from database using stored procedure. Group data by department with LINQ. Export List<DataTable> to Excel with multiple spreadsheets. Bind List<DataTable> to Gri
Customized Auditing In SQL For DDL Operations At Server Level4/23/2024 11:14:16 AM. Explore the intricacies of customized auditing in SQL for DDL operations at the server level. Enhance database security and compliance by implementing tailored logging and monitoring mechanisms.
.NET Remoting: The Interface Approach4/23/2024 9:01:14 AM. .NET Remoting offers efficient remote object interaction, ideal for network resource access. Compared to SOAP-based web services, it's lighter. While easier than Java's RMI, it's more comp
Preview of Dynamic Data and Entity Data For EF 64/23/2024 7:23:32 AM. The preview of Dynamic Data and Entity Data for EF 6 introduces efficient database connectivity and modeling within the .NET Framework. It enables seamless integration of data with code through Entity
Logging Database Operations in Entity Framework4/22/2024 8:53:24 AM. Discover Entity Framework 6's new feature: logging database operations. Easily debug and troubleshoot performance issues by logging SQL commands, parameters, timestamps, and more. Customize loggin
Understanding VARCHAR and NVARCHAR in SQL Server4/22/2024 4:00:34 AM. VARCHAR and NVARCHAR are essential data types in SQL Server for storing character data. Understanding the differences between these data types is crucial for designing efficient database schemas and o
Understanding the Layers of Database Management Systems4/21/2024 2:29:09 PM. Unlocking the Power of Three-Tier Architecture: A Comprehensive Guide to Understanding and Implementing Database Management Systems. Dive deep into the layers of presentation, application, and data ma
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
Zero To Hero In MS SQL Server - Part Five4/19/2024 10:32:41 AM. Embark on a journey from novice to expert in MS SQL Server with Part Five of our comprehensive series. Explore advanced topics including query optimization, stored procedures, indexing strategies, and
Zero To Hero In MS SQL Server - Part Four4/19/2024 10:31:37 AM. In this article, Part Four of 'Zero To Hero In MS SQL Server' delves into advanced topics like query optimization, stored procedures, and indexing strategies. Master database management, T-SQL
Zero To Hero In MS SQL Server - Part Two4/19/2024 10:30:33 AM. Advance your MS SQL Server skills from Part One to mastery with Part Two. Dive into advanced T-SQL, stored procedures, triggers, and performance tuning techniques for efficient database management and
SQL Stored Procedures: Benefits, Implementation & Best Practices4/19/2024 9:52:48 AM. Stored procedures are a powerful feature of SQL databases that allow developers to encapsulate SQL logic and execute it as a single unit. In this article, we'll delve into the concept of stored pr
Understanding OLTP and OLAP for Effective Data Management4/19/2024 6:03:17 AM. This article explores OLTP and OLAP, two crucial systems for data management. OLTP handles real-time transactions, while OLAP analyzes historical data to uncover valuable insights. Learn how they work
Select Query With Logical Operator in a Mongo Database Using C# Driver4/18/2024 1:28:05 PM. Learn how to perform select queries in MongoDB using C# driver. Explore JSON-style object representation, conditional operators, insertion, and retrieval of data. Connect to MongoDB, serialize and des
Select Stored Proc With Raw SQL Query Via EDF Framework4/18/2024 10:43:47 AM. Utilize Entity Data Framework (EDF) for selecting stored procedures with raw SQL queries. Enhance data access in your application by leveraging the power of SQL alongside EDF's object-relational m
Using Table Valued Function for Data Selection - EDF Framework 5.04/18/2024 10:27:02 AM. Learn efficient data retrieval techniques using Table Valued Functions (TVF) through Data Entity Model in EDF Framework 5.0. Enhance database operations by leveraging TVFs within Entity Framework, sim
Reducing Complexity Using Entity Framework Core Owned Types4/18/2024 8:45:52 AM. Simplify data modeling in Entity Framework Core with Owned Types. Streamline database schema and relationships, reducing complexity in code-first approaches. Enhance maintainability and readability wi
A Comprehensive Guide to Entity Framework Core in .NET 84/16/2024 10:54:12 AM. Explore the comprehensive guide to Entity Framework Core in .NET 8, enriched with the latest features of C# 10. Authored by Ziggy Rafiq, this detailed overview covers everything from basic concepts to
Generate Dynamic Models in C# .NET 8 MVC from Database4/16/2024 10:20:45 AM. Creating a C# .NET 8 MVC Application To Generate Dynamic Models From A Database Table. This article demonstrates how to dynamically generate models in C# .NET MVC based on database table schemas, stre
Create a Single Page App with Blazor Server and Entity Framework Core 3.0 4/16/2024 5:34:48 AM. Create dynamic web applications efficiently using Blazor Server, a .NET Core framework, coupled with Entity Framework Core 3.0 for seamless data integration. Leverage C# to build interactive, single-p
Installing EF Core with Empty Template in ASP.NET MVC Core 3.04/15/2024 11:49:21 AM. Discover how to seamlessly integrate Entity Framework Core into your ASP.NET MVC Core 3.0 application using an empty template. Follow a step-by-step installation guide to set up the data access layer
How to Insert Console Application with Entity Framework 4/15/2024 11:41:37 AM. Learn how to seamlessly integrate a console application with Entity Framework for efficient database operations. Explore how to perform CRUD (Create, Read, Update, Delete) operations within your .NET
Create, Copy, Rename And Delete SQL Database In Azure4/13/2024 6:14:54 PM. Learn to manage SQL databases in Azure: create, copy, rename, and delete. Follow step-by-step instructions using Azure portal and SQL Server Management Studio. Efficiently handle database tasks for ef
CRUD Operation with Dapper Using ASP.NET Core4/13/2024 5:08:16 PM. Using Dapper for CRUD operations in ASP.NET Core is straightforward and efficient. Dapper is a micro ORM that provides simple methods to execute SQL queries and map results to objects. Here's a ba
What is Alibaba Cloud Lindrom (ACL) ?4/12/2024 5:52:19 AM. In this article, we will learn Alibaba Cloud Lindorm is a cloud-native multi-model hyper-converged database service developed and optimized for IoT, the Internet, and the Internet of Vehicles (IoV).
Create A Database Project From Existing SQL Database 4/11/2024 7:03:00 AM. 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. W
Enhance SQL Server Queries with OPTION(RECOMPILE) Hint4/11/2024 6:56:49 AM. This article provides an in-depth exploration of the OPTION(RECOMPILE) hint in SQL Server, offering developers and database administrators a thorough understanding of its functionality, practical appl
Insert, Update and Delete Data in HTML54/11/2024 6:18:40 AM. Learn to perform CRUD operations in HTML5 using JavaScript and SQL. Create a form with text boxes and buttons for data manipulation. Use JavaScript to interact with the database, showing, updating, an
How To Unlock HR Schema In Oracle-12C Or How To Fix The ORA - 01033 Error 4/10/2024 10:41:23 AM. In this article, I explain how to unlock the HR schema in Oracle 12c in detail. Sometimes while making the clone of production database into a test server this type of error occurs. So this article is
Core Concept Of ERD (Entity Relationship Diagram)4/9/2024 8:43:47 AM. In this article, we will learn The core concept of Entity Relationship Diagram (ERD) lies in visually representing the relationships between entities in a database system. It illustrates how different
Learn about SQL Table Variable?4/9/2024 4:58:06 AM. Table variables in SQL Server function similarly to temporary tables but with some constraints. They offer local scope and structure definition but lack certain features like non-clustered indexes and
Set Default Value To Dropdown List From Database In ASP.NET MVC4/8/2024 8:21:07 AM. In this article, you will learn how to populate a dropdown list in ASP.NET MVC with default values retrieved from a database. Utilize Entity Framework to fetch data and bind it to the SelectList.
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
Employee Salary Updates Using SQL Update with Inner Join Query4/5/2024 9:16:51 AM. Explore how to update employee salaries while ensuring that each employee has only one salary per job. We'll accomplish this task using the UPDATE statement with INNER JOIN in SQL. Let's dive
How to Use Stored Procedure in PHP4/5/2024 5:42:14 AM. Using stored procedures in PHP involves connecting to a database using MySQLi or PDO, preparing and executing SQL queries that call the stored procedures. Utilize parameterized queries for security an
Power of Filtered Indexes in SQL Server4/5/2024 4:28:34 AM. Discover the power of filtered indexes in SQL Server with our concise guide. Explore practical applications and key benefits, empowering you to harness the full potential of SQL Server for enhanced da
Dynamically Getting Stored Procedures Collection From SQL Server Using C#4/4/2024 9:32:40 AM. In this article, we will learn how to dynamically fetch stored procedures from Microsoft SQL Server using C# for enhanced database interaction. This tutorial explores C#'s capabilities to programm
Generate the Client Side Hash Password Via MD5 Algorithm and Saving it to Database4/4/2024 9:10:42 AM. This article shows how to convert a plain password to a hashed password using the MD5 algorithm on the client side and save it to the database.
Connecting SQLite Database to Mobile App with Flutter and Dart4/4/2024 8:33:05 AM. To integrate an SQLite database into your Flutter mobile app, follow these steps: Add dependencies, create a database helper class for CRUD operations, use it in your app, handle async operations, and
Learn About Power BI Data Source Options And SQL Database Connection - Part One4/4/2024 7:25:57 AM. Explore Power BI's diverse data source options and its seamless connection to SQL databases in this informative series. Learn about querying, data integration, visualization, and more in Part One,
Mirroring Snowflake Database in Fabric Warehouse4/4/2024 2:52:55 AM. In this video, I walk you through how to get started with Snowflake Database, create warehouse, database, tables and records and mirrored the database in Fabric Database for downstream analytics. If y
Advanced Joins In SQL Server 20174/3/2024 10:50:44 AM. Explore the intricacies of SQL Server 2017 with advanced join techniques. Master inner, outer, cross, and self joins to optimize database queries. Elevate your SQL skills with join algorithms and quer
SQL Server: Grant Permission To A Particular Table4/3/2024 10:47:46 AM. In this article, we will learn how to manage database security in SQL Server by granting permissions to specific tables. Safeguard sensitive data and control access with precise authorization settings
Difference Between Union & Union All In SQL Server 20174/3/2024 9:56:30 AM. In this article, you will learn the nuances between UNION and UNION ALL in SQL Server 2017. While both combine results from multiple queries, UNION removes duplicates, whereas UNION ALL retains them.
Temporary Table in SQL Server4/3/2024 9:41:55 AM. In this article, we will learn about temporary tables in SQL Server, a powerful feature for temporary data storage and manipulation. Master T-SQL techniques for creating and managing temporary tables,
Temporary Table vs Temporary Variable in SQL Server4/3/2024 9:41:39 AM. Temporary tables adhere to transaction boundaries, affected by rollbacks, whereas temporary variables remain unaffected, persisting data despite rollbacks. Illustrated through SQL queries, highlightin
Save Encrypted Password In Database In ASP.NET4/3/2024 9:36:57 AM. In this article, Discover how to enhance security in your ASP.NET application by saving encrypted passwords in the database. Learn the process of encrypting passwords before storing them, ensuring dat
Simple Image or File Import Using T-SQL for SQL Server4/3/2024 8:47:23 AM. The article demonstrates importing image files into SQL Server using T-SQL's OPENROWSET, BULK, and SINGLE_BLOB. It covers basic examples and prerequisites, allowing dynamic file paths and names fo
Database Optimization Technique4/3/2024 5:40:07 AM. Database optimization ensures efficient and performant systems. Techniques like indexing, normalization, and query optimization enhance query performance and overall efficiency.
Database First Approach With ASP.NET MVC Step By Step Part 14/1/2024 9:47:43 AM. In this article, I will demonstrate you about Database First Approach in Entity Framework and will also show how to implement it with ASP.NET MVC.
User Defined Objects in JavaScript3/29/2024 4:17:24 AM. JavaScript provides a number of pre-defined objects like Array, String, Image, Date etc. which are very useful in web development.
Contained Database - No Need For Server Level Logins Anymore3/28/2024 10:34:38 AM. Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained database is a database that is completely un-reliant on the instance of SQL
Save Money On Your Azure Monthly SQL Database Bill3/28/2024 10:33:58 AM. Optimize Azure SQL Database costs by leveraging pricing tiers, reserved capacity, and performance tuning. Monitor resource utilization, scale efficiently, and implement cost-effective strategies to sa
What Is Automatic Tuning In Azure SQL Database3/28/2024 6:37:39 AM. Microsoft has long given us DBA tools and suggestions to help tune databases, to fix queries with indexes, and many times they were of questionable merit. We have all seen the dreaded dta_index names
Backup Encryption In SQL Server3/28/2024 6:36:20 AM. SQL Server offers backup encryption to enhance data security. Utilize encryption algorithms and key management to protect database backups, ensuring compliance with privacy regulations and safeguardin
Be Careful With Your SQL Server Max Memory Settings3/28/2024 6:35:24 AM. Quite often, I see database administrators set SQL Server Max Server Memory thinking that only everything related to SQL Server uses this shared memory pool. This is a mistake. There are many things t
New Resumable Online Index Create SQL Server 20193/28/2024 6:32:06 AM. SQL Server 2019 brings a very exciting new feature that is long overdue. Resumable Online Index Create is one of my favorite new things. This, paired with the Resumable Index Rebuilds introduced with
Static Data Masking (SSMS 18.0 Preview)3/28/2024 6:31:38 AM. Static Data Masking in SSMS 18.0 Preview enhances data security by obscuring sensitive information in databases. It safeguards privacy during testing by replacing real data with masked values, ensurin
VLFs - The Forgotten Foe3/28/2024 6:30:53 AM. Unveil the hidden impact of Virtual Log Files (VLFs) in SQL Server. Explore strategies to mitigate performance issues stemming from log file fragmentation and learn essential database maintenance tech
How To Get Started With Always Encrypted For Beginners - Part One3/28/2024 6:27:34 AM. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Se
Seamless Database Integration with C#3/26/2024 5:50:08 AM. Efficiently integrating databases with C# applications is crucial for managing data seamlessly. Explore various approaches like ADO.NET, Entity Framework Core, and Dapper along with best practices for
Business Rules in ServiceNow and Its Automation Potentials3/21/2024 1:45:34 PM. In this article, we will learn automation and efficiency are important in IT service management. ServiceNow provides an effective toolkit for streamlining corporate procedures and increasing output.
Configuring Git in Azure Data Studio for SQL & Synapse Pools3/21/2024 8:30:14 AM. In this article, we'll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio.
TINYINT Data Type in SQL and Its C# Equivalent3/16/2024 10:35:58 AM. Understanding data types is crucial for effective data manipulation and storage. In this article, we will learn about TINYINT in SQL efficient storage for small integers. In C#, use byte or sbyte for
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.
Implementing Common Audit Fields With EF Core’s Shadow Property3/11/2024 9:25:16 AM. Implement audit fields in EF Core using shadow properties for efficient tracking of entity modifications. Utilize Entity Framework's built-in functionality to automatically update created and modi
GraphQL In .NET Web API With Entity Framework Core - Part One3/11/2024 9:22:06 AM. In this article, we will learn about the step-by-step implementation of GraphQL in a Web API using ASP.NET Core, including database setup, scaffolding, configuration, repository creation, and GraphQL
Benefits of Temporary Tables over Table Variables in SQL Server3/10/2024 8:15:37 AM. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handl
Entity Framework Core 5.0 - An Introduction To What's New 3/7/2024 11:26:50 AM. Discover the latest features in Entity Framework Core 5.0, including improved performance, enhanced LINQ capabilities, migration enhancements, and streamlined database schema management.
New Features Of Entity Framework Core 2.03/7/2024 8:53:53 AM. Entity Framework Core is a lightweight and extensible version of Entity Framework. It is based on an ORM (Object-Relational Mapper) which enables us to work with databases using .NET objects. This art
Entity Framework Core Triggers In Action (Unofficial Package)3/7/2024 8:44:28 AM. This article shows you how to work with database triggers in Entity Framework Core using a third-party library and Entity Framework Core Triggers with this unofficial package, enhancing database opera
Remote Access Of The Database Using SQL Server 3/7/2024 8:36:49 AM. Remote access to SQL Server databases enables users to connect to and manage databases from a location outside the physical server. It involves configuring network settings, security measures like aut
How To Secure PII Data In SQL Server Using .NET Assembly3/6/2024 10:46:18 AM. In this article, we will learn PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number, etc. When you are working with financial
Practical Introduction to Entity Framework: Day 63/6/2024 10:40:13 AM. In this article, you will Explore Day 6 of our Practical Introduction to Entity Framework series, diving deeper into database integration. Learn essential concepts, including object-relational mapping
Practical Introduction To Entity Framework: Day 53/6/2024 10:39:36 AM. Day 5 of our practical introduction to Entity Framework delves deeper into database management with advanced concepts like relationships and efficient CRUD operations. Explore Entity Framework Core fo
Practical Introduction To Entity Framework: Day 13/6/2024 10:29:58 AM. In this article, we will discover the fundamentals of Entity Framework in this practical introduction. Learn about ORM concepts, database operations, and CRUD operations through hands-on examples.
Importing Access Database into SQL Server 20123/5/2024 10:40:07 AM. Destructuring simplifies value extraction from objects/arrays. React's event handling enables dynamic responses to user interactions, crucial for interactive UIs. Components manage state/props, fa
How to Enable Remote Connections in SQL Server 20053/5/2024 10:39:30 AM. This article provides guidance on enabling remote connections in SQL Server 2005, addressing the common error message encountered when attempting a remote connection. It outlines the security precauti
SQL Server Effective Database Tune up and Maintenance3/4/2024 11:31:33 AM. This document provides essential tips for effectively maintaining a production database, aimed particularly at developers who may not be professional database administrators. It covers topics such as
Improving SQL Performance Using Covering Indexes3/4/2024 11:29:49 AM. In this article we will try to understand what a covering index is, how to avoid the expensive key lookup operations, and how it can improve our T-SQL performance multi fold times.
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
How to search the data from the associated external content type in SharePoint 20102/29/2024 10:36:46 AM. In this article, we will be seeing how to search the data from the associated external content type. Searching data from associated external content types in SharePoint 2010. Learn to create ECTs, and
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
Build ASP.NET Core API Using Existing Database2/28/2024 10:16:53 AM. I’m sharing a short overview of Asp.NET Core. The journey of .NET Core started with the purpose of Microsoft to build a common .NET base library that provides a common foundation to all its platforms.
How to Read or View Exchange Database EDB File Programmatically2/28/2024 6:03:51 AM. Explore methods to Read or View the Exchange Database EDB File Programmatically. Know how to use this Exchange Server Managed API to View or Read Exchange EDB files.
How to Create CSV File from Excel Spreadsheet 2/27/2024 4:16:16 AM. Explore methods to Create CSV File from Excel Spreadsheet. Get the best solutions to carte or save CSV files from Excel Spreadsheet in easy steps.
Get In Touch With Document DB From Azure Cosmos DB2/22/2024 4:41:24 AM. This article introduces readers to the new features Microsoft unveiled at Build 2017, particularly focusing on Azure Cosmos DB. It explains Cosmos DB as a globally distributed, multi-model database se
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
Blazor - Connect With Oracle Database In Amazon RDS2/21/2024 11:32:58 AM. We will see how to create an Oracle database instance in Amazon RDS (AWS Relational Database Service) and we will connect Oracle database from Blazor application. We will use an Employee details Singl
Trigger Creation: Set Action on Customer Record Create/Update2/21/2024 11:08:31 AM. Learn to automate database actions by creating triggers. Choose the trigger name and action type. Execute actions when customer records are created or updated. Enhance database functionality and effic
Blazor - Create SPA With Azure Database For MariaDB Server2/21/2024 8:27:24 AM. We will create a MariaDB database service in Azure and connect MariaDB in a Single Page Blazor application. Azure Database for MariaDB is a relational database service in the Microsoft cloud. Azure Da
Tips to Launch Your SQL Mission2/20/2024 11:34:01 AM. This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep i
Deploying A Blazor Application On Azure2/19/2024 10:00:19 AM. This comprehensive guide walks through the process of deploying an ASP.NET Core-hosted Blazor application on Azure, covering steps from creating an SQL database server to publishing the application.
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
Working With a BindingNavigator Control in Windows Form2/16/2024 6:49:53 AM. This guide demonstrates implementing a BindingNavigator control in a Windows Forms application, enabling navigation through database records. It outlines steps to create a database, insert records, an

Topics