Monthly Archives: March 2009

Free Ebook: Mastering SQL Server 2005 Profiler

Hi all.

Check out this cool offer from Red-Gate.

Free eBook and 14-day trial for faster SQL Server troubleshooting.

You know what it’s like as a DBA. You haven’t got hours to unravel problems.

Ensure you have the knowledge and an intuitive tool to hand today to troubleshoot SQL Server health and activity issues, fast.

Free ‘Mastering SQL Server 2005 Profiler’ by Brad McGehee, DBA expert with over 12 years’ experience


“By mastering Profiler, the exceptional DBA can track down and fix SQL Server performance and other problems quickly and efficiently, and even spot potential problems before they cause real difficulties.”

Free 14-day trial of new Red Gate SQL Response for no-nonsense monitoring of the health and activity of your SQL Servers. Try out SQL Response now to experience a more proactive, focused approach to troubleshooting SQL Server problems.

Book Review: Expert C# 2008 Business Objects

Hi all.

I want to share some thoughts about this book from Apress.

So, the book is very well organized and written. The ideas are very clear and it actually make me think in the way I normally architect projects. Don’t get me wrong, I’m not doing it that bad, is just it has opened my eyes to other possibilities and some better techniques.

With this book, it’s clear that Rockford Lhotka is quite an expert in architecture and design.

Now, please, make sure you read the first book Beginning C# 2008 Objects From Concept to Code so you’ll get a better and more pleasant reading experience.

Overall, I highly recommend this book if you are a software architect and/or work with n-tier projects or enterprise class projects.

Hope it was informative. Se you soon.

Bookmark and Share

The ASP.NET Capsule #2: Login Programmatically With Forms Authentication

Hi all.

In this capsule, I’ll show you how to login a user using Forms Authentication but programmatically. The process is actually simpler than you might think.

If you know the username you can login the user with the following line of code:

   1:  FormsAuthentication.SetAuthCookie(UserName, false);

Now, the first parameter is obviously the username of the user you want to login, the second parameter is less known but very helpful. If you want to implement the famous “Remember Me” checkbox in a login form, the second parameter will help you, it instructs Forms Authentication to create a persistent cookie for the user thus providing the ability to “remember” the user the next time he/she opens the browser.

Set the second parameter to “false” if you want to discard the cookie when the browser closes, or to “true” to keep the cookie and remember the user the next time.

NOTE: although SetAuthCookie will issue an authentication ticket for the user (persistent or not), it will not know if the user is actually a registered and valid user for the website. For that we would need to implement some type of Membership system (like the ASP.NET Membership System) and validate the user prior to issuing a ticket with SetAuthCookie.

Hope it was informative.


The ASP.NET Capsule #1: Setup SQL Server to Support Forms Authentication with the Membership Provider

Hi all.

For the first ASP.NET Capsule, I want to show you how to setup SQL Server to support forms authentication with the Membership Provider in an ASP.NET website.

So for that, the framework provides with the tool aspnet_regsql.exe that you can launch from the command line (for best results, launch the Visual Studio 2008 Command Prompt) and it will show you the following screen:


When you click next, it will ask you what do you want to do. Configure the database or remove the configuration from the database.


After selecting to Configure SQL Server for application services, we click next and it will prompt for the location of SQL Server.


Then we click next and it will show the summary of options selected in the previous screens.


And finally we click next to actually perform the setup. After a few seconds, the following screen will show up.


And that’s it, you have now a SQL Server ready to support Forms Authentication in your websites.

Hope you liked it, and as usual, all comments are welcome.


Launching “The ASP.NET Capsule”

Hi all.

After a while of thinking, I decided to create what I like to call “The ASP.NET Capsule”.

The aim is to publish information about ASP.NET in small articles (capsules) that are important, easy to follow, updated but most important, fun to read.

So, I have some material to start with but I was hopping to get some help from you in getting feedback in what you might be interested in reading. So, fire up… All comments are welcome.

Best regards,

Jose Guay

Remember this? Over 60 Free Controls from DevExpress

I don’t know if you remember this, but if you haven’t take the opportunity to get this controls, there’s still time (or at least the page still works).

DevExpress is happy to offer you over 60 DevExpress controls free of charge – without royalties or distribution costs.

Grab them before the offer expires.