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 Express
TechNet Road Show
windows phone 7
Windows Server 2008
Windows Server 2008 r2
Windows Server 2012
Browse by Tags
Insufficient data from Andrew Fryer
sql server 2008
Tagged Content List
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
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
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
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 into pigeon holes, and an area where this fails for me is when it comes to SQL Server. My developer friends won’t go near SQL Server unless they have to and this things like LINQ / Entity Framework...
24 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
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
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
BI for small business
When I applied to join Microsoft nearly 4 years ago I had to give a presentation on olap for small business which now looks a little dated. So yesterday I got the chance to revisit my thoughts on this over espresso with BI Guru Rafal Luckaweiki from Project Botticelli who was over to...
3 Mar 2011
SQL Server and dynamic memory with Hyper-V in Windows Server 2008 R2 sp1
Running SQL Server in a virtual machine is a good thing for many reasons however there are two basic rules: don’t over commit processors use fixed or pass through disks (i.e. not dynamic one) The guidance from the SQL CAT (SQL Server Customer Advisory Team) doesn’t extend to memory as up until now you...
28 Feb 2011
Getting Started with SharePoint and SQL Server Reporting Services – a guest post by Jess Meats
One of the capabilities of SQL Server is the ability to create and publish rich reports on your data. One of the capabilities of SharePoint Server is the ability to store, manage and provide a portal to documents. Those documents could be your reports. So you have one system letting you create reports...
8 Feb 2011
Project Atlanta part 2–Installation
Following on from last post I thought I had better fire up Atlanta to see what it cold find out about my demon environment. I made this screencast as I installed and configured it .. It only took a few minutes to get to the stage where I had two servers, one (Oxford-DC, a server with no SQL Server on...
19 Jan 2011
Project Atlanta part 1 – Introduction
In the post Christmas rush to get fit the well off will have personal trainers assigned to them to help get back into shape. Similarly in the world of SQL there is an abundance of experts to help ensure that SQL server is as lean and mean as possible, however not everyone can afford that expertise, or...
18 Jan 2011
Microsoft BI and Kerberos
I was briefing a bunch of partners the other day, and during coffee I went off piste and did a short overview of my presentation “It’s not about the Technology” to the BI MSc course at Dundee University. However sometimes technology does get in the way especially when it comes to implementation...
5 Dec 2010
SQL Server performance in a virtual world
Despite doing quite a few posts and talks on Virtualising SQL Server, I am still getting the odd comment on earlier posts, so please forgive this if you have heard it all before. Firstly these are my musings on the topic to date: Virtualisation for the DBA part 1 - Are you bovvered? Virtualisation...
23 Nov 2010
TechEd Berlin Day 1
Simon and i are at TechEd Berlin all week, his post on the keynote is here. I didn’t get to that as I was setting up BI demos al day on the SQL Server stand. I got asked a couple of interesting SQL Server questions I thought I would share: I have SQL Server 2008 but not R2 what BI features do I...
10 Nov 2010
SQL Server Reporting Services interop part 2
I forgot one thing on my recent post on Reporting services interop, Report Builder. What is Report Builder? it’s an end user (information worker in Microsoft speak), tool that creates a report that can run in SQL Server reporting services. What this actually means is that it creates a xml...
2 Sep 2010
SQL Server Redundancy
When I saw SQL Server redundancy on a recent internal e-mail I wondered if it was about a replacement for SQL Server , DBA job losses, or the rise of the NoSQL movement. It turned out to be nothing more than a general ask about the pros and cons of clustering and mirroring. If there are internal...
31 Aug 2010
SQL Server Reporting Services interop
SQL Server Reporting Services is nearly ubiquitous as SQL Server itself, it is in nearly all versions of SQL Server from Express (with Advanced services) to DataCenter edition and will soon be available in SQL Azure. It’s been around for 8 years and if Microsoft used traditional version numbers...
23 Aug 2010
Spatial Referencing Systems in the UK
I have had a couple of queries about spatial data in SQL Server regarding SRIDs. I have posted already on some of this here , and while I mentioned SRIDs I didn’t really cover what that means so hopefully this explains it... First of all the term Spatial Reference Identifier ( SRID ) is a European...
11 Aug 2010
Tricking a client into connecting to a SQL Server Instance
One of the challenges of consolidation and upgrades is that some applications might have hard coded or difficult to find references to the server instance they are connecting to. When you want to point this hypothetical application to the non-default instance on a new server you can often use DNS to...
16 Jun 2010
Free Tickets to the SQL Master Class
Here’s a problem how do you give away 2 tickets to the SQL Server master class with Kimberly Trip and Paul Randall ? The logical answer is to ask a technical question, but if it’s too hard the winner who answers it won’t get the same benefit from going to the master class. Of course...
8 Jun 2010
Page 1 of 10 (237 items)
© 2013 Microsoft Corporation.
Privacy & Cookies
See all products »
Microsoft IT Camps
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012
System Center 2012 SP1
Microsoft SQL Server 2012 SP1
Windows 8 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
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