JSSUG Speaker Idol 2012 Review

Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event.  Read more about what...

JSSUG Speaker Idol 2012

The Jacksonville SQL Server User Group (JSSUG) has always encouraged new talent to be added to the pool of local...

Visio 2010 Forward Engineer Add-in

Somehow I missed this gem that’s been around for quite a while so I thought I would share it in...

OLAP PivotTable Extensions Update

OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now.  It...

SSRS – Using Lookup Function for Multiple Column Join

When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple...

Office 2013 Preview – Enabling PowerPivot in Excel

With the Office 2013 announcements today I was excited to download and get my hands on the tools.  Because this is still...

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

SQL Lunch #68 – Designing Your First Power View Report

Next week I will be speaking on designing your first Power View report for SQL Lunch.  Be sure to join me...

Identifying Long Running SQL Agent Jobs Script

I’m usually pretty hesitant to share scripts I write because inevitably it will get torn to pieces, but in this...

Using Excel Macro (.xlsm) Enabled Files in SSIS

Recently while working for a client that was running SQL Server 2008 R2 I was tasked with loading an Excel...