Skip to main content
Andrew Fryer   rss
(11-19 of 19 items)
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
SQL Server 2008 R2 CTP2 a quick install Guide | TechNet Video I see quite few tweets and comments that SQL Server is  hard to install, so I thought I would dispel this myth by using the latest CTP of SQL Server 2008 R2 running on the latest operating system, Windows Server 2008 R2. The actual time it took me was 30 minutes (on a  hyper -V virtual machine) but ... More...

TechNet Edge, Windows Server 2008 R2, SQL Server 2008 R2 CTP 2, Hyper-V, Videos, English, Andrew Fryer, Zune, iPod
LINQ and Entity Framework, for the DBA | TechNet Edge Two kinds of people are interersted in SQL Server, the DBA and the Developer. While Developers have been getting very interested in LINQ and Entity Framework and their support in SQL Server 2008 this is all a bit confusing for the DBA. Two UK evangelists Mike Taulty (the developer) and Andrew Fryer ... More...

TechNet Edge, SQL Server, Database Administration, DBA, LINQ, Entity Framework, Videos, English, Andrew Fryer, Zune, iPod
SQL Services - What does it mean for the DBA | TechNet Edge Simon Munro of EMC Consulting  discusses the the new SQL Services platform with Microsoft evangelist Andrew Fryer at the highly popular SQL Bits goes fourth UK community event. More...

TechNet Edge, Database Administration, DBA, SQL Services, Videos, English, Andrew Fryer, Zune, iPod
SQL Server Data Services | TechNet Edge SQL Server Data Services, Microsoft's Cloud database, is SQL but not as you know it. In order to get your head around it we have used an MVP who's an expert in the subject and some Lego Duplo! More...

TechNet Edge, SQL Server 2008, Cloud Computing, Videos, English, Andrew Fryer, Zune, iPod