Resources   No resource found

• SQL Join Optimization: Improve Query Performance on Large TablesJun 03, 2026. Learn SQL Join Optimization techniques to improve query performance on large tables using indexes, execution plans, filtering, and SQL Server best practices.
• Why Are Iceberg Tables Becoming the Default for Data Lakehouses Over Delta Lake?Mar 30, 2026. Discover why Apache Iceberg is overtaking Delta Lake as the preferred table format for data lakehouses. Explore its multi-engine support, scalability, and vendor neutrality.
• High-Performance Bulk CRUD Operations in ASP.NET Core with Oracle Mar 26, 2026. Boost ASP.NET Core performance with Oracle! Learn bulk CRUD using Global Temporary Tables, stored procedures, and Dapper for efficient handling of 100K+ records.
• How to Improve PostgreSQL Performance Using Table Partitioning in CQRS SystemsMar 23, 2026. Improve PostgreSQL performance by partitioning large tables! This guide covers range partitioning with pg_partman, addressing common pitfalls and maintenance.
• Intelligent Tiering for Amazon S3 TablesMar 20, 2026. Optimize Amazon S3 costs for Apache Iceberg tables with intelligent tiering. Learn how to analyze access patterns, implement lifecycle policies, and reduce storage expenses without sacrificing performance.
• How to Optimize PostgreSQL Queries for Large Datasets?Mar 16, 2026. Optimize PostgreSQL queries for large datasets! Learn indexing, EXPLAIN analysis, partitioning, caching, and more to boost speed and efficiency. #PostgreSQL
• Ingesting Tables from Fabric Lakehouse to Fabric Warehouse using Copy JobMar 04, 2026. In this article, you'll learn how to efficiently transfer curated tables from a Fabric Lakehouse to a Fabric Warehouse using Copy Jobs. Optimize your data architecture for high-performance SQL queries and reporting.
• How Variables Work in Power Apps - Set vs UpdateContext vs Collections Feb 27, 2026. Master Power Apps variables! Learn when to use Set(), UpdateContext(), and ClearCollect() for efficient data management, global states, and screen-specific logic. Build cleaner, more professional apps. Variables are essential for managing data and state in Power Apps, but understanding the difference between Set, UpdateContext, and Collections can be confusing for beginners. This article clearly explains when and why to use each type of variable. Learn the scope, behavior, and real-world usage scenarios with simple examples. A beginner-friendly guide to help you write cleaner and more efficient Power Fx formulas.
• How to Use the Index Function in Power AppsFeb 27, 2026. Master the Power Apps Index function! Learn how to retrieve specific items from collections and tables by position, enhancing app interactivity and efficiency. Dynamic data selection made easy!
• Creating a Table Manually in Power BIFeb 25, 2026. Learn how to create tables manually in Power BI using 'Enter Data', DAX, and visuals. Perfect for reference data, parameters, and testing. Boost your Power BI skills!
• Why Does MySQL Lock Tables During Heavy Traffic?Feb 13, 2026. Unlock MySQL performance! Discover why table locking occurs during heavy traffic, impacting speed. Learn to optimize InnoDB, indexing, and transactions for scalability.
• Connecting Lakehouses to Fabric Notebooks and Reading Delta TablesFeb 10, 2026. In this article, you will discover how to seamlessly connect Lakehouses to Fabric Notebooks for effortless data access and transformation. Simplify data workflows and boost productivity!
• How to Upload an Image to the Dataverse Table Using Web API in Power PagesFeb 10, 2026. Learn how to upload images to Dataverse tables from Power Pages using Web API! This tutorial covers configuration, UI design, and JavaScript code for image uploads.
• Using Enter Data in Power BI: The Most Underrated Feature You’re Probably IgnoringJan 24, 2026. I n this article, I demonstrated how to use Power BI's hidden gem: Enter Data! Quickly create lookup tables, mock data, and KPIs directly within Power BI, bypassing Excel and external sources. Perfect for prototyping and small datasets.
• Auto‑Sync Azure AD Users to a Dataverse Table Using a Scheduled Power Automate FlowJan 22, 2026. Automate Azure AD user synchronization to Dataverse! This guide provides a Power Automate flow to read users from Microsoft Graph and upsert them into a Dataverse table. Streamline user management and ensure data consistency.
• UNDROP in Azure Databricks: Recover Dropped Tables Like a ProJan 20, 2026. In this article, I covered how to use the UNDROP command in Azure Databricks with Unity Catalog to recover accidentally dropped tables and materialized views. A data engineer's lifesaver! Discover syntax, permissions, and limitations for effective data recovery.
• Building Smarter Galleries in PowerApps with Table & Record FunctionsJan 06, 2026. Learn to build dynamic PowerApps galleries using Table & Record functions! Master AddColumns, DropColumns, RenameColumns, and ShowColumns for optimized data display.
• How to Restrict Dataverse Table Records to Logged-in Users in Power PagesJan 01, 2026. Learn how to restrict Dataverse table records to logged-in users, ensuring they only see their data. Implement contact-based access control for improved security.
• Import Large Data Sets into Dataverse table Using DataflowsDec 21, 2025. Learn how to efficiently import large datasets into Dataverse using dataflows. This guide provides step-by-step instructions, including filtering and connection tips. Track import history and verify data in your tables.
• n8n Native Data Tables - Built-in Structured Data Storage for Smarter AutomationsDec 17, 2025. Unlock smarter automations with n8n Native Data Tables, a built-in data storage feature that allows you to persist structured data directly within your workflows. By eliminating the need for external databases, spreadsheets, or third-party tools, n8n simplifies data management while keeping automations fast and reliable. In this article, you’ll learn how n8n Native Data Tables work, explore real-world use cases, understand their benefits and limitations, and see practical automation examples you can apply immediately.
• Entity Framework Core – Code First ApproachDec 14, 2025. This article provides a complete and descriptive explanation of the Entity Framework Core Code First approach. It explains how databases are created and managed using C# classes, how DbContext and entities work together, how migrations handle schema changes, and how relationships, configuration, and change tracking are managed in Code First development. Written in simple language, this guide is ideal for beginners and professional .NET developers building modern, scalable applications using Entity Framework Core and SQL Server.
• How to Reduce Lock Contention in SQL Server Financial Ledger TablesDec 02, 2025. Reduce SQL Server lock contention in financial ledger tables! Implement practical techniques like RCSI, insert-only patterns, and optimized indexing for high-concurrency.
• Memory-Optimized Table Variables vs Temp Tables in SQL ServerDec 01, 2025. Unlock peak SQL Server performance! This guide compares memory-optimized table variables and temp tables, offering benchmarks and best practices for optimal use.
• Partition-wise Parallelism Optimization for Very Large TablesNov 27, 2025. Unlock peak SQL Server performance! Learn partition-wise parallelism for massive tables: design, tuning, and real-world examples for faster queries and ETL.
• Improving Slow Scalar Functions Using Inline Table-Valued FunctionsNov 27, 2025. Boost SQL Server performance by replacing slow scalar UDFs with inline table-valued functions (iTVFs). Eliminate row-by-row processing and enable set-based optimization.
• SQL Server Basics: Tables, Primary Keys, Foreign Keys — Explained SimplyNov 24, 2025. Master SQL Server basics! Learn about tables, primary keys, foreign keys, and normalization with clear examples. Build robust, reliable databases. Improve data integrity.
• Creating a SQL Rule Engine Table (Validation Conditions Executed Dynamically)Nov 20, 2025. Build a dynamic SQL rule engine for validation. Define rules as data, not code, enabling rapid changes without deployments. Ideal for ERP, CRM, and more!
• 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.
• Building an API Activity Log Table (Who Accessed What, When, and What Changed)Nov 17, 2025. Build a complete API activity logging system in ASP.NET Core with SQL Server and Angular. Track API access, data changes, and ensure audit compliance.
• Designing a Data Versioning System — store history of every record (SQL Server + .NET)Nov 17, 2025. Implement data versioning in SQL Server and .NET to track record changes. Essential for audit, compliance, and features like time travel and record revert.
• Building a Custom Merge Replication for Selected Tables Only (SQL Server + .NET)Nov 17, 2025. Build a custom merge replication system in SQL Server with .NET for selective table syncing, conflict resolution, and incremental updates. Control, version, and monitor your data!
• Creating a SQL-Based Notification System (Trigger + Queue Table)Nov 18, 2025. Build a robust SQL notification system using triggers and a queue table. Centralize data event tracking, enabling real-time alerts and asynchronous workflows. Includes practical scripts and architecture.
• Efficient Data Partitioning in SQL Server: A Practical Guide for Tables with Millions of RecordsNov 15, 2025. Master SQL Server data partitioning! This guide provides a step-by-step approach to efficiently manage large tables, boost query speed, and simplify maintenance.
• Step-by-Step Guide to Configure Power Pages Web API for Dataverse IntegrationNov 10, 2025. Learn how to configure Power Pages Web API for seamless Dataverse integration. This step-by-step guide covers site settings, table permissions, and web roles to enable CRUD operations. Master add, view, update, and delete functionalities with ease. Boost your Power Pages development!
• Data Versioning and Auditing in SQL Server with Temporal TablesNov 05, 2025. SQL Server Temporal Tables offer built-in data versioning and auditing, simplifying history tracking and compliance. Restore data, query past states easily!
• Multiplication table generator in JavaScriptNov 06, 2025. Create dynamic multiplication tables in JavaScript! This tutorial provides a simple, interactive code snippet for generating tables in real-time. Perfect for learning!
• 🧩 Convert SQL Server DataTable Rows into Pivot Table (With Example)Oct 16, 2025. Learn how to convert SQL Server DataTable rows into a pivot table for enhanced data analysis and reporting. This guide provides a step-by-step example using the PIVOT operator, including dynamic SQL for automatically generating columns. Discover when to use pivot tables and explore alternative techniques like UNPIVOT and GROUP BY. Ideal for BI dashboards and Excel exports, this tutorial simplifies data visualization in SQL Server.
• What is Hash Tables in Data Structures with ExampleOct 12, 2025. Explore Hash Tables, a fundamental data structure for efficient data storage and retrieval. Learn how hashing enables O(1) average-case complexity for search, insertion, and deletion. Understand collision handling techniques like chaining and open addressing. Discover real-world applications in databases, caching, and compilers. This guide covers Python implementation, advantages, and limitations.
• Dataverse Users Table vs Microsoft Entra ID Table: Understanding the Differences and Best PracticesSep 27, 2025. Unlock the secrets of user management in Power Platform! This article clarifies the crucial differences between the Dataverse Users table and Microsoft Entra ID (Azure AD) table. Learn when to use each for security, authentication, and app development. Discover best practices for user provisioning, role assignment, and data synchronization to build robust and secure Power Apps solutions. Master user identity management for optimal Power Platform performance.
• Data Tables in n8nSep 24, 2025. Unlock data persistence in n8n with Data Tables! This built-in, lightweight database lets you store and manage data across workflows without external dependencies. Perfect for lead management, AI context storage, and rapid prototyping. Learn how to use Data Tables for shared state, logging, and configuration management. Discover the pros, cons, limitations, and practical examples to supercharge your n8n automations. Simplify your workflows and avoid Google Sheets data juggling!
• Artificial Intelligence: AI-First Data Modeling for Health Care: From EHR Tables to Learning, Patient-Safe SystemsSep 05, 2025. Transform healthcare data modeling with an AI-first approach! This article outlines a blueprint for building patient-safe systems that leverage facts, features, and AI agents. Learn how to productize data, ensure traceability, and implement AI for early detection, medication safety, and streamlined workflows, all while prioritizing privacy and compliance.
• Generative AI: AI-First Data Modeling for Telecommunications. From OSS/BSS Tables to Intelligent, Self-Healing NetworksSep 03, 2025. Transform telecom data models for the AI era! This article outlines an AI-first blueprint, moving beyond traditional OSS/BSS to leverage modern networks (5G, ORAN) for intelligent automation. Discover how to build self-healing networks with governed data loops, proactive assurance, and superior customer experiences.
• Mastering Common Table Expressions (CTEs) in SQL ServerAug 12, 2025. This article explains SQL Server Common Table Expressions (CTEs), covering benefits, performance, best practices, and real-world examples, helping developers simplify complex queries, improve readability, and handle recursive or hierarchical data efficiently.
• To Delete a Row from Table in SQL ServerAug 06, 2025. Learn how to delete a row from a table in SQL Server using the DELETE statement. This guide explains the syntax, provides examples of deleting rows by specific conditions, and highlights the difference between DELETE and TRUNCATE. Whether you are removing a single record or multiple rows, this article covers the essential steps and best practices for safe data deletion.
• To Backup Data From the tables1 and table2 in SQL ServerAug 06, 2025. Learn how to back up data from specific tables in SQL Server using simple SQL queries. This article covers methods like SELECT INTO, INSERT INTO, and full database backup commands to help you secure data from individual tables without performing a full database backup.
• Dataverse Gets Smarter! Introducing Prompt Columns in Power PlatformAug 07, 2025. If you're working with Microsoft Power Platform, especially Dataverse, here’s a cool update you should know about – a new column type called "Prompt" is now available (in preview as of writing this post).
• ETL Design Pattern to Implement SCD Type 2 Using SQL, SSIS, or dbtJul 30, 2025. SCD Type 2 is widely used in data warehousing to preserve full history of dimensional changes. Implementing it correctly through your ETL process is crucial for accurate historical reporting.
• Star Schema vs. Snowflake Schema – Which One Should You Use?Jul 24, 2025. When designing a data warehouse, choosing the right schema structure is crucial for performance, usability, and scalability. Two of the most commonly used schemas are Star Schema and Snowflake Schema. In this article, we’ll explore what each schema looks like, how they differ, and when you should use one over the other.
• Temp Tables vs CTEs in SQL Server: What You Should Really KnowJul 23, 2025. Explore the key differences between CTEs and Temporary Tables in SQL Server — when to use each, how they work, and tips for writing cleaner, faster queries.
• 🔍 Power Pages: Fetch Data from a Dataverse Table and Display Using Liquid TemplateJul 21, 2025. Learn how to display Dataverse table records on your Power Pages home page using Liquid templates. This guide covers permissions, Liquid syntax, and secure dynamic content rendering for real-world scenarios.
• 🚀 Automating SQL Server Database Backups and Remote Table SyncJul 11, 2025. This SQL stored procedure automates local database backups and replicates all tables to a remote server with suffixes, ensuring disaster recovery, reporting, and schema sync—no manual table handling required.
• Data View and LINQ in C# and VB.NETJul 07, 2025. Learn how to fetch unique values from a DataTable using DataView and LINQ in C# and VB.NET. Explore sorting, filtering, and displaying distinct book records with examples compatible with .NET Core and .NET 9.
• Managed & External Tables in Unity CatalogJun 17, 2025. Learn the key differences between managed and external tables in Unity Catalog, and how they support data governance, optimization, flexibility, and compliance within the Databricks lakehouse architecture.
• Table Sharding in SQL: Types, Examples, and Best PracticesJun 10, 2025. Table sharding improves database scalability and performance by splitting large tables into smaller, distributed shards. It enhances speed, fault tolerance, and cost-efficiency—ideal for growing applications with heavy data loads.
• Power Automate Desktop: Read Excel and Use as Data Table (PAD)May 31, 2025. Learn how to read a local Excel file and convert it into a Data Table using Power Automate Desktop. Easily loop through rows, display data in message boxes, and enhance your automation workflows.
• Export Table Data as CSV in React Using Axios and react-csvMay 14, 2025. Learn how to export table data to a CSV file in a React application using Axios for data fetching and the react-csv library for easy CSV generation.
• Best Practices for Azure Blob, Table, Queue, File Storage with C#May 11, 2025. Azure Storage provides scalable solutions for unstructured and structured data. It includes Blob, Table, Queue, and File Storage, offering features like tiering, lifecycle management, security, and cost optimization for efficient data handling.
• Mastering the Power of Calendar Tables in Power BI with ADDCOLUMNS in DAXMay 02, 2025. This article covers creating dynamic, customizable date tables for advanced time intelligence, enabling better reporting, filtering, and analysis in your Power BI dashboards.
• How to Convert a DataTable to a List of Objects in C#Apr 27, 2025. Learn how to convert a DataTable to a List<T> in C#. Explore manual, reflection-based, and LINQ methods for better performance, type safety, and cleaner code. Improve maintainability in modern C# applications.
• Best Practices for Azure Table StorageMar 30, 2025. Learn the best practices for optimizing Azure Table Storage, from partitioning strategies to query performance enhancements, ensuring scalable and cost-effective data management in the cloud.
• How to get Dataverse Choice Text Value in Power AutomateMar 26, 2025. ?Learn how to retrieve text values from Dataverse Choice fields using Power Automate. This guide offers step-by-step instructions to enhance your workflow automation and data management skills.
• Understanding System-Versioned Tables in SQLMar 25, 2025. System-versioned tables in SQL automatically track data changes, maintaining historical records for auditing and recovery. They consist of a main table (current data) and a history table (past records).
• Understanding SQL CTE (Common Table Expression)Mar 19, 2025. A Common Table Expression (CTE) in SQL is a temporary result set that improves query readability and performance. CTEs simplify complex queries, support recursive operations, and help with aggregation and multi-step calculations.
• A Comprehensive Guide to Azure Storage for .NET DevelopersMar 13, 2025. Azure Storage is a secure, scalable cloud storage solution for .NET developers. It includes Blob, Table, Queue, File, and Disk Storage for various data needs.
• Boost SQL Server Performance with Memory-Optimized TablesFeb 25, 2025. Memory-optimized table variables in SQL Server provide a powerful way to enhance query performance by leveraging In-Memory OLTP. Unlike traditional table variables, they reduce disk I/O and improve execution speed.
• Most common GlideRecord objects in ServiceNowFeb 04, 2025. This article provides an overview of common GlideRecord methods in ServiceNow, which are essential for interacting with the platform's database. It covers key methods like querying, inserting, updating, deleting records, and managing permissions.
• How to Create A Pivot Table in PostgreSQLJan 22, 2025. This article covers using crosstab functions, grouping, and SQL queries to pivot rows into columns, making it easier to analyze complex datasets. Perfect for data analysis and reporting tasks in PostgreSQL.
• Configuring Route Table in AWSJan 18, 2025. Learn how to configure AWS VPC route tables to manage network traffic between subnets and gateways. This guide covers adding routes, selecting gateways, and verifying configurations to connect AWS and Azure environments.
• Local and Global Temporary Tables in SQL ServerJan 13, 2025. Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
• Let's Play with ServiceNow Table API Using PostmanJan 10, 2025. Learn how to create and test a POST Table API in ServiceNow using Postman. Step-by-step guide covers API setup, JSON payload, authentication, headers, and testing, ensuring secure and efficient data handling with best practices.
• Automating Table Creation using SSISDec 10, 2024. In this article, we will see how to create a database table in SQL Server using the SSIS package. Learn how to create a database table in SQL Server using an SSIS package. Follow step-by-step instructions for automation.
• What is a CTE, and How Do You Write a CTE in SQL Server?Nov 29, 2024. A Common Table Expression (CTE) in SQL Server is a temporary result set that can be referred to within a SELECT, INSERT, UPDATE, or DELETE query. CTEs simplify complex queries by breaking them into manageable parts.
• User-Defined Functions in SQL ServerNov 21, 2024. SQL Server supports two types of User-Defined Functions (UDFs): Table-Valued and Scalar-Valued. Table-valued functions return a table based on logic, while Scalar-Valued functions return a single value.
• Temporary Tables vs Table Variables in SQL Server ExplainedNov 19, 2024. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
• Delta Tables in Microsoft Fabric🔼Nov 18, 2024. Delta tables in Microsoft Fabric offer a powerful way to manage large-scale data efficiently. Built on open-source Delta Lake, they enable ACID transactions, versioning, and real-time data streaming.
• How to Store Temporary Information in Table Like Format in C#?Oct 28, 2024. In this article, we will learn how to manipulate and manage in-memory data effectively, allowing for quick access and modifications while maintaining a structured format for your applications.
• Create a Model with Database Table in .NET 8 using EF CoreOct 28, 2024. 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 string, and use migrations to manage your database schema.
• Efficient Data Handling in SQL Server with Table-Valued ParametersOct 27, 2024. 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.
• Getting Started with Databrick DatasetOct 19, 2024. 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, and refine machine learning, big data, and data science projects seamlessly.
• How To Delete Duplicate Rows From A Table In SQL ServerOct 12, 2024. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the original.
• Hidden Gems - Converting the Table Response Into String VariableOct 03, 2024. Discover the hidden gems and best practices for effectively handling data within Microsoft Copilot. Enhance your AI-driven applications by learning essential techniques for data manipulation and integration.
• Database Dictionary (1-1) --- Server, Database, Schema, Table and ColumnSep 24, 2024. This article is to discuss the major schemata in SQL server.
• Check Disk Space Utilization by Tables in SQL Server DatabaseSep 23, 2024. 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, and optimize database performance.
• Get First Row from Dataverse Table in Power AutomateSep 22, 2024. Learn how to retrieve the first row from a Dataverse table using Power Automate. This guide walks you through creating a flow, filtering contacts with emails, and using expressions to extract the first row's contact ID, full name, and email.
• Create Calendar Table Using Power QuerySep 20, 2024. We’ll explore step-by-step instructions for transforming date data, implementing essential date functions, and enhancing your data analysis capabilities in Excel and Power BI. Perfect for improving your reporting and time intelligence skills!
• How to Keep SQL Server Table Columns in SyncSep 19, 2024. how to keep columns in sync across SQL Server tables using efficient methods like triggers, SQL scripts, and the MERGE statement.
• Learn Common Table Expressions (CTE) in SQLSep 04, 2024. Common Table Expressions (CTEs) in SQL are a powerful tool for simplifying complex queries. They allow you to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• Mastering Pivot Tables in SQLAug 28, 2024. Learn to efficiently aggregate, summarize, and transform data using advanced SQL queries. Discover techniques for data analysis, reporting, and visualization to enhance your analytical skills.
• What is Databricks Delta Live Tables (DLT)Aug 28, 2024. Databricks Delta Live Tables (DLT) is a powerful tool for automating data pipelines, ensuring data quality, and simplifying ETL processes. DLT allows real-time data processing and supports both batch and streaming data.
• Explain Subqueries in PostgreSQLAug 16, 2024. Subqueries in PostgreSQL allow you to nest queries within other queries, enabling complex data retrieval. They can be used in various SQL clauses such as SELECT, FROM, WHERE, HAVING, and JOIN. Types include scalar, row, and table subqueries, with correlated subqueries providing powerful filtering capabilities.
• T-SQL Script for Purging Tables with Foreign Key ReferencesAug 02, 2024. This article provides a comprehensive T-SQL script for purging tables in SQL Server, including those with foreign key references, ensuring data integrity and correct order of operations. Ideal for SQL Developers, Data Engineers, and DBAs seeking efficient data management solutions.
• Difference between Temp Table and Table VariableAug 01, 2024. This article will discuss Difference between Temp Table and Table Variable
• Understanding Table Partitioning in SQLJul 24, 2024. Table partitioning is a technique in database design that divides large tables into smaller, manageable pieces called partitions. This approach improves query performance, enhances manageability, and optimizes data storage.
• Dynamically Creating a Table in SQL Server from Information SchemaJul 19, 2024. 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 values.
• jQuery DataTable Plugin to Customize Tables in Power Pages PortalJul 19, 2024. How to integrate the jQuery DataTable Plugin into custom tables within the Power Pages Portal. The DataTable Plugin enhances tables by providing features such as pagination, column filtering, efficient search capabilities, and customizable styling.
• Using EF Core to Scaffold DbContext and Models from Existing Database TablesJul 12, 2024. In this article, we will see how using Scaffolding we can generate database context (DbContext) class for database and model of entities in that database's table. We will be using MS SQL Server as data source and use EF Core framework.
• How to Seed Identity in SQL ServerJul 03, 2024. Discover SQL Server's IDENTITY columns for automatic unique number generation. Learn to create tables with IDENTITY, insert data without specifying IDs, seed values with DBCC CHECKIDENT, manage explicit ID insertions with IDENTITY_INSERT, and reset identity seeds using TRUNCATE TABLE.
• Store Locations and Retrieve Dropdown Data with Stored ProcedureJul 03, 2024. Explore efficient location data management with this guide on storing locations in a database table. Learn to utilize stored procedures for streamlined retrieval of dropdown data, ensuring optimized database performance and simplified data handling in your applications.
• Query to find Table Name, Row Count, Column Count and Data SizeJul 02, 2024. This guide covers techniques to query and display table names, row counts, column counts, and data sizes efficiently. Ideal for database administrators and developers seeking to optimize data management and performance analysis.
• Database Objects Related to Table in Database - Transact SQL QueryJun 29, 2024. The SQL query retrieves distinct object names and their types from SYSCOMMENTS and SYSOBJECTS system tables, categorizing objects by their XTYPE values ('P' for procedure, 'V' for view, 'TR' for trigger). It filters results containing 'table_name' in their definitions, providing insights into database object metadata.