(Pinal Dave) SQL Server 2012 introduces new analytical functions PERCENT_RANK(). This function returns relative standing of a value within a query result set or partition.
Other News
How to compress the size of an image file at runtime
(Ged Mead) This came up as a question on VB City recently, where the poster wanted to reduce image file sizes before saving to a database as a BLOB. It turns out that it’s easier to do than you might think. If you have an Image object, you can use its Save method to store it to your hard drive […]
ArrayObject PHP Class: An Introduction
(Alejandro Gervasio) In this first part of a two-part tutorial, I demonstrate how simple it is to use the ArrayObject SPL class. This class permits you to easily access properties through an array syntax.
Saving Records By ExecuteNonQuery() in FSharp
(Alok Pandey) ExecuteNonQuery() is a method of the Command Class in .NET. It does not return a record. Generally, it is used to store a record from the front end to the DataBase.
IBM Cognos Proven Practices: IBM Cognos BI – Create Side-by-Side Chart Comparisons with IBM Cognos Active Report
A brief video illustrating how to create two side-by-side charts that allow you to compare data from various cities in an IBM Cognos Active Report.
Enabling Drillthrough in Analysis Services
(Siddharth Mehta) Data analysis from a cube starts with aggregated and summarized data, followed by drill-down and drill-through of the data for a deeper and intelligent analysis. Drill down is inherently supported when you browse the data of the cube, but drill through has to be defined as per the
Remoting
Remoting I received this question from a reader regarding how to get applications operating on two different PCs to communicate. That is a broad topic, with many answers. So, today I thought I would consider one of the most difficult methods in Dot Net, which is Remoting. Obviously, there are a lot of other techniques/specifications to accomplish the same thing […]
ADF bug: missing af:column borders in af:table for IE7
(Chris Muir) There’s a rather obscure JDeveloper bug that only effects IE7, for af:columns in af:tables that show af:outputText fields based on dates that are null (phew, try and say that with a mouth full of wheaties). It occurs in 11.1.1.4.0 and 11.1.2.0.0 (and all versions in between it’s assumed
HOWTO: XDB Repository Events – An Introduction
(Marco Gralike) Oracle XMLDB Repository Events, IMHO, was one of the coolest functionalities introduced in Oracle 11.1. In principal they are a kind of event “triggers” that get fired during actions / methods on objects in the XDB Repository.
Using SHOW PROCESSLIST and mysqladmin debug Output in Conjunction with SHOW INNODB STATUS
(Chris Calender) When InnoDB appears hung, I know the natural reaction is to check SHOW ENGINE INNODB STATUS.