Blocking and Locking will be a thing of the past
In-memory OLTP Processing:
SQL Server 2014 (former codename Hekaton) has built-in, in-memory capability for OLTP Transactions with not so expesnive hardware requirements. The release date of SQL Server 2014 was annonuced at its TechEd conference in New Orleans this week.
The ink is still fresh on my new book, Learning SQL Server Reporting Services 2012 and Microsoft has announced another version already. Well, Microsoft is known for its relentless offerings. Transactions can be disk/memory based which does not require expensive boxes and with this feature Microsoft tries to distinguish itself from the likes of SAP Hana (Oracle Database with its Exadata and Exalytics). The performance is very fast but only 50 times faster but not Hekaton faster (Hekaton means 100!!!).
In-memory Buisness Intelligence:
This is already a reality. Look at the terrific features of Power View. You can go two ways with Power View: Power Pivot via EXCEL or Tabular Model with SSAS.
Get a jump start from scratch on your acquaintance with Power Views with my forhtcoming book,
Learning SQL Server Reporting Services 2012
http://hodentek.blogspot.com/2013/05/some-details-of-my-book-on-sql-server.html
Read more on SQL Server 2014 here->
http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/03/sql-server-2014-unlocking-real-time-insights.aspx
http://searchsqlserver.techtarget.com/news/2240185188/SQL-Server-2014-due-out-in-late-2013-in-memory-OLTP-a-big-feature
http://www.techweb.com/news/240062566/microsoft-in-memory-move-challenges-sap- tiwht wyaoracle.html.
In-memory OLTP Processing:
SQL Server 2014 (former codename Hekaton) has built-in, in-memory capability for OLTP Transactions with not so expesnive hardware requirements. The release date of SQL Server 2014 was annonuced at its TechEd conference in New Orleans this week.
The ink is still fresh on my new book, Learning SQL Server Reporting Services 2012 and Microsoft has announced another version already. Well, Microsoft is known for its relentless offerings. Transactions can be disk/memory based which does not require expensive boxes and with this feature Microsoft tries to distinguish itself from the likes of SAP Hana (Oracle Database with its Exadata and Exalytics). The performance is very fast but only 50 times faster but not Hekaton faster (Hekaton means 100!!!).
In-memory Buisness Intelligence:
This is already a reality. Look at the terrific features of Power View. You can go two ways with Power View: Power Pivot via EXCEL or Tabular Model with SSAS.
Get a jump start from scratch on your acquaintance with Power Views with my forhtcoming book,
Learning SQL Server Reporting Services 2012
Read more on SQL Server 2014 here->
http://blogs.technet.com/b/dataplatforminsider/archive/2013/06/03/sql-server-2014-unlocking-real-time-insights.aspx
http://searchsqlserver.techtarget.com/news/2240185188/SQL-Server-2014-due-out-in-late-2013-in-memory-OLTP-a-big-feature
http://www.techweb.com/news/240062566/microsoft-in-memory-move-challenges-sap- tiwht wyaoracle.html.
No comments:
Post a Comment