Related resources for Q#
  • 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.
  • Apache Kafka Without ZooKeeper11/20/2024 4:55:03 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
  • 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
  • BIT Functions New T-SQL Enhancements in SQL Server10/30/2024 5:58:33 AM. In this article, we’ll explore some of BIT functions new enhancements in SQL Server 2022, their practical applications, and a modified example to demonstrate their usage.
  • Integrating OpenAI's Assistant API in .NET Applications10/30/2024 5:41:53 AM. Integrating OpenAI's Assistant API in .NET empowers developers with advanced natural language processing capabilities. Using C# and Visual Studio, set up your project, manage API credentials secur
  • Securing Remote Access to SQL Server10/30/2024 5:39:48 AM. Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protec
  • Windowing Enhancements New T-SQL Enhancement in SQL Server10/29/2024 6:29:27 AM. SQL Server 2022 introduces advanced T-SQL features, enhancing window functions, aggregations, and NULL handling. New options like the WINDOW clause and IGNORE NULLS optimize complex data queries, redu
  • Create a Model with Database Table in .NET 8 using EF Core10/28/2024 7:16:12 AM. This article guides you through creating a data-driven application using .NET 8 and Entity Framework Core. You'll learn to define a model, configure a DbContext, set up a SQL Server connection str
  • Efficient Data Handling in SQL Server with Table-Valued Parameters10/27/2024 5:52:26 AM. This article delves into how TVPs enhance performance by enabling the transfer of multiple rows of data in a single parameter, streamlining stored procedures, and optimizing database operations.
  • Add Multiple Users to SharePoint Group together in one API call10/26/2024 6:33:17 AM. This article outlines how to streamline adding multiple users to a SharePoint Group using Power Automate. By leveraging a single HTTP request, users can efficiently batch add members to a group.
  • Manage Azure SQL Roles with Azure Data Studio10/26/2024 5:43:14 AM. Azure SQL Database is a managed cloud database service enabling secure, scalable applications. With Azure Data Studio, a free, cross-platform tool, database admins can view and manage user roles and p
  • How Select and SelectMany Works in C#10/26/2024 5:05:45 AM. Learn key differences, practical use cases, and examples that demonstrate how these methods simplify data manipulation, making it easier to work with nested and complex data structures in C#.
  • TRIM Function New T-SQL Enhancements in SQL Server10/25/2024 10:44:09 AM. The enhanced TRIM function in SQL Server 2022 adds flexibility for removing unwanted characters in strings, beyond just spaces. Now, developers can use BOTH, LEADING, and TRAILING keywords to trim fro
  • SQL Data Analysis in Databricks Notebook10/25/2024 6:09:40 AM. This video dives into performing SQL Data Analysis in Databricks Notebook.
  • GENERATE_SERIES Function New T-SQL Enhancements in SQL Server10/25/2024 6:06:40 AM. The GENERATE_SERIES function in SQL Server 2022 creates sequences of numbers or dates between specified start and end values, with an optional step. It's beneficial for reporting, filling data gap
  • Domain-first GraphQL API Platforms for Your .NET Stack10/24/2024 12:00:55 PM. In this video, we'll demo how .NET developers can use modern architecture and data storage to build scalable GraphQL APIs for real-time data and AI integration.
  • KEYNOTE - Power of AI and Code Quality and Performance10/24/2024 4:13:34 AM. In this session, you will learn about the Power of AI and Code Quality and Performance.
  • Quality AI Requires Quality Data10/23/2024 8:23:48 AM. This video dives into data quality, with a strong focus on how data is maintained as it moves from transactional to analytic workloads.
  • Redis: RedisString and RedisJSON10/23/2024 8:19:31 AM. RedisString has long been the basic and most common data type in Redis. Recently, RedisJSON has gained popularity as a module that allows you to store, query, and manipulate JSON data natively.
  • ASP.NET Core Middleware10/22/2024 11:57:39 AM. ASP.NET Core Middleware plays a crucial role in the request processing pipeline of web applications. It allows developers to add custom functionalities, such as authentication, logging, and error hand
  • Required Field and Email Validation Using AngularJS10/21/2024 9:39:27 AM. This guide covers key concepts like AngularJS directives, form validation, and custom validators, ensuring user input is properly validated for required fields and email formats, enhancing user experi
  • PAY QR Code Feature: A Guide to Streamlined Vehicle Payments10/21/2024 3:59:37 AM. Discover the innovative PAY QR Code feature that revolutionizes vehicle payments. This guide explores how QR codes streamline transactions, offering a quick, secure, and user-friendly payment solution
  • Azure service bus queue with .net core and python10/20/2024 9:30:13 AM. This article demonstrates how to implement Azure Service Bus queues using both .NET Core and Python. It covers creating a message sender with a web API in .NET Core and a receiver using a console app.
  • Check Constraint in SQL Server 201210/16/2024 9:55:46 AM. A Check Constraint in SQL Server enforces Domain Integrity by ensuring valid values for specific table columns. It restricts invalid data entries, rejects values that don't meet set conditions, an
  • STRING_SPLIT() Ordinal New T-SQL Enhancements in SQL Server10/16/2024 9:01:22 AM. The STRING_SPLIT() function in SQL Server, introduced in 2016, allows for splitting delimited strings into rows. The 2022 enhancement introduces an optional ordinal parameter, enabling retrieval of ea
  • Databricks: Provision and Analyze Azure SQL Database Table10/16/2024 7:38:47 AM. In this video, I covered how to read and analyse Azure SQL Database Table in Databricks Notebook.
  • ' Group By ' with Power Automate10/16/2024 5:52:26 AM. This process involves creating an instant flow to send an email to each user with a table of applications they have created. By listing rows from the "User Application" table, using union an
  • Is PostgreSQL the Future of Databases?10/16/2024 5:00:45 AM. This article explores whether PostgreSQL is the future of databases, highlighting its advantages in scalability, performance, and innovation. Discover how it compares to other database systems in toda
  • Least and Greatest New T-SQL Enhancements in SQL Server10/15/2024 11:42:36 AM. Discover the least and greatest T-SQL enhancements in SQL Server 2022! This article explores the new features and improvements that elevate data manipulation and performance.
  • Write Data from Fabric Dataflow Gen2 to Azure SQL Database10/15/2024 5:16:17 AM. In this new video, I am going to walk you through how to write data from Fabric Dataflow Gen2 to Azure SQL Database.
  • Apply "Go to Bottom" and "Go Up" on Click of Anchors10/14/2024 6:13:08 AM. This article guides you through implementing the Go to Bottom and Go Up functionality in an AngularJS application. Learn how to create a seamless navigation experience in single-page applications usin
  • How To Delete Duplicate Rows From A Table In SQL Server10/12/2024 5:29:23 AM. This guide explains how to delete duplicate rows from a table in SQL Server. Using common techniques like ROW_NUMBER() with PARTITION BY, you can identify and remove duplicate rows while keeping the o
  • Get All Instances of SQL Server in C#10/11/2024 12:29:27 PM. If you're writing a Database Manager application or simply want to retrieve all the instances,this trick might come in handy.
  • Make Divs Editable For User With jQuery10/11/2024 12:28:33 PM. This article outlines a simple method to make a generic DOM element editable, enabling users to modify its internal HTML. By using jQuery, the tutorial demonstrates how to convert a div into a textare
  • DATETRUNC New T-SQL Enhancements in SQL Server10/9/2024 6:48:59 AM. This new feature simplifies date truncation by allowing developers to truncate dates to specific intervals, such as year, month, or day. It improves query performance and data manipulation in SQL.
  • Create Fiscal Year and Aggregate using Power Query M Code10/9/2024 6:28:23 AM. In this Power Query video, I covered how to create fiscal Year and perform aggregation using Power Query M Code.
  • Mastering SQL Query Generation with Azure OpenAI10/9/2024 6:07:40 AM. Leverage Azure OpenAI to transform natural language into SQL queries seamlessly. By integrating Azure OpenAI and Azure SQL Database, you can simplify data querying and enhance accessibility. Learn how
  • Implementing a QR Code Modal for Parking Payment10/9/2024 4:22:38 AM. Implementing a QR Code Modal for Parking Payment streamlines the parking experience by enabling contactless transactions. This approach enhances user convenience, allowing drivers to scan a QR code to
  • Backup And Restore Your Database Using SQL Server Management Studio (Step by Step)10/8/2024 8:54:22 AM. In this article you will learn how to upload your App to Windows Store (Step by Step), backup and restore your database using SQL Server Management Studio (Step by Step).
  • How To Send Mail Using SQL Server: Part 210/8/2024 8:32:47 AM. This tutorial demonstrates how to send emails using SQL Server 2008. It covers configuring an email profile, selecting data from a student table (tblStudents), and binding that data to an HTML-formatt
  • Make AJAX Call and Return JSON Using AngularJS10/8/2024 4:05:12 AM. Learn how to make AJAX calls and handle JSON data using AngularJS in this comprehensive guide. We'll cover how to use the $http service for asynchronous requests, manage responses, and integrate A
  • Read Multiple PARQUET Files from GCS to Azure SQL Database using Azure Data Factory10/7/2024 4:56:25 AM. In this Data Engineering episode, I covered how to read multiple sales parquet files resident in Google Cloud Storage to Azure SQL Database leveraging Azure Data Factory.
  • Exploring Aggregate Functions in Azure Cosmos DB10/7/2024 4:43:48 AM. Aggregate functions in Cosmos DB allow efficient data summarization and analysis across multiple documents. They perform calculations such as AVG, COUNT, SUM, MAX, and MIN to retrieve meaningful insig
  • DATE_BUCKET Function New T-SQL Enhancements in SQL Server10/5/2024 6:28:43 AM. This article will delve into the DATE_BUCKET function, its syntax, and its practical use cases using the AdventureWorks2022 sample database. We’ll also compare DATE_BUCKET with other similar T-SQL fun
  • IS [NOT] DISTINCT FROM New T-SQL Enhancements in SQL Server10/4/2024 6:15:00 AM. The "IS [NOT] DISTINCT FROM" operator is one of the key new T-SQL enhancements in SQL Server 2023. It simplifies SQL queries by handling NULL comparisons more efficiently, improving data int
  • A Fix To PolyBase Issue In SQL Server 2019 Developer Edition10/3/2024 1:16:46 PM. This article will introduce the problem, the reason and the fix related to a PolyBase issue when installing the SQL Server Developer Edition 2019.
  • Rich Text Control With Image And Video In SPFx Using React-Quill10/3/2024 11:49:18 AM. This article explores how to implement a rich text field in Modern SharePoint List forms using React Quill. It covers the process of creating a SharePoint list, setting up an SPFx solution, and integr
  • Generate or find Connection String from Visual Studio10/3/2024 11:44:59 AM. This guide covers various methods, including using the Connection String Builder, accessing app.config and web.config files, and integrating with SQL Server and Entity Framework. Mastering connection
  • NTile Function in SQL Server10/3/2024 11:44:37 AM. The NTile function in SQL Server divides a result set into a specified number of groups, assigning ranks to records within each group. Unlike Dense_Rank, NTile focuses on groups rather than individual
  • Creating Stored Procedures with Managed Code10/3/2024 11:41:01 AM. This article demonstrates how to create a stored procedure in Microsoft SQL Server 2005 using managed code in C#. It details the process of setting up a SQL Server project in Visual Studio, writing th
  • Introduction to JQuery.ajax Call in ASP.Net10/3/2024 11:39:42 AM. This article provides a comprehensive introduction to making AJAX calls using jQuery in ASP.NET applications. It covers the fundamentals of jQuery's AJAX methods, including how to send asynchronou
  • jQuery UI Method - Part 110/3/2024 11:37:03 AM. This article explores jQuery's interaction methods, focusing on the sortable() method, which allows users to reorder HTML elements in lists or grids using the mouse. It covers syntax options like
  • Search Records Between Two Dates Using Stored Procedure And Entity Framework In ASP.NET MVC10/3/2024 11:32:18 AM. In this article, we will learn to write and execute a SQL stored procedure, pass parameters for date filtering, and retrieve results in an efficient and structured manner.
  • Bootstrap For Beginners - Part Two (Bootstrap Containers) 10/3/2024 11:31:45 AM. This article explores Bootstrap containers, focusing on the two main classes: .container for a responsive fixed-width layout and .container-fluid for a full-width layout. It provides practical example
  • How to Use a Cursor in SQL?10/3/2024 11:08:13 AM. A cursor in SQL is a database object that allows row-by-row processing of query results. It enables you to iterate through a result set, perform operations on each row, and manage data more efficientl
  • Integrate Azure AD OAuth2 SSO Authentication RBAC for AKHQ Kafka-UI10/3/2024 10:58:48 AM. This content explores the integration of Azure Active Directory (Azure AD), OAuth2, and Single Sign-On (SSO) for authentication, along with Role-Based Access Control (RBAC) for authorization, specific
  • Learning Priority Queue in Python10/3/2024 10:06:45 AM. A Priority Queue in Python can be implemented using the heapq module, which provides efficient min-heap operations like heappush, heappop, and heapreplace. Unlike a regular queue, a priority queue pro
  • How to Compare Two Objects in C#10/3/2024 7:08:40 AM. In this article, we’ll walk through how to create a generic method that can compare the objects of any class, even those with nested collections. We’ll break it down step by step so you can implement
  • Enhance Search with Azure SQL DB FAISS and Hugging Face Model10/3/2024 6:32:45 AM. In this article, learn how to enhance search capabilities by integrating Azure SQL Database, FAISS, and Hugging Face models. We’ll walk through querying data, generating embeddings using the 'all-
  • Hidden Gems - Adding the Custom Data to Generative Answers10/3/2024 4:17:34 AM. Learn how to input a string variable as custom data for the Generative Answers component in Copilot Studio. Overcome challenges like binding errors and formatting issues by converting large text into
  • Database, Data Warehouse, and Data Lake: A Comparative Analysis10/2/2024 4:49:26 AM. Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
  • Create Year Quarter Month Drill Down With Proper Sort Order In Power BI10/1/2024 9:15:37 AM. This article guides you through achieving Year-Qty-Month drill-down functionality in Power BI, even without a Date column in your dataset. Learn to create a duplicate Month column, generate a SortNumb
  • Display And Sort A Slicer Control By Month Or Quarter Name In Power BI10/1/2024 9:15:10 AM. Discover step-by-step techniques to enhance data visualization and user interaction. By utilizing DAX and built-in features, you'll create a more intuitive reporting experience, allowing users to
  • Implementing Modal Popup In MVC Application10/1/2024 8:23:35 AM. Learn how to implement a modal popup in an MVC application to enhance user interaction and improve UI/UX design. This guide covers the necessary steps, including setting up the HTML structure, using J
  • SQL Vs DAX: Calculating Total Sales & COGS using SQL and DAX10/1/2024 6:54:09 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.
  • Types of Keys in SQL10/1/2024 6:09:16 AM. In SQL, keys play a crucial role in maintaining data integrity and defining relationships between tables. Common types include the Primary Key, which uniquely identifies records; the Foreign Key, link
  • A Detailed Explanation of COUNT in SQL Server10/1/2024 5:10:59 AM. This article explores the differences between SQL counting methods: COUNT(*), COUNT(1), COUNT(column_name), and COUNT(DISTINCT column_name). It highlights their purposes, performance considerations, a
  • Insert Master-Detail Data using Transact-SQL10/1/2024 4:54:39 AM. This document explains how to utilize SQLXML in SQL Server 2000 for efficient batch operations with XML data. It outlines the process for creating stored procedures to insert, update, and delete recor
  • Web Based Game Using JavaScript10/1/2024 4:50:21 AM. In this article, you'll learn how to create a simple web-based game, "Catch My Santa," using HTML, CSS, JavaScript, and jQuery. The game features a 3x3 grid where players must tap on box
  • Longest Consecutive Sequence in Array10/1/2024 4:27:13 AM. The "Longest Consecutive Sequence in Array" problem involves finding the longest sequence of consecutive integers in an unsorted array. This challenge can be efficiently solved using algorit
  • Explaning Joins in Azure Cosmos DB 9/30/2024 8:45:05 AM. Azure Cosmos DB enables seamless querying using SQL-like syntax, allowing joins within JSON documents. This feature facilitates data retrieval from arrays and nested objects within a single container,
  • How to Decide Between Relational Database and NoSQL Databases?9/30/2024 7:12:38 AM. Choosing between relational databases and NoSQL databases involves understanding their key differences, strengths, and weaknesses. Relational databases excel in structured data and ACID compliance, ma
  • Rank and Dense_Rank Function in SQL Server9/30/2024 4:48:24 AM. RANK and DENSE_RANK functions in SQL Server assign sequential numbers to rows based on ordering. RANK skips numbers for ties, while DENSE_RANK does not. Both can partition results using the PARTITION