Q# Resources

Share

Related resources for Q#

ETL Pipeline using Microsoft SQL Server Integration Services1/31/2025 8:19:37 AM. This article is about building ETL (Extraction, Transformation and Loading) pipeline using SQL Server Integration Services (SSIS).
Installing and Using GitHub Copilot in Azure Data Studio 1/31/2025 6:40:01 AM. Azure Data Studio helps manage databases and write SQL queries. With GitHub Copilot, it auto-suggests code completions, making complex SQL tasks easier, including writing queries, using JOINs, and gen
MQTT vs HTTP: Understanding the Differences 1/30/2025 10:48:06 AM. Explore the key differences between MQTT and HTTP protocols in this detailed comparison. Understand their strengths, use cases, and how each protocol fits within IoT applications.
JSON Data with Python in SQLite Database1/29/2025 11:49:37 AM. This article explores handling JSON data in an SQLite database using Python. It covers reading, inserting, and creating tables while leveraging Python’s standard `json` and `sqlite3` libraries for sea
Exploring Snowflake SQL New Capabilities Using SELECT Statement1/29/2025 5:15:57 AM. Learn how to leverage new features for efficient data querying, optimization, and advanced analytics in Snowflake’s cloud data platform. Perfect for data professionals.
The Cybersecurity Frontier - Securing the Fifth Domain of Warfare1/27/2025 11:44:50 AM. Cybersecurity has emerged as the fifth domain of warfare, impacting global security. It involves protecting critical infrastructure, countering cyberattacks, and leveraging AI, blockchain, and zero-tr
Getting Started with Liquid in Web Templates - Microsoft Business Application: Ep. 261/27/2025 10:27:55 AM. In this session, we will give a walkthrough on Liquid in Web Templates.
QUALIFY Databricks SQL Filtering Window Functions Results1/27/2025 4:29:53 AM. In this Databricks video, I covered how to use the Databricks SQL QUALIFY with window functions in SELECT list and in QUALIFY clause.
The SOLID Principles in C# 131/26/2025 3:12:43 PM. Ziggy Rafiq's detailed examples provide an overview of the SOLID principles of object-oriented design in C# 13. You'll learn how to adhere to SRP, OCP, LSP, ISP, and DIP to write maintainable,
Using C# 13's Method Overloading and Method Overriding1/26/2025 12:39:04 PM. With practical examples, key differences, and tips for mastering these core OOP concepts, Ziggy Rafiq explores Method Overloading and Method Overriding in C# 13.
Lazy Loading (4): EntityFramework1/24/2025 3:33:28 PM. This article will discuss lazy loading in Entity Framework. This article series explores Lazy Loading, focusing on its application in various technologies like LINQ, HTML, JavaScript, Entity Framework
Lazy Loading (2): HTML1/24/2025 3:31:33 PM. This series explores Lazy Loading within the LINQ category, focusing on dynamically loading images in HTML to enhance page load times, featuring code examples and demos for practical application.
Lazy Loading (1): Difference Between IEnumerable and IQueryable1/24/2025 3:29:00 PM. This article will discuss The Lazy loading related topic: Difference between IEnumerable and IQueryable
How to Fix Recovery Pending State in MS SQL Server Database1/24/2025 11:32:57 AM. Learn about the causes of SQL Server's "Recovery Pending" state, methods to resolve it, and preventive measures. Explore manual fixes, recovery tools, and best practices to ensure databa
Understanding Precision in SQL Server Calculations1/24/2025 5:28:27 AM. Learn why SQL Server calculations can produce different results depending on the approach used. Discover how single-step and multiple-step calculations handle precision and rounding, and how to achiev
Modern ADO .Net with SQLite in VB and C#1/22/2025 9:55:43 AM. This article demonstrates how to connect SQLite with ADO .NET in C# and VB, showcasing database operations such as creating tables, inserting records, and reading data. It uses the Microsoft.Data.Sqli
Create, Insert and Query Nested Data Structures in Databricks SQL1/22/2025 8:59:37 AM. In Databricks SQL, nested data structures like arrays and structs allow you to elegantly manage and query complex, hierarchical data with ease, transforming intricate datasets into insightful, actiona
How to Create A Pivot Table in PostgreSQL1/22/2025 8:22:08 AM. 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 Postg
Differences Between TRUNCATE and DELETE in SQL Server1/22/2025 8:14:06 AM. Learn the key differences between TRUNCATE and DELETE in SQL Server, two commands used to remove data from tables. Understand their syntax, performance impact, transaction logging, and use cases.
How to Implement Search Function in PowerApps1/22/2025 8:09:51 AM. Learn how to implement a dynamic search function in Power Apps to filter data from sources like SharePoint. This article covers step-by-step instructions for adding search features, improving usabilit
Java Program to Rotate a Square Matrix by 90 Degrees1/21/2025 8:30:23 AM. Rotating a matrix by 90 degrees is a common problem in programming, often asked in coding interviews and competitions. The task involves changing the arrangement of elements in a square matrix such th
Learn Quantifier Operations in LINQ 1/21/2025 6:26:36 AM. Quantifier operations in LINQ simplify logical evaluations of collections using methods like `Any`, `All`, and `Contains`. They enhance readability, reduce boilerplate, and support efficient data vali
Fabric Data Factory: On-Prems Folder to Fabric SQL Database1/20/2025 9:45:15 AM. In this Data Engineering episode, I covered how to connect to files resident in on-prems folder and transform the data using Factory Data Factory dataflow gen2 and publish to the new SQL Database for
Assigning Sequential IDs to Records in Dataverse Using Power Automate1/18/2025 7:22:06 AM. Learn how to create a Power Automate flow to assign sequential IDs to records in Dataverse. This guide covers setting up triggers, extracting numeric values, incrementing IDs, and ensuring unique IDs
Integrate GPT Models with Azure OpenAI Service1/18/2025 6:33:14 AM. Learn to set up Azure OpenAI Service: create an account, request access, deploy resources, obtain API keys, explore models like GPT-4, integrate via APIs, test, monitor usage, and scale for powerful A
Java Program to Check Whether a Number is a Perfect Square1/15/2025 9:14:30 AM. The topic "Java Program to Check Whether a Number is a Perfect Square" focuses on creating a Java program that checks if a given number is a perfect square. A number is considered a perfect
SQL Server – Query Performance – Database Maintenance can Help1/15/2025 3:19:58 AM. To improve query performance in an ASP.NET MVC application using SQL Server, periodic database maintenance steps like updating statistics and defragmenting indexes are essential. This includes manual
Checking Two Matrices Are Equal in Java or Not1/14/2025 9:58:37 AM. Learn how to compare two matrices in Java by implementing a `Matrix` class to handle creation, input, and comparison. This article covers object-oriented concepts, user input, and array manipulation.
What We Didn't Know About C# 131/14/2025 4:21:39 AM. Ziggy Rafiq shows us how to leverage C# 13's hidden gems, including advanced pattern matching and performance enhancements that allow for faster and more effective development.
Best way of implementing Domain-driven design, Clean Architecture and CQRS1/13/2025 11:58:28 AM. Domain-Driven Design (DDD), Clean Architecture, CQRS, and software design principles emphasize building scalable, maintainable systems. Key concepts include aggregates, events, repositories, and facto
Working with GraphQL API in .NET 8 Using HotChocolate1/13/2025 7:06:02 AM. This article covers setting up a GraphQL server, defining queries and mutations, integrating with .NET 8 applications, and optimizing your API development process. Explore HotChocolate’s features for
Local and Global Temporary Tables in SQL Server1/13/2025 6:55:28 AM. Discover the differences between local and global temporary tables in SQL Server. Learn how to create, use, and manage temporary tables effectively.
Transaction in SQL Server1/13/2025 5:32:43 AM. This article covers the basics of SQL transactions, including BEGIN, COMMIT, and ROLLBACK commands, ACID properties, isolation levels, and error-handling techniques for effective database management.
How to Dockerize Your Django App1/11/2025 6:00:08 AM. This beginner-friendly article teaches you how to Dockerize your Django app. With Docker, you can simplify development, ensure consistency, and optimize deployments.
The Ultimate Guide to Writing NUnit Unit Tests in .NET 91/10/2025 10:54:39 AM. Demonstrates how to write robust and reliable unit tests in .NET 9 using NUnit. This article teaches developers how to write effective unit tests in .NET 9 using NUnit, covering test setup, assertions
A Comprehensive Guide for Enterprise Developers on .NET 91/10/2025 10:21:59 AM. Ziggy Rafiq explains how enterprise developers can leverage high-performance APIs, real-time dashboards, and advanced security features using practical examples and best practices.
Bringing Legacy .NET Framework Applications into the Modern Era1/10/2025 10:21:36 AM. With this guide, you'll learn how to migrate your legacy .NET Framework apps to .NET 9, without refactoring code. It also discusses namespace updates, error handling improvements, and unit testing
Advanced C# 13 and .NET 9 Features for Expert .NET Engineers1/10/2025 10:20:34 AM. With this guide, you will learn about enhanced pattern matching, static abstract members, Native AOT, and much more in C# 13 and .NET 9. Written by Ziggy Rafiq, this is the best resource for experienc
Printing Different Types of Star Patterns in Java with Code1/9/2025 6:36:53 AM. Star pattern programs in Java demonstrate the use of nested loops and control structures, creating shapes like squares, pyramids, diamonds, and hollow squares with illustrative code examples and outpu
Learn =, == and === in Javascript1/7/2025 9:42:30 AM. In JavaScript, =, ==, and === are key operators used for assignment and comparison. = is used for assignment, == checks for equality with type coercion, and === checks for strict equality without type
Azure SQL Database - Configure Job using Elastic Agents1/7/2025 8:41:35 AM. This article covers setting up Elastic Job agents, creating jobs, and automating tasks across multiple databases. Streamline database management, schedule tasks efficiently, and enhance performance wi
Create Database-Scoped Users for Microsoft Entra Security Groups1/6/2025 7:24:39 AM. In modern cloud environments, managing access to databases at scale can be challenging. By integrating Azure SQL with Microsoft Entra (formerly Azure Active Directory) Security Groups, you can streaml
Automate Data Integration from ADLS Gen2 to Snowflake using TASKS1/6/2025 5:34:47 AM. In this end to end data engineering episode, you will learn how to implement automated data integration in Snowflake using TASK.
Database Dictionary (1-2-1) --- Using Dynamic SQL Script1/4/2025 1:53:53 PM. This article will discuss when to use dynamic SQL Script and the conditions.
Moq Unit Testing in .NET Core with xUnit1/3/2025 4:48:33 AM. This guide covers mocking dependencies, setting up test projects, and writing efficient unit tests for your applications. Perfect for developers seeking to enhance their testing skills and build robus
Advanced 4-Level CTEs using Fabric T-SQL Notebook1/2/2025 12:47:52 PM. In this episode, I demonstrated how to author 4-level advanced CTEs query using the new Microsoft Fabric T-SQL Notebook.
How to Set Up DynamoDB in AWS?1/2/2025 7:33:42 AM. Amazon DynamoDB is a fully managed, serverless NoSQL database service offering fast performance, scalability, and flexibility. It supports key-value and document data models, with global availability
Enhancing Application Insights with Serilog and SEQ1/1/2025 5:03:20 AM. In this article, we will learn how to enhance application insights using Serilog and SEQ, two powerful tools for structured logging and real-time log analysis.
A Fix to SQL Server Error 18456 - Login Failed12/31/2024 2:32:42 PM. This article is to discuss A Fix to SQL Server Error 18456 - Login Failed.
Implementing Bubble Sort, Merge Sort, and Quick Sort in Java12/31/2024 9:05:12 AM. This article explains how to implement three popular sorting algorithms—Bubble Sort, Merge Sort, and Quick Sort—in Java. It provides simple, step-by-step explanations for each algorithm, including how
AI_GEN Function in Databricks SQL12/31/2024 5:14:12 AM. This video walks you through how you can use the new ai_gen function in Databricks SQL which leverages on generative AI models to process and respond to to user-provided prompts
Using Derived Column Task in SQL Server Integration Services12/30/2024 4:50:34 AM. The Derived Column Task in SQL Server Integration Services (SSIS) allows you to transform or modify data within your ETL process. It enables the creation of new columns or updates to existing ones usi
Simplify Your Queries With “AutoInclude” In EntityFramework Core12/30/2024 4:22:04 AM. In this article, we will discover how the "AutoInclude" feature in EntityFramework Core simplifies query writing by automatically including related navigation properties.
Displaying All Prime Numbers from 1 to N Using Java with Code12/28/2024 6:12:08 PM. Explore three methods to display prime numbers in Java: Simple Loop, Square Root Optimization, and Sieve of Eratosthenes, with detailed explanations, code examples, and efficiency comparisons for each
How to Set Up and Use AWS RDS for Beginners12/27/2024 9:08:08 AM. Learn how to create an AWS RDS database with this beginner-friendly guide. AWS RDS simplifies database setup and management, supporting engines like MySQL, PostgreSQL, and MariaDB.
Configure SharePoint Site Settings Using Power Automate12/27/2024 4:06:47 AM. This article covers automating site settings configuration, reducing manual tasks, and improving efficiency. With Power Automate workflows, you can manage permissions, update site properties, and auto
Check Armstrong Number in Different Ways Using C#12/26/2024 4:14:41 AM. In this article, we will create a program in C# to check if the entered number is an Armstrong number or not. Explore various methods to check Armstrong numbers in C#, including while loops, for loops
Hello World! In 20 Different Programming Languages12/24/2024 9:01:37 AM. In this article, we are going to see how to print “Hello World” in 20 different programming languages. Explore how to print "Hello, World!" in 20 popular programming languages, showcasing sy
Conditional Split in SQL Services Integration Services (SSIS)12/23/2024 9:16:38 AM. Conditional Split in SQL Server Integration Services (SSIS) allows you to route data based on specific conditions within a data flow. It is used to direct data into different paths, enabling dynamic d
AI Ready Data for Enterprise : Unlocking the Future of Business Intelligence12/23/2024 9:01:23 AM. AI-ready data is crucial for enterprises to leverage AI effectively. It involves ensuring data is accurate, structured, labeled, and scalable, enabling AI models to make data-driven decisions, optimiz
Understanding Parallel.For Method in c#12/23/2024 7:06:33 AM. Parallel.For in C# allows executing loops in parallel, improving performance by utilizing multiple processors or cores. It enhances scalability but introduces overhead and requires thread safety for s
How To Count Occurrence Of Each Character From The String In C#12/21/2024 5:17:41 AM. Learn how to count the occurrence of each character in a string using C#. This guide covers step-by-step instructions to efficiently analyze strings and determine the frequency of individual character
Learn NLog Advanced Usage / Change NLog Configuration Per Request12/20/2024 8:39:38 AM. This article explores implementing dynamic logging in multi-tenant applications using NLog. It discusses configuring NLog to enable debug logging on a per-request basis without modifying existing conf
Printing "Hello, World!" in Java: Different Techniques and Examples12/20/2024 7:04:43 AM. This article explores various methods to print "Hello, World!" in Java, introducing beginners to Java's syntax and structure. Examples include basic output, methods, string variables, an
Create FTP Task in SQL Server Integration Services 12/19/2024 11:18:54 AM. Learn how to create and configure an FTP Task in SQL Server Integration Services (SSIS). This task simplifies automated file transfers using the FTP protocol, making it essential for ETL processes.
SQL Exists: Usage, Syntax, and Examples12/19/2024 4:30:17 AM. The "SQL EXISTS" clause is used to test whether a subquery returns any records. It's commonly used in conditional statements to improve query performance. This article covers the syntax,
Unlocking Faster INSERT Operations in SQL Server with TABLOCK12/17/2024 6:48:30 AM. In this article learn how using the TABLOCK hint in SQL Server can significantly speed up INSERT operations by reducing logging overhead and enabling parallel insertions.
Integrating SQS with Lambda using Event Source Mapping12/16/2024 11:58:06 AM. This setup allows Lambda functions to automatically trigger in response to messages in an SQS queue, providing a serverless, scalable solution for asynchronous processing and efficient message handli
Implementing Background Tasks in Python12/16/2024 10:08:39 AM. This article covers key concepts like concurrency, task queues, and process management, helping you execute time-consuming tasks efficiently without blocking your main program flow.
SQL Server ACID Properties12/16/2024 8:24:34 AM. Understanding SQL Server ACID(Atomicity, Consistency, Isolation, Durability) Properties. This article explains ACID properties—Atomicity, Consistency, Isolation, and Durability—highlighting their impo
SQS Message Polling using C#12/15/2024 5:49:24 AM. This article explores integrating Amazon Simple Queue Service (SQS) with C# applications, covering essential concepts like long polling, receiving messages, and using the AWS SDK for .NET.
Character Occurrence in a String in C#12/13/2024 10:39:55 AM. In this article, I will discuss how to count the number of occurrences of a character in a string in C# with Examples. This article explores various ways to count character occurrences in a string usi
Understanding Responsive Applications12/13/2024 8:47:19 AM. Create seamless responsive applications compatible with all devices. Learn key tips, including viewport meta tags, CSS media queries, grid systems, accessibility, lazy loading, performance testing, an
Bulk Insert Example with Two SQLite DB Files using .NET12/13/2024 5:06:10 AM. Learn how to merge two SQLite databases in C# using bulk insert/update. This method reads data from one DB and updates or inserts it into another, achieving efficient data merging.
Understanding the AI_EXTRACT SQL Function in Databricks12/12/2024 7:17:56 AM. This article dives into the mechanics of AI_EXTRACT, its syntax, and various use cases with examples. AI_EXTRACT in Databricks extracts structured data, like names and dates, from unstructured text us
Modern Featured Entity Framework With SQLite DB Example 12/11/2024 10:31:03 AM. Learn to build a .NET Core application using C# async/await and SQLite with Entity Framework. Implement CRUD operations, handle asynchronous tasks, and explore efficient database interaction using Vis
NATS Message Queue Authentication12/11/2024 8:38:23 AM. How to set Authentication and Authorisation in the NATS Message Queue. Explore NATS authentication techniques, including Username/Password, Tokens, NKEY, JWT, and custom methods. Understand security h
New LINQ Methods in .NET 9: Index, CountBy, and AggregateBy12/11/2024 5:06:01 AM. In this article, I will showcase the new methods: Index, CountBy, and AggregateBy. These powerful additions in .NET 9 bring significant enhancements to LINQ, aimed at improving your coding experience
The Complete Guide to NUnit Testing in C# 13 and .NET 912/10/2024 3:23:37 PM. This comprehensive guide explains NUnit testing in C# 13 with .NET 9 with detailed explanations, modern testing techniques, and practical code examples. Authored by Ziggy Rafiq.
SQLite Database with .NET Example12/10/2024 9:51:01 AM. SQLite is a lightweight, file-based relational database ideal for small web, mobile, and .NET applications. This guide demonstrates SQLite integration, CRUD operations, and database handling using C#.
Automating Table Creation using SSIS12/10/2024 8:44:47 AM. 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 instruct
Real-Time Notifications in Amazon Aurora PostgreSQL12/10/2024 6:46:05 AM. In this article, we are going to learn about Implement real-time notifications (Transactional Outbox Pattern) in Amazon Aurora PostgreSQL
How To Reverse Each Word Of Given String12/9/2024 8:45:57 AM. This article demonstrates how to reverse each word in a string using C#. It provides a simple approach to solving this common interview question, with code examples and explanations.
Understanding Triggers in SQL Server12/9/2024 7:29:47 AM. SQL Server triggers are automated procedures executed on DML/DDL events. This guide explores trigger types, real-world examples, and implementations for logging, validation, and restriction in SQL Ser
Explaining Palindrome Program in C#12/9/2024 6:00:47 AM. In this article, I will discuss the Palindrome Program in C# (Palindrome Number and Palindrome String) with Examples. It includes detailed explanations and practical C# implementations.
Transactional Outbox Pattern12/7/2024 3:35:29 AM. The Transactional Outbox Pattern ensures data consistency in distributed systems by storing events in an outbox table within the database. It simplifies reliable messaging, enabling seamless communica
Token Caching in .NET 8 with Microsoft Entra ID12/7/2024 3:22:18 AM. Learn how to optimize .NET 8 web apps with token caching using Microsoft Entra ID. Discover in-memory and distributed caching strategies to boost performance, reduce latency, and improve scalability i
Rate Limiting In .NET Core12/7/2024 3:18:40 AM. This article explores implementing rate limiting using middleware, configuring policies, and handling scenarios like API throttling. Learn to optimize your applications effectively with ASP.NET Core.
Unit Test (2) --- TSQLT12/7/2024 2:51:50 AM. This article will discuss TSQLT Unit Test.
Stratis Launches Liquid Staking Beta on Auroria Testnet12/6/2024 10:23:22 AM. Stratis is excited to announce that liquid staking on the Stratis blockchain is now available in beta on the Auroria Testnet
INSERT INTO and SELECT INTO: Which is Better?12/6/2024 5:50:06 AM. In this article, we’ll explore the differences between these two methods, their impact on temporary tables, and practical recommendations for SQL developers, data engineers, and DBAs. Using examples f
Palindrome Number in C#12/5/2024 8:28:36 AM. Learn to check if a number is a palindrome in C#. Understand what a palindrome number is and follow a step-by-step guide with code examples to implement it efficiently.
ASP.NET Core CRUD using Dapper, .NET 8 using SQL Server12/5/2024 7:18:42 AM. Learn to build a CRUD (Create, Retrieve, Update, Delete) application in ASP.NET Core MVC using .NET 8 and Dapper ORM. This guide covers creating models, repositories, controllers, and Razor views with
Palindrome String Program in C#12/4/2024 10:58:47 AM. Explore how to determine if a string is a palindrome in C#. Learn the concept and examples, and implement a simple solution to check palindrome strings for interview preparation.
How to Reverse Number in C#12/3/2024 10:21:39 AM. Learn two methods to reverse a number in C#: using arithmetic operations and `string.Reverse()`. This essential C# interview topic is explained with practical code examples and outputs.
How to Reverse a String in C#?12/3/2024 3:52:14 AM. Explore four methods to reverse a string in C#: using string.Reverse(), Array.Reverse(), for loop, and foreach loop. Ideal for interview preparation with practical examples and outputs.
Understanding .http Files in .NET 812/1/2024 5:24:59 AM. Discover how to enhance API testing with Visual Studio's .http file feature. Learn to create and execute HTTP requests directly within the IDE, eliminating the need for external tools like Postman
What is a CTE, and How Do You Write a CTE in SQL Server?11/29/2024 8:23:30 AM. 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 ma
Create A Classic Snake Game Using HTML5 Canvas in 10 Simple Steps11/29/2024 7:12:59 AM. In this article we learn how to create a classic snake game using HTML5 Canvas. HTML5 canvas let's you to draw graphics using JavaScript.
Optimizing Performance in Azure Cosmos DB: Best Practices11/29/2024 5:20:56 AM. Azure Cosmos DB optimization enhances performance, scalability, and cost-efficiency. Key practices include selecting the right partition key, customizing indexing, optimizing queries, tuning consisten

Topics