(K. Brian Kelley) I am working with a system that doesn’t allow for NULLs in the SQL Server data model. However, I have clear cases where I’m missing information. For instance, I’m dealing with building out our academic system into a new platform and we have columns for final grade in a course as we
Community
Time Series Analysis in SQL and PL/SQL
(JP Vijaykumar) This article/script is provided for educational purpose ONLY.
Animating SVG Text on a Path
(Mary Lou) Animating SVG text on a path on scroll has been explained really well in this great video tutorial by the keyframers.
MySQL Partition over the Virtual / Generated Column
(Sri Sakthivel Durai Pandian) Had an interesting requirement from one of our client to have the two MySQL partitions ( partition_full / partition_half ) for store the Names based on the user input.
SQL SERVER – Drivers for DevOps – Efficient Monitoring
(Pinal Dave) At SQL Authority, my main job is to work with SQL Server Performance Tuning, and every day I learn that more organizations are implementing DevOps for their database platform.
How To Add Tooltip in React Application
(Sanwar Ranwa) In this article, we will learn how to add React material UI Tooltip in React applications. Tooltip is a pop-up that displays a message or information on hover, click or focus event.
Finding Distinct Values Quickly
(Paul White) Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. It looked at ways to find a relatively small number of distinct values from a moderately large dataset, and concluded that a recursive solution could be optimal.
EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033
(Anuradha Mudgal) Today we are going to have a look on the steps which we use to resolve the issue “EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033”
Oracle Cloud ‘follow up’
(Stefan) Follow up: „How to setup a CentOS instance and connect via ssh“
Try, Try, And Try Again
(mdinh) I hope you don’t judge a post by its title.