## The Harmonic Mean

Posted December 5, 2013The arithmetic mean is what you learned in school. However, it is the

harmonic mean that is often - but not always! - the correct choice when

computing an average over a collection of rates.

Read the full post at www.gennick.com/database.

## The Harmonic Mean

Posted December 5, 2013The arithmetic mean is what you learned in school. However, it is the

harmonic mean that is often - but not always! - the correct choice when

computing an average over a collection of rates.

Read the full post at www.gennick.com/database.

## SQL Developer 4 EA2 Connecting to SQL Server

Posted October 1, 2013I wrote a blog post some time ago about using SQL Developer 3.x to connect to SQL Server. I tried the same thing today from SQL Developer 4 EA2 and it works just fine.

You have to download the 3rd party JDBC driver and point SQL Developer to it. You can read how to do it here.

Cheers

Tim…

Update: My colleague just told me this.

“If you at any point decide to use Windows authentication to connect (like I just did), you might hit this error:

Status : Failure -I/O Error: SSO Failed: Native SSPI library not loaded. Check the java.library.path system property.

## MEDIAN: For When You Don't Really Mean It

Posted April 7, 2013Median is a measure of central tendency useful in describing the typical

experience, or the typical case. It's a type of average along with the

mean, but less susceptible to skew from outlying...

Read the full post at www.gennick.com/database.

## MEDIAN: For When You Don't Really Mean It

Posted April 7, 2013Median is a measure of central tendency useful in describing the typical

experience, or the typical case. It's a type of average along with the

mean, but less susceptible to skew from outlying...

Read the full post at www.gennick.com/database.

## STDDEV: Standing Sentinel on Your Data

Posted March 17, 2013Oracle Database implements a family of STDDEV functions for computing the

standard deviation from the mean. If you think of the mean as beginning to

paint a picture of the underlying data, then...

Read the full post at www.gennick.com/database.

## STDDEV: Standing Sentinel on Your Data

Posted March 17, 2013Oracle Database implements a family of STDDEV functions for computing the

standard deviation from the mean. If you think of the mean as beginning to

paint a picture of the underlying data, then...

Read the full post at www.gennick.com/database.

## Usage Stats

Posted January 24, 2013The video of the online chat that I had with Grant Fritchey about statistics in SQL Server and Oracle * is now online*. It went pretty well – according to the stats 537 people attended, although the peak concurrency I noticed was only 467 – of which there were still over 400 after an hour and a quarter.

At the start of the event, James Murtagh put up a quick poll to see how many attendees used SQL Server, how many used Oracle, and how many used both. There’s a degree of bias in the results, no doubt due to the self-selecting nature of the event, but I thought the results were interesting:

## AVG: What Does it Mean?

Posted January 13, 2013AVG is an aggregate function in SQL to compute the "average" of a set of

values. More precisely, it computes the mean of those values. And even more

precisely, AVG computes what is known as...

Read the full post at www.gennick.com/database.

## AVG: What Does it Mean?

Posted January 13, 2013AVG is an aggregate function in SQL to compute the "average" of a set of

values. More precisely, it computes the mean of those values. And even more

precisely, AVG computes what is known as...

Read the full post at www.gennick.com/database.