Post
Ask Question
Related resources for tab
  • MERGE Stored Procedures in SQL Server4/16/2024 8:14:21 AM. In this article, I present how to use the MERGE statement in a stored procedure to merge a single record and how to use it to merge a list of records by using Table-Valued parameters in SQL Server.
  • Microsoft.Extensions.DependencyInjection for Dependency Injection4/16/2024 5:51:27 AM. Dependency Injection (DI) is a software development design pattern that aims to achieve loose coupling between components and enhance the maintainability, testability, and scalability of applications.
  • Table-Valued Parameters in SQL Server4/16/2024 5:42:55 AM. Table-Valued Parameters in SQL Server enable passing multiple rows of data to stored procedures, enhancing performance for bulk operations. Utilizing user-defined table types, they streamline data man
  • 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
  • Build a Table API with Python and Azure Cosmos DB4/15/2024 11:43:19 AM. Develop a robust Table API using Python and Azure Cosmos DB. Leverage the power of NoSQL with Azure's scalable database solution. Manage JSON data efficiently, perform CRUD operations, and optimiz
  • 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
  • Exploring Frozen Collections in .NET 8 With Benchmarking4/14/2024 5:32:01 AM. Frozen Collections is a new .NET 8 feature that can be used to create Dictionaries and Sets for faster read operations when you don’t need to make changes after the creation. In this article, I presen
  • 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
  • Formatting HTML Table In FLOW - Before Sending Email4/12/2024 8:14:49 AM. Learn how to enhance the visual presentation of your emails by formatting HTML tables in Microsoft Power Automate (Flow) before sending. Discover techniques for styling data effectively, optimizing la
  • How to Create A Table Report Using Visual Studio Report Designer4/12/2024 5:54:12 AM. Learn how to efficiently create table reports using Visual Studio's intuitive Report Designer tool. Explore step-by-step instructions for designing and presenting tabular data, leveraging the powe
  • 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 Form Using HTML Tables4/11/2024 10:31:39 AM. In this article we will see how to create a form using HTML Tables. First we learn how to create controls like TextBox and DropDownList, then we use them together in our table to create a form where u
  • GET, SET The Value From HTML Table In ASP.NET MVC jQuery4/11/2024 10:25:17 AM. Learn how to utilize jQuery in ASP.NET MVC to efficiently GET and SET values from HTML tables. Enhance user interaction and streamline data handling between front-end and back-end components.
  • How To Use Sequelize-CLI In Node4/11/2024 7:03:38 AM. Learn to use Sequelize CLI to create tables, set up relationships with foreign keys. Prerequisites include Node and MySQL. Set up project structure, install necessary packages. Configure Sequelize str
  • 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
  • Mastering SOLID Design Principles in C#4/11/2024 3:58:49 AM. SOLID design principles provide guidelines for creating maintainable, flexible, and scalable software. They enhance code readability, reduce duplication, and promote effective testing. Principles like
  • 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
  • Using jQuery DataTable With ASP.NET MVC Client Side4/9/2024 11:46:04 AM. Utilize jQuery DataTable in ASP.NET MVC for dynamic client-side rendering of tabular data. Enhance user experience with features like pagination, sorting, and filtering, seamlessly integrating with se
  • 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
  • Top 4 Essential Qualities Of A Good Trainer4/8/2024 8:43:14 AM. In this article, you will learn to Discover the key traits of effective trainers. Learn about their expertise, communication, adaptability, and motivational skills. Explore how empathy, organization,
  • 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
  • Using Table Type Parameter In .NET Core4/5/2024 11:24:07 AM. In many cases, we need to send a list of objects to the stored procedure to save or update the list of data in the database, which helps in increasing the performance of the application. Here I'll
  • 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.
  • Use Wikipedia As A Data Source To Prepare Power BI Report4/4/2024 8:55:41 AM. Power BI is a business intelligence tool. It supports so many data sources to prepare a report. As we all know Wikipedia is a very good resource of useful information. We can consume Wikipedia data as
  • 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
  • Joining Three Or More Tables In SQL Server 20174/3/2024 10:45:07 AM. Joining three or more tables in SQL Server 2017 involves using various types of joins such as INNER JOIN, LEFT JOIN, RIGHT JOIN, and CROSS JOIN. These joins combine rows from multiple tables based on
  • 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.
  • Creating Various Types of Tables in SQL Server 4/3/2024 9:42:53 AM. Learn about SQL Server tables like User, Temporary, Global; understand creation methods, differences between temporary and regular tables, storage locations, and utilization of table variables. Exampl
  • 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
  • Table View In Xamarin iOS - Part Two🚀4/3/2024 9:38:56 AM. Part Two of Xamarin.iOS TableView series explores TableViewSource and its methods like GetCell and RowsInSection, essential for populating and managing table view data. Dive into Model-View-ViewModel
  • 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
  • Temporary Tables and Table Variables in SQL Server4/3/2024 5:59:21 AM. In this article we will explore the temporary tables and table variables in SQL Server. From understanding their differences to exploring practical use cases and examples. Whether you're storing i
  • 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.
  • Functional programming in C# - Introduction4/2/2024 8:55:30 AM. Lets learn the concept of functional programming, its usage and why functional programming is important
  • 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.
  • Learn about ASP.NET MVC Life Cycle4/1/2024 6:28:41 AM. Understand the MVC life cycle from HTTP request to response. Learn about ASP.NET's Page class, IHttpHandler interface, and MVC's Controller. Explore RouteTable and UrlRoutingModule for routing
  • Temporary Tables vs Common Table Expressions in SQL Server3/29/2024 11:07:01 AM. In this article, we will learn what is Differences Between Temporary Tables and Common Table Expressions in SQL Server. Temporary tables and Common Table Expressions (CTEs) are SQL Server tools for da
  • 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
  • Keeping Large Table Statistics Current - TF23713/28/2024 6:33:21 AM. Statistics are the magic ingredient that helps the query optimizer create its best guess for generating an execution plan. Keeping statistics as accurate as possible will give the optimizer the inform
  • 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
  • How To Get Started With Always Encrypted For Beginners - Part Two3/28/2024 6:26:09 AM. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them ins
  • 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.
  • Microsoft Fabric: Loading Data into Lakehouse Table3/20/2024 11:56:52 AM. A LakeHouse integrates data lakes & data warehouses, offering benefits of both. Data lakes store raw data diversely, while DataWarehouses handle structured data. LakeHouse combines both for effici
  • Web API Validation3/20/2024 9:41:36 AM. Learn about the importance of validation in Web API development, including techniques like Model Validation and Fluent Validation. Explore how to implement validation rules using data annotations and
  • Responsive Web Design Using Media Queries3/19/2024 6:11:25 AM. Responsive web design utilizes media queries to adapt layouts and styles based on the user's device characteristics, such as screen size and orientation. This ensures optimal viewing experience ac
  • Effective Communication Between Executable Files Using Shared Memory3/19/2024 5:55:09 AM. In a WPF (Windows Presentation Foundation) application, inter-process connectivity typically involves communication between different components or modules within the same application or between separ
  • Establishing Communication Between Executable Files Using TCP/IP3/19/2024 5:29:21 AM. WPF apps use various IPC methods like Named Pipes, WCF, TCP/IP Sockets. TCP/IP sockets offer cross-platform communication with advantages like reliability but face complexity and firewall issues. Step
  • A Comprehensive Guide to Entity Framework Core in .NET 83/17/2024 8:41:25 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
  • 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
  • Lets Create TabView in SwiftUI3/14/2024 4:45:45 AM. This article contains a simple demo of creating Tab View in SwiftUI. Learn how to create a Tab View using SwiftUI in this tutorial. Follow step-by-step instructions to integrate tabs like Home, Favori
  • 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.
  • The One Minute AI - Azure Databricks Overview3/13/2024 8:32:44 AM. The One Minute AI - Azure Databricks Overview provides a concise glimpse into the power of Azure Databricks, a cloud-based platform for data analytics and AI. Explore machine learning, big data proces
  • An Overview Of Azure Databricks Cluster Creation3/13/2024 8:32:12 AM. We will cover the steps for creating Azure Databricks workspace and configure a Spark cluster. Later we will create a simple data table from an existing CSV file and query the data using SQL notebook.
  • A Simple Guide to Creating an Azure Databricks Workspace3/12/2024 10:40:28 AM. Learn how to set up your own Azure Databricks workspace with this easy step-by-step guide. Whether you're new to Databricks or looking to create a collaborative environment for big data analytics,
  • Exploring the Data Table Control in Power Apps3/12/2024 10:15:27 AM. Discover the intricacies of the Data Table Control in Power Apps with our comprehensive guide. Learn to harness its power for seamless data manipulation, visualization, and user interaction.
  • Basics of Azure Databricks: Data Analytics in the Cloud3/11/2024 10:31:10 AM. Azure Databricks stands at the forefront of cloud-based data analytics platforms, revolutionizing the way organizations manage, process, and derive insights from massive datasets. Azure Databricks, ex
  • 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
  • Expandable and Collapsible Tables in PowerApps3/10/2024 7:47:33 AM. This article provides a comprehensive guide on expanding and collapsing multiple tables in PowerApps. It walks through the steps required to set up a canvas control, customize columns, add containers,
  • 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
  • A Guide To Crafting Immutable Objects With C# 10's Init-Only Properties3/7/2024 2:14:37 AM. Discover how C# 10's init-only properties empower developers to craft immutable objects with precision, enhancing code readability and maintainability. In this article, Ziggy Rafiq demonstrates ho
  • 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
  • Display SQL Data Using Knockout in ASP.Net3/6/2024 10:41:07 AM. In this article, we will learn how to fetch SQL data in ASP.NET and display it dynamically using Knockout.js. Utilize AJAX to retrieve data as JSON and bind it to HTML elements, creating an interactiv
  • 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.
  • Backup Your Source Code Daily Using C# Programming3/6/2024 10:26:00 AM. Discover an automated solution for daily source code backup with ease. This content introduces an executable file designed to streamline the backup process, ensuring your data is safeguarded without m
  • React State: Managing Dynamic UI with setState() and Props3/6/2024 9:29:14 AM. In React, "state" represents the internal data of a component, which can change over time due to user interactions or other factors. It's managed using the setState method, allowing comp
  • 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