As you may have noted in my original posting Delegation, Claims, Active Directory…Oh My!…Aw Crap!, it quickly described how to solve issues surrounding the delegation of the claims token within an Active Directory environment. In it I referenced Lee Graber’s excellent posting: The data connection uses Windows Authentication and user credentials could not be delegated. Today Lee had followed up with his new posting Testing the Claims To Windows Token Service for different identities which is an important read because: It includes the full script of the how to test the whether different identities can work properly within the c2wts…
Month: May 2010
Scale-Out Querying with Analysis Services…does it apply to SQL Server 2008 or 2008 R2?
I recently received a great question concerning the whitepaper Scale-Out Querying with Analysis Services: Question, does this also apply for SQL Server 2008? What are you experiences with the scale out? I’m in the process of recommending using this technology to a large customer of mine and want to make sure we are actually able to deploy such a setup. So let’s tackle these issues one-by-one. Does the whitepaper Scale-Out Querying with Analysis Services apply for SQL Server 2008? Yes! Okay, now a more verbose answer here :). The paper is applicable to both SQL Server 2008 and SQL Server…
Hierarchies, Oh Hierarchies…where are thou? (in PowerPivot)
I had a great question from a customer concerning something weird happening with PowerPivot relationships. In this example, we have two tables such as city and state. State Mapping Table City-State Mapping Table With the City-State mapping table, it is apparent that the cities of Boston, Quincy, Norwood belong to MA while Seattle and Redmond belong to WA. Even though the relationship makes sense (as per below) the output doesn’t! I wish we had hierarchies! Alas, one of the biggest wishes in PowerPivot was that we had in hierarchies and we just were not able to put them in. …
Healthcare IT and RHIOs are more than just technology
For those of you whom are interested in Health Informatics and the concept of a Regional Health Information Organization (RHIO), the chapter except A RHIO Struggling to Form: Will it Get Off the Ground? from the book Transforming Health Care Through Information: Case Studies is now available. The chapter definitely covers the issues surrounding technology and how it can be used to help improve healthcare. But what’s even more interesting is the fact the process, committees, and organizational logistics that is required in order to get this to work. It’s not just about getting the document standards to talk to…
Denny Lee 