Post
Ask Question
Related resources for Q#
  • Overview Of Data Gateway In Power BI9/16/2024 11:19:33 AM. A Power BI Gateway connects on-premise data sources, such as SQL Server or SharePoint, to online services like Power BI. It ensures secure communication, supports both Personal and Enterprise Modes, a
  • Data Virtualization from Azure Blob Storage in Azure SQL Database9/16/2024 5:17:34 AM. This solution enables Azure SQL Database to directly access and read files from Azure Blob Storage using External REST Endpoints, bypassing the need for physical data loading. It leverages database-sc
  • POCO to Dictionary Conversion Techniques in C#9/16/2024 5:02:08 AM. This article explores five methods for converting a C# POCO to a dictionary using reflection, LINQ, JSON libraries, and ExpandoObject, comparing their performance through Benchmark.NET to find the bes
  • Making subquery workable9/15/2024 9:24:43 AM. This article discusses Making subquery workable
  • Interesting Query (3) --- Get Rolling Average9/15/2024 9:23:26 AM. This article will discuss Interesting Query (3) --- Get Rolling Average
  • Cross-Site Request Forgery (CSRF) in ASP.NET Core9/13/2024 9:00:31 AM. CSRF is a security vulnerability where attackers trick authenticated users into making unintended requests. This ASP.NET Core example demonstrates using anti-forgery tokens to prevent CSRF attacks. It
  • Entity Framework In MVC - Part Three9/12/2024 12:12:57 PM. This article explains the Code First approach in MVC using Entity Framework. It covers creating a new database from domain classes, reverse engineering an existing database to generate POCO classes, a
  • Create A Simple Web Service In ASP.NET Using C#9/12/2024 6:14:14 AM. This guide covers building a REST API, handling HTTP requests, and integrating with JSON/XML data formats. Ideal for beginners, it provides step-by-step instructions using Visual Studio, focusing on p
  • Entity Framework Core Feature - Global Query Filters9/12/2024 5:59:39 AM. Learn how to implement Global Query Filters in Entity Framework to apply automatic filters at the model level. This feature is commonly used for scenarios like soft delete and multi-tenancy, ensuring
  • Configure SQL Server Session State In ASP.NET Core9/12/2024 5:49:48 AM. This guide covers setting up SQL Server as a session storage provider, configuring the connection string, enabling session middleware, and ensuring session persistence for scalable web applications.
  • CRUD Operation Using Repository Unit Of Work Pattern9/12/2024 5:44:14 AM. Create an ASP.NET MVC project in Visual Studio 2013, add a class library, and set up a SQL Server database. Implement Entity Framework with an EDMX model, then use the Repository pattern for CRUD oper
  • Validate CKEditor Using jQuery Validate9/12/2024 5:12:02 AM. This article explains how to validate CKEditor using jQuery Validate. CKEditor renders in an iframe, causing validation issues with jQuery. A custom jQuery validation method (ckrequired) is introduce
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise Mode9/12/2024 5:10:58 AM. This article explains how to configure a Data Gateway for an On-Premise SQL Server Database using Power BI's Recommended Mode. It covers the installation steps, including downloading and setting u
  • SQL Vs DAX: Calculating Total Sales & COGS using SQL and DAX9/11/2024 8:13:50 AM. This videos show how to use SQL and DAX languages to compute Total Sales and Total Cost achieving the same result in Fabric Warehouse and Power BI.
  • Understanding Two-Phase Commit in Microservices9/11/2024 6:47:37 AM. The Two-Phase Commit (2PC) protocol ensures data consistency in microservices by coordinating transactions across services. It involves a prepare phase where participants log changes and vote, and a c
  • Database Mail Configuration in SQL Server 20089/10/2024 10:16:49 AM. Learn how to configure Database Mail in SQL Server 2008 with this guide. Discover step-by-step instructions for setting up email profiles, configuring SMTP settings, and managing mail settings using S
  • Create Simple Application Using Backbone.js9/10/2024 10:15:08 AM. This article demonstrates a basic Backbone.js example by displaying "Hello World." It guides you through creating a simple Backbone.js application within an ASP.NET web project using Visual
  • Real Time Use Of Context Menu Strip In Windows Form Application9/9/2024 11:35:42 AM. Learn how to use ContextMenuStrip in a Windows Forms application to delete records from a DataGridView. This tutorial covers setting up a context menu, handling right-click events, and executing a del
  • FLOW Trigger Conditions For SharePoint - Run FLOW When Needed9/8/2024 10:44:58 AM. Learn how to configure FLOW in SharePoint to trigger only when necessary using trigger conditions. Control FLOW runs by specifying conditions like item status, reducing unnecessary executions and cons
  • Relations between Dataset in DBMS9/6/2024 12:45:34 PM. A relationship in DBMS links two or more data sets. This article explores types of relationships: one-to-one, one-to-many, and many-to-many, and their implementations in databases.
  • SQL Data Analysis Using Azure Synapse Built-in Serverless Pool9/6/2024 6:06:58 AM. In this video, I demonstrated how to perform SQL Data Analysis in Azure Synapse Analytics using built-in serverless pool.
  • SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause9/5/2024 12:51:37 PM. This article will discuss the issue that SQL: Not Using Aggregate Function in WHERE Clause, instead, Using HAVING Clause
  • Export Data Table To Excel in ASP.Net MVC 49/5/2024 11:09:19 AM. This article demonstrates exporting a Data Table to Excel in ASP.NET MVC. It covers creating a new project, adding a ClosedXML reference, and setting up models and controllers. It details fetching dat
  • Export Data From Database Table to Excel File in ASP.Net MVC9/5/2024 10:55:56 AM. Exporting data from a database to Excel in ASP.NET MVC involves creating a database, setting up a model, and designing a view. Use SqlConnection and SqlDataAdapter to fetch data and Microsoft.Office.I
  • How To Implement CKEditor In ASP.NET MVC9/5/2024 10:45:12 AM. CKEditor is a powerful, browser-based WYSIWYG editor that simplifies HTML content creation. It integrates seamlessly with ASP.NET MVC, allowing users to easily create and manage rich text content.
  • Using JQuery GridView For an ASP.NET MVC Application9/5/2024 9:28:18 AM. Learn how to create a GridView in ASP.NET MVC using jQuery plugins. This guide covers creating static and dynamic GridViews, populating data from a database, and implementing features like paging and
  • Temporary Tables vs Table Variable in SQL Server9/5/2024 7:20:02 AM. In this article you will learn about Temporary Tables and Table Variables in SQL Server 2008. Temporary tables come in two types: Local (prefixed with "#", accessible only to the current con
  • What are Temporary Tables in SQL Server?9/5/2024 7:19:46 AM. Temporary tables in SQL Server, stored in tempdb, assist with short-term data management. They come in Local (scope limited to current connection, prefixed with "#") and Global (accessible t
  • SQL Subqueries: Correlated, Scalar, and EXISTS/NOT EXISTS9/4/2024 9:30:54 AM. Subqueries in SQL are powerful tools for complex queries. They include correlated subqueries, which depend on the outer query’s results, scalar subqueries that return single values, and EXISTS/NOT EXI
  • Database Mail in SQL Server 2008R29/4/2024 8:38:30 AM. Database Mail in SQL Server 2008 R2 enables sending emails directly from SQL Server using SMTP. It supports job alerts, query results, and file attachments, ensuring consistent, scalable, and secure e
  • GridView Paging Sample in ASP.NET9/4/2024 8:21:34 AM. Learn how to implement various paging styles in ASP.NET GridView using C#. This guide covers binding SQL Server data to a GridView, enabling paging, and customizing pager settings like Numeric, NextPr
  • Magnific Pop Up.js Implementation To Zoom In Pictures9/4/2024 7:27:59 AM. This article explains how to implement Magnific Pop Up.js to display full-sized images in a pop-up on a webpage, avoiding the need to navigate away from the page. The guide provides step-by-step instr
  • Configure SQL Server Database Mail for Sending Emails9/4/2024 7:01:19 AM. This guide covers the step-by-step process for setting up Database Mail, including creating and managing mail accounts, profiles, and ensuring your SQL Server can successfully send email notifications
  • Learn Common Table Expressions (CTE) in SQL9/4/2024 6:25:07 AM. 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 DE
  • Filter and Display New Employees in Power Apps with Microsoft Graph9/3/2024 5:05:57 AM. Create a Power Apps app that lists new employees who joined this year by using the Microsoft Graph API. With a button click, retrieve and display user data filtered by hire date in a gallery. This app
  • Overview of the Migration from QnA Maker to Custom QnA Maker9/3/2024 4:51:28 AM. With QnA Maker's retirement approaching, migrate to Custom QnA Maker by March 2025. Custom QnA Maker offers advanced AI capabilities for improved performance and content quality. Use the tool-to-t
  • Advanced Logging Techniques in ASP.NET Core 8 with Serilog9/3/2024 4:00:53 AM. Serilog is a diagnostic logging library for .NET applications. It provides a simple, flexible and powerful way to log application events, errors and other information. This article describes how we ca
  • Advance Chat Application with .NET and SignalR9/2/2024 8:30:14 PM. Build an advanced real-time chat app with .NET 8, SignalR, and MS-SQL. This guide covers creating a chat app with one-to-one and group messaging, utilizing ASP.NET Identity for user roles and permissi
  • Power Query: Best Practices for Memory Consumption9/2/2024 10:27:37 AM. To optimize memory usage in Power Query, filter data early, minimize query steps, and utilize query folding to reduce data processed. Disable background data loading, optimize data types, use dataflow
  • Boost Stability and Efficiency with Advanced AlbertAGPT Techniques9/2/2024 7:22:31 AM. This content delves into cutting-edge methods for improving deep learning performance, optimizing neural networks, and ensuring robust and reliable AI model training.
  • Introduction to SQL Server & Its History9/2/2024 7:10:06 AM. Learn how to create, manage, and query databases using SQL Server, with a focus on essential concepts like database design, data storage, and SQL queries. Perfect for beginners aiming to build a stron
  • ADF: Provision Snowflake Database Table in Azure SQL DB and Create Power BI Report9/2/2024 7:08:05 AM. In this data engineering and data analysis episode, I covered how to provision single snowflake database table in azure sql database and then use Power BI desktop to connect to the data to create Powe
  • Integrating AngularJS with jQuery Select2 for Dropdown Changes9/2/2024 5:00:34 AM. Integrating AngularJS with jQuery Select2 enhances dropdown menus by combining AngularJS’s data binding with Select2’s advanced features. This setup involves initializing Select2 with AngularJS, handl
  • How to Deploy a Gen AI Application on Docker?9/2/2024 4:39:45 AM. Learn how to deploy a Generative AI application using Docker with step-by-step instructions, including Flask setup, containerization, and handling POST requests.
  • Using Factory Patterns in C# 12 to simplify A/B testing8/31/2024 4:40:36 AM. Find out how Ziggy Rafiq simplifies A/B testing with feature toggles in C# 12 by using Factory and Abstract Factory design patterns.
  • Optimizing Searching Algorithms in C# and Reducing Complexities8/30/2024 6:54:15 AM. This article explores the implementation of 10 common searching algorithms in C#, detailing their use cases, workings, and complexities. From simple linear searches to more complex algorithms like Bin
  • Dynamic LINQ with Gridify in .NET8/30/2024 6:07:05 AM. Learn how to leverage Gridify to simplify complex filtering, sorting, and pagination tasks. Perfect for developers seeking to optimize and extend their use of LINQ in C# applications.
  • Complete File Upload and Download in ASP.NET Core MVC8/30/2024 5:08:01 AM. Implement file upload and download functionality in an ASP.NET Core MVC application. This guide covers project setup, model creation, controller logic, view implementation, and security best practices
  • C# 12 Design Patterns: Factory and Abstract Factory8/29/2024 2:29:42 PM. By Ziggy Rafiq, discover how Factory and Abstract Factory design patterns simplify the creation of complex objects in C# 12.
  • Learn Database Mail in SQL Server8/29/2024 10:53:40 AM. Database Mail in SQL Server is a robust feature that enables sending emails via an SMTP server without relying on MAPI clients like Outlook. It offers secure SSL encryption, asynchronous processing, e
  • Crafting Efficient and Maintainable C# Code8/29/2024 4:49:20 AM. This guide explores essential C# best practices for robust, maintainable code. It covers using meaningful variable names, following naming conventions, handling null values, and using var judiciously.
  • Abstract Factory Design Pattern in .NET Core C# 128/29/2024 4:29:33 AM. In this detailed article by Ziggy Rafiq, you will learn how to implement key components like AbstractFactory, ConcreteFactory, AbstractProduct, and ConcreteProduct in .NET Core with C# 12. By leveragi
  • SSRS (4) --- SQL Server Database Project in Visual Studio8/29/2024 2:28:31 AM. This article is to discuss: SQL Server Database Project in Visual Studio
  • Understanding SQL Triggers: A Practical Guide with a New Example8/28/2024 8:38:05 AM. Discover how triggers can automate tasks, enforce business rules, and maintain data integrity in your database. Perfect for both beginners and experienced developers looking to deepen their SQL skills
  • Mastering Pivot Tables in SQL8/28/2024 6:59:59 AM. 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.
  • Understanding CQRS Design Pattern8/28/2024 5:57:21 AM. CQRS (Command Query Responsibility Segregation) is a pattern that separates the responsibilities of reading and writing data into distinct models. This separation can help optimize both aspects indepe
  • Inner Join vs Cross Apply and Left Outer Join vs Outer Apply8/28/2024 5:32:30 AM. In SQL, INNER JOIN and CROSS APPLY differ in functionality; INNER JOIN merges rows based on a condition, while CROSS APPLY uses a table-valued function for dynamic row operations. LEFT OUTER JOIN incl
  • SQL Data Analysis using Azure Synapse Built in Serverless Pool8/28/2024 4:28:22 AM. In this Azure Data Engineering episode, I discussed how to perform SQL Data Analysis using Azure Synapse Built in Serverless Pool
  • Learn to Set Folder Unique Permission8/28/2024 4:11:25 AM. This feature ensures that only selected users or groups can view, edit, or manage the folder's contents, enhancing security and tailoring access to meet specific needs.
  • Unit Test (2) --- TSQLT8/27/2024 1:49:06 PM. This article will discuss TSQLT Unit Test.
  • Mastering Microsoft 365 Copilot Prompts8/27/2024 9:37:09 AM. Microsoft 365 Copilot enhances productivity by using AI to streamline workflows in apps like Word, Excel, and PowerPoint. Mastering prompt techniques—ranging from basic to advanced—enables users to ac
  • Implementation Ajax Calls in ASP.NET Core MVC 8/27/2024 7:03:37 AM. Learn how to build a dynamic fleet management system using AJAX in ASP.NET MVC with SQLite as the database provider. This tutorial guides you through creating, managing, and displaying vehicle data in
  • New in Fabric Warehouse SQL: TRUNCATE8/27/2024 6:07:38 AM. The SQL TRUNCATE command, newly introduced in Fabric Warehouse, offers an efficient way to delete all rows from a table without logging individual row deletions.
  • Create Intelligent Chatbots with C# Tools and Techniques8/26/2024 4:11:15 AM. Build intelligent chatbots using C# and AI frameworks like Microsoft Bot Framework and Azure Cognitive Services. Leverage NLP for natural conversation flow, integrate LUIS for intent recognition, and
  • Quiet Times in Real-time Marketing Dynamic 3658/23/2024 9:50:44 AM. Quiet times in Dynamics 365 Customer Insights manage customer communication by pausing messages during specified periods. You can set weekly schedules and special dates for each channel, like email or
  • Learn about Different Type of Triggers in Oracle8/23/2024 8:02:40 AM. In this article, you will learn about different type of triggers in Oracle.
  • Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed Code8/22/2024 7:14:27 AM. Learn how to use SharePoint 2013 REST API with CAML queries in a C# console application. This guide covers fetching data from SharePoint lists using POST methods, setting request headers, and handling
  • Understanding Microsoft Dynamics 365 API Access Token8/22/2024 5:31:59 AM. Master the basics of Microsoft Dynamics 365 API access tokens with this beginner-friendly guide. Learn about OAuth2.0, Azure Active Directory, and how to authenticate using Postman. Discover how to ob
  • Understanding IN vs EXISTS in SQL8/22/2024 5:29:41 AM. Explore the differences between the IN and EXISTS operators in SQL. Learn how each operator affects query performance, and understand their use cases in filtering and retrieving data. This guide provi
  • Create QR Code Report Using RDLC Report With Preview8/21/2024 6:37:40 AM. In this article we can learn how to make our own QR code. Make a QR report using RDLC reports with preview condition.
  • AngularJS From Beginning: Http Request or Ajax - Part Seven8/21/2024 6:33:37 AM. In this article, we will discuss how to use $http service or ajax request in AngualrJS.
  • Smooth Horizontal Scrolling Text Animation with Play/Pause Toggle8/21/2024 5:57:23 AM. This tutorial covers CSS and JavaScript techniques to build a responsive scrolling marquee that enhances user interaction. Perfect for showcasing announcements, news tickers, or featured content.
  • Real-Time Pageview Tracking With .NET Core8/21/2024 5:28:26 AM. Learn how to implement real-time pageview tracking in your .NET Core application. This guide covers setting up live monitoring of website traffic, capturing pageview metrics, and integrating real-time
  • Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements8/21/2024 4:49:45 AM. In this new episode, I demonstrated how to Read Parquet Data to Fabric Warehouse using COPY INTO & INSERT INTO SQL Statements.
  • Why You Should Learn Azure Cosmos DB?8/20/2024 12:26:01 PM. Discover why learning Azure Cosmos DB is essential for modern data management. With its global distribution, scalability, and multi-model capabilities, Cosmos DB offers unmatched performance and high
  • Event-Driven Microservices with .NET Core8/20/2024 7:18:14 AM. Build scalable, resilient microservices with .NET Core and MediatR by implementing event-driven architecture. This approach decouples services, enhances scalability, and simplifies maintenance. Learn
  • Learn Advanced CQRS with .NET Core8/20/2024 7:12:32 AM. Dive into the advanced implementation of the Command Query Responsibility Segregation (CQRS) pattern using .NET Core and MediatR. This article explains the benefits of CQRS in modern application devel
  • Learn to Shrink a Microsoft SQL Server Database Programatically 8/20/2024 4:59:45 AM. Shrinking a SQL Server database reduces file size by reclaiming unused space in data and log files. This can optimize disk usage, especially in storage-constrained environments. However, it can cause
  • A brief introduction to ASP.NET Core using C#12 and .NET 88/18/2024 1:40:52 PM. A brief introduction to ASP.NET Core using C# 12 and .NET 8 by Ziggy Rafiq. This modern framework enables you to build cross-platform, high-performance web applications. To get started, discover key f
  • Code Examples for .NET 8 Features with C# 128/18/2024 1:22:31 PM. An in-depth look at performance enhancements, language improvements, and new libraries in this comprehensive article by Ziggy Rafiq.
  • Using Network Planner to Determine and Organize Network Requirements for Teams8/17/2024 8:14:50 PM. This content explores how to use a Network Planner to assess and organize network requirements for teams. It covers identifying network needs, designing efficient network structures, and ensuring seam
  • Training a Sequence-to-Sequence Model Using C#8/16/2024 7:32:11 AM. Explore how to train a Sequence-to-Sequence model using C#. This guide covers the fundamentals of Sequence-to-Sequence models, essential for tasks like language translation and text generation.
  • Explain Subqueries in PostgreSQL8/16/2024 7:21:21 AM. 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 i
  • Recursive CTE: Simplifying Complex Queries with SQL8/16/2024 7:14:44 AM. Recursive CTEs in SQL simplify querying hierarchical or recursive data by breaking down queries into anchor and recursive members. They are ideal for traversing structures like organizational charts o
  • Understanding of Iterators in Python8/14/2024 5:39:20 AM. Iterators in Python allow efficient traversal of sequences by implementing iter() and next() methods. Unlike iterables, iterators represent a stream of data and support on-demand value computation, en
  • SpecFlow to Reqnroll - Step-by-Step Guide to Migrating BDD Tests8/14/2024 5:17:24 AM. Easy guide for migrating your feature files, including examples, datatables, and hooks, from SpecFlow to Reqnroll, ensuring compatibility and functionality in your BDD tests, ensuring that your automa
  • PUT vs PATCH: Understanding the Differences with Examples8/14/2024 4:04:51 AM. Learn when to use PUT for full resource updates and PATCH for partial modifications. With practical examples, you'll understand their roles in RESTful APIs and best practices.
  • Azure Data Factory: Append and Convert Multiple CSV Files To Parquet File8/13/2024 11:16:36 AM. In this Data Engineering episode, I was you through to to append and convert multiple CSV Files to Parquet File leveraging the Azure Data Factory
  • HighChart in JavaScript8/13/2024 10:47:18 AM. This article introduces Highcharts, a JavaScript library for creating interactive charts. It covers installation using Highcharts.js and jQuery, and provides a step-by-step guide to creating a bar cha
  • Optimizing JavaScript with Debouncing8/13/2024 5:47:14 AM. This guide delves into optimizing JavaScript performance using debouncing techniques, which help prevent excessive function calls during high-frequency events like scrolling or resizing.
  • Creating a Custom Date Picker in jQuery with Validation8/13/2024 5:44:33 AM. This article demonstrates how to create a custom date picker in jQuery with validation. It covers setting up HTML text boxes for date input, initializing jQuery Datepicker with date range constraints,
  • How to Retrieve and Display Database Records in Java Using JTable8/13/2024 5:22:08 AM. Learn how to retrieve and display database records in Java using JTable with this step-by-step guide. Explore Java Swing for creating a graphical user interface, JDBC for database connectivity, and SQ
  • Iterations and Improving Code Quality with C# yield return8/13/2024 4:10:48 AM. This article explores how the yield return statement in C# can simplify iteration logic and enhance code quality. By allowing deferred execution and creating custom iterators, developers can write mor
  • SQL Server on Azure VMs vs Managed Instance vs SQL Database8/12/2024 11:18:45 AM. Based on the type of the cloud service each Relational azure service use and different aspects formulated the differences and uses cases when to use each database solution.
  • Use JQuery Datepicker In ASP.NET Web Form8/12/2024 11:06:52 AM. In this article I will explain how to use JQuery Datepicker Using ASP.NET WebForm.
  • Difference Between Primary Key and Unique Key in SQL8/12/2024 9:38:24 AM. Primary Key and Unique Key are essential in relational databases for data integrity. A Primary Key uniquely identifies each row and cannot be NULL, while a Unique Key ensures column values are unique
  • Azure Databricks: Group By All Clause8/12/2024 5:25:13 AM. In this Azure Databricks episode, I covered how to use the Group By All clause to efficiently query data in the SQL editor.
  • Multilevel Toggle Responsive Navigation Menu8/9/2024 9:48:15 AM. This article guides you through creating a multilevel toggle responsive navigation menu using HTML, CSS, and jQuery. It includes a mobile-friendly design with nested dropdowns and a hamburger menu tog
  • Validating User Input Using Regular Expression With C#8/9/2024 9:46:52 AM. In software development, validating user input is crucial to prevent errors and security issues. Regular expressions (regex) are used to validate fields such as email, zip codes, and phone numbers. Th
  • Reading An Excel File Using HTML 5 And jQuery8/9/2024 9:45:57 AM. Learn how to read an Excel file from the client-side and display its contents in an HTML table using the FileReader() API and jQuery plugins like "xlsx.core.min.js" and "xls.core.min.js