Where can I read more about the new features and changes? SQL 2008 R2 does include some pretty cool stuff, but it doesn’t include major earth-shaking changes in the database engine itself. Microsoft is following the precedent set with Windows Server 2003 R2, which added some features but wasn’t a groundbreaking change. Why isn’t the next version called SQL Server 2010? If I didn’t want those new features, I’d still have the flexibility of running unlimited SQL Server 2008 instances in virtualization. #Where can i download sql server 2008 r2 software#I’d buy it with Software Assurance anyway, so I’ll get R2’s new features if I want them. In May, Enterprise Edition’s price is going up, and it will have less licensed features. If I was a DBA with a budget to buy SQL Server licenses this year, I’d make that purchase now. To get that feature, you have to spring for the new Datacenter Edition, which costs around $60k per CPU socket. #Where can i download sql server 2008 r2 pdf#Review the SQL Server 2008 R2 Editions PDF and you’ll find that R2 Enterprise Edition doesn’t come with unlimited virtualization. Microsoft sees that coming, and they’re changing it in R2. They might not be virtualized today, but they’re gonna be virtual years from now, and today’s licensing saves you a fortune. #Where can i download sql server 2008 r2 install#SQL Server doesn’t just go away – the instances you install today will still be in production for years to come. You may not be running SQL Server widely in virtualization environments yet, but ask yourself how many SQL Server 20 instances you’re running today. “For enterprise edition there is an added option: if all physical processors in a machine have been licensed, then you may run unlimited instances of SQL server 2008 in one physical and an unlimited number of virtual operating environments on that same machine.” From Microsoft’s SQL Server 2008 Licensing Guide: If you’ve got a 4-socket virtual host and you buy 4 sockets of Enterprise Edition, you can run as many SQL Servers on that host as you want. Right now, if you buy SQL Server 2008 Enterprise Edition now by the CPU, you get unlimited virtualization rights. R2’s licensing has an ugly change for shops who use virtualization. ![]() How will SQL Server 2008 R2 licensing work for virtual servers? When databases are attached to a SQL 2008 R2 server, their version number is upgraded to 660, and these databases cannot be reattached to an older (SQL 2008) server. Keep in mind that this is a preview build, not a feature-compete beta. Check in the SQL Server 2008 section of the download site, or click here to download SQL Server 2008 R2 for free. MSDN and Technet subscribers can download 2008 R2 Enterprise Edition now for free. Where can I download the SQL Server 2008 R2 CTP? You’ll need the upcoming release of Visual Studio 2010 to create and edit. Will I need Visual Studio 2010 to edit DAC Packs?ĭata-tier application projects, new with SQL 2008 R2, can’t be edited with SQL Server Management Studio. No new commands, no new data types, no new stored procedure goodies. T-SQL Enhancements – got nothin’ for you here.It’s the result of Microsoft’s acquisition of DATAllegro. Scale-Out Servers – if you need to scale a data warehouse beyond a single server, you’ll want to keep an eye on Project Madison.You can learn more about it in this screenshot-packed review of what’s new in Project Gemini and this pivot table tutorial for Project Gemini. Excel 2010 will act as a client for SSAS. Business Intelligence – there’s a ton of new functionality for self-service BI in SQL Server Analysis Services 2008 R2.If you’ve heard the terms Utility Control Point, Utility Explorer, or SQL Server Utility, I’ve got your answers in that series. #Where can i download sql server 2008 r2 series#I blogged about it in a 3-part series starting with this article about How SQL 2008 R2 is Like Virtualization for Databases. There’s some infrastructure introductions to support Data-Tier Applications in the future, but they’re not too useful as of the August CTP. ![]() What’s new, and what are the new features in SQL Server 2008 vs SQL Server 2008 R2?įrom a very high level, here’s the new features in R2 that weren’t in 2008: If you don’t have SA, then you’ll need to decide whether the new features in SQL Server 2008 R2 vs SQL Server 2008 will be worth the cost of upgrading, because you won’t get SQL 2008 R2 for free. ![]() If you’ve got Software Assurance for your SQL Server 2008 licensing, then you get all R2 updates included for free. #Where can i download sql server 2008 r2 upgrade#SQL Server 2008 R2 Utility Explorer What’s the cost to upgrade to SQL 2008 R2? Despite it being released in the year 2010, it will not be called SQL Server 2010. SQL Server 2008 R2 will be released in May 2010. What will be the SQL Server 2008 R2 release date? Got questions about the new features in Microsoft SQL Server 2008 R2? Can’t wait for R2’s release date? Here’s the answers I’ve been giving out most often to database administrators wondering about the changes in SQL Server 2008 R2 vs SQL Server 2008.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |