Rob Kerr, MCDBA, MCTS is a Principal Consultant for BlueGranite, a Microsoft Business Intelligence Gold Partner. The views expressed in this blog are his own and are not reviewed or endorsed by BlueGranite or Microsoft.
Keywords
Blogroll

Scripting Analysis Services Database Backup

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]
Posted:8/30/08, 21:19 by keruibo | 0 Comments
Keywords: | E-mail | | Trackback

Microsoft BI with Constrained Kerberos Delegation

In a Microsoft BI environment, we very often want to grant data visibility permissions at the datebase level.  The most common way to accomplish this is to use Kerberos delegation.  In Active Directory, delegation comes in two flavors: Constrained and Unconstrained. Constraine... [More]
Posted:5/17/08, 23:40 by keruibo | 0 Comments
Keywords:,  | E-mail | | Trackback

Analysis Services 2008 Improvements & BIDS Helper

Analysis Services cubes for OLAP analysis have improved substantially between SQL Server 2000 and 2005.  Still, there's always room for improvement.  The recent CTP (Community Technology Preview) editions of the upcoming SQL Server 2008 product shows that the product continues to imp... [More]
Posted:4/28/08, 00:33 by Rob | 0 Comments
Keywords:,  | E-mail | | Trackback