Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Browse by Tags

Related Posts
  • Blog Post: Spruce Up your Data Centre

    The summer holidays can generally be a quiet time for some IT Pros, depending on the industry you work in, so I wondered if this would be a good time for a bit of a tidy up in the data centre.  The easy bit of that is to actually tidy up the physical environment such as cabling left lying around...
  • Blog Post: Licensing and Scaling up SQL Server BI

    Both Standard and Enterprise editions of SQL Server come with a lot more than just a database engine, there’s also a suite of BI tools: Integration Services (SSIS) Reporting Services (SSRS) Analysis Services (SSAS) which you are also licensed to use on the same server as the database engine.  That...
  • Blog Post: SQL Server standard edition in a virtual world

    One of the limitations of SQL Server is that it only supports 4 processors (as you can see here ).  That translates into 4 virtual processors if you run standard edition in a virtual machine.  If there are more than four processors available whether physical or virtual then standard edition...
  • Blog Post: Windows RC sell by date

    I am not sure if Mrs Fryer is trying to cash in on the life insurance or hasn’t quite got the hang of supply chain management.  The thing is I keep seeing stuff in the fridge with “sell by October 2009”, and the odd bit of furry cheese.  Of course software doesn’t normally expire in the way...
  • Blog Post: SQL Server Licensing

    I was talking to one of our reseller partners about licensing for SQL Server at coffee at an event yesterday. He mentioned a bid he was involved in where a college was under the impression that SQL Server needed to be licensed for each core on the server. Of course the reality is that if you decide to...
  • Blog Post: SQL Server Editions

    I recently got a comment on my blog complaining about all of the editions of SQL Server, so why don’t Microsoft just stick to one? SQL Server gets everywhere, from a smart phone to a data centre and now the cloud (with SQL Sever data services). If you are using media player the metadata is in SQL Server...
  • Blog Post: 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...
  • Blog Post: Microsoft Licensing

    Along with particle physics and rail travel, software licensing is at the forefront of modern mathematics.  I am not  a rocket scientist so I have had a couple of issues in the past around licensing: At HM Customs I gave an application to another government and I didn’t realise that I...
  • Blog Post: Licensing in a Virtual World

    Even if you work for Microsoft licensing can be complicated. I am pretty confident on what’s what with SQL Server, but I was in TV land yesterday at a large broadcaster, and they are looking to adopt Windows Server 2008 and SQL Server 2008 as a standard for all of their projects.  We spent an hour...
  • Blog Post: SQL Server 2012 editions and dependencies

    You may have seen that there are going to be some changes to the way SQL Server 2012 is licensed and the editions available, if you haven’t then the detail is here . What I want to cover off in this post is what the various new features depend on so you are clear on what else you need besides the...
  • Blog Post: StreamInsight in SQL Server 2008 R2

    In my recent post on the license changes in SQL Server 2008 R2, I deliberately didn’t cover the way the new features would be distributed across the various editions as at the time of writing the decisions simply hadn’t been made. One of these new features is StreamInsight (the feature formerly known...
  • Blog Post: Virtualized SQL Server

    [Note the information in this post is now way out of date, so please refer to my post here instead.. http://blogs.technet.com/b/andrew/archive/2008/11/08/sql-server-2008-at-teched.aspx Thanks Andrew] I get more and more questions about SQL Server running in a Virtual machine so here’s...
  • Blog Post: Tip of the Day – SQL Server Client tools

    You don’t have to install all of the full SQL Server client tools to get connectivity to SQL Server or analysis services.  They have been broken up and are available individually for download as part of the SQL Server feature pack . For example you can pull down: SQL Server 2008 native client. X86...
  • Blog Post: SQL Server 2008 R2 licensing

    A while I go I did a post on licensing SQL Server in a virtual world , and there some changes you need to be aware of with the release of SQL Server 2008 R2 as the current site for SQL Server 2008 R2 doesn’t have this detail Very simply SQL Server licensing has been aligned to Windows Server licensing...
  • Blog Post: Windows Server 2008 Enterprise edition and Virtualisation

    I get quite a few questions about virtualising SQL Server and typically today this is on VMWare so yesterday I went along to find out more at the VMWare London User Group.   In the current world of computing, vendors compete with everyone but also has alliances with everyone (a bit like the UN really...