Monthly Archives: ottobre 2014

Powerpivot limit with excel 2013-2010

The 64 bit version have a 4GB limit for file size in Excel 2010 but in Excel 2013 that limitation has been removed. The 32 Bit version can only address 2GB of memory which effectively limits the size of the PowerPivot workbook to about 500-700Mb. For more info here

Speaker at “Be different! Big Data | Open Day @Fondazione ITS Kennedy”

The program of the Open Day : 09:30 – 09:45 Saluto Coordinatrice Fondazione ITS, Adriana Sonego 09:45 – 10:15 Le professioni ICT – Cosa offre l’ITS, Valerio Libralato 10:15 – 11:00 L’ITS visto dalle aziende e dai nostri diplomati che lavorano per loro 1. Servizi CGN – Andrea Sella, Federico Parise e Marco Parenzan 2. ALEA srl […]


You can run powershell’s  commands from managment studio with xp_cmdshell. xp_cmdshell ‘PowerShell.exe -noprofile Get-Service’ If return this error :”xp_cmdshell’ does not exist”  need to enabled the xp_cmdshell with  this syntax: EXEC sp_configure ‘show advanced options’, 1; GO RECONFIGURE; GO EXEC sp_configure ‘xp_cmdshell’,1 GO RECONFIGURE GO

Shared SalesTerritory with dynamic security

We have a table which contains the sales territory Areas of Sale of a company . We want to share the areas between the two agents.  Furthermore, we want the agent that queries the cube tabular can see only the areas of its competence. First we’re going to go into our database and add a […]

Switch to our mobile site