Search

OakieTags

Who's online

There are currently 0 users and 15 guests online.

Recent comments

SQL Server

The Harmonic Mean

The 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

I 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

Median 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

Median 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

Oracle 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

Oracle 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

The 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?

AVG 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?

AVG 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.

Statistics

Updated 22nd Jan
I’ve previously advertised the fact that the latest online discussion that Red Gate has arranged for me to have with Grant Fritchey will be on 23rd Jan and we will be talking about statistics. If you’ve listened in to any of these talks in the past you’ll realise that they are completely unscripted; what you get is a couple of guys in a (virtual) pub comparing and contrasting their favourite database engines and trying to learn a little bit about how the other technology works.