Filed under Development

How To: Get data from OLAP cubes

How To: Get data from OLAP cubes

Today I had to read some data from different OLAP cubes and show this information in our application. This could be accomplished using ADOMD.NET client library, which is the multidimensional equivalent to the ADO.NET libraries. This library provides a set of classes (Connections, Commands and Readers) that allows developers to connect, query and get data … Continue reading

How To: Connect via SFTP using SSH.NET

How To: Connect via SFTP using SSH.NET

Overview In these times of APIs-everywhere, it may sound like an anachronism the use SFTP to connect to a remote server and get a list of files for exchanging information, but in the financial world (sadly) it’s more common than you think. In my current project I’ve to connect to a remote server via Secure … Continue reading

Upgrade SQL Server Assemblies .NET version

Upgrade SQL Server Assemblies .NET version

(This is a personal post, just a reminder) Damn! :/ Each time a new version of .NET Framework is installed (or upgraded) in our SQL Server I need to update some assemblies we’re using in some projects. Related posts HowTo: Send Notifications from SQL Server using SignalR HowTo: Redeploy CLR assemblies to SQL Server (Newtonsoft.Json version … Continue reading

DotNet Spain Conference 2016… I was there!

DotNet Spain Conference 2016… I was there!

El pasado miércoles se celebró en Madrid el mayor evento del año en tecnologías de desarrollo Microsoft. Un evento al que han asistido más de 1700 personas de forma presencial y unos cuantos miles más en streaming por Internet. Y sólo puedo decir una cosa: ha sido una experiencia cojonuda a todos los niveles. Me … Continue reading

HowTo: Send Notifications from SQL Server using SignalR

HowTo: Send Notifications from SQL Server using SignalR

Overview In our current project we’ve to push some notifications directly from the database server (SQL Server 2014) to different apps. For example, we’ve scheduled some SSIS (SQL Server Integration Services) projects that pre-calculates large amounts of data. And well, should be nice notify all the apps when new data is available without unnecessary round trips to database. And … Continue reading

DotNet Spain Conference 2015

DotNet Spain Conference 2015

Este fin de semana he tenido la oportunidad de participar en el mayor evento de la comunidad .NET en España hasta la fecha. Se ha realizado en la Universidad de Alcalá, con record de asistentes. Cosa que no me extraña viendo la cantidad de charlas y hands on lab que se han realizado en varios … Continue reading