(stewashton) My last post had code to rewrite SELECT statements that tried to access public package variables. Here I’ll integrate the code into the SQL Translation Framework. Use this only in development environments.
Community
How to manage DB and Cell servers remotely on Exadata with ExaCLI utility – (Part 1)
(Syed Jaffar Hussain) Whoever is working with Exadata or knew how to administrate Exadata major components like DB and Cell nodes, will certainly knows the use of CellCLI, dcli and DBMCLI utilities.
SQL SERVER – Cleanup Plan Cache For a Single Database
(Pinal Dave) During my recent Comprehensive Database Performance Health Check, we had implemented quite a few improvements in the database.
Least Squares: A Matrix Approach in Java
(Mark H Bishop) Many disciplines depend on linear regression for understanding data. Most often, practitioners turn to packaged programs to do the math.
TechTip: Calling SQL Procedures on the Fly
(Juan Macias) The command Call SQL Procedure (CALLSQLPRC or CALLP) allows us to call an SQL or external procedure and optionally retrieve some or all of the result sets returned by the procedure.
Dr. Michael Stonebraker’s 10 fears about the future of the DBMS field
(Emil Kotrc) The performance of Db2 depends on many things. It spreads from the application and the SQL, through the Db2 itself, down to the underlying system configuration.
18 Node.js and JavaScript libraries for fast and simple microservices
(Peter Wayner) Long ago in the early days of the Internet, pointing your browser at a URL meant your machine would start up a conversation with one server, and only one—the one connected with that URL.
Working with Dictionaries in C#
(Tapas Pal) In .NET, a Dictionary class is a collection of a key and value pair of data. C# represents a generic Dictionary class that can be used to create a collection of objects. The key should be identical in a key-value pair and it can have at most one value in the dictionary.
Getting started with Azure SQL Managed Instance
(Jovan Popovic) Azure SQL Managed Instance is fully managed PaaS version of SQL Server hosted in Azure cloud and placed in you own VNet with private IP address.
Animating Elements In From A Mouse-Event Location In Vue.js 2.5.21
(Ben Nadel) Over the weekend, I re-created the Pandora Radio station list animation using Vue.js 2.5.21. Only, I didn’t really “do” anything; because, as it turns out, this list “move” animation is supported right out of the box in Vue.js.