Edvaldo Guimrães Filho
-
Comparison between UWP, WPF, and Other Microsoft Development Technologies
The Microsoft development ecosystem offers a variety of technologies for creating applications that meet different needs and platforms. In this article, we will explore the main Microsoft development technologies, such as Universal Windows Platform (UWP), Windows Presentation Foundation (WPF), Windows… Continue reading
-
Mastering Markdown: A Beginner’s Guide
Markdown is a lightweight markup language that’s popular for formatting text. Used on platforms like GitHub and Stack Overflow, Markdown makes it easy to structure documents with minimal syntax. Here’s a guide to get you started with Markdown essentials! Continue reading
-
MVC, Razor, and Blazor in .NET: The Evolution of Web Development
In the .NET ecosystem, MVC, Razor, and Blazor are powerful frameworks, each playing a crucial role in developing dynamic and responsive applications. Understanding their individual purposes, technical details, and evolution helps developers choose the right tools for their projects and… Continue reading
-
Automating Git Repository Creation on GitHub and Azure DevOps with Git
Managing code across multiple repositories on different platforms can be time-consuming, especially when pushing to both GitHub and Azure DevOps. This guide provides a streamlined workflow to create and configure Git repositories locally, set up GitHub and Azure DevOps remotes,… Continue reading
-
Creating a WPF Application to Display GDP Data from SQL Server
In this article, we will walk through building a simple WPF (Windows Presentation Foundation) application in C# that connects to a SQL Server database, retrieves GDP data, and displays it in a DataGrid. This application serves as an excellent introduction… Continue reading
-
Building a C# Console App to Load GDP Data from the World Bank API Based on User Input
In this article, we will build a C# console application that connects to a SQL Server database and retrieves GDP data for a specific country from the World Bank API. Users can specify the country they want to load data… Continue reading
-
Building a Real-World Data Analysis Template Using the World Bank API: A Comprehensive Guide for Power BI and Analysis Services
I’ve always wanted to access an API to create a more complex tutorial, something that went beyond the basics and dealt with real-world data. Microsoft’s API examples are extensive, but I was looking for something with more tangible applications. This… Continue reading
-
Introduction: Why Access to World Bank Indicators Matters
In an increasingly interconnected and data-driven world, access to reliable global indicators has become a critical resource for businesses, governments, researchers, and policy-makers. The World Bank, a vital source of open global data, provides insight into hundreds of variables affecting… Continue reading
-
Remote Development Over SSH with VS Code: A Comprehensive Guide
Remote development over SSH in Visual Studio Code allows developers to access, edit, and debug code on remote servers with the same seamless experience as local development. Here’s a step-by-step guide to set up and make the most of this… Continue reading
-
Overview: CI/CD and Agile Scrum in Azure DevOps
In an Agile Scrum framework, development teams work in sprints (typically 2-4 weeks) to deliver functional increments of the software. By integrating CI/CD pipelines, teams can automate building, testing, and deploying code to ensure reliable and fast delivery. Azure DevOps… Continue reading
-
Loading Country GDP Data into a SQL Database with C#
In this article, we will discuss how to load GDP (Gross Domestic Product) data for various countries into a SQL database using C#. The goal is to create an application that connects to the World Bank API, retrieves the data,… Continue reading
-
Carregando Dados de PIB de Países em um Banco de Dados SQL com C#
Neste artigo, abordaremos como carregar dados do PIB (Produto Interno Bruto) de vários países em um banco de dados SQL utilizando C#. O objetivo é criar um aplicativo que se conecte a uma API do Banco Mundial, recupere os dados… Continue reading
-
The AMP Lab: A Catalyst for Innovation
The AMP Lab: A Catalyst for Innovation What is AMP Lab? The AMP Lab (Algorithms, Machines, and People Laboratory) is a research laboratory at the University of California, Berkeley, established in 2010. The lab focuses on advancing research in computer science, particularly… Continue reading
-
Apache Spark and the AMP Lab
Apache Spark is a powerful open-source data processing engine designed for big data analytics. Known for its speed and versatility, Spark has transformed how organizations handle large datasets. This article will explore the technical details of Apache Spark, its historical… Continue reading
-
Introduction to SQL Joins
Structured Query Language (SQL) is a powerful tool used for managing and manipulating relational databases. One of the key features of SQL is its ability to combine data from multiple tables through the use of joins. Joins allow users to… Continue reading
-
Understanding OLAP (Online Analytical Processing)
Online Analytical Processing (OLAP) is a category of database technology that allows users to perform complex analyses on large volumes of data efficiently. OLAP systems are structured to support multidimensional queries and are optimized for fast data retrieval, enabling businesses… Continue reading
-
Microsoft SQL Server Family Overview
The Microsoft SQL Server family is a suite of database products designed to provide end-to-end solutions for data management, analytics, and business intelligence (BI). It includes multiple components that handle a range of functions, from database storage to complex data… Continue reading
-
Microsoft Fabric: The All-in-One Data and Analytics Solution
In today’s data-driven landscape, companies need robust, scalable, and integrated platforms to manage data workflows and generate actionable insights efficiently. Microsoft Fabric, launched in 2023, aims to fill this role by consolidating data storage, transformation, visualization, and analytics under a… Continue reading
-
Understanding SQL Joins: Examples with Country GDP Data
In SQL, JOIN clauses allow you to combine records from two or more tables based on a related column. In this article, we’ll create tables for years and GDP (Gross Domestic Product) data for three countries (Brazil, the United States,… Continue reading
-
Azure DevOpsAligned with Agile and Scrum
In Agile and Scrum frameworks, work items in Azure DevOps provide structure to organize and prioritize work according to Agile principles, ensuring each sprint delivers incremental value. This article explores work item types, their role within the Agile and Scrum… Continue reading
-
Work Items in Azure DevOps
In Azure DevOps, work items are crucial for planning, tracking, and managing software development tasks—from high-level goals to actionable tasks. Each work item type serves a specific purpose in organizing work within a team, making it easier to break down… Continue reading
-
Adapting a PowerShell SharePoint Script to .NET Framework C# Using SQL Databases
In this article, we will take a PowerShell script initially designed to create and manage SharePoint Online lists and adapt it for .NET Framework C# to interact with SQL Server databases instead of SharePoint lists. This scenario assumes you want… Continue reading
-
Automating SharePoint Lists for Global GDP Data: Power BI & Power Apps Integration
In this article, we’ll walk through a PowerShell script that automates the creation of SharePoint lists populated with GDP (Gross Domestic Product) data for various countries, sourced directly from the World Bank API. This solution is ideal for integrating real-time… Continue reading
-
Automating SharePoint List Creation and Data Population with PnP PowerShell
Automating SharePoint List Creation and Data Population with PnP PowerShell In this article, we will walk through a PowerShell script that connects to SharePoint Online using the PnP PowerShell module and automates the creation of SharePoint lists. The script dynamically… Continue reading
-
Creating Summary Measures in Power BI for Date Columns: Counting Rows by Year
One common requirement when working with data is summarizing information based on date columns. For example, you might need to count how many rows were created in each year to understand data trends over time. This article will guide you… Continue reading
-
Complete Guide to DAX Functions in Power BI
Data Analysis Expressions (DAX) is a powerful language in Power BI, designed to perform complex calculations, filter data, and create dynamic reports. Whether you’re new to DAX or looking to expand your knowledge, this guide provides 50 essential DAX functions,… Continue reading
-
50 Exemplos de Medidas DAX
50 Exemplos de Medidas DAX Continue reading
-
Silicon Valley Snake Oil: The Illusion of Silicon Valley
The term “snake oil” refers to products or promises that offer extraordinary results without scientific evidence or efficacy. This phrase originated in the 19th-century American West, where traveling salesmen marketed “snake oil” as a miraculous cure-all for various ailments. These… Continue reading
-
Understanding Storage Calculation in Azure: Differences Between SharePoint, OneDrive, and Teams
Understanding Storage Calculation in Azure: Differences Between SharePoint, OneDrive, and Teams In the Microsoft 365 ecosystem, SharePoint Online, OneDrive for Business, and Microsoft Teams are tightly integrated to provide seamless collaboration, file storage, and sharing functionalities. Despite their synergy, understanding… Continue reading
-
Diferenças entre SharePoint, OneDrive e Teams: Como o Armazenamento é Calculado no Azure
O ecossistema de colaboração do Microsoft 365 combina ferramentas poderosas, como SharePoint, OneDrive e Teams, que atuam em conjunto para armazenar, compartilhar e gerenciar arquivos e informações dentro das organizações. Entretanto, a integração entre essas plataformas pode causar confusão, especialmente… Continue reading
-
Comprehensive Technical Guide: Azure AD B2C
Azure AD B2C is a customer identity management solution designed for web and mobile applications. It supports a variety of identity providers (Google, Facebook, Microsoft accounts, etc.), allowing developers to secure applications using existing credentials or custom accounts. Below is… Continue reading
-
SharePoint Governance for Microsoft Teams Sites
Governance in SharePoint is essential, particularly in collaborative environments like Microsoft Teams, where sites are often created automatically. A well-structured governance plan ensures that these sites remain organized, secure, and aligned with organizational objectives. This article outlines strategies for managing… Continue reading
-
How to Publish and Obtain an Existing WDL Workflow in Visual Studio Code
How to Publish and Obtain an Existing WDL Workflow in Visual Studio Code In this section, we will focus on the process of publishing your Workflow Definition Language (WDL) workflow from Visual Studio Code to Azure Logic Apps. Additionally, we’ll… Continue reading
-
How to Generate and Use SSH Keys (id_rsa) on Windows
Secure Shell (SSH) is a protocol that provides a secure way to access remote computers. It is widely used to securely manage servers, especially through the use of SSH key pairs. This article will guide you on how to generate… Continue reading
-
A Comprehensive Comparison of Power Automate and Python with Technical Overview of Workflow Definition Language (WDL)
In this article, we will explore a detailed comparison between Power Automate and Python, focusing on key programming structures such as conditionals, loops, variables, and API calls. Additionally, we will dive deep into the Workflow Definition Language (WDL), which powers… Continue reading
-
World Bank API (WBAPI)
Comprehensive Guide to the World Bank API (WBAPI) The World Bank API (WBAPI) is a powerful tool for accessing a vast array of economic and development data. This guide provides detailed information about the API’s endpoints, examples of how to… Continue reading
-
Understanding Webhooks in Power Automate
Webhooks are a powerful and flexible way to enable real-time communication between different systems. In the context of Power Automate, webhooks allow you to trigger flows based on events that occur in external systems. This article provides a detailed technical… Continue reading
-
Introduction to Power Automate and Azure Functions
Power Automate and Azure Functions are two powerful tools from Microsoft that enable automation and serverless computing, respectively. Power Automate, formerly known as Microsoft Flow, was introduced in 2016 as part of the Microsoft Power Platform. It allows users to… Continue reading
-
Azure Functions and Power Automate Integration: A Technical Deep Div
As modern cloud platforms evolve, the need for more dynamic, scalable, and cost-efficient solutions has grown. This is where Azure Functions come into play. Azure Functions are a core component of serverless computing, a model where developers focus solely on… Continue reading
-
Introduction to Power Automate: A Comprehensive Overview
Power Automate, formerly known as Microsoft Flow, is part of the Microsoft Power Platform, which also includes Power BI, Power Apps, and Power Virtual Agents. Power Automate enables users to create automated workflows between their apps and services, connecting tools… Continue reading
edvaldo b. guimarães filho 