.Net

TRICK: Easily processing lists in parallel

The Task Parallel Library appeared with .NET 4.0 and its mission is to make life easier for programmers when building applications with multiple subprocesses and with threads. The library is very large but it has small gems which we can profit from in an easy and direct way, without having to dive in too deep. […]

Continue Reading

Simulating a slow connection with Fiddler

Normally, we test our web developments on our own computer, where data transfer is almost instant, on test servers located in a local area network, or even on a production server that we access through a high capacity Internet connection. However, our web applications are very different when the client does not have a high […]

Continue Reading

TIP: How to use REPLACE in an NTEXT field of SQL Server

Today, a quick trick… Until SQL Server 2005, the only way to save a database with very long text fields, of arbitrary length, was using a field of the NTEXT type. These fields were useful for these purposes, but they had a lot of limitations that no longer allow the use of certain functions (such […]

Continue Reading
SignalR book

How to manually create proxies of SignalR hubs

When we consume the services supplied by a SignalR hub from a JavaScript client, we typically use the automatically generated proxies, for which we include in our webpage a reference to the script “/SignalR/Js” according to the default route. However, there may be cases where we don’t want this behavior and we prefer to generate […]

Continue Reading

New features of SQL Server 2014

In the last edition of TechEd USA (May 2013), Microsoft announced what the future SQL Server 2014 would be like, and since then more information and preliminary test versions have continued to be released so that we can all be preparing little by little. The final version is here! it has been launched on April 1st and it will […]

Continue Reading

DEVELOPERS’ FAILS #10: Reinventing the wheel… and doing the exact opposite

This month we reach a nice-looking number, 10, with a recommendation that has a lot to do with personal pride, knowing when to delegate and avoiding turning into a control freak. It could be summarized as “Go with the flow but choose the flow wisely!” Developers’ mistake #10: Reinventing the wheel… and doing the exact opposite […]

Continue Reading

How to return the results of a subquery as a single text field

This is a fairly common task, albeit one that is very difficult to achieve with SQL Server. Imagine you have the following scenario: You need to get a list, in a grid, with the basic data for each customer in your database, and after them, in the same row, the date and amount of each […]

Continue Reading

Extended Template for ASP.NET MVC 5 from Visual Studio 2012

Some months ago, the update for Visual Studio 2012 called “ASP.NET and Web Tools 2013.1” was launched. This update makes it possible to use MVC 5 from said version of the development environment. Well, after installing it, those of you who have tried to use ASP.NET MVC 5 from Visual Studio 2012 have probably been […]

Continue Reading

TRICK: Saving a maintenance plan outside SQL Server

As you know, SQL Server has a great utility called “Maintenance Plans” that allows us to create a lot of useful tasks for our databases even if our knowledge is limited: its possibilities range from checking the integrity of the database or updating the statistics to creating backups with lots of options. It also allows […]

Continue Reading
SignalR book

It’s here! SignalR Programming in Microsoft ASP.NET

Finally, the moment I had been waiting for has arrived. After many months of work and preparations, my new book ” SignalR Programming in Microsoft ASP.NET” is now available :-) Hooray! Published in English by Microsoft Press, it has been since its conception a much more ambitious project than my previous foray into the literary […]

Continue Reading