Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Browse by Tags

Related Posts
  • Blog Post: Installing the SQL Server 2008 R2 August Technical Preview

    I see a lot of comments on Twitter making comments about how hard SQL Server is to install and so I thought I would go through a simple installation based on the August Technical Preview, SQL Server 2008 R2. I also used the latest operating system Windows Server 2008 R2 We are also having a debate...
  • Blog Post: Beyond Relational - Installing SQL Server FileTable

    A long time ago in a land far far away, somebody had the bright idea of using a database as part of a file system and the Windows Future System (WinFS) was born – but this is not that story.  However the idea and some of the team moved to the SQL Server engineering team and FileStream was the result...
  • Blog Post: SQL Server 2008 & Virtual Earth

    There's a lot of buzz around Software plus Services (S+S) from Microsoft and others.  It's all very simple as Eileen will tell you -  it's when you use a service like GPS that's remote and public and combine it with some software like CoPilot or TomTom on your GPS to find directions. ...
  • Blog Post: SCO Saturday – part 1 What is System Center Orchestrator?

    Of all the bits of System Center to come out next year it is Orchestrator (SCO) I am most interested in, as it is one of the enablers to create a private cloud. It’s a new bit of the System Center suite and is the glue that not only integrates the rest of System Center, but also most of the popular non...
  • Blog Post: SQL Server 2008 Geometry Data

    One of the problems with our TechNet road shows is getting at the content after the event. Of course we do provide the slide decks, but these can be abut thin as many IT Pro's (including us!) are power point averse, preferring see stuff in action. We can record it all but I am not sure anyone is going...
  • Blog Post: An Interesting VDI case, Holmes.

    Last June I didi a series of interviews with Alun Rodgers of Risual about the cool stuff in Windows Server 2008. In one of these.. Alun is telling me about how Terminal Services (now known as Remote Desktop Services, RDS, in Windows Server 2008 R2) could be used to provide a secure desktop for police...
  • Blog Post: SQL Server TV

    One of the Microsoft guys at the last SQL Bits events was Chris Guest who works in the Media Room team which is all about TV over the internet.  I wasn’t sure why he was at a SQL Server event so I grabbed a camera (well two camera and and cameramen) to find out more… Technorati Tags: SQL Server...
  • Blog Post: LINQ and Entity Framework

    Developers talking to DBA’s – what’s the world coming to? Despite what some people think and a few cheap jokes there are many areas of commonality between these two worlds particularly in SQL Server, and two of these are LINQ and entity framework.  I know they both provide some sort of semantic...
  • Blog Post: Windows Server 2008 – Branch Office Deployment

    In the final part of my interview with Alun Rodgers of Risual , we discuss the rollout out of Windows Server 2008 to branches of a well known fashion house.  You won’t get any tips on dress sense watching this, but you will understand why such  features as the Read Only Domain Controller and...
  • Blog Post: SQL Server 2008 Resource Governor in action

    One of the biggest headaches in SQL Server 2005 is trying to manage resources where there are competing workloads on a shared server. A typical approach is to use instances, but this completely hides memory and CPU from other instances which are then not available to an instance under stress whether...
  • Blog Post: Running SQL Server on Windows Server 2008

    I pulled down SQL Server 2008 RC0 over the weekend and I thought it would be good to get this running on Windows Server 2008.  There doesn’t seem to be a lot of resources around on this but it’s not that hard, in fact you pretty much install Windows Server 2008 and as soon as it’s done put SQL Server...
  • Blog Post: Windows Server 2008 Hyper-V – is it any good?

    I was presenting SQL server 2008 at a NextGen community event and there was a Windows Server 2008 given by Alun Rodgers of Risual (a gold partner specialising in server infrastructure and unified comms).  His session was so well received I thought it would be good to get him to share his experiences...
  • Blog Post: SQL Server 2008 Geo-Spatial functions and indexes

    SQL Server 2008 enables the use of geo-spatial data or location intelligence in four ways: a new geography data type (there's another one for 2D geometry), which can store points, lines, line segments and polygons A rich set of functions to make use of them, e.g. whether they intersect, how far are they...
  • Blog Post: Beyond Relational– Semantic Search with SQL Server FileTable

    Semantic Search new for SQL Server Denali adds extra intelligence to the FullText search capability that has existed in SQL Server for several releases, by looking at the relationships between words and in and across each document.  For example you can find which documents are similar to a specified...
  • Blog Post: PowerPivot Cookery

    I am a pretty good cook (not as good as our chef in residence Marc ) but I don’t practice enough so I wanted to get back up to speed to help out while my wife works on her OU degree and to explain PowerPivot. I have posted this video on YouTube.. ";" mce_src="http://blogs.technet.com...
  • Blog Post: Orange Data Centre part 5– Installing Self Service Portal

    First an apology. One of the reasons I stopped trying to turn my laptop into a mobile data centre was that I have been a login to the Reading Microsoft Technology Centre (MTC) and this has the entire system centre suite running on it and my Dell Covet can’t really compete with that.  However I don...
  • Blog Post: Vision on – Windows 7

    As I’ve said before I’m a bit unsure about whether IT Pros have the time or inclination to watch technical videos.  With our shortened attention spans and demands on our time I am very sure that watching an hour long or even half hour video is going to be watched very often. So James and I cam up...
  • Blog Post: Volunteering with SharePoint 2010

    The voluntary sector is a actually quite similar to the rest of business it’s just that the profits are then used to drive the aims of the not for profit or charity rather than benefitting shareholders or partners. So the challenges of market share and operational efficiency are just as relevant...
  • Blog Post: SQL Server on Windows Server Core part 2–Configuring Server Core

    Windows Server Core is a lightweight installation of any edition of Windows Server, and because it is so lightweight initial setup can be a bit tricky, so here’s what you need to know: Adding roles & features. There’s no Server Manager in Server Core and in any case you might want to do some configuration...
  • Blog Post: A worked example of using spatial and olap data in Reporting Services

    In my last post I went through a possible approach for showing spatial and olap data that the RSPB are planning to evaluate, now I want to show you how this might look in an example. First of all an apology, I am not going to pay the £1500 to license UK postcodes as this is just a demo, rather I am going...
  • Blog Post: Beyond Relational– FullText indexing with SQL Server FileTable

    In my part 3 of my series on FileTable I wanted to search the documents I had saved in parts 1 & 2. This is pretty straightforward, as Full text indexing has been in several versions of SQL Server and is SQL Server 2008 R2 the FullText indexes are part of the databases they refer to.  What caught...
  • Blog Post: SQL Server 2008 Configuration Servers – Blogcast

    Following on form my post on configuration servers in SQL Server 200, I thought you might like to see it in action so here’s a 5 minute blogcast on it…   Technorati Tags: SQL Server 2008 , Configuration servers
  • Blog Post: MCSE for SQL Server

    I have to be honest I gave up getting certified before I joined Microsoft mainly because the exams didn’t keep up with the release of SQL Server specifically the Business intelligence exams. I then had the same problem as an evangelist I was working on the next release of the SQL or Windows Server. However...
  • Blog Post: Beyond Relational - Working with SQL Server FileTable

    In my last post I setup FileTable in SQL Server Denali, and now I ma ready to start using it. Just to recap before I do that FileTable is a way of storing files in what appears to be a normal set of folders under a UNC share but in such a way that  these files are under the control of SQL Server...
  • Blog Post: Windows Server 2008 – Terminal Services

    In the second part of my interview with Alun Rodgers of Risual , we discuss what’s new in Terminal Services in Windows Server 2008, and how he has been helping his customers to implement it.  One use I hadn’t come across was to to provide access to a secure system as part of a normal users desktop...