SQL Server 2014, due out late this year, has an in-memory capability for online transaction processing (OLTP) with table-level granularity and doesn't require expensive hardware like other in-memory databases, according to... News | SearchSQLServer.com
Editor's note: This is the first part of a two-part story by Robert Sheldon. Part two will appear next week.
Virtualization technologies have seen remarkable advancement in recent years. Virtual machines are more powerful... Tip | SearchSQLServer.com
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity... Tip | SearchSQLServer.com
In this edition of SQL in Five, Mark Kromer, national platform architect at Microsoft, says database administrators need to start familiarizing themselves with SQL Server big data technologies.