Although it doesn’t seem possible so soon, Microsoft announced SQL Server 2014 at this year’s TechEd 2013 conference in New Orleans. Quentin Clark, Microsoft Corporate Vice President for SQL Server, said that Microsoft is getting ready for the upcoming SQL Server 2014 release. Some of the most important new features in SQL Server 2014 include the following:
In-Memory OLTP Engine
The new In-Memory OLTP Engine (formerly code-named Hekaton) will provide OLTP performance improvements by moving selected tables into memory. The In-memory OTLP Engine works with commodity hardware and won’t require any application code changes. A built-in wizard will help you to choose which tables go in memory and select the stored procedures that will be compiled into machine code for high performance execution.
EdgeNet, an early adopter, saw a 7X performance increase with no code changes. Microsoft claims that some applications can achieve a 50x performance boost using the new In-Memory OTLP engine.
The balanced business scorecard was developed by Robert S Kaplan and David P Norton to overcome an imbalance in business planning. If you accept that what gets measured gets done, then it is unfortunate if you only measure money.
The traditional means of measuring success through financial performance focuses on achievement to date. It is backward looking and can be counter productive in terms of securing a successful financial future. As Kaplan and Norton say “Financial measures are inadequate for guiding and evaluating the journey that information age companies must make to create future value through investment in customers, suppliers, employees, processes, technology and innovation.”
Performance Management is today one of the main organizational capabilities. It is about the ability to bring together individual contributions, teamwork and departmental activities into a unified organizational system that delivers desired outcomes sustainably. Assessing the organizational performance management capability represents a reality check that assists in developing a roadmap for improvement.
Data discovery capabilities are dominating new purchasing requirements, even for larger deployments, as alternatives to traditional BI tools. But “governed data discovery” — the ability to meet the dual demands of enterprise IT and business users — remains a challenge unmet by any one vendor.
The BI and analytics platform market is in the middle of an accelerated transformation from BI systems used primarily for measurement and reporting to those that also support analysis, prediction, forecasting and optimization. Because of the growing importance of advanced analytics for descriptive, prescriptive and predictive modeling, forecasting, simulation and optimization (see “Extend Your Portfolio of Analytics Capabilities”) in the BI and information management applications and infrastructure that companies are building — often with different buyers driving purchasing and different vendors offering solutions — this year Gartner has also published a Magic Quadrant exclusively on predictive and prescriptive analytics platforms (see Note 1). Vendors offering both sets of capabilities are featured in both Magic Quadrants.