(Grant Fritchey) I absolutely love Query Store and the ability it provides to force a plan is amazing. However, there are a lot of little gotchas in this functionality.
Community
Working with SQL Cursors
(Manoj Debnath) In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time.
Oracle rowcache fastgets
(Frits Hoogland) This blogpost is about the Oracle database row or dictionary cache. This is a separate cache that caches database metadata, like database object properties or user properties.
Nulls are not stored in indexes … most of the time
(Connor McDonald) This question got posed on Twitter today
ORA-16014: log X sequence# XXX not archived in Standby
(Anuradha Mudgal) Today we are going to have a look on the steps which are used by DBA’s to resolve issue “ORA-16014: log X sequence# XXX not archived, no available destinations (In Standby Database)”.
The Remainder Operator Works on Doubles in Java
(Jeremy Grifski) I’ve been teaching at OSU for nearly two years, and it always astounds me how much I learn from my students.
Getting Started with IBM Z Resiliency
(Bill White, Marc Coq, Pabitra Mukhopadhyay, Carlos Alberto Pistillo, David Raften, Mai Zeng) Resiliency is the ability to provide the required capability in the face of adversity, without significant impact.
Getting Started with Azure DevOps
(Eric L. Anderson) I have been doing a lot of work lately with our build and release pipelines in Azure DevOps and while it is fresh on my mind I’m going to do a few posts to remind me of some of the things I have leaned and may or may not have gotten to use.
Introduction To .NET 5 For ASP.NET Developers
(Bipin Joshi) If you are keeping an eye on the progress and future direction of .NET you might be aware that somewhere in May 2019 Microsoft announced that the next major release after .NET Core 3.0 will be .NET 5. And just a few days ago they announced the availability of .NET 5 Preview 1.
Pixelating An Image Using GraphicsMagick And Lucee CFML 5.2.9.31
(Ben Nadel) The other day, while searching for some GraphicsMagick information, I came across a Stack Overflow post that was discussing an approach to pixelating part of an image.