(Jean-François Gagné) Recently, I was puzzled by MySQL replication ! Some weird, but completely documented, behavior of replication had me scratching my head for hours. I am sharing this war story so you can avoid losing time like me (and also maybe avoid corrupting your data when restoring a back
Other News
SQL SERVER – Script to Find All Columns with a Specific Name in Database
(Pinal Dave) My biggest pleasure for my job is meeting new people every day while doing a Comprehensive Database Performance Health Check. Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database.
Data Binding In Angular 8
(Khaja Moizuddin) In this article, we will learn about Data Binding in Angular. As we know Data Binding is used for binding the data from View to Component or Component to View.
Analysing Database Time with Active Session History for Statements with Online Optimizer Statistics Gathering Operations
(David Kurtz) I have been looking into the performance of online statistics collection. This feature was introduced in 12c. When statistics are collected online there is an extra OPTIMIZER STATISTICS GATHERING operation in the execution plan.
Using Azure Functions Durable HTTP APIs
(Mark Heath) One of the really nice new features released last year in Durable Functions v2 is support for “Durable HTTP APIs”.
Seriously Inconsistent Table Information in MySQL 8.0 Information_Schema
(Peter Zaitsev) In MySQL 8, Information Schema was basically re-written to utilize the all-New Data Dictionary which made it faster and better in many ways. Yet it also introduces some very counterintuitive behaviors when it comes to how actual and consistent data is.
Troubleshooting SQL Server Replication Installation
(Gareth Newman) When you attempt to configure a SQL Server distributor or create a publication in SQL Server Replication, an issue you can come across, is that the SQL Server Replication feature it is not installed!
How to Install Angular 9 CLI and Create an Angular 9 Project with Routing
(Ahmed Bouchefra) In this tutorial, we’ll install the latest Angular CLI version and generate a new Angular 9 project with routing.
Add a deployment to Oracle GoldenGate 19c Microservices
(Bobby Curtis) Once you have an up and running Oracle GoldenGate Microservices environment, there may come a time when you need to add another deployment to the enviornment. Adding deployments is easily done using Oracle GoldenGate Configuration Assistant (OGGCA).
Deploying ASP .NET Core 3.1 to Azure App Service
(Shahed C) This is the fourth of a new series of posts on ASP .NET Core 3.1 for 2020. In this series, we’ll cover 26 topics over a span of 26 weeks from January through June 2020, titled ASP .NET Core A-Z! To differentiate from the 2019 series, the 2020 series will mostly focus on a growing single c