SQL PASS Summit 2011 Recap
This week has been an exciting and memorable week for me. The last PASS Summit I attended was in 2009...
2011-10-14
1,842 reads
Devin Knight
PerformancePoint – Using SSAS Actions
The latest project I worked on had a heavy dose of PerformancePoint and one of the requirements was to launch...
2011-09-23
2,292 reads
SSRS – Dealing with truncating spaces
I apologize ahead of time on this post today because it will require lots of pre explanation and screenshots to...
2011-09-22
2,071 reads
PASS Pre Con - Building a Microsoft Business Intelligence Platform
PASS Summit is quickly approaching and while many of you are registering I wanted to remind you of some of...
2011-09-07
1,159 reads
SSIS - Inferred Member Insert in Fact Table Load
Recently while working on a different solution for loading inferred member solution in our fact table load I ran into...
2011-08-16
2,948 reads
PowerPivot – Commonly Used DAX Expressions
Today I will be presenting in a webinar, which by the way is recorded for later viewing, on Commonly used...
2011-08-11
1,674 reads
PowerPivot – Creating KPIs
Probably one of the most anticipated additions to the latest version of PowerPivot is the ability to create KPIs. PowerPivot...
2011-08-08
2,812 reads
PowerPivot – Perspectives
PowerPivot – Perspectives
Many times when developing larger Analysis Services cubes you may find it necessary to use Perspectives to logically split...
2011-08-05
4,418 reads
PowerPivot – Creating Hierarchies
Hierarchies are one of the long awaited features that will now be available in the latest version of PowerPivot. Hierarchies...
2011-07-31
4,840 reads
Modified Insert Unknown Row to Dimension Table
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...
2011-07-29
2,911 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers