Skip to main content
SQL Server 2008 R2   rss
(11-19 of 19 items)
PowerPivot part 2 - Preparing data | TechNet Edge Having got all the data you need into Powerpivot, you will need to create relationships between the various sheets you have imported.  You may also need to create some additional columns of data and filter what you have retrieved. For more information check out www.powerpivot.com. This is part 2 in ... More...

TechNet Edge, PowerPivot, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, Videos, English, Andrew Fryer, Zune, iPod
PowerPivot part 4 - Sharing in SharePoint 2010 | TechNet Edge The Power of PowerPivot is for a user to be able to share their analysis with their team.  The obvious choice for doing this is SharePoint and SQL Server 2008 R2 Analysis services can be sepcially configured to support PowerPivot anlysis in SharePoint 2010.  This screencast won't show you how to do ... More...

TechNet Edge, PowerPivot, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, Screencasts, English, Andrew Fryer, Zune, iPod
PowerPivot part 5 - Management | TechNet Edge Allowing users to share their PowerPivots in SharePoint is very useful but does need to be managed by the IT Pro.  In this screencast you can see the management dashboard that gets installed as part of PowerPivot in SharePoint 2010 to monitor the resources and usage of these PowerPivots. For more in... More...

TechNet Edge, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, PowerPivot, Screencasts, English, Andrew Fryer, Zune, iPod
PowerPivot part 3 - Analysis  | TechNet Edge PowerPivot is there for end users to quickly analyse their data.  It does this by using the familiar pivot table and pivot chart tools, as well as the improved functionality in Excel 2010 such as slicers. for more information visit www.powerpivot.com This is part 3 in a series of 5 More...

en-GB, Videos, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, PowerPivot, Zune, iPod, TechNet Edge, Videos, en-gb, Andrew Fryer
The Evil Query | TechNet Edge Many DBA's have seen a query from hell where a mulit-million row fact table is joined to its major dimensions. One approach is to throw hardware at the problem, and this is exactly what we discuss in this video with Henk van der Valk from Unisys Holland. He's got SQL Server 2008 R2 running on a serv... More...

TechNet Edge, SQL Server 2008 R2, Videos, English, Andrew Fryer, Zune, iPod
SQL Server 2008 R2 Master Data Services | TechNet Video What is Master Data Services in SQL Server 2008 R2? Who better to answer this question than Donald Farmer a program manager at Microsoft who has long been associated with the most interesting parts of the Microsoft BI platform. More...

TechNet Edge, Business Intelligence, SQL Server 2008 R2, Videos, English, Andrew Fryer, Zune, iPod
Report Builder 3 Report Parts in SQL Server 2008 R2 | TechNet Video Report Builder 3 is the latest version of the end user report design tool in SQL Server 2008 R2. A key feature in the new version is that you can now save the individual components (parts) of a report so that they can be re-used in other reports. For example you might want to use the same chart or t... More...

TechNet Edge, reporting, SQL Server 2008 R2, Report Builder 3, Videos, English, Andrew Fryer, Zune, iPod
Reporting on Spatial data in SQL Server 2008 R2 | TechNet Edge Report Builder 3 the latest version of the end user reporting tool in SQL Server 2008 R2  has built in support for Bing Maps and you can try this for yourself in the November CTP. More...

TechNet Edge, Report Builder 3, SQL Server 2008 R2, Videos, English, Andrew Fryer, Zune, iPod
installing SQL Server 2008 R2 with the Prepare Image Option | TechNet Edge SQL Server 2008 R2 has some new advanced insatllation options which allow you to partially install SQL Server and then complete the installation at a later time. In conjunction with the sysprep function in Windows this allows you to prepare a virtual machine which can then be reused again and again ... More...

TechNet Edge, virtual machine, SQL Server 2008 R2, Videos, English, Andrew Fryer, Zune, iPod