(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.
Author: SSWUG Research
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”.
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.
Globally Configuring Values For JSON Serializer In ASP.NET Core 3.1
(Shweta Lodha) This article will focus on how one can set certain constraints on the given data type for JSON serialization and that too at the application level, which means changes need to be done at a global level rather than doing for specific custom class or property.
SQL SERVER – Always On Listener Failure – Provisioning Computer Object Failed With Error 5
(Pinal Dave) In the past, I have written a few blogs where I explained a few issues about the failure of listener creation in the cluster. In this blog, we would see another cause of listener creation failure.
MySQL 8 Group Replication Limitations
Most of our customers are 24*7 internet properties and their applications ( i.e. entire business operations) rely heavily on availability of respective database systems nodes, These systems going unavailable cause serious impact on reputation, customer experience and revenue.
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
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).
Azure: Crossdomain.xml inside Root of Blob Storage
(OwenDavies) My recent Azure adventures are working with a Flash client as the front end, which meant the need to implement a crossdomain.xml file to allow the Flash client to connect to my site.
Copy Table from Oracle to SQL Server on Linux
(Pablo Echeverria) SQL Server on Linux only allows creating linked servers to another SQL Server, so what options do you have when you want to consume data from an Oracle database table inside a SQL Server query when working on Linux?