SSAS-Info.com website update information for February 2009
Please add our newsletter address to your safe senders list!
This newsletter can be accessed online at:
http://www.ssas-info.com/analysis-services-newsletters/45-site
Special offer - SSWUG.org BI Virtual Conference - April 22-24, 2009. You can use special discount code (xxxxx) to get 10$ discount.
The following information was added to the SSAS-Info.com website during the month of February.
News
- SSAS News - MS released SQL Server 2008 SP1 CTP
- SSAS News - MS released Cumulative update package 2 for SQL Server 2005 Service Pack 3
- SSAS News - MS released Cumulative update package 12 for SQL Server 2005 Service Pack 2
- Announcements - New book released - Microsoft SQL Server 2008 MDX Step by Step
- Announcements - SSWUG.org BI Virtual Conference - April 22-24, 2009
- Announcements - New Book released - Smart Business Intelligence Solutions with Microsoft SQL Server 2008
Software
- SSAS Tools - SSAS Monitoring Scripts For Management Data Warehouse (Free)
- SSAS Tools - SSIS Package For Collecting SSAS DMV Data (Free)
- SSAS Tools - SSRS Reports to document SSAS 2008 DB structure using DMVs (Free)
- SSAS Tools - Scripts for Stress Testing Analysis Services using ASCMD (Free)
- SSAS Tools - A Solution for Collecting Analysis Services Performance Data From Many Sources For Performance Analysis (Free)
- SSAS Client Tools - Fractal:Edge
Jobs
- SSAS Jobs - Permanent job-New York/New Jersey-advanced Microsoft SQL Server 2005 (SSAS, SSRS, SSIS, MDX)
- SSAS Jobs - Direct Client - SSAS / SSRS developer Required, NYC
- SSAS Jobs - BI Architect / Developer - Northern, New Jersey
Tips
- SSAS Tips - Use BIDS 2008 to validate Analysis Services 2005 cubes
Articles
- MDX - The LEVEL_UNIQUE_NAME Intrinsic Member Property
- MDX - Calculated Members with ROOT(), Subcube and WHERE
- MDX - Intrinsic Member Properties: The HIERARCHY_UNIQUE_NAME Property
- MDX - Arbitrary-shaped sets and the Storage Engine cache
- Security - Measure Tool – Making SSAS measures physical to apply security
- Excel - Quick and Easy Data Access with Excel Services
- Reporting Services - Hacking MDX Query Designer Parameters
- Reporting Services - SQL Server Reporting Services Calendar Control for Date Parameter (SSAS OLAP)
- Reporting Services - Enabling Drilldown on (SSRS) Reporting Services 2008 Charts
- Reporting Services - Implementing Real Analysis Services DrillDown in a Reporting Services Report
- Reporting Services - Implementing Access to SQL Server Analysis Services 2008 by Parameterization feature on SQL Server Reporting Services 2008
- Reporting Services - Retrieving Cube Metadata in Reports
- Data Mining - Text Data Mining on Mosha's blog
- Time Dimension - Date Dimensions Part 2
- AMO - Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
- AMO - Analysis Services Partition Processing
- AMO - How to Restore an SSAS database using Windows PowerShell and SQL Server 2008 AMO
- Design - SSAS: Reference materialized dimension might produce incorrect results
- Design - LastNonEmpty Gotchas
- Design - Space Considerations for Various OLAP Data Types
- Design - More Exposure to Settings and Properties in Analysis Services Attribute Relationships
- Connectivity - Integrating Visio 2007 with SQL Server Analysis Services
- Connectivity - Analysis Services 2005/2008 Heap Corruption
- Management - How to deploy an Analysis Services database using a script
- Data warehouse - Top 10 Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions
Webcasts
- SSAS Data Mining Webcasts - Running A Basic DMX Query - SQL School Video
- SSAS Data Mining Webcasts - Running Singleton Queries Against a DMX Data Mining Model - SQL School Videos
- SSAS Data Mining Webcasts - Installing & Congfiguring DM Add-in for Excel - SQL School Video
- SSAS Data Mining Webcasts - Data Mining in Excel 2007 Pt.1&2 - SQL School Video
Comments
- Comments - new version released
- Comments - Hi,It looks like video is no longer
- Comments - Can you please comment your query? It's
- Comments - This saved me time, many thanks
- Comments - very helpful thanks
- Comments - I would make a slight change to this exa
SSAS Companies
- Consultants - Marco Schreuder
- Consultants - MindRight Solutions
- Training Providers - CodeCenters International
- Training Providers - SetFocus - The Master’s Program
And thank you for rating the articles!