Choosing the Right Analysis Services: MOLAP vs. Tabular Recording and Q&A

I hope you were able to attend my free webinar on Choosing the Right Analysis Services: MOLAP vs. Tabular on...

DBA Myths: An index on a bit column will never be used.

Not true. (Or I guess probably wouldn’t be posting about it would I?)
Probably the first thing I should point out...

The RedMonk Programming Language Rankings: January 2014 #programming

The RedMonk Programming Language Rankings: January 2014
As long as we have been doing our programming language rankings here at RedMonk,...

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

Get performance statistics for queries and query plans that are cached by SQL Server for faster query execution

You can use the following two DMVs to give you that information:
sys.dm_exec_cached_plans – You can use this dynamic management view to...

First Presentation Ever And My 50th Post

Last Monday was the first time I've ever presented anything. Honestly, it was the first time really speaking in public...

The CHOOSE keyword

G’day,
I love coming across features of SQL that I’ve not used before and one happened today – the CHOOSE statement – introduced...

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

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

SQL Saturday #285 Atlanta

It’s been a couple of months since my last SQLSaturday and it’s time! Atlanta is my third SQL Saturday that I’ll...