Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (July 11 to July 17). Here they are, in order of popularity:
If you're a mobile developer looking for a database that won't crush devices more thoroughly than Play Services 5.0, SQLite isn't the only option anymore. Now there's Realm, currently available for iOS (and Android, soon).
In the past, we’ve been providing you with a new article every Friday about what’s new in Java 8. It has been a very exciting blog series, but we would like to focus again more on our core content, which is Java and SQL.
If you're wondering about the similarities between your database choices and your militarized suburban vehicle choices, Bruce Momjian and Marc Linster have the presentation for you!
Imagine you want to collect detailed usage statistics to tune your Oracle database, e.g. if you want to have A-Rows and A-Time values in your execution plans. It's simple enough, but of course, you hardly ever have the required privileges. So how can we get those advanced statistics? Easy: by using a logon trigger.
While there’s not much application-side IDENTITY generator
optimization (other than configuring database identity preallocation),
the sequence identifiers offer much more flexibility in this regard. One
of the most common optimization strategy is based on the hi/lo
allocation algorithm. This article will investigate various
sequence-like generation strategies and all the available optimizations.