Designing Evolvable Web APIs with ASP.NET

EvolvableDesigning Evolvable Web APIs with ASP.NET
Harnessing the power of the web
By Glenn Block, Pablo Cibraro, Pedro Felix, Howard Dierking, Darrel Miller

A simple review:

I am a very lucky person because I had the opportunity to read this fantastic book before to roll out. Seriously, anyone who wants to learn how to write a really consistent webapi using the last Microsoft technologies, needs to read this first.

The first part is amazing. If you don’t know a lot about the http protocol, you will love this part. It is easy to understand but not simple. It covers almost everything you will need to write an API … knowing what you are doing.

The second part was an epiphany for me. It covers some topics I always wanted to know in deep, like Basic authentication, how, why and why not, Oauth, how why, where…

As I said, almost everything you need to write consistent WebAPI applications is in this book. Maybe I miss more deep and extensive samples, but I understand this can be another book…

Definitely, i recommend this book.


Send emails from SQL Server

To use this feature from SQL Server, you can use the stored procedure sp_send_dbmail following the next steps:

Configure the Database Mail

Open, within the SQL Server Management Studio, the Database Mail item.

Do it with double click on it or with right click and selecting Configure Database Mail.


It will start the wizard to configure the Database Mail.

Skip the first screen, and click on Next on the second screen to set up the service.


Click Yes to enable the feature:


Write a name and a description for the new profile and click on Add to add a new SMTP account:


Fill all the needed fields and click Ok:


Click on Next to go to the next screen.

Check the checkbox on the column Public to make the profile public:


Click on Next to go to the next screen.

If you need it, change values like Retry Attempts, etc, on this screen, if not, simply click on Next to go to the next screen.


Click on Finish and wait to end the feature activation and click on Close.

Now open a New Query window. We are going to set the Profile as default with this script:

EXECUTE msdb.dbo.sysmail_update_principalprofile_sp
 @profile_name = 'Test Profile',
 @principal_name = 'public',
 @is_default = 1 ;

Now we can write a, for instance, a trigger which sends an email in certain circumstancies. Let’s say we have a table called Names and we want to know when a record is updated. We can write a trigger like this one:

 EXEC msdb.dbo.sp_send_dbmail
 @subject=N'Testing email from db',
 @body=N'Names record updated.' ;


That’s it. I hope it will help you.

More documentation about this Stored Procedure on:

Visit my profile on Google Plus