Filed under .NET Framework

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

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

Today’s review – Advanced Installer

Today’s review – Advanced Installer

Hi again guys! :) Today I’d like to tell you why I decided to change my software deployment method. I’ve spent a lot of time in the last days looking for an alternative way to deploy client applications. During this period I’ve tested different options (including the options provided by Microsoft Visual Studio) and finally … Continue reading

Using ASP.NET Membership in SQL Azure

Using ASP.NET Membership in SQL Azure

The scenario: Sometimes we forget SQL Azure is not SQL Server. This morning in the project I’m working, we needed to create a small ASP.NET membership database in SQL Azure. It seems easy! Would you expect troubles with this? Nope? Ok, me neither… until I tried to execute aspnet_regsql to create the database: An error … Continue reading

Observer Design Pattern with .NET

Observer Design Pattern with .NET

.NET Framework 4.0 offers a set of new features focused on Observable/Observer design pattern. Actually, such pattern is a subset of Publish/Subscribe design pattern. Such kind of patterns aim to provide a mechanism for push-based notifications. My friend and colleague José Miguel Torres has written the best post I’ve never read about it: Take a … Continue reading

How to: Grouping groups

Today I would like to show a tip for grouping active directory groups using LINQ to objects. Suppose this scenario: You wanna retrieve all the roles a user belongs, grouping them by their domain name, as shows: Groups under: – Group name: All – Group name: LOCAL Groups under: BUILTIN – Group name: Users – … Continue reading

How to: Check if current user is member of ‘domain admins’

How to: Check if current user is member of ‘domain admins’

The scenario Sometimes in business applications it’s interesting checking if current user is member of the ‘domain administrators’ role. For example I am used to checking if current user has administrative privileges in order to showing some advanced configuration options (changing the application’s connection string, or allow creating new users). IsInRole To acomplish this we … Continue reading