Resources  
  • Temporary Tables vs Common Table Expressions in SQL ServerMar 29, 2024. In this article, we will learn what is Differences Between Temporary Tables and Common Table Expressions in SQL Server. Temporary tables and Common Table Expressions (CTEs) are SQL Server tools for data manipulation.
  • What is Language Integrated Query in C#?Mar 29, 2024. Know about LINQ (Language Integrated Query) in C# and their benefits. In this article, we have explained LINQ with an example.
  • How Do You Implement Number Localization in Vue.jsMar 28, 2024. In Vue.js applications, number localization ensures numerical data aligns with users' language and region preferences. Utilizing the Intl.NumberFormat API, Vue components dynamically format numbers for a culturally sensitive user experience.
  • Visual Studio 2022 IntelliSense Hover not Working ProblemMar 26, 2024. VS 2022 extensions can interfere with the IntelliSense Hover functionality. Fix Visual Studio 2022 IntelliSense Hover not working by uninstalling the problematic extension causing the issue.
  • Deletion of Record using Power Shell Script with FetchXML Query in D365Mar 23, 2024. Deletion of Contact Record using Power Shell Script with FetchXML Query in D365
  • History and Evolution of Visual Studio and Supported .NET VersionsMar 22, 2024. This article gives a Brief overview of Visual Studio's evolution and its significance in software development. Description of each major version of Visual Studio from 1997 to 2022, highlighting key features, enhancements, and updates introduced in each release.
  • Deploying Web Apps and APIs with Visual Studio Mar 22, 2024. Deploying Web Apps and APIs with Visual Studio involves utilizing Visual Studio's built-in deployment features to efficiently publish your applications. You can configure various settings such as publishing method, target location, exclusion of specific files or folders, and launch preferences.
  • Important PySpark Import StatementsMar 21, 2024. PySpark, the Python API for Apache Spark, has gained immense popularity for its ability to handle big data processing tasks efficiently. In this article, we'll explore the top five import statements in PySpark and delve into their significance in building robust data processing pipelines.
  • Configuring Git in Azure Data Studio for SQL & Synapse PoolsMar 21, 2024. In this article, we'll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio.
  • Introduction to Line Charts in Power AppsMar 21, 2024. Explore the power of line charts in Power Apps for visualizing SharePoint list data trends efficiently. Learn about their benefits, such as intuitive representation and dynamic data analysis, along with features like customization and interactivity.
  • Exploring Inter-Process Communication in WPF Using Named PipesMar 19, 2024. In a WPF application, inter-process connectivity typically involves communication between different components or modules within the same application or between separate WPF applications running on the same system or across different systems.
  • Deploying a Windows Server Virtual Machine in Microsoft Azure Mar 17, 2024. To deploy a Windows Server Virtual Machine (VM) in Microsoft Azure, you'll configure various settings to create your virtual environment.
  • Exploring Blackbox AI Code Generation, Code Chat, and Code Search for VS CodeMar 15, 2024. Discover the latest enhancements in Visual Studio Code (VS Code) with Blackbox AI Code Generation, Code Chat, and Code Search features. Boost productivity, streamline collaboration, and navigate code effortlessly within the familiar VS Code environment.
  • How to Install Configure VPN on Windows ServerMar 14, 2024. This detailed guide offers step-by-step instructions on how to set up a VPN on Windows Server. Learn to set up a VPN on Windows Server 2019 efficiently. Understand the server's dual roles: client and host. Follow clear steps for installation and configuration. Simplify remote access and enhance security.
  • Managing Storage Spaces with File Server Resource Manager (FSRM)Mar 13, 2024. FSRM has key features to provide control over your storage space. I cover topics such as Quota Management and File Screening Management in this article.
  • Creating Users and Groups Within an Organizational Unit on Windows ServerMar 12, 2024. Active Directory Users and Computers is a common tool used by administrators to manage objects in an Active Directory domain.  
  • Complete Guide to Install Elasticsearch and Kibana on WindowsMar 12, 2024. In this article, I will provide a detailed, step-by-step guide on setting up Elasticsearch and Kibana on a Windows system. We'll begin by downloading the necessary files, and then proceed to installation and configuration on your local machine.
  • Installing File Server Resource Manager on Windows ServerMar 11, 2024. In this article, we will learn File Server Resource Manager (FSRM) is a role service in Windows Server that allows you to manage and control the data stored on your file servers. FSRM helps you to classify files, set quotas on folders, and create reports monitoring storage usage.
  • A Seamless Debugging Experience with Source Link in .NET 8Mar 11, 2024. Discover how to enhance your debugging experience in .NET 8 with Source Link, authored by Ziggy Rafiq. This article guides about the efficient use of Source Link for debugging, providing invaluable insights for software developers. With this authoritative resource, you can master the intricacies of debugging in .NET 8.
  • Benefits of Temporary Tables over Table Variables in SQL ServerMar 10, 2024. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handling large datasets and complex data manipulation tasks.
  • Leveraging Compiled Queries for Enhanced Performance in LINQMar 09, 2024. Compiled queries in LINQ allow developers to pre-compile LINQ queries into executable delegates, reducing the overhead of query compilation and optimization. By caching the compiled query execution plan, compiled queries improve the performance of frequently executed or complex queries in C# applications.
  • Migrating ASP.NET Apps to Containers #2: Windows FontsMar 06, 2024. This post delves into challenges faced during the migration of ASP.NET apps from Windows to Linux Docker containers. It specifically addresses the complexities associated with Windows Fonts in this migration process.
  • Understanding FORMATMESSAGE() Function in SQL ServerMar 06, 2024. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • How to Do Distributed File System (DFS) In ServerMar 04, 2024. In this article, we will learn a distributed File System (DFS) as the name suggests, is a file system that is distributed on multiple file servers or multiple locations.
  • SQL Tuning - Effective Strategies with Practical ExamplesMar 03, 2024. SQL Tuning — Effective Strategies with Practical Examples
  • How to Do Zone Transfer in Windows ServerMar 01, 2024. Zone transfer is a crucial process for synchronizing DNS zone data across multiple servers, ensuring all DNS servers responsible for a domain remain updated with the latest information. By following the step-by-step instructions outlined in the article, users can configure zone transfer between primary and secondary DNS servers effectively.
  • Implement and Configure Windows Defender Application Control (WDAC)Mar 01, 2024. Windows Defender Application Control is a security software application designed to protect devices, from malware and other harmful software. Its main purpose is to allow trusted applications to run on PCs.
  • Create Auto-Numbering in Microsoft Dynamics 365 EntitiesFeb 29, 2024. Automate entity numbering effortlessly in Microsoft Dynamics 365 with no code required. Utilize system settings, business rules, and workflow automation to generate unique serial numbers for records, enhancing data management and streamlining processes.
  • Print Output of First n Natural Numbers in UI Screen in Unity 3Feb 28, 2024. To print the output of the first 'n' natural numbers on the UI screen in Unity 3, you can create a simple script and attach it to a Text UI element.
  • [Solved]: Permission to send an SMS has not been enabled for the region indicated by the 'To' number in TwilioFeb 28, 2024. In this article, we will see how to resolve the Twilio error: Permission to send an SMS has not been enabled for the region indicated by the 'To' number in C#
  • Quick SQL Refresher Feb 28, 2024. The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, exception handling, indexes, views, stored procedures, transaction control, triggers, and cursors.
  • How to Install WDS in Server?Feb 26, 2024. This article provides a comprehensive guide on installing Windows Deployment Services (WDS) on Server 2019, detailing each step in the process.
  • Creating a Personalized Waiting Window in .NET 6, 7, 8 WPFFeb 26, 2024. A custom loader in a WPF (Windows Presentation Foundation) .Net 6,7,8 application serves the purpose of indicating to the user that the application is performing a task or operation that may take some time to complete.
  • Clustered Column Chart in Power BIFeb 23, 2024. A clustered column chart in Power BI will allow easy customization and formatting. Users can adjust the colors, labels, and axes to better suit their needs and preferences.
  • Installing and Configuring XAMPP on Windows 11Feb 20, 2024. This article provides a comprehensive guide on installing XAMPP, the popular PHP development environment, on Windows 10/11. XAMPP includes Apache, MySQL, PHP, and Perl, making it a convenient solution for local development.
  • Mobile Number Validation Using Angular and BootstrapFeb 19, 2024. This article illustrates the implementation steps for 10-digit mobile number validation in an Angular app using reactive forms and Angular's phone number validation pattern. It guides us through setting up the reactive forms module
  • How to Do Work Folder in Windows Server?Feb 19, 2024. Work Folders in Windows Server 2019 enable seamless synchronization of user files between devices, ensuring access to up-to-date data. Administrators can set up and manage Work Folders via Group Policy and Active Directory.
  • How to Manage Drive Space with Storage Sense in Windows 11?Feb 16, 2024. Storage Sense can automatically free up drive space for you by getting rid of items that you don't need, like temporary files and items in your Recycle Bin.
  • Create Card Visualizations in Microsoft Fabric Power BIFeb 14, 2024. If you want to display the KPIs in the dashboard, you need a Card visual. I am going to show you how to use card visual in Microsoft Power BI
  • Analyzing Image Moderation using Azure Content SafetyFeb 13, 2024. At the end of the article readers will able to understand and implement the usage of Content safety studio with moderating image contents in real time scenarios.
  • SharePoint Online List JSON View Formatting - Video ThumbnailFeb 13, 2024. Customizing YouTube video thumbnails in SharePoint lists enhances visual appeal and user experience. By creating a list with specific columns and using JSON formatting, you can display thumbnails along with details like titles and descriptions.
  • Use .http files in Visual StudioFeb 13, 2024. In Visual Studio, .http files enable direct API testing within the IDE from Visual Studio 2019 onwards. Before this, developers relied on tools like Postman or Swagger, or unit testing. These files streamline API testing by allowing requests.
  • Getting started with Azure OpenAI GPT Modules and Azure OpenAIFeb 13, 2024. In this module, we will be learning about modules in Azure Openai prompt engineering techniques and getting started with Azure Openai Studio.
  • Analysis of T-SQL and PL/SQLFeb 12, 2024. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for efficient database application development.
  • Local Temp Tables, Global Temp Tables, Table Variables, and CTEs ComparisonFeb 12, 2024. In SQL database management, optimizing data storage is vital for efficient query execution. Local and global temporary tables, table variables, and CTEs are versatile options for temporary data storage, each with distinct use cases.
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor Feb 11, 2024. Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations, and recent user experience enhancements for streamlined stream processing logic.
  • The Amazing Adventure of MongoDB QueriesFeb 09, 2024. This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, execution as detective work, utilizing the Aggregation Framework for complex queries.
  • PowerApps Dropdown / ComboBox with ImageFeb 09, 2024. Create visually enriched PowerApps Dropdown/ComboBox with images. Enhance the user experience by incorporating thumbnails or icons alongside selectable options, leveraging data binding and custom templates for seamless integration.
  • Supported File Types for Data Ingestion into KQL Database in FabricFeb 06, 2024. This article is about Understanding the Supported File Types for Data Ingestion into the KQL Database in Fabric Real-time Analytics. Supported file types include JSON, CSV, XML, & Text. Note: XLSX is not supported. See how to ingest & transform data using Data Factory.
  • Mastering T-SQL Rank FunctionsFeb 06, 2024. SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential numbers, RANK assigns unique ranks allowing ties
  • Build Interactive Map Visual in Power BIFeb 05, 2024. Unleash the power of geospatial data in Power BI by creating interactive maps. Transform raw data into compelling narratives, track sales, visualize demographics, and engage your audience with filters, drillthroughs, and storytelling bookmarks.
  • How to Do Account Lockout Policy on ServerFeb 05, 2024. An account lockout policy disables a user account if an incorrect password is entered a specified number of times over a specified period.
  • SQL Joins for Efficient Database QueriesFeb 05, 2024. Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data retrieval.
  • Deploying a .NET MVC App on Azure App ServicesFeb 05, 2024. Deploy an Asp.Net 8 MVC application on Azure App Services using Visual Studio. Learn to create app services, configure settings, and publish the project, making it .
  • How to Create Folder Redirection on ServerFeb 05, 2024. Under Microsoft Windows, the redirection is often performed by Group Policy, when used in an Active Directory environment. It can also be performed by manually editing the Windows Registry, changing library locations, or with tools such as Tweak UI. Disk quotas can be used to limit the amount of space taken up by users' special folders.
  • Perform CRUD Operations in Dynamics CRM Using PowerShellFeb 05, 2024. In this article, we will discuss how to perform CRUD operations in Dynamics CRM using Powershell. In this article, we will explore the potential of PowerShell in Dynamics CRM for seamless CRUD operations. Learn to connect, create, retrieve, update, and delete records, enhancing automation across various business processes for increased efficiency.
  • Implementation of Collection View in .NET MAUIFeb 02, 2024. In this article, I will explain MAUI Collection View implementation using Visual Studio 2022. .NET MAUI Collection View is a view for presenting lists of data using different layout specifications. Collection View should be used for presenting lists of data that require scrolling or selection.
  • Creating Your First GUI with TkinterFeb 01, 2024. This beginner-friendly article will guide you through the basics of Tkinter, showing you how to create a simple, interactive window.
  • Optimize SQL Database PerformanceFeb 01, 2024. "Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases. for optimize SQL database performance, ensuring faster queries, reduced resource consumption, and improved overall database responsiveness.
  • Using CoPilot in VS Code to Rocketship Your Coding - Part 1Jan 31, 2024. Welcome to the era of efficient and productive coding with GitHub Copilot in Visual Studio Code (VS Code). That's exactly what CoPilot brings to the table. By analyzing your code and context, it provides accurate and relevant suggestions to help you write high-quality code with ease.
  • Command Line Arguments in C ProgrammingJan 30, 2024. Programming can be powerfully customized with command line options without requiring changes to the code. In this article, we will learn how command line arguments in C programming empower users to modify a program's behavior, providing flexibility and adaptability without altering the source code.
  • Visual Studio Feature: Convert JSON or XML to ClassesJan 30, 2024. In this article, I will demonstrate how to use the Visual Studio feature Paste JSON as Classes or XML as Classes. This feature was introduced in Visual Studio 2013. This compelling feature will help the developer convert JSON to a C# class or XML to a C# class.
  • Import Power BI Visual from AppSource to Your WorkspaceJan 24, 2024. Power BI comes with many out-of-the-box visuals that are available in the Visualizations pane. Discover how to enhance your Power BI reports with certified visuals from AppSource. Learn the step-by-step process to import and add these visuals to your reports in Power BI Desktop or Service.
  • How to Lock Windows 11 PC Automatically when you're AwayJan 24, 2024. Windows 11's Dynamic Lock feature automatically locks your device when you step away.
  • How to Create Virtual Machine in Azure PortalJan 23, 2024. Azure virtual machines (VMs) can be created through the Azure portal. This method provides a browser-based user interface to create VMs and their associated resources. This quickstart shows you how to use the Azure portal to deploy a virtual machine (VM) in Azure that runs Windows Server 2019.
  • Visualizing Data with Style: Pie and Stacked Line Charts in PygalJan 23, 2024. This article is tailored to guide you through creating two distinct types of charts: the Pie Chart and the Stacked Line Chart.
  • Create and View Decomposition Tree Visuals in Power BIJan 23, 2024. The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order.
  • The Term Oh-My-Posh Is Not Recognized as a Name of CmdletJan 22, 2024. This article explains how to set up oh-my-posh on Windows PCs. From the references, the steps can be found to implement for Linux and MAC OS as well.
  • Create a Metrics Visual in a Power BI Report Jan 22, 2024. Integrating metrics and scorecards deeply into reporting solutions is a great way to drive alignment and progress on a team.
  • Securing Your .NET Applications With ExamplesJan 20, 2024. In the realm of software development, security remains a paramount concern. This is especially true for .NET applications, which often handle sensitive data and interact with critical systems. By adhering to security best practices, developers can create robust applications that safeguard user information and withstand potential attacks.
  • Number Guessing Game in PythonJan 19, 2024. In this article, you will learn how to write a Guess-the-number game in Python using a Google Colab. You will learn three different ways to implement it.
  • Create Xamarin Android Custom Loader with LoaderEase NuGet PackageJan 19, 2024. The fundamental objective of a wait window is to furnish users with feedback, mitigating any perception of unresponsiveness or ambiguity during tasks that may consume considerable time. Leveraging the NuGet package " Xamarin.Custom.LoaderEase" enables users to effortlessly fashion a personalized loader aligned with the visual theme of their application.
  • Data Insights: Analyzing Key Influencers with Power BI VisualsJan 18, 2024. The key influencers visual helps to understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers.
  • Implementing IP Rate Limiting in ASP.NET Core MVCJan 18, 2024. IP rate limiting is a crucial aspect of web application security that helps prevent abuse, protect against brute force attacks, and ensure fair resource usage. In this article, we will walk through the process of implementing IP rate limiting in an ASP.NET Core MVC application using middleware.
  • How to Clean and Replace Corrupted Files in Windows 11Jan 17, 2024. The SFC process usually takes 5–10 minutes to complete, but it may take longer if the task is heavy. If the process takes longer than an hour, it may be stuck.
  • AI Visuals Using Q&A for Power BI Business Users Jan 17, 2024. The Q&A feature in Power BI lets you explore your data in your own words using NLP. Q&A is available on dashboards and on reports. This article is written for business users, and explains how to use the Q&A feature in a report.
  • Create a Workspace in FabricJan 15, 2024. This article explains how to create workspaces in Microsoft Fabric. In workspaces, you create collections of items such as lakehouses, warehouses, and reports.
  • External Logging for APIs with SerilogJan 09, 2024. With Serilog, logging for APIs and Windows Services becomes an effortless endeavor. By configuring Serilog to use external logging sources, you ensure that your application's behavior is well-documented and can be easily analyzed.
  • Understanding Collection Types in C#Jan 09, 2024. Delving into collection types like IEnumerable and IQueryable in C# unveils their impact on data querying efficiency. While IEnumerable offers simplicity for in-memory operations, it might load unnecessary data. IQueryable optimizes query execution by fetching only required data, which is beneficial, especially with extensive datasets or remote sources.
  • What is Windows Sandbox?Jan 06, 2024. Windows Sandbox is an isolated environment that can be used to test Windows applications without changing your parent OS.
  • Azure Migrate Application and Code Assessment Tool for .NETJan 05, 2024. Explore seamless Azure migration with AppCAT, a powerful tool for .NET. Visual Studio and CLI installations, detailed analyses, and insightful reports empower coding excellence.
  • Registry Configuration for Launching Programs by File ExtensionsJan 03, 2024. Associating a specific program with a particular file type through registry configurations involves defining entries in the Windows Registry.
  • How to create a Logic App to insert Page number into PDF Jan 03, 2024. In this article, we are going to learn about How to create a Logic App to insert Page number into PDF
  • Logging Brilliance in .NET Core Part 2 : Using of Serilog in Windows Service Dec 26, 2023. Learn to implement external logging in API and Windows Service using Serilog. This guide covers Serilog configuration, worker class setup, and package references, ensuring efficient information tracking with detailed examples.
  • Handle Dropdown Mouse Actions and Windows Using Selenium C#Dec 26, 2023. This article will be helpful in understanding how to handle dropdowns and windows, plus different mouse action methods. In Html, the select tag is used to create the dropdown
  • Handling Frames, Windows Alert in playwrightDec 25, 2023. This article will help you to understand how to handle windows alerts and frames using playwright automation tool.
  • Creating Dynamic PIVOT Query in SQL ServerDec 23, 2023. In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
  • Create and Debug Lambda Function in VS CodeDec 22, 2023. Create an AWS lambda function in the local environment and debug it before pushing it to a cloud environment. With the help of a few tools such as AWS SAM or serverless framework, developers can emulate lambda environment on their local machine; this allows for rapid iteration and testing before deploying the code base into the cloud.
  • Deploying Your Solution to Azure via FTPDec 20, 2023. In this Article we will Learn how to deploy your solution to Azure by FTP (File Transfer Protocol). This step-by-step guide demonstrates efficient methods to upload builds, ensuring a smooth transition to Azure cloud services.
  • How to Configure Amazon CodeWhisperer in Visual StudioDec 20, 2023. In this article, you will learn how to configure Amazon CodeWhisperer in Visual Studio 2022 using individual tiers. Learn how to configure Amazon CodeWhisperer in Visual Studio 2022 using individual tiers. Follow the steps to install AWS Toolkit, sign in, and seamlessly use CodeWhisperer for coding suggestions.
  • Query to Find and Drop User-Defined Stored ProcedureDec 20, 2023. In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run in production environments; it poses serious risks.
  • How to Download the Package Deployer using Power Platform Tools in Visual Studio Code?Dec 20, 2023. Step-by-step details to download the package deployer using power platform tools in Visual Studio code. Learn an efficient alternative to download the Dynamics 365 Package Deployer using Visual Studio Code and Power Platform Tools. Follow the outlined steps after setting up the prerequisites.
  • Create Your First Angular Using Angular CLI 17.0.6, Node: 20.0.1, npm 10.2.3 on WindowsDec 18, 2023. Create your first angular 17 apps using the steps. Explore building your first Angular 17 app with this guide, covering prerequisites, Node.js and TypeScript installation, and Angular CLI setup. Navigate the new features and unleash Angular 17's potential.
  • Handling Windows and Frames Using Selenium With JavaDec 18, 2023. This article will help you to understand how to handle windows and frames using selenium with Java. Selenium WebDriver session involves opening a window that is initially controlled by the WebDriver.
  • How to Plan for a Windows 365 Cloud PC Deployment?Dec 18, 2023. Securely stream your Windows experience including your personalized apps, content, and settings from the Microsoft Cloud to any device with your Windows 365 Cloud PC.
  • How to Download the Configuration Migration Tool using Power Platform in Visual Studio Code?Dec 18, 2023. Step by step details to download the configuration migration tool using power platform tools in visual studio code
  • Optimizing SQL Queries: CTE vs Temporary Tables for SpeedDec 17, 2023. In Microsoft SQL Server, there are different methods to enhance query performance: Common Table Expressions (CTE) and temporary tables.
  • Handling Windows and Frames using Selenium With PythonDec 17, 2023. This article is for understanding how to handle windows and frames using selenium with python.
  • Setup an Environment for Copilot StudioDec 15, 2023. How to set up an environment in Power Platform to copilots using Copilot Studio. This guide outlines the steps to set up an environment for Microsoft's Generative AI feature in Copilot Studio, enabling the creation of AI-powered chatbots using Power Platform.
  • Filter Options in Power BI VisualsDec 14, 2023. Exploring Filter Options in Power BI Visuals. Power BI, Microsoft's potent business intelligence tool, amplifies data analysis with versatile filter options. Uncover insights by exploring columns, relative date, visual-level, page-level, drill through, and top/bottom filters, enhancing user experience and reporting impact.

About Visual-Studio-Query-Window-with-line-number

NA

OUR TRAINING