Devin Knight
Archives: July 2012
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 allows you to have some exposure to what’s going on under the covers (Among many other features) while you browse a cube using an Excel PivotTable. This weekend there has… Read more
0 comments, 1,666 reads
Posted in Devin Knight on 31 July 2012
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 datasets together. Those functions were the Lookup Function, LookupSet Function and the MultiLookup Function. My general recommendation for these function is not to use them when you have… Read more
0 comments, 4,083 reads
Posted in Devin Knight on 27 July 2012
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 a customer preview we’re bound to find things here and there that aren’t functioning as expected when experimenting with the Office tools.
The things I had on my… Read more
0 comments, 3,048 reads
Posted in Devin Knight on 17 July 2012
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 Power View report has been touted as being so simple that within a handful of clicks you can add rather impressive elements, like effective visualizations, to… Read more
0 comments, 1,134 reads
Posted in Devin Knight on 16 July 2012
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 for the event and as always “No fluff, just stuff”.
Add To Outlook: Add To Calendar
Date and Time: 7/18/2012 11:30:00 AM CST
Topic: #68-Designing Your First Power… Read more
0 comments, 1,062 reads
Posted in Devin Knight on 11 July 2012
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 case I’d actually like some feedback so I can continue to grow this solution.
This script spawned from Jorge Segarra (@SQLChicken) and I working on a project together that had… Read more
0 comments, 3,904 reads
Posted in Devin Knight on 8 July 2012