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

SQL Server Training in 2013

Unbelievably it is December already and 2013 is fast approaching. With the Christmas break fast approaching now is the time...

OT: Space Exploration and the Future of Humanity

I am old enough to remember watching the Apollo 11 landing in 1969 as a young child. Before and after...

Management Studio Database Diagram Owners

If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio...

MDX #22 – What to use for explicit sorting on dimensions

I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...

Why SQL Server security matters: A case study

Database technologies are an essential component of many information systems because they store a large amount of sensitive corporate data...