Insufficient data from Andrew Fryer

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

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… Read more

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 it would now be on V5. … Read more

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… Read more

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 as Complex Event… Read more

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… Read more

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!).  So… Read more

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 will only use 4. However if… Read more

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 Package (sqlncli.msi)… Read more

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 might be OK for a… Read more