Related resources for Data Modeling
  • Unique Key in SQL: Syntax, Usages, and Example5/16/2024 9:30:31 AM. Unique Key in SQL ensures each record in a database table is distinct. Syntax involves defining columns with UNIQUE constraints. It prevents duplicate values, enhancing data integrity and search effic
  • Entity Framework: Code First Migrations With the Existing Database5/9/2024 11:52:10 AM. Explore Entity Framework's Code First Migrations to seamlessly integrate existing databases with your application. Learn efficient techniques for data modeling, schema synchronization, and version
  • Multi-Tenant Migrations With Entity Framework 6.0 (Code First Model)5/1/2024 11:04:59 AM. Master multi-tenant migrations in Entity Framework 6.0 with ease. Learn seamless data management strategies for code-first models, ensuring robust and efficient database migrations in a multi-tenant e
  • How To Learn Power BI And How Long It Takes To Learn Power BI4/30/2024 9:19:06 AM. Power BI, a powerful business intelligence tool by Microsoft, transforms raw data into actionable insights through reports and dashboards. Learn essential skills like data visualization, modeling, and
  • 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
  • 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
  • What is Record Keyword/Function in C#?4/3/2024 10:37:44 AM. Records introduced in C# 9.0 represent a significant enhancement to the language's capability for handling data. This article aims to explore records in-depth, covering their syntax, features, and
  • 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.
  • Class vs. Record vs. Struct in C#3/26/2024 4:15:44 AM. Understanding the distinctions among classes, records, and structs is vital in C# development. Classes encapsulate data and behavior, records offer immutable data modeling, while structs are lightweig
  • Creating Global Option Sets & Using Them Effectively in CRM3/18/2024 6:57:37 AM. To create a Global Option Set in Dynamics 365, define a set of standardized values applicable across multiple entities. Then, reference this set when creating option set fields, ensuring consistent da
  • Getting Started With Amazon Redshift3/15/2024 6:15:26 AM. Amazon Redshift is a powerful data warehousing service designed for analyzing large datasets. Leveraging columnar storage and parallel processing, it offers fast query performance. Redshift integrates
  • Create Virtual Entity in D365 CRM3/14/2024 9:55:58 AM. Creating virtual entities in D365 CRM allows the integration of external data sources seamlessly into your CRM environment. It streamlines data access, enhancing insights and decision-making without e
  • 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 Two3/11/2024 9:23:26 AM. Explore advanced GraphQL integration in .NET Core Web API using Entity Framework Core. Learn efficient data modeling, schema design, and resolver implementation for seamless API development.
  • Practical Introduction To Entity Framework: Day 33/6/2024 10:32:09 AM. Day 3 of this practical Entity Framework introduction delves into database transactions, query optimization, and advanced EF features. Learn to manage relationships, optimize data models, and fine-tun
  • Building Reports With Power BI Designer Using Excel Data3/5/2024 10:30:51 AM. Transform Excel data into insightful reports with Power BI Designer. Utilize its intuitive interface and powerful features for data modeling, visualization, and dashboard creation, enabling interactiv
  • 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.
  • Data Vault Design in Azure SQL - Read PII with Customer Keys2/5/2024 11:00:54 AM. Data Vault design in Azure SQL - Utilizing Customer keys to read PII information in databases. Ensuring data security in the cloud era is crucial, especially with the rise in data attacks. Protecting
  • What is SQL Server Management Studio (SSMS)11/7/2023 4:14:32 AM. SQL Server Management Studio (SSMS) is a tool used to manage and develop Microsoft SQL Server databases. It provides a graphical interface for connecting to servers, creating and modifying database ob
  • Using Records In C# 9.010/20/2023 7:26:18 AM. C# 9.0 introduced a significant language feature known as records, which simplifies the creation of classes for immutable data. Records provide a concise and elegant way to define classes for storing
  • A Guide to Avoiding Power BI Data Modeling Mistakes10/3/2023 5:55:15 AM. A Guide to Avoiding Power BI Data Modeling Mistakes.
  • Best Practices for Power BI Data Modeling9/24/2023 5:59:13 PM. In this article, we will learn about best practices for Power BI Data Modeling.
  • Happy 155 Years Of Business Intelligence3/2/2021 3:18:15 PM. Business Intelligence is not just about turning data into information rather organizations need that to impact how their business operates and responds to the changing marketplace.
  • Data Modeling In Power BI10/27/2020 8:45:12 AM. In this article, you will learn about Data Modeling in Power BI.
  • Master-Details App In Angular With Cosmos DB Using Embedded Data Modeling 5/28/2019 1:26:19 PM. In this post, we will see how to create a Master-Details application in Angular using ASP.NET Core and Cosmos DB. Instead of using multiple tables like in the traditional RDMS approach, we will use a
  • MongoDB With C#9/25/2014 11:31:56 PM. This article describes the basics of working with MongoDB using C#.