Welcome to Agile BI Community Sign in | Join | Help

Browse by Tags

All Tags » SSAS   (RSS)

Developer Gaps

I’ve been meaning to post about this ever since I saw Jamie’s post on “ The SQL Developer Gap ”. I couldn’t agree more with what Jamie expressed. Prior to getting into serious BI development, I was primarily an application developer. This was at a time Read More...
Posted Thursday, March 18, 2010 2:40 AM by jwelch | 0 Comments

Presenting at Midlands SQL PASS Chapter

I’ll be presenting at the Columbia, SC PASS user group on July 7. I’ll be speaking on “Getting Started with Analysis Services 2008”, which is a demo heavy introduction to using SQL Server Analysis Services 2008. If you want to use SSAS, but aren’t sure Read More...
Posted Sunday, June 28, 2009 11:26 PM by jwelch | 0 Comments
Filed under: ,

Formatting Numbers in SSRS (and SSAS)

This is a little off of my usual SSIS posts, but I ran across an interesting item. It’s probably well-known to people who work with format strings on a regular basis. However, I’ve used them for a while, and just ran across this the other day, so I thought Read More...
Posted Tuesday, December 16, 2008 4:08 AM by jwelch | 2 Comments

BIDSHelper 1.2 Is Out

BIDSHelper 1.2 is now available at CodePlex . The new version has a number of SSIS specific features, like expression and configuration highlighting, a tool window that lists all the expressions in the package, and a Package Smart Diff tool. Darren (one Read More...
Posted Sunday, November 18, 2007 9:25 PM by jwelch | 0 Comments
Filed under: , ,

I'm balanced, except when I'm not

Jamie posted a question on ragged hierarchies to his blog today: Are you balanced or unbalanced? I started thinking about it this evening, and decided to post my thoughts here. I think that, for the most part, business requirements drive should drive Read More...
Posted Friday, August 31, 2007 3:42 AM by jwelch | 0 Comments
Filed under: , ,

BIDS Helper 0.9 Beta is Released

The 0.9 beta of BIDS Helper has been released on CodePlex. It's got a lot of great features for working with Analysis Services, and some future enhancements will include SSIS. Read More...
Posted Wednesday, May 16, 2007 4:13 AM by jwelch | 0 Comments
Filed under: , ,

Retrieving Information from Active Directory with SSIS

I was recently asked to help someone retrieve information from Active Directory for use in SSIS. My initial thought was "This shouldn't be too difficult. I know there is an OLE DB driver for Active Directory, so it should just be a matter of hooking up Read More...
Posted Saturday, April 07, 2007 3:46 AM by jwelch | 5 Comments
Filed under: ,

Attachment(s): ActiveDirectory.zip

Open Source SQL Server Stuff (OSSSS)

I was on the CodePlex ( www.codeplex.com ) site today looking for the Analysis Services Stored Procedure project, and found that they have a number of SQL Server related projects available. First, all of the SQL Server samples have been uploaded to the Read More...
Posted Friday, March 30, 2007 5:58 AM by jwelch | 0 Comments
Filed under: , , ,