Microsoft announces in-memory-enhanced Microsoft SQL Server 2014, supports hybrid cloud with Windows Server and System Center upgrades.
VMware Vs. Microsoft: 8 Cloud Battle Lines
(click image for larger view and for slideshow)
Microsoft may be stumbling in the consumer space with Windows 8 and Surface tablets, but it's full steam ahead in the enterprise market as the company announced the release of public-beta versions of Microsoft SQL Server 2014, Windows Server 2012 R2 and System Center R2. The announcements were made Monday at the company's TechEd Conference in New Orleans.
Microsoft's enterprise server and tools business is in an enviable position, with $19 billion in annual revenue and growing 10% over the last year, according to the company. Microsoft SQL Server has 46% of the database management system market (by license numbers -- Oracle leads on revenue), while Windows Server is the operating system for 74% of the gigantic x86 server market, according to Microsoft.
The upgraded products Microsoft is releasing as public community technology previews this week are aimed at keeping the growth going. Where Windows Server and System Center are concerned, Microsoft's big bet is that customers will embrace a hybrid cloud world with a mix of on-premises, private-cloud and public-cloud deployment. With Microsoft SQL Server 2014 the promise -- as is always the case with databases -- is higher scalability and improved performance.
The first big gain in Microsoft SQL Server 2014 is improved resource governance. With SQL Server 2012, for example, it was possible to allocate server CPU power and memory usage, but the 2014 upgrade adds allocation of I/O capacity. This will enable administrators to assign specific database tables to fast storage options, such as flash storage arrays or solid-state disks, for better performance in I/O-intensive applications.
The SQL Server tuning advances will help Microsoft catch up to the Smart Flash Cache and Infiniband network speeds Oracle is delivering with its Exadata Database Machine. Microsoft is forging ahead of Oracle on another front: in-memory transactional processing. The technology preview previously known as Project Hekaton is now simply known as the In-Memory OLTP Engine built into Microsoft SQL Server 2014.
With this new in-memory option, database administrators will be able to speed selected transactional applications and processes by moving associated database tables into memory. And to help customers take advantage of this feature, Microsoft said it has developed built-in diagnostics that reveal which tables and stored procedures would benefit from the move into memory.
Microsoft is in a middle-ground position between Oracle and SAP with this in-memory move. Oracle can exploit flash memory with its Exadata Database Appliance, but it has yet to announce plans to take advantage of the much-faster random access memory (RAM) built into modern processors. SAP, in contrast, offers its all-in-memory Hana database, which runs on industry-standard x86 servers, but begs for state-of-the-art, memory-intensive configurations.
With Microsoft SQL Server 2014, companies won't have to upgrade hardware or change applications to take advantage of in-memory performance, according to the company. With that said, there's only so much memory to go around on legacy server deployments, so it remains to be seen just how much customers will be able to improve performance without upgrading hardware.
Edgenet, a company that participated in the private beta of SQL Server 2014, has reportedly gained real-time inventory-management capabilities through the upgrade. The company sells inventory management software to big-box retailers; before the database upgrade, it was tough for the company's applications to keep up with fast-moving inventory data. With fast, in-memory transaction processing, retailers can count on up-to-the-second accuracy on what is and isn't available in a store, according to Microsoft.
In another SQL Server 2014 upgrade, administrators can create, with a right click of a mouse, backup and disaster-recovery instances of the database in Microsoft's Azure cloud from the SQL Server Management Studio. That will save time and effort compared to much more complicated produces for cloud backups supported in SQL Server 2012, according to Microsoft.
The Agile ArchiveWhen it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
2014 Analytics, BI, and Information Management SurveyITís tried for years to simplify data analytics and business intelligence efforts. Have visual analysis tools and Hadoop and NoSQL databases helped? Respondents to our 2014 InformationWeek Analytics, Business Intelligence, and Information Management Survey have a mixed outlook.
Join us for a roundup of the top stories on InformationWeek.com for the week of December 14, 2014. Be here for the show and for the incredible Friday Afternoon Conversation that runs beside the program.