On the Advantages of DateTime2(n) over DateTime

Starting with SQL 2008, we database developers started becoming more familiar with datetime2.  Sometimes folks need convincing though, so here...

Lost in Translation – Deprecated System Tables – sysprocesses

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

Speaking at Oracle Training Days

A first for me. I’m attending a non-SQL Server event, trying to bring a little knowledge of my platform to...

Power View and Reporting Services

There has been an active discussion thread on Chris Webb’s blog about the similarities & differences between various Microsoft BI & reporting...

Logins vs Users

Logins are not Users. It’s a pretty easy concept but one that seems to give a lot of people problems....

MDX #23 – “Hello World!” Lesson in MDX

Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...

T-SQL: CASE Statement

For the month of December, I’ll be taking a little holiday from blogging. In the meantime, enjoy a few of...

Last Weeks Top 10 “Reading” Links #9

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out...

HDInsight, Finally

See this:

That’s right. The install worked. All I had to do was get a completely clean server set up. No...

SQLOS Basics - Query and CPU

In this article We are going to understand the basics of SQLOS - CPU scheduling.
In high level:
1. When an user connects to SQL...