Monthly Archives: novembre 2014

SSIS in the cloud with Azure Data Factory

Wow I’ve Just Seen this fantastic video. shows a new fantastic service on the cloud: Azure Data Factory. This is a service to allow developers to integrate disparate data sources.  It is a platform to manage the data you have both on-prem and in the cloud. It provides access to on-premises data in SQL Server and cloud data […]

My session at SqlSaturdayParma #355

Free tools for Dax developer

DAX Studio: A tool for running DAX queries against Excel PowerPivot models or Analysis Services Tabular models.  DAX Formatter is a free tool that transform your raw DAX formulas into clean, beautiful and readable code.

SQL Server 2012 SP2 Cumulative Update 3 Released!

Was released the update SQL Server 2012 SP2 Cumulative Update 3  Public KB Article

Clear cache tabular

Clear cache tabular <ClearCache xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”> <Object> <DatabaseID>Namer</DatabaseID> </Object> </ClearCache>

Better performance with ADDCOLUMNS instead SUMMARIZE

There is three tables: City,Calendar,Pdp. Pdp is the fact tables with 20.000.000 rows. execute the  script below  and analyze the query plan with profiler evaluate summarize( ‘Pdp’, ‘Calendar'[year], ‘City'[City], “Sales”, SUM(‘Pdp'[Price]) ) the profiler shows that VertiPaq engine get years and cities with a scans the fact table if i take the year and the city […]

WebCast: Analyze data course (BigData + BI)

Speaker:  Marco Pozzan Contents:   _ Business Intelligence e Business Analytics _ Big Data _ Hadoop _Hadoop + Business Intelligence = Analisi di grandi quantità di dati _ Excel, lo strumento di analisi View overview  

Switch to our mobile site