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 »

Advertisements

Pilot-View on Microsoft Gemini 1

September 12, 2009

I’ll take in somehow big series about Microsoft Gemini and its features, I found it great very fast while loading big dataset and also I submit bug once it occurs.

I’ll talk in this post about Load & Prepare Data (From Database) in Microsoft Gemini…

First, you should have Microsoft Excel 2010 Technical Preview (until now 12-9-2009) which in Microsoft Office 2010 Technical Preview, don’t you know what’s Gemini check this https://ramymahrous.wordpress.com/2009/05/06/what-you-need-to-know-about-gemini/

First, let’s install Gemini as it’s not by default installed on Excel 2010

Gemini2If you download it from Microsoft Connect, it comes with two client versions, x64 and x86 choose which fits your processor architecture.

Gemini1 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


Data Warehousing: Laying the Foundation to Success

September 8, 2009

Session #15: Data Warehousing: Laying the Foundation to Success

Event: 24 Hours of PASS

Presenter: Erik Veerman

Download


Building Flexible Data Services for the Web Using the ADO .NET Data Services Framework

September 8, 2009

Session #18: Building Flexible Data Services for the Web Using the ADO .NET Data Services Framework

Event: 24 Hours of PASS

Presenter: Steve Jones

Download


First official video about Gemini from Microsoft

September 1, 2009

Project Gemini for Excel 2010

What’s GeminiProject code-name “Gemini” for Excel 2010 provides ground-breaking technology, such as fast manipulation on large data sets (often in millions of rows), streamlined integration of data, and the ability to effortlessly share your analysis through SharePoint 2010.

Video | http://www.microsoft.com/officebusiness/office2010/Default.aspx?vid=Geminiv


Overview of Gemini features

August 25, 2009

From Microsoft Gemini team blog

The key question behind Gemini is: how much value can an Excel user derive from Microsoft’s BI stack without having to pick up a book on OLAP, Dimensional Modeling or Analysis Services?

More on http://blogs.msdn.com/gemini/archive/2009/08/24/overview-of-gemini-features.aspx