Q# Resources

Share

Related resources for Q#

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.
Printing "Hello, World!" in C#: Different Techniques and Examples12/29/2024 6:13:44 AM. Learn various techniques to print "Hello, World!" in C#, including Console.WriteLine, string variables, string interpolation, static constructors, LINQ, and asynchronous programming, enhanci
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
Best way of implementing Domain-driven design, Clean Architecture and CQRS12/28/2024 12:20:51 PM. This tutorial will help you to understand how to implement Domain-driven design, Clean Architecture and CQRS in C# applications
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.
Learn =, == and === in Javascript12/9/2024 5:53:56 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
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
Implement Databricks Lakehouse Federation (BigQuery)11/29/2024 4:42:00 AM. In this new video, I covered how to implement and run federated queries federated queries on Google BigQuery.
C# Foundation - Implicitly Typed Variables11/28/2024 6:08:47 AM. Implicitly typed variables in C#, declared using the var keyword, let the compiler infer the data type from the initialization expression. This improves code readability and reduces verbosity, especia
Learning SEQUENCE in SQL Server11/28/2024 6:02:51 AM. A SEQUENCE in SQL Server is a user-defined object that generates a sequence of numeric values in a specified order. Unlike identity columns, SEQUENCE objects are independent of tables, offering flexib
Create On Demand Job in AWS11/27/2024 10:40:23 AM. This architecture integrates AWS Lambda, API Gateway, SQS, and S3 to process on-demand jobs. API Gateway triggers Lambda functions via REST API, Lambda processes jobs, polls messages from an SQS queue
Explaining CTE in SQL Server11/27/2024 8:21:27 AM. Common Table Expressions (CTEs) in SQL simplify complex queries by creating temporary result sets. They can be used in SELECT, INSERT, UPDATE, and DELETE statements, supporting scenarios like hierarch
Renaming a Database in SQL Server11/27/2024 5:11:47 AM. Renaming a database in SQL Server is vital for tasks like aligning naming conventions, testing, or version control. It involves setting the database to single-user mode, ensuring no active connections
Using ROLLUP and CUBE with Spark in Microsoft Fabric11/26/2024 10:30:55 AM. In this article, we will Discover how these SQL features can help generate hierarchical summaries, enhance data insights, and improve reporting in big data environments.
Format Literal Strings in C#11/26/2024 10:10:49 AM. Different techniques to display special characters and add different types of formatting to the output. This article explores C# string literals, including regular, verbatim, and interpolated strings,
Rank Functions in SQL server11/26/2024 6:44:08 AM. In this article, we will learn about Rank functions in SQL Server, like RANK(), DENSE_RANK(), ROW_NUMBER(), and NTILE(), are used to assign rankings to rows within a result set.
JSON Data Handling in SQL Server11/26/2024 4:58:34 AM. SQL Server supports JSON for managing semi-structured data. You can store JSON in NVARCHAR(MAX) columns, parse it with JSON_VALUE, JSON_QUERY, and OPENJSON, and modify it using JSON_MODIFY.
Apache Kafka Without ZooKeeper11/25/2024 9:06:11 AM. Apache Kafka Without ZooKeeper employs the KRaft protocol (KIP 500), replacing ZooKeeper for metadata management. This enables simplified deployment, enhanced reliability, and native support for Kafka
How to Use Markdown to Format Power Automate Approval Requests11/25/2024 5:52:24 AM. This guide explains how to create visually appealing and well-structured emails, improving clarity and user experience in approval workflows. Customize your emails with ease using HTML.
Quick Summary of Microsoft Ignite 2024 with Copilot Studio11/25/2024 5:07:57 AM. Discover key announcements, innovative AI tools, and productivity features that are transforming the Microsoft ecosystem. Explore how Copilot Studio empowers developers and businesses to achieve more
How to incrementally load data from Microsoft Fabric Lakehouse to Warehouse11/25/2024 5:00:00 AM. In this end-to-end data engineering episode, I demonstrated how to incrementally load data from Microsoft Fabric Lakehouse to Warehouse using Dataflow and Data Pipeline.
New Features in SQL Server 2025: A Guide for Data Engineers11/24/2024 5:46:37 AM. SQL Server 2025 introduces advanced AI integration, vector support, and performance upgrades like optimized locking and enhanced columnstore indexing. New features include JSON data type, regular expr
Data Cleansing in SQL Server11/24/2024 5:13:36 AM. Learn the essentials of Data Cleansing in SQL Server to enhance data quality and reliability. This guide covers techniques like removing duplicates, handling null values, standardizing formats, and tr
Exploring SQL Databases in Microsoft Fabric11/22/2024 11:29:28 AM. Microsoft Fabric now integrates SQL databases, bridging transactional and analytical workloads in a unified platform. It enables cloud-native data storage in OneLake, supporting Parquet and Delta form
Comparison Between SQL and MongoDB Database11/22/2024 5:23:46 AM. SQL and NoSQL(MONGO) DB Comparison. This article compares MS SQL Server and MongoDB, highlighting their development, data models, schemas, performance, and query mechanisms, aiding in understanding th
Webgrid and Gridview in ASP.NET Core and .NET Core Explained11/21/2024 11:10:24 AM. Learn dynamic paging and sorting in .NET Core using JavaScript and jQuery. Modify URLs with query strings for seamless server interaction, leveraging Bootstrap for responsive design and intuitive user
User-Defined Functions in SQL Server11/21/2024 5:14:12 AM. 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 valu
Satya Nadella Unveils AI Innovations at Microsoft Ignite 202411/21/2024 4:43:15 AM. Satya Nadella's keynote at Microsoft Ignite 2024 showcased AI's transformative impact on business, security, and innovation. Highlights included Copilot, AI agents, Azure AI Foundry, Quantum C
.NET 9 CountBy: A New LINQ Powerhouse11/20/2024 7:19:31 AM. .NET 9 introduces the CountBy method, a powerful addition to LINQ that enhances querying capabilities. This feature allows developers to count elements based on specified conditions efficiently.
Temporary Tables vs Table Variables in SQL Server Explained11/19/2024 10:49:20 AM. This article explores their key distinctions, advantages, and ideal applications, helping users understand when to use each for better query performance and resource optimization.
Unlocking the Power of the SELECT Feature in SQL Server11/18/2024 12:04:57 PM. This article explores the basics of the SQL Server SELECT statement, demonstrating how to query data from tables using practical examples. Learn how to fetch specific columns, improve query performanc
Types of APIs and Essential API Testing Tools11/18/2024 8:41:55 AM. Learn about essential API testing tools such as Postman, SoapUI, and JMeter, which help ensure the functionality, performance, and security of APIs through effective testing and automation.
How to Identify the Owner of a Microsoft Form11/18/2024 5:24:35 AM. This article provides a step-by-step guide to help you find the owner of a form using MS Form responses. For one of our clients, we needed to transfer all Microsoft Forms from individual users to a se
Enhance SQL Server Stored Procedure Performance – Tuning Tips11/18/2024 3:51:42 AM. Covering indexes and filtered indexes in SQL optimize database performance by efficiently retrieving data for queries. Covering indexes include all needed columns, while filtered indexes target specif
Data Professionals to LLM/GPT Prompting for Everyday Tasks11/17/2024 10:52:39 AM. A guide for data professionals on leveraging Microsoft OpenAI with Python for efficient workflows and enhanced data analysis. Focuses on prompt design, including clear instructions, context, and tempe
Data Quality, Security, and Building Trust in AI11/15/2024 5:14:14 AM. As AI adoption grows, data quality, security, privacy, and trust are becoming critical. Organizations must prioritize data cleansing, validation, encryption, and access controls to ensure reliable AI
Understanding IEnumerable In C#11/14/2024 5:49:01 AM. IEnumerable in C# is an interface that defines a standard way to iterate over a collection of objects. The IEnumerable interface in C# provides a standard, efficient way to iterate over collections us
🚀 Unlock Your Coding Potential with Amazon Q: AWS’s New AI Coding Assistant! 🚀11/13/2024 7:02:38 AM. If you are looking to enhance your coding workflow, check out Amazon Q. This AI-Powered coding assistant helps simplify coding with features like Code Understanding, Code Generation, Refactoring and T
Beginner's Guide to CRUD Operations in .NET Core 8 Web API11/12/2024 7:30:14 AM. This guide walks you through creating a .NET Core 8 Web API for managing employee data with full CRUD operations. Using Entity Framework Core, you’ll define models, connect to a SQL database, create e
RxJS Operator Essentials: Map, Tap, Filter, and More11/12/2024 5:15:13 AM. This article explores key RxJS operators in Angular, like map, tap, filter, take, and takeLast. You'll learn how each operator manipulates data streams to handle emitted values, log information, a
SSRS (4) --- SQL Server Database Project in Visual Studio11/11/2024 8:37:33 PM. This article is to discuss: SQL Server Database Project in Visual Studio
Difference Between =, == And === In JavaScript11/10/2024 4:30:41 AM. In this article I am going to explain what is difference between =, == and === in JavaScript.
Everything you need to know about QuickGrid in Blazor11/9/2024 6:21:07 AM. This guide covers the basics of setting up QuickGrid, customizing columns, and optimizing performance in Blazor projects. Perfect for developers seeking a simple, powerful grid component for their Bla
Hacking MySQL for Big Data11/8/2024 11:14:47 AM. In this video, we will go through the things that make MySQL & its counterparts capable of performing well on bigger data sets.
Integrate MySQL and Snowflake for Real-Time Insights11/8/2024 4:38:58 AM. This guide covers migrating data from MySQL to Snowflake, highlighting two methods: using Estuary Flow for real-time data sync with minimal setup, and a manual CSV export/import for smaller datasets o
Code Reviews to Eliminate Common Anti-Patterns11/7/2024 9:52:19 AM. Enhancing software quality by avoiding antipatterns in code reviews that cover antipatterns in the Input Kludge, Magic Pushbutton, Encapsulation Violation, Anemic Domain Model, and
Data Fetching Unleashed: Next.js, React Query and their BFF11/6/2024 11:37:01 AM. This video explores the intersection of Next.js, React Query, and the Backend for Frontend (BFF) design pattern, three vital elements pieces that help solve the puzzle of performant and scalable data
Understanding Distributed and Monolithic SQL Architectures11/5/2024 10:01:52 AM. In this article, we explore the key differences between distributed and monolithic SQL architectures. We delve into their respective advantages and disadvantages, focusing on scalability, performance,
Managing User Data in Azure AD with Microsoft Graph API11/5/2024 5:47:57 AM. Microsoft Graph API is a RESTful web API that provides access to Microsoft 365 services, enabling developers to manage user data in Azure Active Directory. It allows operations such as retrieving, cre
Exploring the New T-SQL Enhancements in SQL Server 202211/5/2024 5:39:41 AM. In this article we will explore the powerful new T-SQL enhancements in SQL Server 2022, including features like DATE_BUCKET, DATETRUNC, and IS DISTINCT FROM, designed to simplify data handling and opt
Creating a CQRS Architecture in .NET Core 811/4/2024 7:29:08 AM. This guide outlines a practical implementation of the CQRS (Command Query Responsibility Segregation) architecture using C# and MediatR, emphasizing the separation of read and write operations for bet
Creating Azure SQL Database with Tables11/4/2024 4:59:13 AM. In this video, I demo how to create Azure SQL database, create and insert records into the table, and query the data.
Sitecore Pipeline to add rel="noopener noreferrer" to a General Link11/2/2024 4:09:54 AM. This guide explores how to utilize the Sitecore pipeline to efficiently add the rel="noopener noreferrer" attribute to general links. This attribute enhances security by preventing potential
Implement a RAG Solution Using Azure SQL Database11/1/2024 11:03:43 PM. In this brief video I walk you through the components of retrieval augmented generation (RAG). I talk about embeddings and vectors and even show you how they are created. Finally, I'll show you

Topics