(stewashton) Strings that contain multiple values violate first normal form, which mandates “one value per column per row”.
Other News
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”.
Data Ethics, Protection and Privacy
Pro-Center Video Programming for IT Professionals...
Auditing and Detecting Illicit Activity in SQL Server
Pro-Center Video Programming for IT Professionals...
Data Protection Planning and Execution
Pro-Center Video Programming for IT Professionals...
Thinking Like an Attacker
Pro-Center Video Programming for IT Professionals...
The Cloud Is Coming!
Pro-Center Video Programming for IT Professionals...
