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.
  • Create Bulk Variables in Azure DevOps Variable Groups with CLIMar 22, 2024. Learn how to automate the process of adding multiple variables to a Variable Group in Azure DevOps using the Azure DevOps CLI and Microsoft Excel. This article provides a step-by-step guide to streamline the process and avoid manual data entry.
  • Introduction to Image Control in Power AppsMar 22, 2024. Explore the versatility of Image Control in Power Apps. Learn to enhance user interfaces by effortlessly displaying images. From data visualization to graphic elements, master the art of visual design and image management.
  • Introduction to 3D Object Control in Power AppsMar 21, 2024. Introduction to 3D Object Control in Power Apps explores integrating 3D objects into user interfaces. Learn how to manipulate objects, design interactions, and enhance user experiences using Power Apps' visual programming capabilities for augmented and virtual reality applications.
  • 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.
  • Microsoft Fabric: Loading Data into Lakehouse TableMar 20, 2024. A LakeHouse integrates data lakes & data warehouses, offering benefits of both. Data lakes store raw data diversely, while DataWarehouses handle structured data. LakeHouse combines both for efficient query performance. Fabric platform enables easy creation & management of LakeHouses. 2 / 2
  • Save specific Email to Excel File using Azure Logic App Mar 12, 2024. Azure Logic Apps is a cloud-based service that streamlines business processes. This guide details how to automate moving specific emails to Excel in OneDrive seamlessly using Azure Logic App workflows.
  • Introduction To Term Store Management in SharePoint OnlineMar 12, 2024. In this article we will discuss – Introduction To Term Store Management in SharePoint Online And How to create Term Store using PowerShell.
  • Exploring the Data Table Control in Power AppsMar 12, 2024. Discover the intricacies of the Data Table Control in Power Apps with our comprehensive guide. Learn to harness its power for seamless data manipulation, visualization, and user interaction.
  • Introduction of Power AppsMar 11, 2024. Explore the fundamentals of Power Apps in this introductory series. Learn how Microsoft's low-code platform empowers users to create custom business solutions with ease. Dive into interface design, data integration, and more in Part 1 of this comprehensive guide.
  • Top 10 VPNs in 2024Mar 11, 2024. While some VPNs excel in speed, others prioritize features or affordability. Here's a list of some of the top contenders in 2024.
  • 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.
  • React Development Journey Series: Introduction to React.js 🚀Mar 08, 2024. Embark on a React Development Journey with our Introduction to React.js series!
  • Fromula-Based Columns in Dataverse TablesMar 05, 2024. This content discusses the concept of formula columns in Microsoft Dataverse tables, highlighting their functionality in displaying calculated values using Power Fx, a user-friendly programming language. It provides steps on how to add a formula column and explores various use cases and limitations associated with this feature.
  • Exploring the Export Functionality within SharePoint ListsMar 04, 2024. The Export feature in SharePoint Lists facilitates exporting list data to formats like Excel or CSV, aiding data analysis and sharing. It enhances collaboration by enabling users to extract and manipulate data conveniently.
  • Expandable and Collapsible Tables in PowerAppsMar 04, 2024. This article provides a comprehensive guide on expanding and collapsing multiple tables in PowerApps. It walks through the steps required to set up a canvas control, customize columns, add containers, and implement expand/collapse functionality using icons.
  • Introduction to Design Patterns in FlutterMar 02, 2024. Explore the importance of design patterns in software development. Learn about different types of patterns, their benefits, and how they can improve code efficiency, readability, and maintainability. Ideal for developers seeking to enhance their coding practices.
  • Automating Excel data to SharePoint Lists with Power AutomateFeb 28, 2024. In this article, we will discover seamless automation of Excel data migration to SharePoint Lists using Power Automate. Streamline your workflows, enhance productivity, and ensure data integrity with this efficient solution.
  • How to Create CSV File from Excel Spreadsheet Feb 27, 2024. Explore methods to Create CSV File from Excel Spreadsheet. Get the best solutions to carte or save CSV files from Excel Spreadsheet in easy steps.
  • Create an Excel Template and Upload It to the LibraryFeb 26, 2024. In this article, Here, you'll find instructions on how to create and use an Excel template for various tasks, ensuring a blank starting point for your projects.
  • Introduction to Vue.js and Building a Simple Todo ListFeb 26, 2024. In the ever-evolving landscape of web development, Vue.js has emerged as a powerful and versatile JavaScript framework. In this three-part series, we'll embark on a journey to explore Vue.js and demonstrate its capabilities by building a simple yet functional to-do list application.
  • .NET Delegates for Mere Mortals: IntroductionFeb 19, 2024. Explore .NET delegates practically in this article. Learn to use delegates for flexible, reusable code. Follow examples, download source code, and understand delegate syntax, including anonymous methods and lambda expressions.
  • Overview of BlazorFeb 18, 2024. In this article, you will learn about Microsoft Blazor technology, Single Page Application, Progressive Web Application, etc.
  • An Introduction to Azure AI Language ServicesFeb 15, 2024. Using Azure AI-Language Services to speed up your AI Projects. Azure AI Language Services revolutionizes language processing with advanced NLP features. Features include Text Analytics, QnA Maker, LUIS, and Language Studio for seamless integration and enhanced capabilities. Upgrade today.
  • How to Create a SharePoint List Directly from ExcelFeb 13, 2024. Learn to seamlessly migrate Excel data to SharePoint lists. Enhance collaboration and data management with this step-by-step guide.
  • Resolving Database Reconnection Challenges in .NET with PollyFeb 13, 2024. This content provides an overview and detailed implementation guide of utilizing the Polly library for connection retry in .NET applications. It demonstrates creating an Employee class and table, simulating temporary database disconnection.
  • 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.
  • What Are Relationships in Power BIFeb 08, 2024. This content provides an overview of the different types of relationships that can be established between tables in Power BI. It discusses four main types of relationships: many-to-one, one-to-one, one-to-many, and many-to-many.
  • Show Dynamics 365 Account Contacts in Side Panel HTML TableFeb 05, 2024. In the Account Entity Form, we are showing the Account Related Contact in the Side Pane using an HTML Page. Learn how to create a JavaScript web resource to load promotions in Microsoft Dynamics 365 using the Xrm API. Additionally, build an HTML web resource for displaying related contact information in a table.
  • How to Use Drag and Drop in Angular?Feb 05, 2024. Learn how to implement drag-and-drop functionality in Angular tables. Follow these steps: create a component, install the Angular drag-and-drop library, add HTML and TypeScript code for table manipulation.
  • Excel Formula: Generate Random Dates and Extract Day, Month, Year, QuarterFeb 05, 2024. This article shows how to Generate Randomised Dates and Extract Day, Month, Year, and Quarter using a Single Formula in Excel. Explore advanced Excel formulas using the LET function and dynamic arrays to generate 100,000 rows of randomized dates.
  • Introduction to Apache Kafka with .NETJan 30, 2024. This is an introduction to Apache Kafka and how to work with Kafka with .NET. This article introduces Apache Kafka, a distributed event streaming platform, and explains how to set it up with .NET. It covers installation, configuration, and integration, providing a comprehensive overview of Kafka.
  • PowerApps Save as CSV from Export to ExcelJan 29, 2024. In this article, we will learn how to export a report in CSV format using PowerApps and Power Automate. Create a SharePoint list, connect data sources, and build a flow to export data to a CSV file.
  • PowerApps Save as CSV or Generate Report from CSV/ExcelJan 24, 2024. I often come across where the business wants to have a report in excel format. But the question is could we save as csv using PowerApps. Then with the help of Power Automate we can. There is a lot of requirements which could be achieved in PowerApps with the help of Power Automate.
  • Scrum : An Introduction to Agile DevelopmentJan 17, 2024. In this article, we will see the scrum process in agile development. Scrum, a key framework in Agile development, emphasizes collaboration and iterative delivery. Explore its process, roles (Product Owner, Scrum Master, Development Team), artifacts, and the numerous benefits it offers.
  • Deleting Duplicate Records Using CTEJan 09, 2024. In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
  • Introduction to MultithreadingJan 08, 2024. Learn about Multithreading and the difference between using Thread and threadPool. The difference between multithreading and concurrency
  • Introduction to Llama LLMJan 03, 2024. Llama LLM represents a significant leap forward in the evolution of language models. Its contextual understanding, nuanced comprehension, and multilingual proficiency make it a versatile tool for a wide range of applications across industries - join me while I discuss this new technology and how you can benefit from it. Llama LLM is a cutting-edge language model that builds upon the advancements of its predecessors (GPT and others).
  • Introduction to Microsoft Fabric: A Comprehensive OverviewJan 02, 2024. Explore the world of Microsoft Fabric in this comprehensive overview, where we delve into its unified analytics platform that seamlessly integrates data movement, data science, real-time analytics, and business intelligence. Discover how its SaaS foundation, key components like Power BI, Azure Synapse, and Azure Data Factory, and the central data lake, OneLake, come together to revolutionize enterprise data analytics. This article is your gateway to understanding how Microsoft Fabric simplifies and transforms data analytics in the modern business landscape.
  • Introduction to Docker and ContainersJan 02, 2024. Containerization, a savior for both developers and DevOps engineers. Containers have revolutionized the world of software development and deployment. These lightweight, portable, and self-contained environments have transformed how applications are built, shipped, and run. At the forefront of containerization technologies is Docker.
  • Introduction to the IDisposable PatternJan 02, 2024. Article on the IDisposable pattern in C#, covering introduction, details, code examples, and best practices. This article will explore the IDisposable pattern, its significance, and how to implement it effectively in C# code.
  • Truncate All Table Data in MSSQLJan 02, 2024. In this article we will learn about how to truncate all tables in a SQL Server database using dynamic SQL. Exercise caution, as this operation deletes all data without the possibility of rollback. Learn essential precautions.
  • Write the Data to Excel TemplateDec 29, 2023. Learn the art of writing data into Excel templates in C# with this step-by-step guide. Create an ASPX page, use libraries like Newtonsoft.Json, and implement the Factory Pattern effortlessly.
  • Table(s): Temp Table, Table Variable and CTE (Common Table Expression)Dec 26, 2023. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
  • How To Create a WCF ServiceDec 26, 2023. How can I create a WCF service that manages employee details while interacting with an SQL database, including the necessary SQL table script for employee information storage?
  • 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.
  • Delving into Meaning: An Introduction to Semantics Dec 19, 2023. Why is this fascinating field important? Semantics touches almost every aspect of our lives, from the clarity of legal documents to the power of poetry. It helps us build smarter AI systems that truly understand language, craft convincing arguments, and bridge cultural divides through effective communication.
  • 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.
  • Advanced Conditional Formatting: Turn On & Off Cell Color with CHECKBOXES in ExcelDec 12, 2023. This article shows how to create advanced conditional formatting in Excel and using the new checkboxes to turn on and off the applied cell colors.
  • Using Date Function in Data Validation in ExcelDec 10, 2023. Learn how to use Excel's DATE function for effective data validation. Set criteria for a date column to ensure entries fall within a specific range, enhancing accuracy and data quality.
  • PIVOT AND UNPIVOT Operators in SQL ServerDec 05, 2023. In this article, we are going to learn PIVOT and UNPIVOT Operators in SQL Server with some examples.
  • VSTACK Append in Excel with Total RowNov 24, 2023. In the article, Explore the power of Microsoft Excel with the LET, VSTACK, and HSTACK functions. This article guides you through creating complex formulas for dynamic data combination and summarization across multiple tables.
  • Streamlining Azure DevOps Management with ExcelNov 22, 2023. In the dynamic landscape of software development, effective project management is non-negotiable. Microsoft Azure DevOps emerges as a powerhouse, offering a suite of tools covering the entire software development lifecycle. Among its array of features, the integration of Excel Connector proves to be a game-changer, empowering teams to manage projects more efficiently by leveraging the familiar and flexible environment of Excel.
  • An Introduction to Redux in React NativeNov 21, 2023. Discover Redux - the state management library that revolutionizes React Native development. With Redux, you can simplify data flow, achieve code maintainability, and build scalable apps. Get a hands-on experience and transform your React Native projects!
  • Fabric Data Warehouse: Save as Table and Analyze Result FunctionalitiesNov 20, 2023. In this article, we'll delve into the Microsoft Fabric Data Warehouse features: Save as Table and Analyze Result. These functionalities offer users and analysts several advantages in terms of data management and visualization.
  • Inserting 1 Million Dummy Product Data into SQL Server Using Bogus PackageNov 17, 2023. When working with databases, populating them with substantial amounts of data for testing or demonstration purposes is crucial. The Bogus package in C# provides a convenient way to generate fake data, making it an excellent choice for creating large sets of dummy records. This guide will walk you through inserting 1 million dummy product records into a SQL Server database using Bogus.
  • Efficient Data Integration using HSTACK & XLOOKUP FunctionsNov 07, 2023. This article effectively explains how to integrate data from different sources using Excel's HSTACK and XLOOKUP functions. The step-by-step breakdown and the clear demonstration with sample data make it easy for readers to understand and implement the data integration process seamlessly.
  • Load Bulk Data to Azure Table StorageNov 03, 2023. This article provides all the information about how to utilize the Azure SDK for Python to load bulk data into Azure Table Storage. The script's step-by-step breakdown effectively guides users through the process, including necessary setup and configuration, as well as the bulk data insertion steps.
  • Improving SQL Table Data PerformanceNov 01, 2023. This article discusses strategies and best practices for optimizing SQL table data performance. Topics covered include indexing, normalization, partitioning, data types, query design, monitoring, hardware, caching, sharding, and maintenance. These practices aim to improve database efficiency and, in turn, enhance application performance and user satisfaction. Regular maintenance is stressed for sustained success.
  • Create Excel Charts (Waterfall, Funnel, Treemap, etc) with JavaOct 30, 2023. This article explains how to create waterfall chart, funnel chart, treemap chart, box and whisker chart, sunburst chart, and histogram chart in Excel with Java.
  • Using Power Automate for HTML Table CreationOct 27, 2023. Learn easy way to send the Dynamic CRM Data to Email in the Table Format. To manually start the flow, log in to Power Automate, select Create, and then choose an instant cloud flow.
  • Recover Deleted Table Data "without Backup" in SQL ServerOct 27, 2023. This article will discuss Recover Deleted Table Data "without Backup" in SQL Server.
  • Creating a Calendar Table in Excel Power Query and its BenefitsOct 20, 2023. This blog is based on Creating a Calendar Table in Excel Power Query
  • Read And Upload Excel Data To Oracle TableOct 18, 2023. In the realm of data management and integration, the process of reading and uploading Excel data to an Oracle table involves multiple fundamental steps. First, the data needs to be read from an Excel file, which might contain various types of information such as numbers, texts, or dates. This data is typically organized in rows and columns.
  • What are Temporal Tables in SQL Server?Oct 16, 2023. A temporal table, also known as a system-versioned temporal table, is a type of database table designed to track changes to data over time automatically. It accomplishes this without the need for complex custom code or triggers. Temporal tables are particularly useful in scenarios where you need to maintain a historical record of changes made to your data.
  • How to Create Table & Insert Records in Microsoft Fabric Data Warehouse SQL EndpointOct 16, 2023. This article covers how to create table and insert records in the Microsoft Fabric Data Warehouse SQL Endpoint
  • How to check if SQL table is temporal?Oct 16, 2023. How do you know if table is a temporal table.
  • Introduction to Git BisectOct 09, 2023. This article provides an introduction to git bisect, an useful git command to search for faulty commits in git repository
  • ClosedXML Excel Printing settingsOct 06, 2023. This article will describe all the printing settings available in CloseXML excel library.
  • ASP.NET Core 7 - Introduction of Rate Limiting middlewareOct 05, 2023. This article is an Introduction of Rate Limiting middleware in ASP.NET Core 7.
  • Python in Excel Data Analysis using the New PY FunctionOct 04, 2023. This article delves into performing Data Analysis using the new Python in Excel PY function
  • An Introduction to VMware NSX-T: Revolutionizing Network VirtualizationOct 03, 2023. This article introduces readers to VMware NSX-T, explains its key features, and provides real-world examples of how it is used in various industries. You can expand on each section to provide more in-depth information or include additional examples and use cases as needed to reach the desired word count.
  • Transferring Data from One Table to Another Across DatabasesSep 26, 2023. This article explores how to ingest data from a table in SalesData database to another table in the Data Warehouse database.
  • Restore a Table from a Backup Database through Restore/ExportSep 19, 2023. This article is to discuss how to recover one table from a backup file
  • Update Size of File Column in Dataverse TableSep 17, 2023. This article will walk you through that how we can update the size of already created file type column in Dataverse table.
  • Stored Procedure in SQL ServerSep 12, 2023. A stored procedure is a reusable collection of SQL statements stored on the database server. It simplifies code maintenance and execution. Stored procedures can be invoked by triggers, other procedures, and various programming languages like Java, .Net, and Python, making them versatile.
  • Excel Sheet Generation in .NET Core 6 Web API and Angular 15Sep 04, 2023. By implementing this approach, you create a hassle-free way for users to generate and download Excel sheets from your web application, improving data reporting and export capabilities. This can be particularly useful in scenarios where users need to work with tabular data in Excel format without manual data entry or complicated procedures.
  • Insert JSON Array into Table with Stored Procedure ParameterSep 04, 2023. Learn how to efficiently save and insert JSON array data into a database table using SQL Server's T-SQL language, with adaptable concepts for other database systems.
  • Exploring Statistical, Table - manipulation and Text Functions in DAXAug 29, 2023. This segment goes beyond the basics and explores functions like CALCULATE, FILTER, and ALL. It covers techniques for creating dynamic measures, time intelligence functions, and handling more intricate data modeling scenarios. Learners will gain insights into optimizing DAX formulas, solving real-world business problems, and building sophisticated data models for enhanced reporting and analysis in Power BI.
  • Introduction to SolidityAug 25, 2023. It was first mentioned by Gavin Wood and developed by Christian Reitwiessner in 2014. The language is statically typed, meaning that variable types must be declared before they are used. It is also case-sensitive, which means that the uppercase and lowercase letters are treated as distinct characters.
  • IoT Success with AzureAug 25, 2023. Unlock Azure IoT Success: Best Practices for Seamless Implementation. From defined objectives to compliance, explore how to excel in IoT projects within the Azure ecosystem for transformative outcomes.
  • Understanding Azure Storage Aug 21, 2023. Discover the prowess of Microsoft Azure Storage in the ever-changing cloud landscape. Offering secure, scalable solutions for diverse needs, it empowers businesses with versatile services, from IoT data storage to disaster recovery. Unleash innovation with Azure Storage.
  • Add Row in Excel using Power AutomateAug 18, 2023. Streamline Excel Data Input: Automate with Power Automate and Microsoft Forms. Learn how to effortlessly add rows to Excel using these tools, enhancing data management and efficiency.
  • Kafka For Mere Mortals: IntroductionAug 10, 2023. The purpose of this series is to help you to understand and use KAFKA in your real projects along with any programming languages, especially with the .NET platform
  • Append Only Ledger Table In SQL ServerAug 09, 2023. An append-only ledger table is a type of database table that only allows new data to be appended to the end of the table. Once data is added to an append-only ledger table, it cannot be changed or deleted.
  • Convert Excel Data Into DataTableAug 08, 2023. Learn to leverage the .NET Excel framework for effortless handling of Microsoft Excel files in your .NET applications. Discover conversion techniques, API integration, and practical implementation for data manipulation.
  • Understanding User-Defined Table Types (UDTs)Aug 04, 2023. Learn about User-Defined Data Types (UDTs) in database management systems. UDTs offer flexibility to create custom data types, enabling better organization and management of complex information in various scenarios. Explore examples and benefits.
  • Introduction to Unit Testing in .NET CoreAug 01, 2023. Learn the fundamentals of unit testing in .NET Core, including manual vs. automated testing and popular testing frameworks like xUnit.net.
  • Introduction to Powerful Numerical Computing with Python NumPyAug 01, 2023. Explore the essentials of Python NumPy in this beginner's guide. Learn to wield powerful arrays, perform advanced calculations, and elevate your data manipulation skills
  • Introduction Of Flurl API Used For Third Party API Integration Jul 30, 2023. Flurl is a popular .NET library used for simplifying and improving the integration of third-party APIs into your applications. It is designed to make working with HTTP requests and RESTful APIs more fluent and expressive in C# or any other .NET language. The name "Flurl" is a combination of "fluent" and "URL," highlighting its focus on providing a fluent and intuitive API for working with URLs and HTTP requests.
  • Building a Timer Triggered Azure Function to Fetch Weather Data and Upload to Azure Blob Storage Table Jul 24, 2023. Timer Trigger using Python get weather data and upload azure blob storage table
  • Introduction to Powerapps and Business Benefits of the Powerapps Jul 18, 2023. Introduction to the Power platform and PowerApps, Overview of the PowerApps types, business benefits of the PowerApps as an overview
  • CTE (Common Table Expression) and Recursive CTE in SQL ServerJul 10, 2023. Learn about the Common Table Expression (CTE) in SQL Server with the WITH clause. Simplify code, improve query readability, and use recursive queries with the SQL WITH clause.
  • Introduction to Machine Learning with PythonJun 30, 2023. This article provides a concise introduction to machine learning with Python. It explains the basic concepts of machine learning, including supervised, unsupervised, and reinforcement learning. The article highlights essential Python libraries for machine learning, such as NumPy, pandas, scikit-learn, TensorFlow, and Keras.
  • Custom search functionality for data tables for server-side processing with PHP and MySQLJun 30, 2023. To add custom search functionality to Data Tables for server-side processing with PHP and MySQL, you can modify the SQL query dynamically based on the search criteria provided by the user.
  • Node.js- Introduction, Features, Installation Guide, and BenefitsJun 29, 2023. Node.js: Introduction, Features, Installation Guide, and Benefits. Beginner for Node.JS
  • Extracting Text from Images using Azure OCR and Match in an Excel Sheet using PandasJun 22, 2023. The concept revolves around enabling the police to capture a snapshot of a vehicle's license plate and quickly retrieve the corresponding information from a database. In this particular scenario, an Excel sheet serves as the database for storing and accessing the relevant details.
  • How to Send Weekly Reports to a Group of Users in SharePoint?Jun 19, 2023. How can you send weekly reports to a group of users in SharePoint? Also, how do you create an HTML table?
  • GraphQL in.NET: IntroductionJun 09, 2023. In this article, you will learn what is graphQL, Why it was introduced, and what are the differences between GraphQL and REST approaches
  • Types of Temporary Tables in SQL ServerJun 09, 2023. The concept of temporary tables in SQL Server, their advantages, and types.

About Pivot-Tables-and-introduction-in-Excel

NA

OUR TRAINING