Weekly Newsletter (7 Mar 2022)

Monday, March 07, 2022 View online | Switch to the Daily Build Welcome to this week's newsletter from CodeProject. To ensure that future newsletters you receive from The Code Project aren't mistakenly blocked by antispam software, be sure to add the maillist.codeproject.com domain to your list of allowed senders. Advertisements Weekly Poll Results What things do you (currently) trust AI to do for you? Survey period: 28 Feb 2022 to 7 Mar 2022 It's ubiquitous, but is it a hammer looking for a nail? Is it mature enough to be relied upon? Is it just too creepy? Or is it just all good? Which of the following are you OK with? Option Votes %   Detect people, cars, rodents or Amazon deliveries in your webcam feeds 141 22.10 Diagnose cancer in a brain or lung scan 179 28.06 Suggest news items I might be interested in 143 22.41 Scan my fruits and veggies and automatically remove the moldy ones 92 14.42 Automatically tag my friends and family in pictures I upload 92 14.42 Help me write a letter, document or story by completing sentences and improving my writing style 107 16.77 Drive my car for me 49 7.68 Help solve a problem with my banking via a chat bot 30 4.70 None of the above 277 43.42 Responses 638    Respondents were allowed to choose more than one answer; totals may not add up to 100% This week's survey: Have you ever been asked to include a backdoor in your software? Latest Additions New articles added data-analysis How Do You Know If a Graph Database Solves the Problem?   (3 votes) by Jennifer Reif (updated 4 days ago) In this article we take a look at what a graph database can and cannot do and give you a few of the tools to help that decision. Database Development Lightweight Implementation of Autocomplete   (2 votes) by gggustafson (updated 2 days ago) Autocomplete, or word completion, is a feature in which an application predicts the rest of a word a user is typing. This article describes a lightweight implementation. Debian Create a Digital Ocean Droplet for .NET Core Web API with a real SSL Certificate on a Domain   (5 votes) by Marc Clifton (updated 5 days ago) I want to host some simple applications under a real HTTPS domain. This article describes my foray into doing exactly this with a Digital Ocean Droplet. Desktop Programming Top 10 Benefits of .NET Reporting Tools   (4 votes) by Mateen Firoz (updated 6 days ago) In this article, we'll identify the top 10 benefits of using reporting tools for your development projects. High Performance Computing Comparing Programming models: SYCL and CUDA   (1 votes) by Dhruv__Patel (updated 4 days ago) In this article we compare and contrast SYCL and CUDA, and discuss how the oneAPI compiler can work with SYCL. Hosted Services Modernizing Java Apps and Data on Azure Part Three: Migrating to Azure App Service   (2 votes) by Jeff Griffith (updated 5 days ago) How to lift and shift our Java app to Azure using Azure App Service Modernizing Java Apps and Data on Azure Part Two: Migrating Data   (1 votes) by Jeff Griffith (updated 6 days ago) How to set up an Azure PostgreSQL database, migrate app's data over, and ensure the application still works Streaming at Scale with Azure Event Hubs for Kafka Developers Part 1: Getting Streaming Data into Azure   (1 votes) by Glenn Prince (updated 4 days ago) In this article, we create an Event Hubs instance and a demonstration application that sent messages using the Kafka API. Streaming at Scale with Azure Event Hubs for Kafka Developers Part 2: Processing Streaming Data with Azure Functions in Python   (0 votes) by Glenn Prince (updated 3 days ago) In this article, we develop several Azure Functions in Python to process the payload we receive and save the data to a Cosmos DB instance. Streaming at Scale with Azure Event Hubs for Kafka Developers Part 3: Analyzing and Visualizing the Data   (0 votes) by Glenn Prince (updated 2 days ago) In this article we finish building our application by adding Power BI to build reports and dashboards on top of our Cosmos DB dataset. Programming Languages Visitor Pattern in C# - 5 Versions   (6 votes) by Mark Pelf (updated 5 days ago) Tutorial article describing Visitor Pattern in C# Multithreading in C#   (8 votes) by Uladzislau Baryshchyk (updated 4 days ago) An overview of multithreading in C# A C# Library to Generate and Display Digital Signals   (4 votes) by JorgeLuisOrejel (updated 3 days ago) C# library that generates and displays various digital signals in Windows Forms Improving WCF Service Quality (Part 4 - Logging)   (0 votes) by Utku Ozan ÇANKAYA (updated 6 days ago) How to add logging to WCF services Improving WCF Service Quality (Part 2 - Validation)   (0 votes) by Utku Ozan ÇANKAYA (updated 6 days ago) How to add validation to WCF service requests Improving WCF Service Quality (Part 3 - Authentication & Authorization)   (0 votes) by Utku Ozan ÇANKAYA (updated 6 days ago) How to add authentication and authorization to WCF services Web Development 6 Misconceptions About Open-Source   (0 votes) by Mateen Firoz (updated 6 days ago) In this article we provide a brief history of open-source, discuss some misconceptions regarding open-source, then look at some enterprise options that effectively combine both commercial and open-source options. Articles updated Best practices The Software Rewrite   (23 votes) by Greg Utas (updated 2 days ago) Open-heart surgery on your Big Ball of Mud Desktop Programming 3D Face Viewer and Matcher   (128 votes) by Yang Kok Wah (updated 5 days ago) A tool to generate face images and animated gif files for different angles and lighting using only a single face image. Also includes Face Matcher using Microsoft Face API. General Programming Robust C++: Safety Net   (37 votes) by Greg Utas (updated 3 days ago) Keeping a program running when it would otherwise abort Robust C++: Object Pools   (16 votes) by Greg Utas (updated yesterday) Recovering from memory leaks Math Expression Evaluator for VBA   (2 votes) by W. García (updated 5 days ago) A class module developed to evaluate mathematical expressions given as VBA strings Programming Languages QR Code Encoder and Decoder C# Class Library for VS 2022 .NET 6.0 (Version 3.0.0)   (116 votes) by Uzi Granot (updated 2 days ago) QR Code libraries to allow program to create QR Code image or read image containing one or more QR Codes PDF File Analyzer With PDF Parsing Classes. (Version 3.0 for VS 2022 .NET 6.0)   (73 votes) by Uzi Granot (updated 6 hours ago) PDF File Analyzer is designed to read, parse, and display the internal structure of PDF files. Version 2.1 supports encrypted files. Bring Your Animations to H264/HEVC Video   (31 votes) by Shao Voon Wong (updated 18 hours ago) Bring your animations to H264/HEVC video using C++ and C# with h/w acceleration Fluent Interface Pattern in C# - With Inheritance Problem   (18 votes) by Mark Pelf (updated yesterday) Tutorial article on Fluent Interface Pattern in C# Anonymous Pipes Made Easy   (16 votes) by pdoxtader (updated 6 days ago) A simple and convenient wrapper class for Anonymous Pipes in C# using serialization. Making HTTP REST Request in C++ With WinHTTP   (6 votes) by Shao Voon Wong (updated yesterday) How to make an HTTP REST request in C++ with WinHTTP wrapper Web Development HTML Buttons for User Interaction Rather than User Interface   (18 votes) by Zijian (updated 5 days ago) Basic user interaction designs with buttons in Web applications New Tips and Tricks added Database Development Tutorial: Compare JSON Documents and Apply Patches in TerminusDB and MongoDB   (0 votes) by Oliver Smith 2022 (updated 4 days ago) Save time comparing JSON docs and build collaboration features into your applications Desktop Programming Airspace Solution   (0 votes) by Saurabh Singh _ (updated 5 days ago) A simple approach to handle Airspace problem Mobile Apps How to Create Adapters Easily in 2022 as an Android Developer   (0 votes) by AmrDeveloper (updated 2 days ago) How to get any Adapter class from model class easily and quickly VBA Outlook Attachments Counter, Don't Send Mails Without Attachments Anymore   (2 votes) by Joan M (updated 6 days ago) When you forget to attach an invoice and your customer doesn't alert you... well, you start thinking about methods to prevent it from happening again. New Technical Blogs added Database Development SQL SUM Function   (0 votes) by essentialSQL (updated 11 hours ago) The SQL SUM function returns the total value within a table or group. In its simplest use, SUM() totals a column for all results and returns a single value. In this example the query returns the total orders for all SalesOrderDetail records SELECT SUM(LineTotal) AS OrderTotal FROM Sales. Programming Languages SQL TOP   (0 votes) by essentialSQL (updated 11 hours ago) Some times you just need to use SQL TOP to reduce the number of rows shown in your result. This is handy for troubleshooting for showing a summary, such as the first in a list. SQL TOP Video I put together a video to help you understand TOP. If covers the main topics presented in […]. SQL FULL Join   (0 votes) by essentialSQL (updated 11 hours ago) The SQL FULL JOIN combines results from a left and right outer join into one result.  Or in other words, it is an inner join including unmatched rows from both the left and right tables.  This is the key difference between a SQL FULL JOIN and inner join. Contains in SQL   (0 votes) by essentialSQL (updated 12 hours ago) Sooner or later, you want to know when a column contains in SQL another value.  In this article we'll go over several ways you can test to see whether one value is contained within an another. SQL HAVING Tutorial   (0 votes) by essentialSQL (updated 12 hours ago) Use SQL HAVING to filter summary results from a GROUP BY.  It specifies the search condition for the group or aggregate. SQL HAVING is only used with SELECT.  It is mostly used when a GROUP BY is present, if one isn't there is an implicit single aggregated group. How to do an Impossible Join with String Split   (0 votes) by essentialSQL (updated 2 days ago) Use STRING_SPLIT() to join two tables © 2022 The Code Project.  All rights reserved. This email was sent to vutunglampro@gmail.com. To stop receiving The Weekly Newsletter click here. CodeProject 20 Bay Street, 11th Floor, Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900 Please do not reply directly to this email. It was sent from an unattended mailbox. For correspondence please use webmaster@codeproject.com