Friday, June 29, 2007

Include Column Headers When Copying the Results

In Microsoft SQL Server Management Studio, there is now an option to include column headers with the rows that you copy from the results pane. For example, when I copy the following records from SQL Server Management Studio and pasting into Excel, I now know the names of the columns:

ID First Name Last Name
1 Robert Doe


To enable this feature in Management Studio, click Tools -> Options -> Query Results -> SQL Server -> Results to Grid and check 'Include column headers when copying or saving the results' and click OK. Click on the screenshot below for a screenshot.

Monday, June 4, 2007

Secret Question Authentication Schemes

Ok, this post isn't directly related to coding, but it is related to website design. This morning I visited a credit reporting website (who shall remain nameless) to obtain my credit score. It asked for the basic info, including name, address, SSN, and b-day. Once the website had my info, the next page told me that I already had an account. Great. The website asked for my username and password. I tried a couple of usernames and passwords that I have used in the past, but no luck. Did you forget your password, the website asked? Yes, I guess so. Ok. Take me to the forgotten password page. Now it's asking for my favorite TV show as my only option for my "Secret Question." What? I hardly ever watch TV. I tried a couple of shows that I used to watch. No luck. Sorry, if you can't remember your favorite show that you never watched, I won't let you in, the website blares.

I'd say don't get me going about these subjective authentication schemes, but it's too late.
What I dislike is that the example above was based on an opinion that I had about a TV show from years ago. If a website must use a question-based authentication scheme, a better solution
would be to base the questions on facts, such as the year I graduated from high school, the mascot of my high school, my mother's mother's maiden name, and so on and so forth.

In summary, if you must use secret question authentication schemes, make sure the questions are based on facts, not favorites.

Friday, June 1, 2007

Search Only Microsoft.NET Websites

I find it annoying when I go to Google.com, search for a .NET class or error, and get a page full of websites that have the same copy of a newsgroup post. Well, for you .NET developers, there is a solution: DotNet Developers Search (http://www.searchdotnet.com). Developers Search is a custom Google search that only searches relevant websites and newsgroups.

To make it even easier, you can add DotNet Developers Search to the search bar of Mozilla Firefox and Internet Explorer.

To add Developers Search to the Firefox search bar, 1) click on the dropdown button next to the search icon. 2) Click "Add SearchDotNet".

To add Developers Search to the Internet Explorer 7 search bar, 1) click on the dropdown button next to the magnifying glass. 2) Click "SearchDotNet".