(Shahryar Ghazi) An interesting scenario that I came across today was the fact that if you use the same alias as the column name in a formatted string (using DATE_FORMAT) and you also use same alias in ORDER BY or GROUP BY clause then MySQL uses the string output of DATE_FORMAT to sort records rathe
Other News
Back up, restore, and roll forward in an InfoSphere Warehouse data partitioning environment
(Deepa Vyas and Amitkumar Bamane) Knowing how to back up and restore your database is a fundamental skill for every database administrator. In a partitioned database environment, where your database is split across multiple partitions or nodes, there are special considerations.
SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
(Pinal Dave) Madhivanan is SQL Server MVP and very talented SQL expert. Here is one of the nugget he shared on Just Learned.
Cohesion
Be a SSWUG.ORG Beta Tester! By late Jan. 2012, SSWUG.ORG will be launching a new version of our site. We’ll have a fresh new look with some new cool features. However, we want to make sure it ready for the masses. If you want to be one of the first to see the new SSWUG.ORG, and help determine it’s final […]
Server Automation
Server Automation The end of the year holidays are nearly here. Now’s the time to make sure your automated tasks are tuned up so that you can enjoy a great holiday without interruptions. Here’s a quick checklist: Backup Strategy is working and validated for adequate space Automated tuning processes are working Disk allocation is adequate Tables are defragmented Databases are […]
DOM Events in JavaScript
(David Walsh) Mozilla Firefox 7 introduced CSS’ useful text-overflow: ellipsis, an outstanding method of dynamically and elegantly concatenating strings within their parent elements. Firefox was late to the text-overflow party, so the Dojo Toolkit offered dojox.ellipsis, a resource that would shim e
Drs. Wood & Seuss Explain RDF in Two Minutes
(Eric Franzon) “How would you explain RDF to my grandmother? I still don’t get it…” a student recently asked of David Wood, CTO of 3Roundstones. Wood was speaking to a class called “Linked Data Ventures” and was made up of students from the MIT Computer Science Department and the Sloan School of Bu
Be Careful When Using The jQuery Proxy() Method Outside Of A jQuery Context
(Ben Nadel) Over the weekend, I spent a few hours trying to wrap my head around some modular JavaScript application development. In order to keep my modules decoupled from one another, I tried to make appropriate use of the publish / subscribe method of communication.
A DBA_HIST_SQLSTAT query that I am very fond of
(Neil Johnson) This is a quick post to share a SQL statement I use a lot at work. The query mines the AWR tables (beware the licence implications) for a specific SQL ID and date/time range and shows a few choice statistics for each snapshot period.
Day 10: The Twelve Days of SQL: Sometimes the optimizer needs a hint
(Iggy Fernandez) Questioning the capabilities of the Oracle optimizer is considered heresy by some. When I submitted a paper containing some of the above material in this series to a large user group conference a few years ago, the reviewer took offence and responded: “I was disappointed that you qu