French characters on a qwerty keyboard

Since I am using Qwerty keyboards, it is not that easy to type the accented characters in french or even the euro symbol.

I can still use the Windows Character Map, or remember the ASCII code, but I can now also open up a website such http://www.copypastecharacter.com/, which simply does what it says he does (Copy/Paste characters)

Resharper 5.0 EAP

Resharper 5.0 is on its way...Despite the VS 2010 support, there are some promising new features

• External PDB support
• Project Refactoring
• Better ASP.Net support
• And much more as the JetBrains' Guys demonstrated us over the past years...

Visit their blog for all details

• ReSharper 5.0: Intro
• ReSharper 5.0 Overview

Tools I like and use

It's now a casual thing to publish the tools you used, so here is my list (for a .Net developer):

• Visual Studio 2008/2010 Pro
• Visual Studio Power Commands Add-In
  
• Web Deployment Project 2008/2010
• JetBrains Resharper 5.x

• Sybase PowerDesigner
  
• Enterprise Library Blocks (Data, PolicyInjection)
  
• MyGeneration (Code Generation)
  
• MS Build (+ Commuity Tasks)
  
• NUnit
• Wix
• JetBrains TeamCity

• Redgate Reflector
• Redgate SQL Compare
• TortoiseSVN
• VisualSVN
• SandCastle + Help File Builder

• Firefox (with Firebug)
  
• Chrome
  
• Notepad++
  
• Softerra LDAP Browser
• Paint .Net
  
• TrueCrypt
• FileZilla
• SyncToy 2.0

If you'd like more tools, check out others' list

• Scott Hanselman's 2007 Ultimate Developer and Power Users Tool List for Windows

MS SQL Server Profiling - Missing Indexes

If you are using MS SQL Server, there is a good chance that you have (or will have) to monitor and improve some of your queries.

Since its 2005 edition, SQL Server provides a feature to find the missing indexes, giving you some information about potential indexes that it thinks would improve performances. This information can be really useful to proactively improve the queries that are getting slower when the number of records grow.

However, like almost everything, this is not all back or white...you should consider the proposed information, but not create dozens of indexes on every table if you don't want your server to spend all its time, processing and especially I/O to maintain indexes.

On the same topic, you will find a couple of nice SQL statements below:

• http://sqlserverpedia.com/wiki/Find_Missing_Indexes
• http://sqlserverpedia.com/wiki/Find_Queries_in_the_Plan_Cache_That_Are_Missing_an_Index
  

Ecological font

For those who wants to help saving the Earth, http://www.ecofont.eu

Impersonate a user in SQL2005

It's often useful to run a stored procedure or any script with the permissions of another user (i.e. impersonate a different user than the current one).

It is possible to do so since SQL 2005 is out there, and is as simple as shown below:

EXECUTE AS USER = 'anotheruser'
GO

--Your SQL Statement

REVERT
GO

Note the REVERT command to restore the original user.

In order to impersonate a user, you will grant the IMPERSONATE rights on the user you want to impersonate to the user who will be impersonated it.

GRANT IMPERSONATE ON USER:: [AnotherUser] TO [MyCurrentUser];

Users with sysadmin role can impersonate any user, without being granted the IMPERSONATE right.

For all details, check the online reference @ http://msdn.microsoft.com/en-us/library/ms181362.aspx

Running multiple instances of Firefox

It is always useful to have several browser instances when developing and testing so that you can "impersonate" several different users at the same time.

IE does it for each different window; Firefox always shares the same instance even for different windows.

As per the title of this entry, you already know that Firefox allows you to do it but the "feature" is simply not available as a simple check box.

1. Start Firefox with the Profile Manager

If you installed Firefox in the default installation location, open a command prompt and run "C:\Program Files\Mozilla Firefox\firefox.exe" -no-remote -ProfileManager

2. Create a new profile

You can choose any name but I used "testprofile"

3. You are ready now to run a second instance of Firefox with the testprofile

Again, if you installed Firefox in the default installation location, open a prompt and run "C:\Program Files\Mozilla Firefox\firefox.exe" -no-remote -P testprofile

If you need to run the other instance on a regular basis, you will simply create a shortcut with the command line above.

Need to run more than 2 instances at a time? You will need to repeat the process above and create more test profiles.

For more command line arguments, check the Firefox KB.

Windows Authentication with Firefox

With Firefox, follow the steps below to enable Windows authentication for your servers.

1. Open Firefox 2.x or 3.x

2. Navigate to the url "about:config"

3. Locate the following preference names and set their value with the list of servers separated with comma.

• network.automatic-ntlm-auth.trusted-uris
• network.negotiate-auth.delegation-uris
• network.negotiate-auth.trusted-uris

Your value should look something like this: localhost,myserverA,myserverB

Google's browser...

Google had just made the first BETA version of his (open-source) browser available.

First impression is good! The browser starts really fast with a simple UI as Google knows hwo to make them.

Browsing is also fast, using the same rendering engine as Safari (i.e WebKit)

Oops, I also forgot to give its name: Google Chrome

Read the comics explaining the history of the browser,

Download and install it,

And finally check that your web sites render properly with Safari and Chrome ;-) 

Tips for MyGeneration

I am a big fan of code generation based on templates. It gives all the flexibility you are expecting when coding by hand, but still

• Increase your productivity
• Decrease maintenance efforts
• Code consistency across your project(s)
• etc...

I have been using MyGeneration for a while now and I recently found a good post from Michael Freidgeim summarizing most of the good links you need if you use it.