See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Application Lifecycle Management
Azure Machine Learning
Data Protection Manager
Essential Business Server
Full Text Search
Microsoft Security Essentials
Performance Point Server
Read Only Domain Controller
Remote Desktop Services
Slowly Changing Dimensions
Software + Services
SQL Server 2008
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014
SQL Server Express
TechNet Road Show
Windows Phone 7
Windows Server 2008
Windows Server 2008 R2
Windows Server 2012
Windows Server 2012R2
Browse by Tags
Insufficient data from Andrew Fryer
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...
25 Aug 2009
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...
31 Aug 2011
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. ...
1 Feb 2008
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...
25 Jun 2011
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...
4 Feb 2008
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...
6 Nov 2009
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...
11 May 2009
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...
18 May 2009
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...
12 Jun 2008
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...
6 Feb 2008
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...
9 Jun 2008
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...
12 Jun 2008
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...
5 Feb 2008
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...
6 Sep 2011
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...
25 Jan 2010
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...
18 Mar 2011
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...
28 Aug 2009
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...
22 Jun 2011
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...
14 Aug 2011
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...
20 Sep 2010
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...
5 Sep 2011
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
3 Apr 2008
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...
31 Aug 2012
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...
1 Sep 2011
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...
12 Jun 2008
© 2014 Microsoft Corporation.
Privacy & Cookies