Creating Your First SSAS 2012 Tabular Project

No matter how simple it is, new things come with some confusion; at least until you get used to it....

Be careful with two digit years

I recently had a scary conversation with a user, which can be broken down to:
User: Why would the data have...

LAST_VALUE() Analytic Function–SQL Server 2012

Earlier, i discussed FIRST_VALUE() function. FIRST_VALUE() returns the first value from an ordered set of records. Similarly LAST_VALUE() returns the last...

Data Labels, Axis Interval, Rotate Label Text: SSRS Nugget

Charts present summary data in a visually appealing format. Following is a chart for sales over month:

Before
I frequently use a few...

Read contents of a file to variable – SSIS

Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...

#meme15 – Use. Twitter. Why?

Should an average Jane or Joe professional use twitter?
Yes.
Why?
Because, I’m using it.
Not enough reasons? <grumpy face> I knew you wouldn’t...

FIRST_VALUE() Analytic Function–SQL Server 2012

Given a customer table:
CREATE TABLE Customers
(CustId INT, OrderDate DATE, OrderAmount MONEY) ;
INSERT Customers VALUES
(1, ’2011-12-03', 12500)

, (1, ’2011-10-07', 15000)

, (1,...

Management Studio Split Tabs

This is by far the simplest and silliest post ever, but i just figured how to create vertical tabs in...

Why doesn’t my gauge show correct values?

Here is an issue I encountered recently while using gauge in reporting services.

There are three gauges in the report one...

Full Load. Incremental Load. Whaaat?

Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was...