Category: SQL Server Database

xVelocity

Microsoft is re-branding its Vertipaq in-memory engine that is currently used in PowerPivot and naming it xVelocity.  That’s hardly worth a blog entry per se.. Howerver, and this is big, xVelocity now is added to both Analysis Services AND Database engines… Supposedly, this technology incrases preformance of the existing relational queries by 10-100… I will

Continue reading

Microsoft SQL Server 2012 Virtual Labs

Microsoft has posted 16 virtual labs online. The labs cover three major areas: Business Intelligence Mission Critical Operations Database Management Those of us who are trying to jump start Self Service BI in our organizations should checkout the following three: Creating a PowerPivot Model and Report in the Excel Client Defining DAX Calculations with Microsoft

Continue reading