(Ben Nadel) The other day, I was peer-reviewing some really cool static-asset processing pipeline stuff that Sean Roberts is building when something small caught my eye.
Community
Diving into query optimization
(Tomer Shay and Michael Coburn) EverSQL is a platform that intelligently tunes your SQL queries by providing query optimization recommendations, and feedback on missing indexes. This is the second post of our EverSQL series, if you missed our introductory post take a look there first and then come b
Enterprise Manager 13c – Database Usage Tracking Report Bug with FTP destination
(Dirk Nachbar) Within Oracle Enterprise Manager 13c you have a nice Feature under the BI Publisher Reports to generate Database Usage Tracking Reports and to deliver them to a FTP Server, called BurstToFTP.
Generate a formatted guid from database – Use Snippets
(Martien van den Akker) A very simple quick post today. I’m re-engineering a few Java based Mock Webservices into a SOA Suite/BPEL service.
What’s new in 19c – Part I (Grid Infrastructure)
(Syed Jaffar Hussain) Every new Oracle release comes with bundle of new features and enhancements. Though not every new feature is really needed to everyone, there are few new features that worth considering.
Diagnose and Fix SSIS Performance Problems for ETL Loads
(Fikrat Azizov) I was helping diagnose underperforming ETL jobs for one of my clients. They had SQL Server Agent Jobs which were calling SSIS packages to populate their DWH and these jobs were running much slower than they used to and were failing occasionally.
Web scripting and the JavaScript Language
(Julie C. Meloni and Jennifer Kyrnin) This lesson introduces the concept of web scripting and the JavaScript language. As the lesson moves ahead, you’ll learn how to include JavaScript commands directly in your HTML documents and how your scripts will be executed when the page is viewed in a browser
RESTGrid
(JUST_Neeraj) RESTGrid is a simple WorkflowETL system in .NET Core which uses REST services to interact with the outside world.
#0415 – SQL Server – Performance Tuning – Use STRING_AGG to generate comma separated strings
(Nakul Vachhrajani) With more and more data being exchanged over APIs, generating comma-separated strings are becoming a much more common requirement.
Db2 Recursive SQL in the Real-World
(Daniel Luksetich) You can find a ton of articles about recursive SQL dating back as early as 2004, but for this article I was asked to provide actual real-world situations where recursive SQL was put to use. In all of the situations it was a great success! First, however, a refresher.