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
sql server 2008 r2
Tagged Content List
Lab Ops 2–The Lee-Robinson Script
In my last post I mentioned how Marcus Robinson & had adapted PowerShell scripts by Thomas Lee to build a set of VMs to run a course in a reliable and repeatable way. With Marcus’s permission I have put that Setup Script on SkyDrive, however he has a proper day job running his gold partnership...
20 Sep 2013
SQL Server Spruce up
Landrovers, will take a lot of pounding and neglect, but when my wife drove hers to Australia she made very sure it was properly set up for 2 years on the road Similarly SQL Server is also often out in the wild far from DBA’s and inspection from maintenance tools, like System Center . However now...
8 Aug 2013
Installing SQL Server in a Virtual World
I do get occasional feedback that SQL Server is hard to install, all those screens all those checkboxes etc. etc. This is simply a reflection that there is so much in SQL Server aside form the database engine, however if you know what you want and you are doing this regularly then script it, if...
29 Jul 2013
Server 4024 part 1 – Virtualisation
A database is only as good as the operating system it resides on. SQL Server only runs on Windows and given that Windows Server 2012 (WS2012) is a huge change from what there was in Server 2008 R2 what does this new OS mean for the DBA. The reference to Server 4012 is because that would be WS2012...
29 May 2013
System Center Advisor– now live
I remember hearing about a Project Houston about a year ago, a cunning plan to allow Microsoft to check the heath of your SQL Server databases and the operating system it sits on. It is now live and it’s called System Center Advisor . It works by using an internet gateway server you setup which in turn...
7 Mar 2012
Application Platform Knowledge Hub
Albert Einstein once remarked that you don’t need to remember everything, you just needed to remember where to look. When it comes to learning about Microsoft products this can sometimes be harder than it ought to be and what resources there are can be fragmented so you do have to remember where...
6 Feb 2012
NO SQL Server
I spent last Thursday at Black Marble’s Architect Forum and my slot was on SQL, NoSQL, some SQL. It went down very well but I used OneNote on my tablet not PowerPoint and like all modern art my drawing needs a bit of explaining.. Databases were originally used to store transactions which are highly...
10 Dec 2011
Getting Started with SCOM 2012 beta
System Center Operations Manager (SCOM) 2012 is now in beta along with all of the other System Center 2012 suite , and because it’s a beta the installation process is a little tricky. Having spent a morning on it I thought it would be good if I told you what I did so you don’t have to go through this...
3 Nov 2011
SQL Server HP Appliances & the modern data centre
There is a lot of advice on whether to virtualise SQL Server and many dbas are under pressure to do this. There’s good advice here from SQL CAT on best practice on hyper-V and if you are in the business of acquiring hardware to run SQL Server virtualised then there are two reference architectures...
17 Oct 2011
SQL Bits 11 - Notes & Queries
If you didn’t manage to fight your fight your way through the Everton & Liverpool fans to SQL Bits I thought you might like to see some of the random questions I got asked.. How do I manage SQL Azure? I think the key thing about developing for the cloud is to ensure that your application can handle...
3 Oct 2011
SQL Server sprawl
Normally the term sprawl carries an implied criticism, in the case of SQL server that DBAs have lost control of their infrastructure and users are install it willy nilly without regard for data protection or disaster recovery. However when it comes to SQL Server user group meeting then sprawl is...
7 Sep 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; specifically is there enough money in the budget and to find that out I need to run a report. This is what’s meant by operational reporting and this distinction means that this report can be considered...
24 Aug 2011
Query Across the Mersey
SQL Bits 9 , Adelphi Hotel Liverpool 29th September to 1 October 2011, what else do you need to know? Well possibly a few things if you are now reading the second line of this post or you haven’t been to them before.. It’s the biggest and best SQL event in Europe, I know this because we get people coming...
10 Aug 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 will respond if I can to requests on my blog , twitter etc. a particularly if it’s from people new to a particular technology. This is partly out of a recognition that we’re all experts in...
7 Aug 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 functionality built in but nothing has been mentioned about the strange world of data mining . Data mining has been in SQL Server since analysis services was launched but I have rarely seen it being used - it...
4 Aug 2011
The 7P’s of projects
Proper Preparation & Planning Prevents Pathetically Poor Performance I mention this because the process of working out how to make changes to your data centre can and should take longer than doing the actual work. For example if you are going to dive into virtualisation or do more with it,...
6 Jun 2011
Virtualising SQL Server - a second opinion
I caught a really good presentation from Chris Kranz( www.wafl.co.uk and @ckranz), Principal Solutions Architect responsible for Storage and Virtualisation projects at leading Systems Integrator, Kelway (UK) Ltd . at the Leeds VM user group last month. Chris first encountered virtualisation...
17 May 2011
Good diary management is career mission critical at Microsoft and may well be the same for you and if it is I have some free stuff for you to try. The Microsoft BI team have issued a calendar analytics spreadsheet that shows you how you are spending your time. It works by connecting to exchange and picks...
10 May 2011
Guest Clustering–What is it and do you need it?
I am pretty sure the term guest clustering is not a standard industry term nor is it official Microsoft speak, so what do I mean by it? I mean the business of creating a cluster out of a group of virtual machines – you might call this a virtual cluster but that might confuse it with clustering physical...
9 May 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 am seeing my favourite database suffering a lot of abuse out there as part of the blind rush to virtualisation. A good example is, Gillian, a dba I met at SQL Bits who was nearly in tears because...
19 Apr 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 as the best bit of my job is swapping ideas and stories with like minded individuals, not to mention the odd lively debate. I also get the impression that many of you enjoy this too and I often...
10 Apr 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 looks like after I have left it running across a couple of servers I have pointed to the servers.. Just one thing to note, in my last post I introduced Advisor as “essentially Systems Center Operations...
6 Apr 2011
Bye bye Atlanta, Hello System Center Advisor
One of the many announcements to come out of the recent Microsoft Management Summit was System Center Advisor . Essentially this is Operations Manager (SCOM) in the cloud, so a sort of InTune for servers. I had a look at the precursor to this, Project Atlanta back in January, but at the time it...
4 Apr 2011
Applied Business Intelligence
Like many IT Professionals, I love my gadgets but what really matters is what you do with them – so which games do you play on your gamer PC what did you photograph with that monster lens you bought for your DSLR and who did you hook up with on Facebook at the weekend? The same is true...
21 Mar 2011
Farewell old friend–time to say goodbye to SQL Server 2005
It always nice to see historic aircraft , and vintage cars out and about rather than stuck in museums, the noise and even the smell of castor oil add to this nostalgia. However keeping them going requires a lot of effort and keeping them current with modern rules means that a Fokker triplane will...
16 Mar 2011
Page 1 of 4 (92 items)
© 2013 Microsoft Corporation.
Privacy & Cookies
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
Compatability & Converters
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
Support by product
Forefront Edge Security
Forefront Server Security
Other support links
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Look up event IDs and error codes
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums