(Dave Stokes) Common Table Expressions (CTEs) are a very useful tool and frankly a big improvement on sub-queries. But there are differences in how they are implemented in MySQL and MariaDB.
Community
Managing Persisted State for Oracle JET Web Component Variable with Writeback Property
(Andrejus Baranovskis) Starting from JET 6.0.0 Composite Components (CCA) are renamed to be Web Components (I like this new name more, it sounds more simple to me). In today post I will talk about Web Component writeback property and importance of it.
Goldengate ERROR OGG-02037 Failed to retrieve the name of a missing Oracle redo log.
(Fahd Mirza Chughtai) One extract got abended and wasn’t able to start in Oracle Goldengate Version 12.2.0.1.160517 23194417_FBO. The redologs were present but extract was still abended and threw following error in the report file.
Scheduling Exports of Your Data Using the Cart
(Jeff Smith) This post won’t show you how to acutally do the scheduling bits – I’m going to assume you know how to use contrab or Windows Scheduler -but I will show you how to get SQL Developer setup so that you can call it from the command-line to do your export.
ASP.NET Core With Dapper And VS 2017 Using JWT Authentication WEB API and Consume it in Angular2 Client Application
(Rajesh kumar das02) I was trying to implement JWT Auth in web API. I want to consume the Web API in my Angular 2 client side application.
Azure SQL Database – Fixing My Scaling Failure
(blobeater) This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I was confused, so confused that I ended up logging a support request with Microsoft.
Using OpenApi.Document() To Create A Power BI Custom Connector For The Power BI REST API
(Chris Webb) The idea of creating a Power BI custom connector for the Power BI REST API is not a new one: Miguel Escobar wrote one earlier this year (see here for the source code and documentation).
Query Store and Plan Cache Plans Compared
(Grant Fritchey) Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is in cache is the plan that was used to execute the query.
Top 10 Node.js Developer Tools
(Sagar Arora) With the introduction of Node.js, it has become easier for application developers to create a fast, reliable, and scalable web application with much fewer lines of code.
Returning an XML Encoded String in .NET
(Rick Strahl) XML is not as popular as it once was, but there’s still a lot of XML based configuration and data floating around today.