(Siddharth Mehta) Correlation analysis is a method of data analysis where the relation between two measures are determined in addition to identifying outliers in the data set. For this type of analysis, a scatter chart is very helpful. In this tip we would look at how to create a scatter chart base
Other News
Parallel Processing and Distributed Storage
Parallel Processing and Distributed Storage James points out something I’d like to touch on regarding Parallel Processing and Centralized Data. For this discussion, let consider the following concept that Centralized data doesn’t necessarily mean only a single copy of the data in a single location. Centralized data could mean a single authoritative perspective on data, capable of interacting with that […]
SelecTViews – Interview with Kalen Delaney, author of SQL Server 2008 Internals
Video Programming for IT Professionals
Centralized Data in Parallel
Centralized Data in Parallel I was reading Kevin Kline’s article “CPU in Flux” in the September 2011 edition of “Database Trends and Applications. Kevin touched on a topic I have had on my backburner for some time now, Multiple CPU systems. The main thrust of his article is that CPU manufacturers have changed course in order to get more power […]
Distinctive Database Development
(Christian Shay) Object-relational mapping (ORM) technologies enable developers to write object-oriented code against a conceptual model of their data rather than accessing the database directly. For example, with an ORM, a developer can make an update to an instance of an EMPLOYEE class or request
Fine Grained Auditing and SYS_CONTEXT
(Uwe Hesse) For an Oracle Database, we have several ways to audit user activity. With this posting, we will take a closer look at Fine Grained Auditing (FGA), working together with the very useful standard function SYS_CONTEXT. The demonstration is done with 11gR2 but should work very similar with o
Trigger keyboard and mouse actions with your voice and xdotool
(Colin Beckingham) xdotool is a helpful library of instructions that allows programmers to emulate keystrokes and mouse actions. The particular strength of the tool comes when the keyboard or mouse is absent or in accessibility situations where the user is not physically able to employ regular input
Rows and Columns Merging in ASP.NET GridView Control
(bmdayal) Its been a long time I have written any article on ASP.NET. Just few weeks back I got a very intresting requirement where I had to customize my GridView by Grouping the Columns and also merging the Rows by using Colspan properties. So while in View mode of GridView the data should be displ
Non-Virtual Interface Design Pattern
The non-virtual interface pattern is a design pattern that controls how methods in a base class are overridden. Base classes include public, non-virtual members that may be called by clients and a set of overridable methods containing core functionality.
Top five features in SQL Server Developer Tools
(Robert Sheldon) When Microsoft releases Denali — code name for the next version of SQL Server — the company also plans to release SQL Server Developer Tools (SSDT). Introduced as Project Juneau last November and made available in July as part of the second public Denali preview, SSDT provides an