Tech4Him – Technology with Integrity

A Christian technology chaos wrangler and his thoughts

SSWUG vConf – Analysis Services End-to-End

Posted by Tom On April - 22 - 2009

1364283972_68f730d552_mPresenter: Craig Utley
craig@solidq.com

DB –> SSIS –> Relational Data Warehouse –> SSAS (Cubes) –> SSRS

Data Sources

  • SSAS Projects have one or more data sources that point to data in some physical format
  • Data sources should impersonate a domain use with least privileges for the purpose of accessing data. Read the rest of this entry »

Popularity: 3% [?]

SSWUG vConf – Agile Business Development

Posted by Tom On April - 22 - 2009

2513682441_b2beea0d6bAgile Business Intelligence – Proven Techniques that move BI Development into the Agile World

Presenter: Ted Malone
http://portal.sqltrainer.com

Gotta love Ted. He’s been with SQL Server since Beta v1.0 on OS/2.

Ted’s presentation is about Agile development method using Visual Studio Team System. Hoping some methodologies can apply using other tools. Read the rest of this entry »

Popularity: 4% [?]

Flow ControlBelow I am posting some of my notes from the various sessions, along with comments, observations and occasional odd humor. ;)

The Accidental Business Intelligence Administrator

This session is designed for SQL Server DBAs who find themselves having to support SQL Server Business Intelligence projects using Reporting Services, Integration Services or Analysis Services. We’ll talk about the lifecycle of projects using these tools, how they impact your SQL Server infrastructure, and what adaptations you might need to make as a production DBA in order to maintain and secure them. Along the way, you might just learn what all those “other” services do that are listed in the SQL Server Configuration Manager. Read the rest of this entry »

Popularity: 5% [?]