(Paolo Bruni, Jason Arnold, Leticia Cruz, Jeff Feinsmith, Willie Favero, Anna Griner, James Guo, Chris Harlander, Johannes Kern, Ravi Kumar, Ruiping Li, Andy Perkins, Steve Speller, Jonathan Sloan and Dino Tonelli) The IBM DB2 Analytics Accelerator for IBM z/OS is a high-performance appliance that
Other News
ADF and service dependencies
(Maarten Smeets) In order to keep the business-IT gap manageable, it is important for analysts, designers and architects to know what their implemented application landscape actually looks like. An important part of this is insight in dependencies between different components.
OPTIMIZER_MODE = FIRST_ROWS_N
(Andrew Reid) I have known about the first_rows optimizer mode for some time. This tells Oracle to use an execution path which will return the first few rows as quickly as possible. However, I recently read about the first_rows_n optimizer mode, which apparently appeared first in Oracle 9.
30 SQL Developer Posts in 30 Days, Day 29: Preferences Revisited
(Jeff Smith) Setting up a new install of SQL Developer this morning – exciting stuff as we’ll be teasing some v4.1 features at Open World this week – I found myself immediately tweaking the following preferences.
MySQL Goes Mobile: A Roundup of Popular MySQL Mobile Apps for iOS
(Rob Gravelle) One of the hottest trends in the world of databases right now is administration using mobile devices. Today’s database administrator doesn’t have to be chained to his/her desktop workstation all day long and then hope that he/she doesn’t get the dreaded wakeup call at 3 AM! I rememb
Transforming Binary Data At The Bit Level Using ColdFusion And BitBuffer.cfc
(Ben Nadel) For the last two weeks or so, I’ve been digging into bit-wise operations in ColdFusion. This all started out as an exploration of Base32-encoding, that I needed for a larger project. As I was looking into the Base32-encoding, it occurred to me that a great deal of the complexity in the e
SSRS deploying reports using RS.EXE command line video
(Scott Murray) SSRS 2012 reports can be deployed in various ways including:
Database Anti-Patterns
Recently I encountered a database design intended to reduce the load on a relational database that actually had the reverse impact. The problem was a parent child relationship having a 1 to 1 or many relationship. Normally you would use two tables. You would have a parent table and a child table, containing a foreign key to the parent table. […]
SSWUGtv: Cloud Technology Partners: Ben Grubin, Director of Product Management from Cloud Technology Partners discusses PaaSLane™, a solution to asses
Video Programming for IT Professionals
RDBMS Concept In Normalization & De-normalization of Data — Part 4
RDBMS Concept In Normalization & De-normalization of Data – Part 4 As stated in the last article that “In the forthcoming article we will be noticing particular fine point’s concerning the Practical Reliance of Normalization, few rules for converting the tables from one Normal Form to another Normal Form and then focusing on what is De-Normalization?”, here is the article....
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here