BI Mashups
Tuesday I attended an interesting session presented by J.R. Arredondo and Dave Pae about putting together Enterprise Mashups using SharePoint Designer for WSS or SharePoint 2007.
Mashups are one of those buzzwords, not unlike Twitter, FaceBook, etc., that sounds like a ...
[More]
Thoughts from the TechEd 2009 Gemini presentation.
[More]
The following issue is a problem in SSAS that you might run into either in test or deployment environments (see references).
In a nutshell, when a client session running Vista or Windows 2008 talks over the network to an SSAS server running on Windows 2008, and they use Kerberos f...
[More]
I've been heavily involved in PerformancePoint implementations since the beginning of that product's lifecycle...our company has done many deployments for clients. It's a great dashboarding technology, and I'm continually amazed how quickly we can put together compelling solu...
[More]
Server core is a lightweight, capable edition of Windows Server 2008. A lot of baggage isn't there, making more resources available for network applications, while reducing the attack surface area.
Some GUI tools are still available, but one of them that's not is a facilit...
[More]
A while ago Ken Schaefer posted some great documentation on Kerberos delegation. His series is titled IIS (Internet Information Services) and Kerberos FAQ. This is a great backgrounder, and a nice guide on advanced delegation concepts.
If you haven't checked out Microsoft's eLearning content for SQL Server 2008, make sure to take a look at the following link:
Clinic 6189: What's New in Microsoft SQL Server 2008 for Business Intelligence
Just as with other BI front-end technologies in a Microsoft environment, Excel Services worksheets that access back-end data (e.g. Cubes, Databases) require Kerberos delegation configuration. However, most MOSS installations are initially configured for NTLM security, and making the transiti...
[More]
There are a number of ways to automate backups of Analysis Services databases. Some examples I've seen: SSIS Packages, PowerShell, SQL Agent jobs with XMLA.
Here is a "quick and dirty" way using a .vbs cscript that can be called form the operating system, or schedul...
[More]
Microsoft recently released the latest version of its SQL Server platform: SQL Server 2008. Like its predecessors, the new release is a bundle of components that work together to deliver a seamless and integrated BI platform.
The 2008 version includes numerous performance enhancements that w...
[More]