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
Filed under English …
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
(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
HowTo: Redeploy CLR assemblies to SQL Server (Newtonsoft.Json version issue)
The Story Hi again, Some time ago I published a post about how to send notifications from SQL Server using SignalR. We are using SignalR self-hosted in a Windows Service in a separated server, and it had been running fine until now. This week I had to set up a new SQL server which will replace the … Continue reading
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
How to: Remove diacritics (accents) in C# strings
Quick note: How to remove diacritics (accents) from a C# string? Use this extension method ;)
How to: Server Side Filter database (Entity Framework + DevExpress Filter control)
Imagine you have a table with millions of rows. It’s not a good idea showing all these data in a grid or similar, and it doesn’t matter you’re developing a web or desktop application… It’s not a good idea at all. In these cases we should use conditional filters applied in the data source (usually … Continue reading
Extract extra large Icon from a file, including network paths!
Edit (04/16/2014): Added a new function called GetBitmapFromFolderPath, which returns the associated icon from the path to a Folder (or drive!). Sometimes we are required to show a list of files with their associated icons. This task sounds quite easy, and in fact it is… Except if you have to deal with files in network paths or you … Continue reading
Global Windows Azure Bootcamp
On April 27, something very cool is happening. A bunch of Windows Azure MVP’s and community activists are organizing a Global Windows Azure Bootcamp. This is a completely free, one-day training event for Windows Azure, all organized by the community, and presented in person all over the World. I’m not sure if this is the … Continue reading
MVP Site interview (full version)
Yesterday there was published my brief interview in the MVP site. http://mvp.microsoft.com/en-US/Pages/default.aspx (english) However, it is not the full version, that I publish here. Hope you enjoy it ;) Lluís Franco Interview Born in Barcelona (Spain) with more than 20 years of experience in the software development sector, Lluis Franco holds a number of Microsoft … Continue reading