Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
Restore SQL Server to an earlier version
It’s a simple matter to restore SQL Server backups to later versions, in fact you don’t need to do...
Author: Andrew.Fryer Date: 11/20/2008
SQL Server and Virtualisation
I am still getting loads of questions on virtualising SQL Server so rather than blogging away here,...
Author: Andrew.Fryer Date: 11/19/2008
Talking about Business Intelligence to your FD part 2
The other hot topic at last Friday’s ICAEW round table on Business Intelligence was KPI’s. Toby...
Author: Andrew.Fryer Date: 11/19/2008
Talking about Business Intelligence to your FD part 1
As I have remarked before Business isn’t run by the IT Department it is run by the people who hire...
Author: Andrew.Fryer Date: 11/17/2008
What you see is what you get
Data Visualisation is one of my many interests and Marc Holmes showed us a bunch of wordles...
Author: Andrew.Fryer Date: 11/14/2008
SQL Server 2008 Plan Guides
So here’s how it’s done.. So here’s how it’s done..I rarely know more about SQL Server than my...
Author: Andrew.Fryer Date: 11/14/2008
Blogging – Relevant or Redundant?
I rarely go off topic on my blog, but I was wondering whether I am wasting my time here. ...
Author: Andrew.Fryer Date: 11/11/2008
SQL Server 2008 Hyper-V and high availability
Imagine you have a windows 2003/SQL Server 2005 cluster (active-active) and your mission is to both...
Author: Andrew.Fryer Date: 11/10/2008
SQL Server 2008 at TechEd
I have finally finished at TechEd after another round of interesting questions on the Microsoft SQL...
Author: Andrew.Fryer Date: 11/08/2008
SQL Server 2008 supports how many cores?
I often say that a database is only as good as the system it is running on. For example SQL Server...
Author: Andrew.Fryer Date: 11/07/2008
SQL Server is a tough job but someone’s got to do it
During a quiet moment at TechEd I was talking to the Search Server Express product team about our...
Author: Andrew.Fryer Date: 11/06/2008
SQL Server 2008 Mirroring in Standard Edition
I opened the data management track at TechEd EMEA yesterday, to a full room and as ever if I am...
Author: Andrew.Fryer Date: 11/04/2008
Governance, Risk Management & Compliance
Blog posts which just reference whitepapers etc. can annoy some of you so I try and limit these, but...
Author: Andrew.Fryer Date: 10/30/2008
SQL Server 2008 Cluster on Windows Server 2008 in Hyper-V
I remember the old batman shows had a “don’t try this at home” disclaimer after every show, and this...
Author: Andrew.Fryer Date: 10/30/2008
SQL Server 2008 Filestream FAQs
I get a lot of questions about how filestream works with the other new features in SQL Server, so...
Author: Andrew.Fryer Date: 10/28/2008
Security Update MS08-067
There’s no easy way to say this but whatever version of windows you are running, the first thing you...
Author: Andrew.Fryer Date: 10/27/2008
Help for Small Business
It’s good to see that the government has noticed that small business are essential to the lifeblood...
Author: Andrew.Fryer Date: 10/27/2008
SQL Server 2008 Notification Services
Notification services is one of the deprecated features in SQL Server 2008, essentially it is...
Author: Andrew.Fryer Date: 10/21/2008
Report Builder 2.0 released
Typical, you spend a day off line at a team building exercise and then you find that the SQL Server...
Author: Andrew.Fryer Date: 10/20/2008
Barriers to upgrading to SQL Server 2008
Most IT Professionals like to use the latest (stable) version of a product, so what’s holding up...
Author: Andrew.Fryer Date: 10/20/2008
SQL for Girls
My good friend James has coined a phrase “Work is what we do, not somewhere we go”, so I have just...
Author: Andrew.Fryer Date: 10/17/2008
Virtualization Unplugged Tour
I know many DBA’s have strong opinions on the pros and cons of virtualization especially when...
Author: Andrew.Fryer Date: 10/15/2008
SQL Server 2008 Free Training
The UK SQL Server community have come up with a cunning plan to connect more people who are serious...
Author: Andrew.Fryer Date: 10/14/2008
SQL Server 2008 – Getting tough with Policy Management
Policy management can work in a number of ways from being prescriptive to warning you either on...
Author: Andrew.Fryer Date: 10/13/2008
Virtualizing SQL Server 2008
Those of you at last months SQL Server unleashed events may remember Prem Maher form the SQL...
Author: Andrew.Fryer Date: 10/10/2008
SQL Server 2008, TechNet Road-show answers
Following Tuesday’s TechNet event in Manchester, I promised to answer the questions in my blog that...
Author: Andrew.Fryer Date: 10/09/2008
Microsoft Kilimanjaro - nothing to see, please move along
There are a ton of new project names coming out of the Microsoft BI conference in Seattle, which...
Author: Andrew.Fryer Date: 10/07/2008
SQL Server 2008 Merge and Integration Services
The new Merge T-SQL command has great potential in a data warehouse scenario and Integration...
Author: Andrew.Fryer Date: 10/06/2008
Free SQL Server 2008 e-book
I love e-books, it’s so embarrassing turning up on a client site with a pile of manuals (even worse...
Author: Andrew.Fryer Date: 10/03/2008
Windows Live Writer just keeps getting cooler
Every couple of months as I write my blog in Windows Live Writer, it pops up and says “would you...
Author: Andrew.Fryer Date: 10/02/2008
SQL Server 2008 Experience
The SQL Server Experience is a new slick one stop shop for all things SQL Server 2008. It’s not all...
Author: Andrew.Fryer Date: 10/01/2008
SQL Server 2008 – implicit date addition
I am a pretty lazy DBA, and I use the UI wherever I can to get the job done as simply and...
Author: Andrew.Fryer Date: 09/30/2008
SQL Server 2008 Cumulative Update Package #1
Cumulative updates have not always been popular with DBA’s as may of you prefer to wait for service...
Author: Andrew.Fryer Date: 09/29/2008
SQL Server 2008 Management event in Manchester
Unlike Manchester United, SQL Server 2008 is under new management. What I mean by this is that there...
Author: Andrew.Fryer Date: 09/29/2008
BarCamp5London
A BarCamp is where about 100 web geeks spend all weekend together discussing what’s hot and...
Author: Andrew.Fryer Date: 09/28/2008
Dashboard Decisions SharePoint or Performance Point?
When it comes to dashboards, Microsoft’s business intelligence stack seems to have some overlap in...
Author: Andrew.Fryer Date: 09/15/2008
SQL Server Unleashed – Decks
Quite a few people have asked me where the decks are for the SQL Server unleashed event and I now...
Author: Andrew.Fryer Date: 09/15/2008
Steve Ballmer Plays the Queen Elizabeth Hall
I have seen quite a few concerts, plays etc. at the Queen Elizabeth Hall in the South Bank Centre,...
Author: Andrew.Fryer Date: 09/11/2008
SQL Server 2008 Happy RTM
Thanks to everyone who came along to celebrate SQL Server 2008 at our unleashed event yesterday and...
Author: Andrew.Fryer Date: 09/10/2008
Business Intelligence for Small Business – Analysis
If you have been following this blog over the last few days, then we are at the stage we know...
Author: Andrew.Fryer Date: 09/09/2008
Business Intelligence for Small Business – Scorecards
If you have read my last two posts and are interested in applying BI to your business, how do you...
Author: Andrew.Fryer Date: 09/08/2008
Business Intelligence for Small Business – Where’s the evidence?
Technorati Tags: softwre plus services,BI,Business intelligence,small business Georgina (Curious...
Author: Andrew.Fryer Date: 09/08/2008
Making the case for Business Intelligence in Small Business
While many IT professionals equate business intelligence (BI) with large organisations, the...
Author: Andrew.Fryer Date: 09/07/2008
SQL Server backup & restore across versions
This may be a short post in stating the [insert your favourite expletive here] obvious, but you can...
Author: Andrew.Fryer Date: 09/07/2008
SQL Server 2008 Central Management Servers
I have done a blogcast and a few posts around the configuration servers in the betas of SQL...
Author: Andrew.Fryer Date: 09/05/2008
Data Warehousing from the Experts.
If you glance to the side of this post you will see that one of the few books on my bookshelf is the...
Author: Andrew.Fryer Date: 09/02/2008
TechED 2008 Barcelona – Because You’re Worth It
Following on from yesterday’s post, I wanted to encourage the DBA’s to demonstrate your influencing...
Author: Andrew.Fryer Date: 09/01/2008
SQL Server 2008 Change Data Capture
One of the things that isn’t really clear form all the blurb about SQL Server 2008 is how the...
Author: Andrew.Fryer Date: 09/01/2008