February 2010 - Posts

Over a number of months I have had students on courses and members of the community express concerns over the new release of SQL Server 2008 R2 Enterprise Edition. They have been given the impression that with the new release they would only be entitled to 1 instance per processor license due the release of two new editions in SQL Server 2008 R2 known as Data Centre Edition and Parallel Data Warehouse Edition

Being at the MVP Summit last week gave me the opportunity to speak directly with the SQL Server team who led me to a resource that confirms that SQL Server 2008 R2 Enterprise Edition will still allow multiple instance of SQL Server. Specifically 25 instance per processor license. While this is lower that the 50 instance that are currently allowed in SQL Server 2008, I know that this news will certainly ease the concerns that some of you, who have asked this question.

You also have the ability to run 4 vurtual machines on this edition.

The link for this information can be found here


If you require more instance or virtual machines, then consideration should be given to using Data Center Edition of SQL Server 2008 R2.

More information can be founnd here







Posted by Testas | 1 comment(s)


 Just to let you know we have not forgotten about Manchester and Leeds, Sessions have been put up for manchester and we are finalising the venue as I write this. We are also looking for a Leeds venue, any members who can help would be gratefully recieved

 In the interim, Martin Bell and Myself are speaking at Vbug..... details below



WED 3RD MARCH 6.30pm


Table Valued Parameter - good, bad or just plain ugly? with Martin Bell

Passing arrays to stored procedures has never been easy! With the release of SQL Server 2008 and the new Table Valued Parameter feature have we now got an easy solution to this problem or do they still suck? Martin will look at what options are available in the different versions of SQL Server and compares the performance and practicalities of using each one.


End to End Report Creation and Management in SQL Server Reporting Services 2008 with Chris Test-O'Neill

With Reporting Services 2008, Microsoft takes a step forward in presenting SQL Server as an enterprise data platform.  Innovations in data regions, vast improvements  in visualisation, and a new Report Designer, Microsoft SQL Server 2008 Reporting Services provides a tool that can be used by all members in the organization.

This session will begin on Installation issues. You will walk through the authoring, management and delivery of reports, focusing  on the new features of Reporting Services 2008, creating a report in the new report designer. Raising awareness of Report management options and the delivery mechanisms to deliver reports.


To register and for more details go to http://www.vbug.co.uk/Events/March-2010/VBUG-Manchester--relaunch-event-with-two-guest-speakers.aspx

Posted by Testas | 3 comment(s)

Microsoft has released a hotfix that should alleviate this problem which applies when you generate a report model from a data source within SharePoint Server 2007 and 3.0

When you generate the model the following error is returned "Server was unable to process request. ---> The operation has timed out"

For the hotfix and further information use the following link




Posted by Testas | with no comments

Hi all

For anyone who attended SQLBits goes west at the Celtic Manor in Newport, I am sure you will agree it was the best SQLBits to date and I am very much looking forward to the next installment. The videos are available for you  to view to recap on the sessions you attended or the sessions you missed.

For those who did not attend, I would recommend that you grab a coffee, and popcorn if you so wish and browse the library of videos available. They are definately worth a look. However, after you watch these, I hope I see you at the next SQLBits




Posted by Testas | with no comments
Filed under: ,