Optimizing Performance in SQL Server® Analysis Services

September 22, 2009

Update. For whom missed it I found it as a post by Carl Rabeler http://sqlcat.com/top10lists/archive/2009/02/24/top-10-performance-and-productivity-reasons-to-use-sql-server-2008-for-your-business-intelligence-solutions.aspx

Read the rest of this entry »

Want to learn SQL Server Data Services (SDS)?

September 9, 2009

Overview of Microsoft SQL Server Data Services
This 1-hour online clinic provides SQL Server developers who are experienced in implementing database solutions with an overview of SQL Server Data Services (SSDS).

The topics covered in the clinic include:
– Introduction to SSDS
– SSDS Object Model
– Working with SSDS

More on: http://learning.microsoft.com/Manager/ResourceDetails.aspx?resourceId=cbe836be-394e-4a23-9f87-5d12127cccd5&clang=en-US&brand=Learning

Developing an Application for Microsoft SQL Server Data Services
This 1-hour online clinic provides SQL Server developers who are experienced in implementing database solutions with an explanation of the knowledge and skills required to develop an application in SQL Server Data Services (SSDS).

Topics covered in the clinic include:
– Building an SSDS Application
– Enhancing an SSDS Application

More on: http://learning.microsoft.com/Manager/ResourceDetails.aspx?resourceId=9b2d7204-9f2e-4657-a4c7-0952b32ae081&clang=en-US&brand=Learning

More on SQL Azure Database: http://www.microsoft.com/azure/data.mspx

SharePoint BI

July 23, 2009

I’m reading 6 posts on SharePoint Magazine about SharePoint BI. I like to share it with you

Part 1 – Getting to Know You – Intro to SharePoint BI
Part 2 – Sell! Sell! Sell! Why Build a Dashboard Anyway?
Part 3 – KPIs – Where do I Come From?
Part 4 – Dissecting Dashboards
Part 5 – We Really Need to Talk – Scorecards & Reports (Not published yet)
Part 6 – Beware the Bogeyman – Securing Dashboards (Not published yet)

Reporting and Business Intelligence in Microsoft Dynamics AX 2009

May 16, 2009

Reporting and Business Intelligence in Microsoft Dynamics AX 2009

FREE From Microsoft E-Learning

About this Course
This two-day instructor-led course provides students with the knowledge and skills to leverage the extended Reporting and Business Intelligence (RBI) features of Microsoft Dynamics AX 2009. The training course covers installation of pre-requisites and supporting technology, creating and deploying reports using SQL Server Reporting Services, creating, adjusting and deploying business intelligence projects using SQL Server Analysis Services, and integrating all these features together in the Rich client, Enterprise Portal or Role Centers, for the end-user.

Audience Profile
The course is intended for developers or those individuals who will be creating and deploying reports and business intelligence projects.

At Course Completion
After completing this course, students will be able to:
– Differentiate between Microsoft Dynamics AX 2009 reporting features, SQL Server Reporting Services and SQL Server Analysis Services.
– Appreciate the benefits of leveraging SQL Server Reporting Services and SQL Server Analysis Services with Microsoft Dynamics AX 2009.
– Explain what the Role Center in Microsoft Dynamics AX 2009 is used for.
– List the system requirements for Reporting and Business Intelligence for Microsoft Dynamics AX 2009.
– Step through the procedures for installing SQL Server Reporting Services and the integration components for Microsoft Dynamics AX 2009.
– Design reports in Report Builder and Visual Studio using Microsoft Dynamics AX 2009 data sources.
– Integrate SQL Server Reports with Microsoft Dynamics AX 2009 Client, Enterprise Portal and Role Centers.
– Step through the procedures for installing SQL Server Analysis Services and the integration components for Microsoft Dynamics AX 2009.
– Become familiar with SQL Server Business Intelligence Studio.
– Navigate the multi-dimensional space of OLAP cubes.
– Import cubes from Microsoft Dynamics AX 2009.
– Fix broken cubes.
– Create new cubes from Microsoft Dynamics AX 2009.
– Deploy and process cubes.
– Read and write MDX expressions in KPIs.
– Step through the procedures for installing Role Centers for Microsoft Dynamics AX 2009.
– Modify existing Role Centers.
– Create new Role Centers.

To add this course to your Microsoft learning or start it right now; here you’re:  http://www.microsoft.com/learning/en/us/syllabi/50195A.aspx

SQL Server 2008 Training Kit

May 16, 2009


First to be honest I don’t remember who gave me this link or where I got it from, but once I remember I’ll update this post.
SQL Server 2008 Training Kit: http://download.microsoft.com/download/9/1/1/911EC8F9-4407-42F0-A7EE-335BA0E61F50/SQL2008TrainingKit.Setup.20090505.exe

What’s its goal:

The goal of the SQL Server 2008 Developer Training Kit is to provide information about new features in SQL Server 2008. Its primary audience is solution architects and developers already familiar with SQL Server who want to learn about new functionality available in this release. The content focuses on development aspects and illustrates how to design more effective database applications that take advantage of improved capabilities in SQL Server 2008.

The material is organized into several feature areas:

  • Spatial Support provides an overview of the new spatial data types that allow for the creation, comparison, analysis, and retrieval of spatial data.
  • FILESTREAM describes how SQL Server 2008 enables the storage of binary large object (BLOB) data as files on the file system in a manner that ensures transactional consistency with the database.
  • CLR introduces the common language runtime integration feature and describes new support for nullable types and additional .NET Framework libraries supported in SQL Server 2008.
  • Reporting Services highlights enhancements to SQL Server Reporting Services including the new Report Builder 2.0 authoring tool.
  • Date and Time introduces the new ANSI standard compatible data types that provide increased range and accuracy.
  • T-SQL shows several new language enhancements including table-valued parameters, row constructors, grouping sets, and the MERGE statement.

Within each feature area, you will find presentations, demo scripts, and hands-on labs that will help you understand important aspects of each feature.

In the training kit, you will find the AdventureWorks Racing Community application. This sample application highlights some of the new functionality introduced in SQL Server 2008.

SSAS Resource Hub

May 10, 2009


This website is designed for the developers and administrators who work with Microsoft SQL Server Analysis Services (SSAS) 2005 or 2008. Here you will be able to find latest news, MDX FAQs, OLAP design FAQs, links to articles, BI blogs, webcasts, forums, job postings, products and any other information that is related to SSAS.

Personally, I recommend every BI Developer to follow up this portal http://www.ssas-info.com/ 

RSSNews RSSArticles

Microsoft BI: Thinking Bigger About BI

April 12, 2009

Microsoft: How Do I BI

Microsoft: How Do I BI


Now more than ever, you need to get the right information to the right person, faster, and in an easy-to-consume format. Learn more about Microsoft’s comprehensive and fully integrated set of business intelligence (BI) technologies that can help you reduce the complexity of organizing and distributing information, enable better business decisions, and improve your bottom line.


Stay up to date with a constantly refreshed library of webcasts that includes news on the latest features, high-level overviews, and technical drilldowns.

Virtual Labs

Get hands-on experience with the process of building different types of BI content. Virtual labs are simple, with no complex setup or installation.


Stream or download podcasts to learn how Microsoft is addressing the key BI needs of our customers.

I recommend all BI developers not just whom work on BIDS to take a look this benefical e-learning board.