Resources No resource found - Azure DevOps: Resolve Merge Conflicts with Pull Request ExtensionMar 27, 2024. In this article, we are going to learn how to resolve git merge conflicts within Azure DevOps by using an Azure DevOps Marketplace extension called Pull Request Merge Conflicts.
- .NET Evolution: Journey of Innovation and TransformationMar 20, 2024. Discover the limitless potential of .NET, Microsoft's groundbreaking framework for building versatile and high-performance applications. From desktop to web, mobile to cloud, .NET empowers developers with a comprehensive set of tools, libraries, and languages to create cutting-edge solutions tailored to your needs.
- Getting Started With Mapster in ASP.NET CoreMar 20, 2024. Learn how to streamline object mapping in ASP.NET Core applications using Mapster. This comprehensive guide covers installation, basic mapping techniques, advanced features like custom mapping, and practical examples to help you master the art of efficient data transformation.
- How to Combine Multiple vCard (VCF) Files into OneMar 20, 2024. Explore methods to merge or combine multiple vCard (vcf) files into a single. Get the best solutions to combine bulk vCard files into one.
- Data Transformations: ETL, ELT, and the Reverse ETL RevolutionMar 10, 2024. Delve into the complexities of data management through an in-depth examination of ETL, ELT, and the pioneering emergence of Reverse ETL in this extensive guide. Explore the applications, benefits, and evolving dynamics of these transformative methods shaping the data terrain.
- Mail Merge in Outlook - Simplest Guides for YouFeb 29, 2024. Explore methods to mail merge in Outlook. Get the best manual and programmatically approach to performing mail merge in Outlook.
- What You Need to Know About Data WarehousesFeb 27, 2024. A data warehouse serves as a centralized data management system aimed at bolstering business intelligence (BI) tasks, particularly in the realm of analytics. It is primarily used for conducting queries and analyses and storing vast volumes of historical information.
- Merging Arrays within Synapse / Azure Data Factory PipelineFeb 07, 2024. merging arrays in Azure Data Factory / Synapse pipelines. By utilizing functions like "join" to convert arrays to strings, "concat" to combine strings, and "split" to transform strings back to arrays, this solution ensures comprehensive data integration.
- 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.
- Concatenate Two Strings in C# Jan 17, 2024. In C#, string concatenation can be achieved using the + operator, String.Concat method, String.Join method, or string interpolation. Choose the method that suits your coding style and project requirements.
- Identifying the Root Cause of SQL Server ProblemsJan 10, 2024. Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Management Studio for queries and execution plans, employ Profiler Traces, analyze Dynamic Management Views, monitor disk space, and review application code for optimization.
- Getting Started with SQL Server 2022 SSDT 17.8Dec 07, 2023. It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.
- Join vs. Except and Intersect in SQLDec 06, 2023. SQL Improvement Performance Tips & Tricks. Explore SQL data retrieval methods with JOIN, EXCEPT, and INTERSECT keywords. JOIN combines rows from multiple tables based on a related column, while EXCEPT and INTERSECT compare and combine SELECT statement results.
- Power BI Query Folding Sep 22, 2023. Query Folding in Power BI is a performance-enhancing feature that optimizes data analysis. It pushes data transformations to the source, improving data refresh and incremental processes. Learn how it works, its benefits, and its limitations, and see practical examples of efficient data handling in Power BI.
- Merge Multiple JSON files via Synapse / Data Factory PipelinesSep 20, 2023. Merge Multiple JSON files via Synapse/Data Factory Pipelines
- Power BI Data Transformation Basics for InsightsSep 12, 2023. Power BI Power Query Basics Transforming Data for InsightsPower Query is a data transformation tool in Microsoft's Power BI suite. It connects, cleans, and shapes data from diverse sources, enabling insightful analysis. Learn its basics and key transformations with examples.
- Conditional INSERT, UPDATE, DELETE with MERGE QuerySep 04, 2023. The MERGE statement is a versatile SQL command used for conditional INSERT, UPDATE, or DELETE operations, streamlining database management tasks efficiently in a single query.
- Joins in SQL ServerAug 17, 2023. Understanding of various joins in SQL Server with examples and SQL Script for self learning.
- Source Control (4-9-3), Git - Merge in ConceptAug 14, 2023. This article discusses the Merge for Git.
- Source Control (4-9-2), Git - Merge in Client SideAug 01, 2023. Explore a comprehensive series of articles on Source Control, ranging from standalone apps like MS SourceSafe to web services like GitHub, Azure DevOps, and Git. Understand merging methods, integration, and comparisons for effective version control.
- Source Control (4-9-1), Git - Merge in Server SideJul 31, 2023. This article discusses the Merge for Git.
- Source Control (4-9), Git --- Merge: Fetch, Pull, Push and SyncJun 01, 2023. This article discusses DevOps Merge: Fetch, Pull, Push and Sync
- How To Use Cross Join In MySQLMay 12, 2023. We learn cross-joins with the help of an example
- How To Join Tables In MySQLApr 27, 2023. MySQL joins are used to combine data from two or more tables based on a related column between them. There are several types of joins available in MySQL
- Advanced Query Tuning Techniques in SQL ServerApr 27, 2023. Advanced Query Tuning Techniques in SQL Server
- How To Use Full Outer Join In MySQLApr 24, 2023. A full outer join combines the result of both the left and right outer join, returning records from both the tables and matching them if possible. Used to merge data from two tables
- Pull Sooner And Merge Faster In VS CodeMar 15, 2023. The key to faster merging is to pull sooner! Here is how you can make sure you’re always up to date with your remote and reduce the chances of conflicts.
- 3 Ways To Merge Arrays In JavaScriptMar 06, 2023. An array is a data structure representing an ordered collection of indexed items. In this article, we'll go over 3 different ways to merge arrays in JavaScript.
- Instant Merge Conflict Detection In VS CodeMar 06, 2023. Would you like to know if your branch has conflicts before you go to merge it in? ??
- Data Transformations At Scale Using Azure Cosmos DBMar 01, 2023. Azure Cosmos DB provides a powerful platform for data transformations at scale. By using features such as Change Feed, Stored Procedures, and Azure Functions, businesses can transform data quickly and accurately.
- Join us for Hack Together: Microsoft Graph and .NETFeb 24, 2023. Join us for Hack Together, our virtual hackathon to learn how to build powerful apps with Microsoft Graph and .NET. If you’re a beginning coder, a student, or an expert looking for an opportunity to learn a new skill, don’t miss this opportunity!
- How To Join Two Arrays In C#Feb 07, 2023. In this article, we will learn different methods to join two arrays in C#.
- Configuration Transformation (1) - Web.ConfigJan 23, 2023. This article will discuss Configuration Transformation for Web app.
- Configuration Transformation (2) - App.Config - SlowCheetahJan 23, 2023. This article will discuss Configuration Transformation (2): App.Config --- SlowCheetah.
- How To Use SQL MERGE StatementJan 10, 2023. In this article, you will learn how to use the SQL MERGE Statement.
- How To Configuring Hybrid Azure AD Join Devices In A Managed DomainNov 29, 2022. In this article, you will learn how to Configuring Hybrid Azure AD Join Devices in a Managed Domain.
- See How Others Changes Compare To Your Own In VS CodeNov 22, 2022. Get the ultimate perspective on all the work in progress in your repository and how it compares or possibly conflicts with the changes you are making on your own branch with GitLive’s new Repository View ??
- Merge Multiple Word Files Into Single PDFOct 21, 2022. In this article, you will see how to merge multiple word files into a single pdf using Itextsharp in c#.
- How To Add Custom Add-Ins To MS WordOct 07, 2022. This article shows you how to add add-ins to word desktop.
- How To Add Add-Ins In PowerPoint Sep 20, 2022. In this article, you will learn how to add custom add-ins.
- Git - Error - Refusing To Merge Unrelated HistoriesAug 13, 2022. In this article, we show how to overcome Git errors and merge unrelated histories.
- How To Deploy Excel Add-ins To Your OrganizationAug 12, 2022. This article show you how to deploy excel add-ins in your organization.
- Early Merge Conflict Detection Across All Branches In VS CodeAug 03, 2022. We are happy to announce that GitLive's flagship feature, early merge conflict detection, now works across all branches in VS Code!
- Biggest Myth About Digital TransformationJul 21, 2022. In this article, you will learn about the biggest myth about Digital Transformation.
- How To Add Custom Add-Ins To ExcelJul 05, 2022. In this article, you will learn how to add Excel add-ins.
- Can You Resolve Merge Conflicts Before They Happen?💥Jun 16, 2022. Solving merge conflicts is fun! - said no one ever. Nobody likes them, but it doesn’t change the fact that they are, well, part of the job. In this short post, I would like to briefly explain where they come from, show how to solve them and as an added bonus, suggest a solution to potentially avoid them in the first place!
- How To Deploy PowerPoint Add-ins To Your OrganizationJun 15, 2022. This article shows you, how to deploy PowerPoint add-ins.
- SQL Cross JoinJun 13, 2022. This article will explore the SQL Server CROSS JOIN to join unrelated tables.
- How To Deploy Word Add-Ins To Your OrganizationJun 03, 2022. This article show you how to deploy word add-ins to your organization.
- How To Create Excel Add-InsMay 10, 2022. in this article i will show you how to create Excel Add-ins
- How To Create PowerPoint Add-InsApr 04, 2022. in this article, I will show you how to create PowerPoint Add-ins
- Quick Tip - Remove CONVERTS/CASTS From WHERE/JOIN ClausesMar 29, 2022. In this article, you will learn how to remove CONVERTS/CASTS from WHERE/JOIN clauses.
- How To Deploy Outlook Add-ins To Your OrganizationMar 19, 2022. This article provides a comprehensive guide on deploying Outlook add-ins to organizations for other users. It covers the step-by-step process of deploying add-ins using Office 365, ensuring easy access for users within the organization.
- How To Publish Outlook Add-Ins Using Visual Studio CodeMar 17, 2022. In this article, you will learn how to publish outlook add-ins using visual studio code.
- How To Create Word Add-InsMar 16, 2022. in this article I will show you how to create word add-ins.
- Performance Comparison Using Three Different Methods for Joining ListsMar 07, 2022. This article explores the performance of joining 2 large lists based on 3 different methods: AddRange, using arrays, and using Linq's Concat extension method.
- Design The Full Load And Delta Load Patterns In SSISFeb 14, 2022. Loading Data Design Patterns will provide you with two main recipes for SQL Server Integration Services (SSIS). Design patterns, the full load and the incremental load, to solve common problems encountered when staging data.
- Source Control (2-2), TFS - MergeFeb 10, 2022. This article discusses the Merge for TFS.
- How To Use Catch Output Reject In tMap Component With ExamplesFeb 10, 2022. In this article, we will learn about the use of the Catch Reject Output settings in tMap components with a real-time example. 
- Working With The tMap Component In Real-Time ExamplesFeb 08, 2022. In this article we will learn about the use of tMap component in real time example.
- SQL UPDATE with JOINDec 29, 2021. This tutorial will show you the concept of SQL UPDATE With JOIN.
- Usage Of Join Function In Power AutomateDec 17, 2021. In Power Automate, at times we must join few items which received in the form of strings. As a scenario, response of the user was taken to show this function behavior.
- How To Create Outlook Add-insNov 24, 2021. In this article, you will learn how to create outlook Add-ins.
- Power BI Basic Data Transformation TechniqueNov 24, 2021. When working in a large set of Data, definitely we cannot use the data as it is. We need to perform some refinements so that we can exactly look into the data in which we are interested. In Power BI, this process is called Data Transformation, which can be done in different ways. In this article, we will have a look at the different ways of data transformations.
- Query Editor in Power BI for Data TransformationNov 08, 2021. From our previous articles, we know how to load data into our Power BI from various data sources. But that exact data is not enough to create our Power BI reports. We need to shape those data, that is refine the data, add new columns, rename the columns, and many other improvements to create data models.
- Cinchoo ETL - Merge Different CSV Files Into One Large CSV FileNov 04, 2021. In this article, you will learn how to merge different CSV files into one CSV file using Cinchoo ETL.
- SQL Server Merge StatementJul 16, 2021. In this article, you will learn about the SQL SERVER MERGE statement.
- Azure Data Factory - Implement UpSert Using Dataflow Alter Row TransformationJun 18, 2021. In this article, we will learn how to implement UpSert using Dataflow Alter Row Transformation.
- SQL JoinsJun 18, 2021. In this article, you will learn about SQL Joins.
- SQL- Self Join And Group ByMay 29, 2021. This article will discuss SQL: Self Join and Group by.
- Fixing - The Runtime Connection Manager With The ID Can Not Be FoundMay 27, 2021. In this article, you will learn about fixing SSIS package issue for Dynamics 365 CE.
- Tips And Tricks To Merge Two Power BI ReportsMay 24, 2021. This article describes steps to merge Power BI report files into a single reports.
- Let's Learn About GitHub Projects 📥📤 In DetailMay 21, 2021. We can now implement GitHub Projects at the Organization level. All users in the Organization will have access to its Projects, so we and our team can plan and manage work across repositories.
- Let's Learn About Git Default Branch 📥📤 In DetailMay 11, 2021. In this article, I will describe the below-mentioned points in detail, what is git default branch, use of git default branch, how to change the git default branch, check git default branch using Git Bash.
- Let's Learn About Merging The Git Branches 📥📤 And Create Pull Request In DetailsMay 07, 2021. Explore the intricacies of merging Git branches and initiating pull requests in this comprehensive guide. Learn how to manage version control effectively, collaborate with teams, and streamline your development workflow using platforms like GitHub, Bitbucket, or GitLab.
- Convert HTML, Merge PDFs And Adobe Sign Approval Using Power AutomateMay 07, 2021. In this article you will learn how we can implement functionalities like Converting Html, Merge Pdfs and Adobe Sign Approval using the Inventory Approval Scenario
- Merge Statement In SQLFeb 26, 2021. Merge Statement is a very popular clause in SQL. It handles Insert, Update and Delete in a single query no need to write different logics for each.
- Merge Multiple Pdfs Into A Single Pdf Using ItextSharpJan 27, 2021. In this article, I will explain how to merge any number of Pdf into a single Pdf Using ItextSharp.
- Merge Multiple PDF Files Into Single PDF Using Itextsharp In C#Jan 07, 2021. In this article I am going to explain how to merge multiple pdf files into a single pdf in using Itextsharp in c# here I also explained the use of Itextsharp library as well as how to find and delete existing files on the directory.
- Overview Of Yeoman Generator For Office Add-insDec 08, 2020. In this article, you will learn about the Overview of Yeoman Generator for Office Add-ins.
- Operations On Dataframe - Part TwoSep 30, 2020. In this article, we will learn about various methods of combining dataframes and about Aggregation Functions like quantile(), mad(), sum(), count(), min(), and max().
- How To Split Or Merge Word Documents In JavaSep 30, 2020. In this article, you will learn how to Split or Merge Word Documents in Java.
- Adaptive Joins In SQL ServerSep 01, 2020. In this article, you will learn about Adaptive Joins in SQL Server.
- Everything To Know About Digital Transformation And How Agile Supports ItAug 10, 2020. In this article, you will learn about everything to Know About Digital Transformation and How Agile Supports It.
- Difference Between Inner Join And Full Join In SQL Server Aug 07, 2020. In this article, you will learn about the difference between Inner Join and Full Join in SQL Server.
- Difference Between Inner Join And Right Join In SQL ServerAug 05, 2020. In this article, you will learn about the difference Between Inner join and Right join In SQL Server.
- Data Analytics Using SSIS And Power BIAug 03, 2020. This tutorial is for performing data analytics using SSIS for data transformation and Power BI for visualization
- Compare And Find Data Differences Between Two Tables In SQL ServerAug 01, 2020. This article provides a step-by-step guide to finding data differences between two tables in MS SQL Server
- IT Transformation StrategyJul 31, 2020. In this article, you wi.ll learn about an IT Transformation Strategy
- Difference Between Inner Join And Left Join In SQL ServerJul 16, 2020. In this article you will learn about the difference Between Inner join and Left join In SQL Server.
- Joining Three Or More Tables In SQL Server 2017Jul 07, 2020. In this article, you will learn how to joining Three Or More Tables In SQL Server 2017.
- How To Generate Reports From Merge Table In Power BIJul 03, 2020. In this article you will learn How to Generate Report from Merge Table in Power BI.
- Best Sorting AlgorithmJul 03, 2020. In this article, you will learn about which sorting algorithm is the best.
- Merge Two Tables In Power BIJul 02, 2020. In this article, you will learn about joins of Two Tables in Power BI.
- Advanced Joins In SQL Server 2017Jul 02, 2020. In this article, you will learn about advanced joins in SQL Server 2017.
- Self Join In SQL Server 2017Jun 29, 2020. In this article you will learn about Self Join in SQL Server 2017
- Joins In SQL Server 2017Jun 23, 2020. In this article you will learn about joins in SQL Server.
- Load Data to a SQL Table from SharePoint List Using SSIS - Part ThreeMay 12, 2020. In this article, you will learn how to load data to a SQL table from a Sharepoint list using SSIS.
- Load Data To A SQL Table From SharePoint List Using SSIS - Part TwoMay 08, 2020. In this article you will learn how to load data to a SQL table from SharePoint list using SSIS.
- Load Data to an SQL Table from a SharePoint List Using SSIS - Part OneMay 07, 2020. This article will help you to load records in an SQL server table from a SharePoint list using SSIS (SQL Server Integration Service) services.