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
SQL Server 2012 has plenty of new features for everyone, from developers to administrators. There are several features for high availability and database administration that will improve DBA operations. We're going to look at four of them:... 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.