TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
About database
Share
facebook
twitter
linkedIn
Reddit
Topics
No topic found
Content Filter
Articles
Videos
Blogs
News
Complexity Level
Beginner
Intermediate
Advanced
Refine by Author
[Clear]
Monica Rathbun (9)
Nimit Joshi (4)
Rohini Parade (4)
Sundaram Subramanian (4)
Rinki (3)
Sarathlal Saseendran (3)
Sai Sherlekar (3)
Abiola David (2)
Abhimanyu K Vatsa (2)
Vijay Prativadi (2)
Farhan Ahmed (2)
Chittaranjan Swain (2)
Ajay Kumar (2)
Fiyaz Hasan (2)
Mithilesh Tata (2)
Anoop Kumar Sharma (1)
Alok Pandey (1)
Munesh Sharma (1)
Prashant Shinde (1)
Azeem Anzari (1)
Rajendra Prasad (1)
Vikas Gupta (1)
Shripad Kulkarni (1)
Naveen Kumar (1)
Jitendra Mesavaniya (1)
Divyansh Gupta (1)
Shirsendu Nandi (1)
Mohammad Elsheimy (1)
Ziggy Rafiq (1)
Nirmal Dayal (1)
Salman Beg (1)
Subham Ray (1)
Mahak Gupta (1)
Sanghdeep Sanghratne (1)
Rushi Mehta (1)
Jaimin Shethiya (1)
Manoj Kalla (1)
Abhishek Mishra (1)
Dhavalkumar Patel (1)
Sharad Gupta (1)
Lajapathy Arun (1)
Rahul Bansal (1)
Jithu Thomas (1)
Satya Karki (1)
Shashangka Shekhar (1)
Deepak Middha (1)
Venkatesan Jayakantham (1)
Nilesh Jadav (1)
Pankaj Patel (1)
Gajendra Jangid (1)
Mukesh Kumar (1)
Ashish Bhatnagar (1)
Mohamed Azarudeen Z (1)
Praveen Sreeram (1)
Ishika Tiwari (1)
Akshay Patel (1)
Debasis Saha (1)
Jignesh Trivedi (1)
Humza Tufail (1)
Nitesh Jha (1)
Rohatash Kumar (1)
Raj Kumar (1)
Nipun Tomar (1)
Samir Behara (1)
Vijai Anand Ramalingam (1)
Gurpreet Arora (1)
Avnish Kumar (1)
Guest User (1)
Virendra Gour (1)
Related resources for database
No resource found
Getting Started Wth MongoDb Atlas
4/26/2024 12:00:41 PM.
Learn how to get started with MongoDB Atlas, a cloud-based database service that offers a scalable and flexible solution for managing NoSQL databases. Explore data modeling, cluster configuration, and
Searching Records by DropDownList in ASP.NET
4/26/2024 9:54:25 AM.
This tutorial guides the creation of a web app to search records via DropDownList. It includes SQL commands to create a database, insert records, and configuring data sources. The process involves set
What Is There In SQL Server Integrated Services (SSIS) Toolbox?
4/26/2024 5:31:29 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
Database First Approach in MVC 5: Part 2
4/25/2024 10:41:59 AM.
In MVC 5's Database First Approach (Part 2), delve deeper into leveraging Entity Framework for seamless integration with existing databases. Explore scaffolded views, data validation, and CRUD ope
Database First Approach in MVC 5: Part 1
4/25/2024 10:10:15 AM.
This article shows the development of an ASP.NET Web application in an MVC 5 project template that connects with a database that exists already and allows the users to interact with the data.
Database First Approach in MVC 5: Part 3
4/25/2024 8:02:50 AM.
Learn advanced techniques in database design, Entity Framework Designer, and building robust Data Access Layers within the Model-View-Controller architecture.
Ingest Data into Azure SQL Database using SSMS
4/25/2024 6:43:37 AM.
This video shows how to ingest data into Azure SQL Database using SQL Server Management Studio.
Table Splitting in Entity Framework
4/25/2024 5:56:24 AM.
Entity Splitting in Entity Framework involves mapping an entity across multiple database tables, aiding in organizing data and optimizing performance. Table Splitting divides a single table into two,
Entity Framework Code First Example
4/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 Framework
4/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 First
4/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 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 DataSet
4/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 Level
4/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 Approach
4/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 6
4/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 Framework
4/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 Server
4/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 Systems
4/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 One
4/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 Five
4/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 Four
4/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 Two
4/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 Practices
4/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 Management
4/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# Driver
4/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 Framework
4/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.0
4/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 Types
4/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 8
4/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 Database
4/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.0
4/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 Azure
4/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 Core
4/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) Hint
4/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 HTML5
4/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 MVC
4/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 Core
4/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 Query
4/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 PHP
4/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 Server
4/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 Database
4/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 Dart
4/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 One
4/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 Warehouse
4/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 2017
4/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 Table
4/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 2017
4/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 Server
4/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 Server
4/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.NET
4/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 Server
4/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 Technique
4/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 1
4/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 JavaScript
3/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 Anymore
3/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 Bill
3/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 Database
3/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 Server
3/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 Settings
3/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 2019
3/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 Foe
3/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 One
3/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 Potentials
3/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 Pools
3/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# Equivalent
3/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 Cluster
3/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 Property
3/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 One
3/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 Server
3/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.0
3/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 Assembly
3/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 6
3/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 5
3/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 1
3/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 2012
3/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 2005
3/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 Maintenance
3/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 Indexes
3/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 .NET
3/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 2010
2/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 Database
2/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 Programmatically
2/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 DB
2/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 Operation
2/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