Weekly Newsletter (19 Aug 2019)

Monday, August 19, 2019 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 Add Video/Voice Call Into Your App With Just A Few Lines Of Code Add high-quality live video/audio calls to any app or site. Build engaging communication experiences from one-to-one chats to large-scale interactive broadcasts with ease. Get a 30-Day Trial with $25 worth of Free Usage Credit Now! How to track every change to your SQL Server database Want to see who made database development changes, what they were working on, and why they made each change? Redgate SQL Source Control works with your source control system to give you a full version history, with line-level changes. Try free Weekly Poll Results What makes great documentation? Survey period: 12 Aug 2019 to 19 Aug 2019 Great docs can convince us to use a product. Bad docs just make our lives painful. Option Votes %   It contains code samples 504 72.62 It includes step-by-step instructions to complete specific tasks 422 60.81 It provides information targeted towards novice users 333 47.98 It provides information targeted towards advanced users 304 43.80 It includes a walk-through of a sample application 316 45.53 It lists common API calls 316 45.53 Is comprehensive and covers every possible scenario (within reason) 195 28.10 It provides a quick overview of the key points in the documentation 395 56.92 Other (please comment) 48 6.92 Responses 694    Respondents were allowed to choose more than one answer; totals may not add up to 100% View optional text answers (49 answers) This week's survey: What size monitor are you sporting these days? Latest Additions New articles added Algorithms & Recipes Pck/Edit: A GUI for Building Parsers   (4 votes) by honey the codewitch (updated 2 days ago) Quickly and easily build parsers and tokenizers using Pck's editor Pck/LALR(1): An LR parsing algorithm   (1 votes) by honey the codewitch (updated 4 days ago) An LALR(1) parsing algorithm as part of Pck Pck/Cfg: Context Free Grammars in PCK   (1 votes) by honey the codewitch (updated yesterday) Using PCK's grammar system, and understanding the concepts behind it. ASP.NET Seeding Data MVC 6 .NET Core Application   (7 votes) by dnxit (updated 3 days ago) Seeding data in MVC 6 .NET Core 2.2 application at startup Creating ASP.NET Core Application with Docker Support   (4 votes) by Shweta Lodha (updated 4 days ago) In this article, we will see how to utilize docker for ASP.NET Core application. C / C++ Language Dark corners and pitfalls of C++   (0 votes) by SimbirSoft (updated 2 days ago) C++: love and intrigue Database Database for Financial Accounting Application III: Completing Infrastructure   (1 votes) by Niemand25 (updated 10 hours ago) Designing a simple yet functional database for financial accounting application Files and Folders decode multiPage rotate tif.zip   (1 votes) by LeisureBamboo (updated 5 days ago) The decode and encode of multiPage rotate tif.zip GDI Real Label Size and View Angle Measurement Tool   (3 votes) by Member 13092868 (updated 5 days ago) This tool helps you create a label with given degrees of view angle. Also helps you estimate REAL label height and width by providing you linear correction functions to apply to inaccurate MeasureString values HTML / CSS Create Music Playlist with HTML5 and JavaScript   (0 votes) by MattZand (updated 4 days ago) Learn how to leverage the power of HTML5 audio and video tags Product Showcase Getting Started with RavenDB Cloud Database   (0 votes) by Judah Gabriel Himango (updated 3 days ago) Spin up a RavenDB database quickly and cheaply. Create a highly-available database cluster in minutes. Try out the all new RavenDB Cloud for free at cloud.ravendb.net. Trigger Snowflake IFTTT Flows in Azure App Service   (0 votes) by Jerod Johnson (updated 4 days ago) This article shows how to automate IFTTT (if-this-then-that) workflows with standard wizards in Logic Apps. Site & Server Management Learn to use SQL Server Date Functions   (3 votes) by essentialSQL (updated 4 days ago) SQL server's date functions provide you a set of function that you can use to manipulate dates.  The function are used for a wide variety of operation such as adding weeks to a date, calculating the difference between two dates, or to decompose a date into its fundamental parts. Tools and IDE Prepare (Oracle) SQL for Spooling   (1 votes) by Marijan Nikic (updated yesterday) An HTML tool written in JavaScript to convert a regular Oracle SQL query into a spooling script Windows Workflow Foundation Introduce an IPC Component Based on Windows Message   (1 votes) by flyhigh (updated 6 days ago) Simple and reliable IPC module based on Windows message, which supports recursive call up to 19 rounds because of the limitation of Windows. Articles updated .NET Framework Adding EntityFrameworkCore Support to .NET Core Project   (8 votes) by Benktesh Sharma (updated 5 days ago) Demonstrate how to add EF support in .NET Core project Artificial Intelligence and Machine Learning TensorFlow - Creating C# Applications using TensorFlowSharp   (8 votes) by Sau002 (updated 5 days ago) How to create C# applications using TensorFlowSharp ASP.NET Export to Excel using NPOI - C# and WEB API   (8 votes) by Mohammed Dawood Ansari (updated 5 days ago) "How to export the List into an Excel file" in a generic way using NPOI with .NET/.NET Core WEB API C# Wexflow - Open Source Workflow Engine In C#   (182 votes) by Akram El Assas (updated 5 days ago) A high-performance, extensible, modular and cross-platform workflow engine. Built for automation. Database SQL Index Manager – Free GUI Tool for Index Maintenance on SQL Server and Azure   (45 votes) by Sergey Syrovatchenko (updated 3 days ago) Open source index maintenance tool for SQL Server and Azure Edit Controls MFC/Win32 HEX Control 2.5   (52 votes) by Jovibor (updated 3 days ago) HEX control for MFC/Win32 apps Miscellaneous Getting Started with gRPC Client and Server using ASP.NET Core   (0 votes) by syed shanu (updated 2 days ago) In this article, we will see how to create a gRPC service using the ASP.NET Core template. We will also create a client application using .NET Console core to call the gRPC service server method directly to send and receive the message from the client application. Threads, Processes & IPC C++11 FreeRTOS GCC   (14 votes) by Piotr Grygorczuk (updated 6 days ago) Enable C++11 multithreading features in GCC for FreeRTOS New Tips and Tricks added Ajax How to properly use the Ajax Toolkit Rating control   (0 votes) by dimpant (updated 3 days ago) Utilize the Rating Ajax control in your ASP.NET Web Forms application. Button Controls Faded/Dimmed Button Images   (1 votes) by AntGamble (updated 3 days ago) Dim Windows Forms Buttons when disabled C / C++ Language Fancy Time from std::chrono namespace   (0 votes) by Alexey Shtykov (updated 6 days ago) How to become a fancy guy who uses C++ time library instead of old and famous time.h C++: Size Matters in Platform Compatibility   (0 votes) by Shao Voon Wong (updated 3 days ago) Data width must stay unchanged for cross-platform interoperability Debug Tips Console.log Object display   (2 votes) by DaveAuld (updated 4 days ago) Object inspection with %O in the console output. Libraries Introduction to Rest.API.Translator   (2 votes) by Alen Toma (updated 3 days ago) Communicate with REST API using interface and expression instead of URL New Technical Blogs added Amazon Web Services What is SQLite3?   (7 votes) by essentialSQL (updated 3 days ago) SQLite3 Review SQLite3 is a compact free database you can use easily create and use a database. Azure How to remove /api from Azure Functions URLs   (1 votes) by Ryan Peden (updated 3 days ago) How to customize the URLs of your Azure Functions Code Generation Advent Of Code – Some Assembly Required – Puzzle 7   (2 votes) by Member 14516258 (updated 6 days ago) Advent Of Code – Some Assembly Required – Puzzle 7 Content Management Server What is a SQL Server Data Dictionary?   (1 votes) by essentialSQL (updated 4 days ago) What is a Data Dictionary? In SQL Server the data dictionary is a set of database tables used to store information about a database's definition.  The dictionary contains information about database objects such as tables, indexes, columns, datatypes, and views. Database Learn about Stored Procedures   (4 votes) by essentialSQL (updated 4 days ago) In this blog post, you will learn about stored procedures What is a Database Trigger?   (4 votes) by essentialSQL (updated 3 days ago) What is a Database Trigger? A database trigger is special stored procedure that is run when specific actions occur within a database.  Most triggers are defined to run when changes are made to a table's data. What is a Database Table?   (3 votes) by essentialSQL (updated 3 days ago) A relational database is made up of several components, of which the table is most significant.  The database table is where all the data in a database is stored, and without tables, there would not be much use for relational databases. Database Indexes Explained   (3 votes) by essentialSQL (updated 3 days ago) A database index allows a query to efficiently retrieve data from a database.  Indexes are related to specific tables and consist of one or more keys.  A table can have more than one index built from it.  The keys are a fancy term for the values we want to look up in the index.  The […]. SQL Reporting Services Query Plans in SQL   (3 votes) by essentialSQL (updated 3 days ago) All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide Getting Started Using SQL Server.  Let’s get started and learn about a query plan. What is a Query Plan? What are the Major Part of a SQL DB?   (3 votes) by essentialSQL (updated 3 days ago) A SQL database is used to store and retrieve data.  The database is housed in a database server and largely controlled by a database management system.  All SQL databases, whether they MS SQL Server, MySQL, Oracle, or Progress have several components in common. SQL Truncate and Delete   (4 votes) by essentialSQL (updated 3 days ago) In SQL Server there are a couple a ways you can delete rows from a table.   You can use the TRUNCATE and DELETE command.  Though the end result of both commands is the same, there are very important differences you should know about. Whats the Difference between Truncate and Delete? How do I combine results from several SQL tables (hint: there are three ways)   (1 votes) by essentialSQL (updated 3 days ago) Many times in a relational database the information you want to show in your query is in more than one table.  This begs the question "How do you combine results from more than one table? SQL ACID Explained   (1 votes) by essentialSQL (updated 3 days ago) What are the  ACID Database Properties? The ACID database properties define the key characteristics SQL databases use to ensure database modification are saved in a consistent, safe, and robust manner. ACID is an acronym to remember the key principles of a transnational system. Uncategorised Technical Blogs What is the difference between WHERE and HAVING clauses?   (3 votes) by essentialSQL (updated 3 days ago) In this article learn when to use WHERE and HAVING.  Both perform similar functions, but for different purposes! All the examples for this article are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database. Blogs updated Cross Platform Bypassing ASLR and DEP - Getting Shells with pwntools   (0 votes) by Apex95 (updated 5 days ago) A short trick to bypass both ASLR (Address Space Layout Randomization) and DEP (Data Execution Prevention) in order to obtain a shell in a buffer-overflow vulnerable binary © 2019 The Code Project.  All rights reserved. This email was sent to vutunglampro@gmail.com. To stop receiving The Weekly Newsletter click here. CodeProject 503-250 Ferrand Drive, Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100 Please do not reply directly to this email. It was sent from an unattended mailbox. For correspondence please use webmaster@codeproject.com