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
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
On the Twelfth Day of Christmas an IT Pro sent to me...
Twelve New Servers Coming The product guys at Microsoft have been busy so there are going to be lots (but not 12) of new servers coming out this year: Windows Server 2008 (in 8 exciting flavours depending on whether you need virtualization or not) SQL Server 2008 editions: developer, express,...
5 Jan 2008
SQLBits Goes West 19-21 November, Newport
When I am not doing the day job I like to draw and paint to relax so I have combined a bit of business & pleasure for the SQL Bits Goes West conference by doing a few cartoons for them… As you can see the event has grown to three days. While there has always been a deep dive, paid for training...
26 Aug 2009
On the Fifth Day of Christmas an IT Pro sent to me...
Five Acronyms One of the worst things about being in IT is doing battle with all the acronyms we use, and having to constantly explain them to people who don't work in our industry. Two of the worst things about being in IT is doing battle with all the acronyms we use, having to constantly explain them...
29 Dec 2007
What you see is what you get
Data Visualisation is one of my many interests and Marc Holmes showed us a bunch of wordles like the one above in yesterdays team meeting, and we had to guess the blogger. Mike Taulty won despite not recognising his own blog!. You can see why Marc didn’t use my wordle, SQL Server sort of stands...
14 Nov 2008
Compression without Compression in SQL server 2005 sp2 fact tables
In case you weren't at the excellent SQL Community yesterday evening, I thought I would share a top tip for getting on top of your fact tables in the next version of SQL Server. Mark Hill of Edenbrook gave the evening an update of the relational engine as it affect BI and we then got into a debate about...
27 Sep 2007
SQL Server BI Community Evening, 10th June, Reading
I wanted to call out the BI evening on 10th June because they’ve given me a slot to talk about SQL Server 2008 r2 and specifically the BI features you can expect. There’s also sessions on Data Modeling and information architecture from Alex Pratt & Andrew de Rozairo (Sybase) and one on...
1 Jun 2009
I sat watching Dave the other night and there’s a bit in it where Kevin Kline simply states that he wants to give everyone in America a job that wants one. I’m not sure if our the MD of Microsoft, Gordon Frazer has seen this, but he’s just announced that we plan to get to 500,000 people into work...
10 Sep 2009
Georgina (aka Curious George) and Faith who look after all things TechNet have this Champion IT competition going on which I really ought to have mentioned before. Basically you can nominate yourself or a colleague for doing something a little bit special with the Microsoft platform in one of three...
16 Jan 2008
SQL Server events in Manchester
I am still tracking through the virtual e-mail mountain following 3 weeks holiday in Sri Lanka and I see the SQL Community have focused their attentions on Manchester. In addition to the upcoming SQL Bits goes Fourth on 28th March (venue tba). Tony Rogerson and Martin Bell are hosting an evening...
2 Feb 2009
SQL Community and the Curse of The Cursors
So following form my last post, Eric Alsop’s session for the SQL Community last night was on cursors of course. His simple but effective presentation showed up a couple of scenarios where cursors are still useful weapons in an DBA’s armoury despite all the new stuff put into SQL standards and SQL Server...
18 Apr 2008
Chat to Us about SQL Server
Why do so many SQL Server people make the effort to come to evening and weekend events? These people can all read so surely they can find what they need on-line. Many already know a lot about the product and have a lot of experience behind them. I believe that part of this is to debate...
16 Jun 2008
Safer Internet Day 9th Feb
If I was writing a bill of rights for the internet my main focus would be to make the web a safe and fun place for everyone, but that’s not going to happen so instead I spend some of my spare time trying to help children be safe on line (a sort of digital green cross man). Because this entails...
28 Jan 2010
SQL Bits Friday session
I promise this is the last time I mention SQL Bits this week, but I wanted to let you know I have got 25 free tickets for the paid for event this Friday which would normally cost £149 to attend. The venue is the Celtic Manor in Newport… and is probably the next best thing to going to TechEd. There...
16 Nov 2009
Internet Safety for adults
I did an internet safety presentation to the association for retired police officers on Friday, and it still amazes me how little my generation know about social media and the internet in general. There are basically three camps when it comes to awareness of the dangers the internet poses...
6 Oct 2010
What do Evangelists do at the Weekend?
This weekend the Microsoft evangelists were out in force at the BBC Mashed, a hack event at Alexandra Palace. The delegates have 24 hours to make something cool with sponsors stuff, and those sponsors also included the Lonely Planet , The BBC , O’Reilly publishers, Channel 4 , The Guardian , and...
23 Jun 2008
I am in the middle of SQL relay this week, but I just realised that you might like to have a copy of my Denali slide deck, which I have now posted to SkyDrive . You are welcome to have a look at it even if you couldn’t make one of the four venues I am presenting at this week, but there isn’t a lot of...
5 Oct 2011
Do What You Love
“Happiness lies in being privileged to work hard for long hours in doing whatever you think is worth doing.” - Robert A. Heinlein, “ To Sail Beyond The Sunset ” I want to make two comments about that quote; firstly it pretty much sums up working at Microsoft, secondly that is on an e-mail signature...
16 May 2011
Expenses on Virtual Earth
There’s a lot of heat on MP’s expenses so if you want to quickly see how your local MP compares then have a look at them on Virtual Earth here .. What I like about this is that it shows the spikes, so in my neck of the woods this MP is in red because he’s claiming a lot. But what’s interesting...
20 May 2009
Computer Weekly Blogging Awards
Somebody out there is reading this, and thinks that my stuff is worth voting for and so I have been short listed for a Computer Weekly blog award. Thanks very much whoever you are! If anyone out there is of the same enlightened opinion please vote for me in the programming and technical blogs...
4 Jul 2008
Merry Christmas and a Happy 2011
Like most IT professionals I usually avoid reading blogs with too much personal stuff in, so I try and avoid that in my own posts. But it is Christmas Eve so here’s your card .. As this supposed to be a technical blog you might like to know that this is a tawny owl that lives near me and...
24 Dec 2010
Evangelism Evangelism Evangelism
The IT Pro Evangelist team are all at a huge education event , BETT , this week. Viral , Steve , Eileen , James and me. We are there to give help and advice to the IT Pro's working in education, so we'll be taking a little longer to answer your comments and e-mails. I have only had one question...
10 Jan 2008
SQL Bits Conference Calling
This is a short post to say thanks to all the MVP's working hard to organise the next SQL Bits conference on 1 March (register here ). Tony , Chris , Simon Darren, Allan and Martin and the rest of the SQL Server Community know exactly what's like to plan this when they're scattered across the UK and...
31 Jan 2008
On the Tenth Day of Christmas an IT Pro sent to me...
Ten Boards a Bleeping Well past Christmas now but I couldn't miss this opportunity to ask why does my motherboard need to bleep when I turn it on? why do I need a sound when windows starts, but most of all how do we get rid of the pervasive hum of modern day life. A think passive cooling like in...
3 Jan 2008
SQL Bits - Don’t be square be cubed
The UK SQL community are doing their next SQL Bits cubed on Saturday 13th Sept at Hatfield University. Possible excuses for NOT attending would be: You are reading this blog not because you are a highly skilled DBA but: You like my witty style You are one of my 2 friends You have been bribed by...
31 Jul 2008
I am like c# - I am event driven. I like to meet people and I like to present or be presented to in person. Last night I watched one of our MVPs, Simon Sabin , give us ( the UK SQL Community ) the DBA's guide to the CLR - when to use it and when not to. Great stuff and you get free beer and pizza...
22 Feb 2008
© 2014 Microsoft Corporation.
Privacy & Cookies