Have you ever wondered how you can get a date from SQL without the hour/second/minute part ?

How maybe comparing 2 dates without this part ?

Search no more ! Here is a secret I will share with you :

SELECT CAST(FLOOR(CAST(SentDate AS float)) AS datetime) FROM Message

This will return the date as follow :

2005-10-13 00:00:00.000

I hope this will help you !

To open Remote Desktop Connection from the command-line :

1. Windows + R (or Start\Run).

2. Type mstsc.

Et voilà!

Some time ago I encountered a scenario where I needed to find a value that was stored somewhere on a database. I did not know at the time in which table it was stored. I was in need for a way to search in every tables on a specific database,

Fortunately, Vyaskn create a stored procedure that does that. And it does it very well.

Keep this script somewhere near!

Link : http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

This can be of great help for all of you who deploy ASP.NET applications or Web Services. Countless hours have been lost forever. But no more!

ASP.NET Identity Matrix

If you are doing remoting and you get a RemotingException with the message : “Requested Service not found” there is a really good chance there is an error in your configuration file. Mine was because the objectUri attribute was written all in lowercase. Be carefull !!

Another case this error can come up it’s if the lifetime is expired. To remedy to that override the InitializeLifeTimeService method and return null.

19 public override object InitializeLifetimeService()

20 {

21 return null;

22 }

Resources I used :

• http://msdn2.microsoft.com/en-gb/library/2eb9bfae.aspx
• http://codejunkie.wordpress.com/2006/03/05/remoting-exception-requested-service-not-found/

Today I wanted to know if I will at least be able to retrieve all my previous blog’s posts from Wdevs. So, I asked the question in the codeproject’s forum and got my answer. This will not be possible for a while, but my friend Google have a cached version of my old friend.

I will extract all pertinent post and re-post them as soon as possible.

Did you know about a way of automating your UI test on your web application ? Next week, I will take a moment to do a series of posts about a tool called Selenium, so you will be able to bypass the long learning process I got into and avoid the problems I had encountered.

You can visit the Selenium’s web site at this address.

Now, I can’t wait to get my hand dirty with the next version of Visual Studio, Orcas. The javascript enhancements are just … incredible. You get intellisense (one that seem better than the current intellisense of Visual Studio 2005) and this intellisense can access your custom javascript library. You can add reference to a script inside an assembly. And the best part is coming … you can comment your function and they show on the intellisense. After reflection, it seems that all the features that interest me are about intellisense.

I know there is already some editor that can provide the same functionality, but as .NET developer using Visual Studio there is some advantages having it all in one place.

For a demo of all these features, go here.

You can get a list of all features specifications of Orcas, here.

Ok, before you read the rest of this post make sure you have some time left before you. This is not a joke, those games can be quite addicting and you may not be able to work today.

Now to the rest of you, take a look at Tower Desktop Defense. This is an amazing game with a great challenge. The goal is simple, don’t let any creeps going to the other side of the screen. At higher level it is almost impossible. But do not seek help on the Internet and finding an already existing design. This will spoil your experience. Nothing beat the feeling of finding the right design and improve it as you play more.

There is also VectorTD. Personally, I think those guys are my hero. No need for fancy graphics or advanced AI to create an excellent game. Thumbs up !.

Check out their blog here.

I used to blog on Wdevs and for some time now, there is some reliability problems. I don’t want to discriminate WDevs but I hate the fact that I have something to blog about and not being able to do it because the server is down. Well, it is for at least 2 days now. As soon as possible, I will start moving posts here because some of them has helped a lot of people and I really want to give back what I have learned in the past years. Then, why am I here? I have heard some good comments about WordPress and why not? They seems pretty reliable and I really like to be able to control more of the content like the sidebar and being able to add custom pages. There is also a Search feature (!), and multiple “skins”.

And then again, I really hope to be of some help to all of you if it’s possible. Good reading!