The answer is 42

Hi dude! Welcome to my blog, all the code and samples you can find here are completely free without restrictions. Most of them are just self notes or nice pieces of code I want to remember. Hope some of them can help you ;)

Recent posts

  • How To: Getting events from SQL Server (9/30/2019) - Overview Sometimes we need to execute some long-running SQL Server processes (Stored procedures or functions) and it’d be nice to get progress messages, and why not, a percent value in order to show a progress bar in our application. In the past I’ve used different techniques to archive this, from SQL Assemblies for calling a… Continue reading →
  • How To: Get data from OLAP cubes (12/12/2017) - 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 (11/29/2017) - 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 (4/19/2017) - (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 →
  • Despedida del programa Microsoft MVP (9/27/2016) - Después de 13 años como Microsoft MVP, este año me despido del programa. Y quiero hacerlo dando las gracias a todos, a la propia Microsoft y -sobre todo- a la gente que he conocido en este periodo: empleados de la propia Microsoft, toda la gente del programa MVP o de las comunidades, etc. Al fin y al cabo,… Continue reading →
  • HowTo: Redeploy CLR assemblies to SQL Server (Newtonsoft.Json version issue) (8/3/2016) -   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 →
  • GAPAND 2016 is over (7/4/2016) - BUENO… Otro año ha pasado, y otra edición más del GAPAND a la saca. No, si al final esto va a convertirse en un clásico y todo… bueno, el tiempo lo dirá. Lo que si os puedo asegurar es que ha sido la mejor edición hasta la fecha, ya que el feedback de la gente (que… Continue reading →
  • Video de mi charla en la #dotNetSpain2016 (3/29/2016) - Hola de nuevo, Lo prometido es deuda, he subido a Channel9 un video sobre mi sesión de ‘async Best practices’ de la pasada #DotNetSpain2016 :) https://channel9.msdn.com/Blogs/channel9spain/Async-best-practices-por-Llus-Franco El vídeo dura una hora y veinte minutos aproximadamente y trata todos los contenidos de la sesión y la última demo con un poco más de profundidad. Espero que os… Continue reading →
  • Materiales++ de mi sesión ‘async best practices’ (3/4/2016) - Hola de nuevo, Durante los últimos días me ha contactado bastante gente haciéndome preguntas sobre mi sesión de la pasada DotNet Spain Conference. Aquí van un par de ellas con sus respuestas, por si son de vuestro interés ;) “Las demos eran un proyecto de consola, pero qué consola era esa? No es el clásico cmd de… Continue reading →
  • DotNet Spain Conference 2016… I was there! (2/26/2016) - 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 (11/4/2015) - 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 (3/3/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 →
  • How to: Remove diacritics (accents) in C# strings (6/25/2014) - 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) (6/23/2014) - 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! (4/16/2014) - 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 →