(Peter J. Jamack) The data warehouse has been an ongoing battle among organizations for years. How do you build it? What data can you integrate? Should you use Kimball or Inmon, corporate information factory (CIF), or data marts? The list could go on for days — decades, even. With big data, the que
Author: SSWUG Research
Tips on Using db2advis with Multiple Queries
(Ember Crooks) Many times, the SQL analysis I do is extremely focused – mostly on SQL that is a proven resource hog or a suspected problem. Analyzing all SQL used in a particular process can be a bit different, and may not be something that is frequently done in WebSphere Commerce databases.
How to safely change the ‘postgres’ user password via ‘psql’
(Gabriele Bartolini) One of the most recurring questions I get from users that are starting their long and prosperous journey with PostgreSQL involves connecting with the “postgres” user.
Oracle 12c: Export by View
(Marco Gralike) A small enhancement, but what a golden nugget! At least that’s what I think.
Oracle Database 12c By Example – SQL Developer and Multitenant
(Jeff Smith) As you may have heard, Oracle Database 12c is now available. In addition to the binaries and docs going out, we also published a few new Oracle By Example (OBE) chapters. You can find those links here on our product page.
Table Statistics With Histograms procedure – TSWH
(Bobby Durrett) I’ve uploaded the most recent version of a stored procedure that I use for gathering optimizer statistics on a table in Oracle. You can download a zip here. See the file buildandtest.bat to see how to build the needed tables and procs and run the supplied tests.
How to Add a jQuery FAQ Accordion in WordPress
Recently one of our users asked us if there was a way for them to add a FAQ accordion on their WordPress site. There are many plugins available that allows you to add a frequently asked questions or FAQs section in WordPress. In this article we will show you how to add a jQuery FAQ accordion in your
Learn About Android Manifest.Xml File
(Amir Ali) Every application in Android has an Android manifest file that is present in its root directory. It is a XML file that works as a bridge between developers and the Android system. The Android manifest XML file allows the developer to tell all the functionalities and requirements of the ap
What’s the big deal about Big SQL?
(Cynthia M. Saracco and Uttam Jain) If you specialize in relational database management technology, you’ve probably heard a lot about “big data” and the open source Apache Hadoop project. Perhaps you’ve also heard about IBM’s new Big SQL technology, which enables InfoSphere BigInsights users to quer
Theming Chrome Developer Tools
(K. Scott Allen) The default styles for the Developer Tools in Chrome are a bit uninspiring.