Search

OakieTags

Who's online

There are currently 0 users and 32 guests online.

Recent comments

SQL Server

Dates in A Range

I revisit the problem of returning a row for each day in a month, and
generalize the solution to return rows for any desired range of dates. Then
I go further and explore how to return multiple...



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

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.

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.