PowerPivot for Excel Now 2012 Only

I’m not exactly sure when this happened, but it looks like Microsoft has moved past the PowerPivot 2008R2 and PowerPivot...

Puzzling TVFunctions

I had the opportunity to tune a highly-used function the other day, and was most puzzled by the difference between...

SQL In The City: London 2012, Recap

Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...

SQL Server: Instant Deadlock Alert Using WMI in Your Mailbox

In my last post I have explained,how to setup alert for blocking using WMI. In this post let us see how...

T-SQL Tuesday #32 – A Life in the Day

It’s T-SQL Tuesday time again, delayed a week this month, so I had  a whole extra week to get ready....

T-SQL Tuesday: A Day in the Life of a BI Developer

My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles.  I’ve been a BI developer for...

BI Systems Architecture Diagrams

Today I have decided to prepare myself for a meeting with a potential client (tomorrow) and write an article about...

Building Your First Power View Report

This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog.

Fulfilling User Needs
Developing a...

Crystal Reports DataDate in SSRS

Crystal Reports has a special field name “DataDate”. This date shows the last time the data on the report has...

Encrypting Connections to SQL Server

I manage databases for financial organisation. These databases have confidential data of our customers such as credit card numbers, security...