(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.
Other News
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.
JavaScript Tracing: How to Find Slow Code
(Michiel Mulders) Finding slow JavaScript code can be a tricky problem to solve. Small code changes can have a big impact on the performance of your code.
DB2 for z/OS Locking for Application Developers Part 3
(Gareth Copplestone-Jones) This is the third article in the series on locking for DB2 for z/OS developers. To recap, data integrity and application performance are dependent on application programs being designed and coded to take into account the locking strategy used and working in collaboration w
User Lockout with ASP.NET Core Identity
(Marinko Spasojevic) The user lockout feature is the way to improve application security by locking out a user that enters a password incorrectly several times.
Exploring Color Histograms In GraphicsMagick And Lucee CFML 5.2.9.31
(Ben Nadel) Within InVision, one of the interesting features of “Boards” is that, when you upload an image, the app shows you the “top colors” present in the image (which you can then re-add to the Board as a Swatch).
Microsoft Details Low-Code DevOps
(David Ramel) The burgeoning low-code application development space should and can do DevOps too, says Microsoft, which has detailed new tooling for its Power Apps and Power Platform.
Connecting to a MySQL Database in .NET
(Hannes Du Preez) .NET is great and provides a ton of tools for working with databases and data sources. There are times though that a data source may not be inherently supported.