(Hannes DuPreez) Welcome to the final installment of my Xamarin article series. I think you’ll agree that we have covered a lot during the past few months, and I hope that this series has helped you in some way.
Community
Structuring React applications
(Jack Franklin) One of the best features of React is that it doesn’t force much convention and leaves a lot of decisions up to the developer.
Understanding Cross-Site Replication in a Tungsten Composite Multi-Master Cluster for MySQL, MariaDB and Percona Server
(Eric M. Stone) In this blog post we will discuss how the managed cross-site replication streams work in a Composite Multi-Master Tungsten Cluster for MySQL, MariaDB and Percona Server.
Making Lists
(stewashton) Strings that contain multiple values violate first normal form, which mandates “one value per column per row”.
DBMS_JOB – the joy of transactions
(Connor McDonald) This is a followup to yesterdays post on DBMS_JOB and is critical if you’re upgrading to 19c soon.
Transforming Missing Data using Oracle Data Mining
(Brendan Tierney) In a previous post I showed how you can normalize data using the in-database machine learning feature using the DBMS_DATA_MINING.TRANSFORM function. This same function can be used to perform many more data transformations with standardized routines.
SQL SERVER – Natively Compiled Stored Procedures and Location of Compiler
(Pinal Dave) I recently implemented a Memory Optimized Table solution at one of the large financial organizations while working on Comprehensive Database Performance Health Check. It was indeed a very large scale project where I had to help a customer get 10x speed to their original transactions wit
Quiz Application in React (Using Redux)
(Anurag Gandhi) A general purpose quiz application in React that can be used to run quizzes, mock tests, surveys, etc. This is an alternate version of my another article: “Quiz Application in Angular”.
Get-DbaHelpIndex command in DBATools
(Rajendra Gupta) DBATools is an open-source PowerShell that contains a collection of useful commands. In this series of articles on DBATools (see TOC at the bottom) we performed installation of it.
Common SQL Server Mishaps
(Tim Radney) I’ve been teaching and writing about common SQL Server mistakes for many years.