(mdinh) I have been patching a lot lately and wanted a fast and easy method to source Oracle environment.
Community
Oracle ADF BC Reusing SQL from Statement Cache
(Andrejus Baranovskis) Oracle ADF BC by default is trying to reuse prepared SQL query from statement cache. It works this way when ADF BC runs with DB pooling off (jbo.doconnectionpooling=false).
Time SQL Execution with Python
(John Brady) I’ve said before in this blog how I find Python to be very useful for doing various things, including processing data to or from an Oracle database.
Preventing SQL from Running on a Testing SQL Server
(Hannes Du Preez) There are two ways to prevent your SQL code from running on a testing or production server.
DBA Myths: Can a differential backup get bigger than the full backup?
(Kenneth Fisher) The thing about DBA Myths is that they are generally widespread and widely believed.
Free SQL tuning tool: How’s My Database?
(Daniel Janik) It’s taken longer than I thought it may and I’ve run into several problems along the way but had a few people in the MVP community swing some homeruns to help me complete the BETA of this new SQL Server community query tuning tool.
Lesser Known jOOë Features: Useful Collectors
(lukaseder) jOOë is our second most popular library. It implements a set of useful extensions to the JDK’s Stream API, which are useful especially when streams are sequential only, which according to our assumptions is how most people use streams in Java.
Break When Value Changes: Data Breakpoints for .NET Core in Visual Studio 2019
(Leslie) “Why is this value changing unexpectedly and where or when is this occurring?!”
Solve 3 Biggest SQL Server Performance Challenges with Spotlight
(Pinal Dave) My primary responsibility is to help people with SQL Server Performance Tuning and Optimization, and I believe there are three important challenges any DBA faces.
AI and Big Data on IBM Power Systems Servers
(Scott Vetter, Ivaylo B. Bozhinov, Anto A John, Rafael Freitas de Lima, Ahmed.(Mash) Mashhour, James Van Oosten, Fernando Vermelho and Allison White) As big data becomes more ubiquitous, businesses are wondering how they can best leverage it to gain insight into their most important business questio