Transact-SQL query to obtain basic information about partitioned tables

Here is the simple query that returns basic information about all tables in a database that are partitioned:

SELECT SCHEMA_NAME([schema_id]) AS...

What Is a Throwout Bearing?

A throwout bearing is a part of an automotive clutch system that temporarily disengages the engine from the manual transmission while shifting....

Deploying a Hadoop Cluster on Amazon EC2 with HDP2 #bigdata #hadoop

In this post, we’ll walk through the process of deploying an Apache Hadoop 2 cluster on the EC2 cloud service...

Million Dollar Buggy Club The baddest swamp buggies in the south! #4×4

The baddest swamp buggies in the south!
Formed in 2009 the Million Dollar Buggy club was originally comprised of 10 members...

Comparing Columns In Power Query

A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a...

Get data from Facebook with #Excel 2013, #PowerPivot and #PowerQuery

Facebook graph is the primary way for external apps to talk with Facebook. This allows you to get all the...

Hello...

This is my blog. Here, I’d like to say "Hello" and wish myself many posts. I’ll be mainly posting about...

I’m on Twitter! @AdamKreul

I’m just a little late to the party, but no time like the present, right?  I plan to be very...

Introduction To Hive’s Partitioning #bigdata #hive

A simple query in Hive reads the entire dataset even if we have where clause filter. This becomes a bottleneck...

K-means Clustering 86 Single Malt Scotch Whiskies #scotch #bourbon #stats

The first time I had an Islay single malt, my mind was blown. In my first foray into the world...