Notes From SQLSaturday #273

Speaker dinner at Spaghetti Warehouse was packed. Great crowd, not such great service. At 8:45 pm we still had not...

Oracle Tips for MSBI Devs #5: Working with Oracle on Windows Azure

As you have likely noticed in my series, Oracle Tips for MSBI Devs, I have done a lot of work...

R skills attract the highest salaries #r #getpaid4stats

Two recent salary surveys have shown that R language skills attract median salaries in excess of $110,000 in the United...

SQL Saturday OKC 309!

SQL Saturday OKC is coming up!
The event will be August 23rd, 2014!

Now is the time to get signed up. We...

SQL Server sample databases

Here are some places on the web where you can find sample databases for SQL Server. It’s nice to have...

Standard Deviations with CTE in SQL

I was working with a client recently getting the number of standard deviations a student was off the average number...

The “Perfectly Optimized” Page – #infographics

The “Perfectly Optimized” Page infographic states that there is no such thing as a “Perfect Page”. But don’t be discouraged!...

What’s the difference between a temp table and a table variable?

I recently saw an answer to this question on dba.stackexchange.com written by Martin Smith. It was probably one of the...

Why I Developed SQL Code Guard: A Fairy Tale from a DBA

A long time ago, in a galaxy far, far away….
About ten years ago, I realized I was spending more than...

@RedHat and @Hortonworks fuse Hadoop and cloud in new partnership

A Strategic alliance between the biggest Linux vendor and the leader in fully opensource hadoop is a killer combo. Read...