Network World - While SQL Server 2008 was little more than a service-pack level upgrade, the 2012 version of Microsoft's database has a boatload of new features and delivers solid performance improvements.
Specifically, SQL Server 2012 offers Business Intelligence to help companies analyze business data, an AlwaysOn availability and uptime enhancement, Contained Databases for managing databases as a group and a quick-query tool called ColumnStore Index.
On the flip side, Microsoft's new licensing model will probably cost enterprises more money. And database administrators should be aware that taking full advantage of these new features will require additional network bandwidth and will impose extra burdens on IT.
SQL Server 2012 comes in three versions: Standard, Business Intelligence and Enterprise, with most of the new features reserved for the Enterprise Edition. And Microsoft has replaced its per-CPU licensing model with a per-core model. (See how we conducted our test.)
For earlier SQL Server versions, you bought one license per physical processor regardless of how many CPU cores it had. If you chose your server hardware smartly, you could buy eight CPU cores for the cost of one SQL Server license and save enough in licensing fees to pay for the new server. To license SQL Server 2012 for that same server, you'll need eight core licenses. The new core license fees are less than the previous per-CPU fees, but, if you do the math, Microsoft has conspicuously increased SQL Server's price.
Here's a rundown of the new features:
SQL Server 2012's Business Intelligence improvements essentially let users view a database as a spreadsheet. Users can program sophisticated spreadsheet formulas and reports that operate directly on database contents.
A user can, for example, program a new database report via these spreadsheet operations and then take a notebook computer running the new report (and connected wirelessly to the database server) into a meeting. The attendees can watch the report update in real time as database contents change.
Business Intelligence is a godsend for companies whose corporate policies allow (or encourage) users to program their own spreadsheets. However, BI is anathema for companies that want to control ad hoc manipulation of databases - and the decisions that ensue from such manipulation.
In companies that embrace Business Intelligence, network and database administrators will see their workloads blossom. As we tested Business Intelligence in the lab, we saw this effect firsthand. Extrapolating our results across a large company, we estimate that the unbridled use of SQL Server 2012's Business Intelligence feature will likely increase administrator workloads by 10% to 25%.
Think of AlwaysOn as database mirroring in which the secondary (substitute) server can be an active, already-in-use SQL Server 2012 instance. The secondary server takes up the slack when a primary instance fails. Because the substitute server may not have the horsepower of the primary server and because it's also doing other work, response times may slow dramatically. But the application blithely carries on without suffering an outage. The mirror doesn't have to be a standby server that sits idle until failover time.
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- 4 Customers who never have to refresh their PCs again This paper illustrates a common theme: the combination of desktop virtualization and thin client computing helps organizations deliver an up-to-date user experience more...
- Mobile Devices: The New Thin Clients Get essential guidance for understanding the role thin clients plus virtual desktops play in the enterprise today.
- Taking Windows Mobile on Any Device Taking Windows applications mobile has many advantages, but the process of identifying a solution is complex. Learn how to solve this complex problem...
- PaaS - Powering a New Era of Business IT Why PaaS has suddenly become relevant and irresistible to many organizations. Dive into the opportunities and considerations associated with using PaaS from an...
- Redefine Your IT Operations: Remote Office IT Has Never Been Simpler Join us to see why PC Pro named Dell PowerEdge VRTX the "2013 Server of the Year." PowerEdge VRTX may be just what...
- Mobile Apps and Devices Slash Customer Cycle Time Consolidated Engineering Laboratories' field employees used to collect data on triplicate forms that were sometimes hard to read and difficult to manage. After... All Hardware White Papers | Webcasts