Insufficient data from Andrew Fryer
The place where I page to when my brain is full up of stuff about the Microsoft platform
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 &...
Author: Andrew.Fryer Date: 09/05/2011
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...
Author: Andrew.Fryer Date: 09/01/2011
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...
Author: Andrew.Fryer Date: 08/31/2011
SQL Server Reporting Services–if it’s important look after it
Before I can commit funds to a new project be it at work or at home I need to know I can afford it;...
Author: Andrew.Fryer Date: 08/24/2011
Installing Denali ctp3–how hard can it be
l forget sometimes that installing SQL Server isn’t that straightforward, in part because it is now...
Author: Andrew.Fryer Date: 08/18/2011
SQL Server on Windows Server Core part 4 – Sysprep & SQL Server
Installing SQL Server can be tedious and boring, and now that we live in a virtual world surely...
Author: Andrew.Fryer Date: 08/17/2011
SQL Server on Windows Server Core part 3–Installing SQL Server
In my previous two posts in this series I have installed and configured Win Server Core, and now I...
Author: Andrew.Fryer Date: 08/16/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...
Author: Andrew.Fryer Date: 08/14/2011
Query Across the Mersey
SQL Bits 9, Adelphi Hotel Liverpool 29th September to 1 October 2011, what else do you need to know?...
Author: Andrew.Fryer Date: 08/10/2011
Running out of space
One of the best parts of my job is helping people, and although I am not a Microsoft support guy, I...
Author: Andrew.Fryer Date: 08/07/2011
Data Mining not dead, but possibly forgotten
With the launch of SQL Server 2008 R2 and SQL Server Denali ctp3 there has been ever more BI...
Author: Andrew.Fryer Date: 08/04/2011
BISM and Consumerisation in BI
What on earth is consumerisation and what has it got to do with Business Intelligence? ...
Author: Andrew.Fryer Date: 07/28/2011
the BI Sematic Model in SQL Server Denali ctp3
Some sort of semantic model is needed in every BI solution but what is it and why do I need...
Author: Andrew.Fryer Date: 07/25/2011
Analysis Services cubed in SQL Server Denali ctp3
I have now managed to install analysis services (SSAS) in SQL Server Denali ctp3 three times to...
Author: Andrew.Fryer Date: 07/21/2011
Reporting Alerting in SQL Server Denali ctp3
The installation experience for SQL Server Denali is very similar to SQL Server 2008 R2 but there...
Author: Andrew.Fryer Date: 07/20/2011
Before I get started with SQL Server Denali ctp3
I have spent the last couple of days setting up a demo environment for SQL Server “Denali”, and I...
Author: Andrew.Fryer Date: 07/18/2011
Gone Critical
Many of us would associate the the term critical with the Register, so when I was asked by Tim...
Author: Andrew.Fryer Date: 07/13/2011
SCO Saturday part 2–configuring interop with SCVMM
Apologies for skipping a post on this last week, embarrassingly I couldn’t get System Center...
Author: Andrew.Fryer Date: 07/09/2011
Haiku-V
Virtualisation Good management tools Private cloud appears Public cloud worries Cause...
Author: Andrew.Fryer Date: 07/08/2011
Reach for the Cloud - System Center 2012
For me the most interesting stuff in the System Center 2012 is the cloud stuff. Some of...
Author: Andrew.Fryer Date: 07/07/2011
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...
Author: Andrew.Fryer Date: 06/25/2011
SQL Server developer training kit–to useful to be just for developers
One of the few niggles I have about working at Microsoft is the way we try and put you the reader...
Author: Andrew.Fryer Date: 06/24/2011
Volunteering with SharePoint 2010
The voluntary sector is a actually quite similar to the rest of business it’s just that the...
Author: Andrew.Fryer Date: 06/22/2011
Have a word with your accountant
I spent yesterday afternoon at a CIMA members meeting to discuss enterprise 2.0, on the back of some...
Author: Andrew.Fryer Date: 06/15/2011
OLTP performance in Denali - Less is more
I get the occasional criticism about SQL Server that all then new stuff is related to BI, and there...
Author: Andrew.Fryer Date: 06/14/2011
Mixing the public and private cloud
No one except startups will completely embrace the public cloud immediately. This means that a mixed...
Author: Andrew.Fryer Date: 06/09/2011
The 7P’s of projects
Proper Preparation & Planning Prevents Pathetically Poor Performance I mention this because the...
Author: Andrew.Fryer Date: 06/06/2011
How the Private Cloud affects your IT department
My Desktop counterpart Simon May posted a great article on How the public cloud affects your IT...
Author: Andrew.Fryer Date: 06/03/2011
Notes & Queries from TechDays 2011
I have been at TechDays Live all last week and although I did a bit of presenting, I was mainly...
Author: Andrew.Fryer Date: 06/01/2011
Direct access to DirectAccess
My favourite thing Windows 7 working together with Windows Server 2008 R2 is DirectAcess, not...
Author: Andrew.Fryer Date: 05/24/2011
Get your own best of the Microsoft Management Summit bits
Many of us couldn’t afford to make it Vegas for the MMS 2011 so in the UK last month the UK TechNet...
Author: Andrew.Fryer Date: 05/19/2011
NULL <> ISBlank()
While Excel is definitely the most widely used BI end user tool, SQL skills are often needed...
Author: Andrew.Fryer Date: 05/17/2011
Do What You Love
“Happiness lies in being privileged to work hard for long hours in doing whatever you think is worth...
Author: Andrew.Fryer Date: 05/16/2011
Dear Diary
Good diary management is career mission critical at Microsoft and may well be the same for you and...
Author: Andrew.Fryer Date: 05/10/2011
SQL Server AlwaysOn in a virtual world
Despite what I posted yesterday about clustering, mirroring is the preferred option for many DBAs in...
Author: Andrew.Fryer Date: 05/10/2011
Microsoft VDI – it exists and it works
I really enjoy going to technical community events even the ones that are run by Vmware, but you...
Author: Andrew.Fryer Date: 05/05/2011
Extreme Standardisation
I spent yesterday at the Best of the Microsoft Management Summit in London and rather than have...
Author: Andrew.Fryer Date: 05/04/2011
SQL Azure Update
The annoying thing about cloud services like SQL Azure is that they keep changing as more features...
Author: Andrew.Fryer Date: 05/02/2011
Hyper-V integration components, notes and queries
Virtual machine need resources from the host operating system/hypervisor and in the Hyper-V world...
Author: Andrew.Fryer Date: 04/21/2011
Help stamp out SQL Server neglect
eI am thinking of starting a new royal society the for the protection of cruelty to SQL Server as I...
Author: Andrew.Fryer Date: 04/19/2011
Event Handling for the IT Professional
My diary is solid for the next few weeks as there seem to be a lot of events on. This is good for me...
Author: Andrew.Fryer Date: 04/10/2011
Thoughts on Dynamic Memory
Dynamic memory has some people worried. I get it because even with my monster orange laptop...
Author: Andrew.Fryer Date: 04/07/2011
Using System Center Advisor
In my last post I fired up the new release candidate of System Center Advisor, and this is what it...
Author: Andrew.Fryer Date: 04/06/2011
Bye bye Atlanta, Hello System Center Advisor
One of the many announcements to come out of the recent Microsoft Management Summit was System...
Author: Andrew.Fryer Date: 04/04/2011
KPI confusion
I saw a discussion the other having a go about the fact that it is possible to create KPIs in a...
Author: Andrew.Fryer Date: 04/01/2011