February 7, 2010 at 9:39 am
Can any using SQL Server 2008 - post their 'good', 'bad' and ugly !
which new features would benefit us from migrating from previous versions.
Cheers guys
--------------------------------------------------------------------------------
Justin Hostettler-Davies
http://www.databaseexpertise.com
[font="Verdana"]Justin Hostettler-Davies[/font]
www.databaseexpertise.com
February 7, 2010 at 10:39 am
2008 R2 is predominantly a set of BI focused addons for SQL Server. There are virtually no changes to the database engine (I've counted 3, maybe 4). It's mostly scale out for BI (project Madison), Self-service BI in the form of PowerPivot add-on for Excel 2010 (Project Gemini) and some managability changes; dacpacks, control points, SQL Fabric, etc (Kilimanjaro), plus a few other extras, like Master Data Services.
Lots of toys, but no major database engine changes.
p.s. If you ask a question here, expect to get the answers here too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 7, 2010 at 11:26 am
There are quite a few nice features that are being added into Reporting Services like the Map Report Item, Report Part Gallery, Shared Datasets, Sparklines, Data bars, Indicators, and more. Report Manager also got updated - Report Manager 2008 R2 August CTP Facelift. A couple of the big items based on some of the acquisitions over the years is Master Data Services and Parallel Data Warehouse. Another great new item that we have been waiting for since the Microsoft BI Conference back in 2008 is PowerPivot (this will require Excel 2010 on the desktop for creating and SharePoint 2010 for delivery).
These are just a few of the new items coming.
What's New in SQL Server Installation
What's New (Reporting Services)
SQL Server 2008 R2 Parallel Data Warehouse
Self-Service Business Intelligence in R2
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
February 7, 2010 at 11:33 am
I'd put Streaminsight in the ugly since it's just in Data Center edition. I might also put the fact that Enterprise has some lower limits on hardware though they're not "low" by any means (http://msdn.microsoft.com/en-us/library/cc645993%28SQL.105%29.aspx)
The Reporting Services enhancements are great, along with Powerpivot, and they should help better get information to users.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 7, 2010 at 11:34 am
Steve Jones - Editor (2/7/2010)
I'd put Streaminsight in the ugly since it's just in Data Center edition.
It's in the other editions too, though no word of what limitations there'll be in the others.
http://blogs.msdn.com/streaminsight/archive/2009/11/24/streaminsight-november-ctp-refresh-released.aspx (2nd comment)
http://social.msdn.microsoft.com/Forums/en/streaminsight/thread/fa1235ba-f3a4-47e0-ad03-b4d2360a01f5
Seems there's a little miscommunication with the marketing people...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2010 at 5:58 am
Steve Jones - Editor (2/7/2010)
.........the fact that Enterprise has some lower limits on hardware though they're not "low" by any means (http://msdn.microsoft.com/en-us/library/cc645993%28SQL.105%29.aspx)......
on this, can anyone confirm for me whether the MAX 4VM's are per processor license (R2 Enterprise) or whether its per physical host? A guy from our software house say's physical host but i can't believe that to be the case............
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
February 8, 2010 at 6:10 am
I'll have to check that again, but I tought that with sql2008 that limit was removed for a single OS install. (so one OS hosting n sql 2008 instances on a per proc ent edtn).
http://www.microsoft.com/Sqlserver/2008/en/us/licensing.aspx
However I will await the Pricing list for May 2010 which should include the R2 modifications.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 8, 2010 at 6:52 am
http://blogs.msdn.com/sellinglicensing/archive/2010/02/04/sql-price-increases.aspx
SQL Price Increases
Summary:
With the release of SQL Server 2008 R2 (April price lists), there will be a
15% increase in the processor pricing of SQL Server 2008 Enterprise Edition and a 25% increase in the processor pricing of SQL Server 2008 Standard
. Along with the pricing changes, there will be a new premium edition released, SQL Server Datacenter Edition. This version will allow maximum memory, CPU and Virtualization support. Therefore, there will also be changes going forward in SQL Server Enterprise including:
· Maximum memory of 2TB RAM
· Up to 8 Procs CPU Support
· Virtualization rights for 4 VM’s* – Customer’s with Software Assurance using unlimited virtualization with SQL Server 2008 EE will have free step up rights to Datacenter Edition.
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
February 8, 2010 at 7:01 am
On the question of the price increases I asked my purchasing guys if I could avoid these by not downloading R2 but using 2008 SP1 instead. they said I would have to get backward compatibility licenses and still have to pay the increased costs.
So we are stuck with the price increase whether we need the new features or not.
I am a tad confused as to whether all future releases will be based on R2 or there will be two streams of SQL 2008 going forward from SP1 and R2. Can anyone confirm?
---------------------------------------------------------------------
February 8, 2010 at 7:32 am
as far as i can tell, come may when R2 is released, that is the only version you can buy licenses for, but you will be able to run "R1" with these. We've been advised to get as many "R1" licenses as we think we'd need before May in order to save on having to potentially upgrade to datacentre if we wanted another server to add into our farm.
As per usual, the microsoft licensing model ain't as straight forward as it could be :w00t:
_________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie
February 8, 2010 at 7:50 am
at least we now know why it was called R2 and not just released as SP2!
---------------------------------------------------------------------
February 8, 2010 at 7:52 am
george sibbald (2/8/2010)
at least we now know why it was called R2 and not just released as SP2!
Because it's not a service pack. It's a set of add-ons for SQL Server. There are very few changes to the core database engine.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 8, 2010 at 7:57 am
GilaMonster (2/8/2010)
george sibbald (2/8/2010)
at least we now know why it was called R2 and not just released as SP2!Because it's not a service pack. It's a set of add-ons for SQL Server. There are very few changes to the core database engine.
sorry, I was being a bit sarcastic! I was referring to the fact that R2 has led to a hefty price increase as there are a number of new features. Once R2 is released you will have to pay for those features whether you use them or not.
---------------------------------------------------------------------
February 8, 2010 at 8:32 am
Actually I think this is the way to do. So many people have complained about features in SPs, myself included. I prefer SPs to be just fixes.
Adding those new features, should come at some price. If you don't use them, why upgrade?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
February 8, 2010 at 8:39 am
Steve Jones - Editor (2/8/2010)
Actually I think this is the way to do. So many people have complained about features in SPs, myself included. I prefer SPs to be just fixes.
Agreed 100%. I don't want to have to worry about what patch level a server is at to tell if I can use a feature or not. Just worrying about the version's enough hassle.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 15 posts - 1 through 15 (of 19 total)
You must be logged in to reply to this topic. Login to reply