MICROSOFT SQL SERVER 2008 R2 WITH TOOLS SOFTWARE

SQL 2008 R2 Enterprise Edition is capped at 8 CPU sockets, and thereвЂ™s a memory cap as well, but I havenвЂ™t been able to track down a public page showing the cap. The current SQL 2008 comparison page shows that Enterprise has no licensing limit on memory or the number of CPU sockets. Makes sense.ДЄ little less easy to stomach, however, is a new set of caps on Enterprise Edition. This isnвЂ™t a common need for OLTP systems, so itвЂ™s only included in Enterprise, not Standard. MDS helps make sure data follows business rules. ItвЂ™s targeted at enterprises with data warehouses that need to manage incoming data from lots of different sources, and that data isnвЂ™t always clean or correct. SQL 2008 R2вЂ™s BI tools include a new Master Data Services tool. In Enterprise, Microsoft giveth and Microsoft taketh away. ItвЂ™s good to see that Microsoft recognizes all servers need to be managed, not just the expensive ones. It canвЂ™t be the management server itself вЂ“ it canвЂ™t be a Utility Control Point вЂ“ but at least we can manage Standard. In addition, Standard can now be a managed instance вЂ“ it can be managed by some of the slick multi-server-management tools coming down the pike like the Utility Control Point ( read my SQL 2008 R2 Utility review). ThatвЂ™s a game-changer, and IвЂ™d expect to see smaller companies that do backup compression вЂ“ and nothing else вЂ“ to start falling by the wayside. In SQL 2008 R2, even Standard Edition gets backup compression.

MICROSOFT SQL SERVER 2008 R2 WITH TOOLS SOFTWARE

If all a DBA needed was compression, they could buy backup compression software much cheaper than the price of Enterprise Edition. Companies had to need Enterprise for multiple features in order to stomach the price. At the time, Enterprise Edition cost around $20,000 more per processor than Standard Edition, so companies couldnвЂ™t justify upgrading to Enterprise Edition just to get backup compression. SQL Server 2008 introduced backup compression, but it was only available in Enterprise Edition. Standard Edition: Now with Backup Compression At #SQLPASS this week, Microsoft unveiled a couple of new editions that got a lot of attention, but thereвЂ™s some really interesting things going on if you dig a little deeper.

Microsoft sql server 2008 r2 with tools