Access "Where to look next for BI applications? Try the cloud"
This article is part of the August 2010, Vol. 3 issue of Exploring SQL Azure features and opportunities
In the last year, cloud computing has gained significant traction. Currently, there are two options for database and business intelligence (BI) applications like the PowerPivot product for accessing and consuming data in the Microsoft cloud -- SQL Azure and a new technology code-named “Dallas.” Each of these products has a particular sweet spot for deployment. Here’s a look at how they can benefit you based on your line of business. PowerPivot: BI applications for Excel Users PowerPivot is a free add-on for Microsoft Excel 2010 that provides BI capabilities such as data viewing, reporting, and slicing and dicing from within Excel. Before releasing PowerPivot, Microsoft did an extensive research of BI users, learning which tools they were using and which ones they needed. One of the main findings was that the vast majority of BI users didn’t have any tools, mainly because of their cost and complexity. PowerPivot allows BI users to leverage their knowledge of Excel to create BI applications. It puts the power of BI into the hands of millions of Excel users ... Access >>>
Premium Content for Free.
Where to look next for BI applications? Try the cloud
by Roman Rehak, Contributor
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?
Are we there yet? The slow road to SQL Azure
by Eric Johnson, SQL Server MVP
SQL Azure offers full-blown SQL Server functionality in the cloud and could ease management and development. But whether it’s ready to fully replace SQL Server remains to be seen.
- Where to look next for BI applications? Try the cloud by Roman Rehak, Contributor
Pros and cons of the DACPAC with SQL Server 2008 R2
by Denny Cherry, Contributor
Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.
- Pros and cons of the DACPAC with SQL Server 2008 R2 by Denny Cherry, Contributor
More Premium Content Accessible For Free
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
Microsoft has worked to address the big issue of "big data," as companies are dealing with a constant influx of digital information. SQL Server is no...