(Larry Leonard) This code is for CMS (Central Management Servers), and displays all the databases on all the servers that don’t have a specified table.
Author: SSWUG Research
Quickly Check If SSL For SQL Is Enabled
(Chris Bell) To quickly check SSL is configured on your SQL Server you can run the following query.
MySQL Vs Db2 – Part 1
(Srinivasa Inaganti) MySQL is open-source RDBMS and is gaining popularity in the recent years.. I am starting a comparison series for mysql and db2.
Geographic replication and quorum Calculation in MySQL/Galera
(Marco Tusa) Nowadays most companies use geographic distributed platforms to better serve their customers. It is quite common to see companies with datacenters in North America, Europe and Asia; each site hosting databases and shared data. In some cases the data is simply spread around for better ac
On Installs and Updates of SQL Developer
(Jeff Smith) As we get nearer to releasing our next update for Oracle SQL Developer, there are a few FAQ’s I’d like to answer.
The Hitchhiker’s Guide to the EXPLAIN PLAN Part 37: POISED: A problem-solving method
(Iggy Fernandez) P.O.I.S.E.D. is the acronym I invented for the performance tuning method described by Chris Lawson in The Art and Science of Oracle Performance Tuning; it stands for Problem, Observation, Interpretation, Solution, Execution, and Documentation.
SQLTXPLAIN and the AWR Warehouse- Part II
(Kellyn Pot’Vin) I finally have a moment to look into my “hacked” SQLT XPRECT/XTRACT runs and see if the changes I made were enough to run properly with the AWR Warehouse.
DropDown Binding With jQuery
(Joginder Banger) In this article we learn how to bind a Dropdown using jQuery.
DevOps made easy with Bluemix
(Lauren Schaefer) Need an easy DevOps solution? You’ve come to the right place: IBM Bluemix.
It’s TR Time: What’s Next For The IBM i Database?
(Dan Burger) Web application development depends on two document formats for the interchange of business data: XML and JSON. The smaller (lighter weight), quicker to transmit, and more efficient is JSON. XML has been a good choice and has served its purpose well. It continues to do so.