Skip to main content
Andrew Fryer   rss
(1-10 of 19 items)
SQL Azure Connectivity This video is part of the Module 2: Setup and Configuration of SQL Azure Databases within the Introduction To SQL Azure course. This video covers SQL Azure firewall and the management portal. After watching this video, visit www.microsoftvirtualacademy.com, enroll in the SQL Azure cloud course and t... More...

TechNet Edge, Zune, iPod, Andrew Fryer, Media, Microsoft Virtual Academy, SQL Azure, Screencasts, Homepage
So you want to be an IT Professional  | TechNet Edge Where do IT professionals come from, and more to the point why would anyone want to get into this undervalued sector of the IT industry? I met one of the new Microsoft UK interns, Jonathan Lickiss, who is embarking on just this career and I put these questions to him.  I was also curious about how h... More...

TechNet Edge, Andrew Fryer, Zune, iPod, English, Videos
Woodland Trust part 2  | TechNet Edge In this second interview with Lionel Wilson, IT Director of the Woodland Trust, we'll be discussing some of the power savings and other efficencies they will achieve as they move into their new sustainable HQ building.  While the building itself does have a lot of clever passive technology built int... More...

TechNet Edge, Zune, iPod, Hyper-V, Customer Story, Windows Server 2008 R2, Remote Desktop Services, UKDPE, Sustainability, English, Andrew Fryer
Woodland Trust on Hyper-V and Remote Desktop Services  | TechNet Edge Woodland Trust is a leading green charity in the UK who are not afraid of challenging conventional thinking to promote the environment and sustainability.  On the one hand they need to be very conscious of costs and providing an enviroment where their staff are effective, while promotiong best pract... More...

TechNet Edge, Andrew Fryer, Zune, iPod, Hyper-V, Virtualization, Customer Story, Remote Desktop Services, Videos, English
SQL Server 2008 Introduction to Resource Governor | TechNet Video I actually made this screencast of Resource Governor before SQL Server 2008 came out, and it's had a lot of hits on my blog so I thought I should add it to TechNet Edge, as there doesn't seem to be one on this really useful feature here. The resources this refers to are memory and CPU, and the goven... More...

TechNet Edge, SQL Server 2008, Screencasts, English, Andrew Fryer, Zune, iPod
PowerPivot part 1 - Loading Data | TechNet Edge The first thing you need to do in PowerPivot is to load in some data. In this screencast data is pulled in from a variety of sources (including SQL Azure and Reporting Services) to show how simple and powerful the tools for this are. For more information checkout www.powerpivot.com. This is part 1 i... More...

TechNet Edge, PowerPivot, Office 2010, Excel 2010, SharePoint Server 2010, SQL Server 2008 R2, Screencasts, English, Andrew Fryer, Zune, iPod
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 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
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