(Martin Bach) Oracle 11g introduced the abilty to control the behaviour of the dbms_stats package by setting preferences on the database, schema, and table level.
Community
Athena: Extracting data from JSON
(Anand) Suppose you have a table in Athena and its column contain JSON data. How can you extract the individual keys?
Choose your shape
(Pieter Van Puymbroeck) A common thing we heard from customers is that it would be desirable to use different shapes in a Data Guard configuration in the Oracle Cloud.
Part 2: Docker for Oracle Database Applications in Node.js and Python
(Christopher Jones) This is the second in a two part series on using Docker for Oracle Database applications.
Improve Power BI Performance with SQL Server Indexing
(Semjon Terehhov) What Power BI queries do to an underlying SQL Server data warehouse can be both complicated and confusing to understand. I am writing this tip to help DBAs and developers get the most out of their resources and avoid service degradation over time by providing an indexing strategy f
Raw Websockets Minigame with Angular and ASP.net Core
(SleepyCrat) A asp.net core web project implementing websockets using .net core’s middleware. We implment the websocket client app using Angular and a aste of vanilla javascript.
MySQL InnoDB Cluster Tutorial 3 ( Switching cluster mode and primary member )
(Sri Sakthivel Durai Pandian) So far, I have written two tutorial blogs about MySQL InnoDB Cluster . Those blogs describe about the InnoDB Cluster configuration and how to integrate InnoDB Cluster with the MySQL router .
Using XSLT And XML Transformations To Style My Blog’s RSS Feed As An HTML Page
(Ben Nadel) For years, I’ve been using CSS to add a touch of style to my blog’s RSS feed. For those of you who are relatively new to web development, RSS stands for “Really Simple Syndication”; and was one of the primary ways that content was distributed on the web prior to the “Social Media” era.
Oracle Cloud Infrastructure Cloud Shell – Here’s what I discovered
(Trent) This week I spotted a new terminal-like icon at the top of my OCI tenancy. Upload clicking it, its a GCP-esque terminal emulator directly in the browser.
SQL SERVER – Display Rupee Symbol in SSMS
(Pinal Dave) Recently, I was reached out by one of the my financial technology clients based out of the USA who has just launched their services in India. Their system worked fine in most of the area but the challenge was to display the Indian currency sign.