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

Decoupling ASP.NET MVC controllers, step by step

I wanted to write this post because it is a scenario that I usually encounter in development companies: they understand the benefits of reducing the coupling between components, but they deem it too complex to implement in their day to day work because they don’t know what tools there are to do it and how […]

Continue Reading