CSS Tips & Tricks

• Pure CSS Speech Bubbles
• Fun with Unicode
• 22 Advanced CSS Text Effects And Web Typography Tips
• Bread Crumbs

Solution: SQL 2000 to SQL 2005 upgrade error -1

I was trying to perform an upgrade at a Microsoft site from SQL 2000 to SQL 2005. I had a pop up window during the upgrade analysis process of SQL 2005 that was blank.
The message I was getting in the WI install log located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup000#_computername_WI.log was Error Code: 0x80077370 (29552)

The Problem is in Upgrade advisor. In my case it was failing because .Net 3.5 SP1 was installed.
The following workaround amazed me and worked perfectly:

"Once SQL installation starts create a subdirectory BPAClientunder C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA directory. And copy BPAClient.dll (from the sibling bin directory) into this directory."
(http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.setup/2008-10/msg00265.html)
The BPAClient.dll file can be found at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin.

Charles Web Proxy

Charles is an HTTP proxy / HTTP monitor / Reverse Proxy that enables a developer to view all of the HTTP and SSL / HTTPS traffic between their machine and the Internet. This includes requests, responses and the HTTP headers (which contain the cookies and caching information).

http://www.charlesproxy.com/

Solution: Display issues with Internet Explorer 8

Problem: Internet Explorer 8 displays web pages weird, strange or incorrectly.

Solution1: Change security setting to the default level
     Tools -> Internet Options -> Security -> Internet -> Default level

Solution2: Make sure browser compatibility mode is turned off
     Tools -> Developer Tools -> Browser Mode

Code Syntax Highlighter written in JavaScript

Display code on a web page:

http://alexgorbatchev.com/wiki/SyntaxHighlighter

Process Explorer

Process Explorer is a great tool by Micrsoft for tracking down processes that are taking up too much cpu or memory.

Flex Error "Flash player not found"

http://curtismorley.com/2007/10/09/flex-error-flash-player-not-found-3/

Web Site Testing Tools

http://www.testing-web-sites.co.uk/testing-tools/

Expected identifier, string or number error message in IE

Error: "Expected identifier, string or number" error message in IE but works in firefox and safari.  

Solution: This error can be fixed by removing the extra comma at the end of the key value pairs of an anonymous function.

Solution: Access Forbidden Error IIS

Error: HTTP 403.9 - Access Forbidden: Too many users are connected
Internet Information Services

Solution:  Uncheck the "HTTP Keep-Alives Enabled check box under IIS -> Web Site -> Properties.