Calculating the length of a hash in SQL Server

Some time ago I added a script component to a few SSIS packages to compare rows with each other using...

Conditional Aggregates

The Problem: A legacy table contains amounts and a char column indicating whether the amount is a credit or a...

Correlation Does Not Imply Causation

One of the biggest mistakes we can make when troubleshooting is to confuse the necessary responsibility of observing activity that...

DELETE operations on tables

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...

Enterprise-class real-time stream analytics for Big Data

Since the beginning of the information age, enterprises have relied on processing data to gain insights and make business decisions....

Four steps to identify and relocate an application portfolio to the cloud

Large enterprises looking for ways to modernize and migrate a portfolio of business applications to cloud will need to adopt...

HDFS Explorer – Manage HDFS Storage from Windows

f you’re planning to use HDFS Explorer with the Hortonworks Sandbox or Cloudera VM, you’ll need to define your Hadoop...

Impala Performance Update: Now Reaching DBMS-Class Speed #cloudera #bigdata

Since the initial beta release of Cloudera Impala more than one year ago (October 2012), we’ve been committed to regularly...

MapReduce On Hive Tables Using HCatalog

HCatalog makes Hive metadata available to users of other Hadoop tools like Pig, MapReduce and Hive. It provides connectors for...

My Experience Aboard SQL Cruise 2014

Where do I begin? First let me say, WOW what an experience!

How it All Began
When I first heard about SQL...