By the way...

So Microsoft has planned to give a new year present by forcefully pushing IE6 to the next world. They have decided to upgrade everyone's browser to maintain a minimum version. Read more here: IE to Start Automatic Upgrades across Windows XP, Windows Vista, and Windows 7

The SSMS intellisense wasn't working for me when we migrated our database server from 2005 to 2008. Here is what I used and its working for me pretty well. http://www.devart.com/dbforge/sql/sqlcomplete/download.html Install the Express version of it and it does the job!

How often do you see a new programming language launched? Yes, its very rare. Google today has launched a new programming language called DART which seems similar to C/C++ and Java. Following up here: Google Dart - A javascript alternative and http://www.dartlang.org/

Recently, Microsoft Security Essentials (MSSE) installed on my PC detected a "Password Stealer". I opted to delete the "password stealer". Then I tried to open my Chrome browser and BOOM, it crashed saying the file doesn't exist. I figured out that the "password stealer" deleted by MSSE was in fact Google Chrome. I reinstalled Chrome, but that won't run saying a permission error. Here is what I did to solve that: 1. Go to: C:\Documents and Settings\ \Local Settings\Application Data\Google\Chrome\Application 2. Run chrome_new.exe That's it, now run Chrome.exe, and you should be able to use Google Chrome again.

Documentation of Code seem the least "productive" task but it is important. I have always been adding comments in the code but until today, I couldn't find a "great" tool that could do more than just copying my comments and display in an auto-generated documentation. Then, here is what I found, an automated documentation generating tool: 1. Download and install "Doxygen" http://www.stack.nl/~dimitri/doxygen/index.html 2. Install GraphViz (open source majorly funded by AT&T) http://www.graphviz.org/ 3. While generating the documentaion through "Doxygen", mention "Use dot tool from the GraphViz Package" option if you are on the Wizard > Diagrams tab. 4. Create Folder in which you want to have the documentation generated and specify other preferences. 5. You'll have to select "Run" tab and say "Run Doxygen" to generate to documentation. Open "Index.html" to start viewing the docum...

Recently I ran into a problem while dealing with DataSets. I was adding a colum to an XSD through Visual Studio desinger and it kept failing with following error: Cannot add a SimpleContent column to a table containing element columns or nested relations. This is a known issue. However, the solution is not well known :) To be simple and streight forward, I tell you the solution which I tried and it worked, 1. Note down the column names, datatypes and relationships of the table. 2. Delete the table. 3. Add new table and add columns to it. 4. Redefine relationships. Best of luck.

You can use the following query to perform your search. Just replace the "@myValue" with your value. Declare @TN as varchar(200), @CN as varchar(200), @myValue varchar(30), @SQL as nvarchar(1000) , @SN as varchar(200), @Exact_Match bit Create Table #myTable (Table_Name varchar(200), Column_Name varchar(200), Number_Of_Rows int) -- Replace @myValue with the value you're searching for in the database Set @myValue = 'Value to Search' -- 0 for LIKE match, 1 for exact match Set @Exact_Match = 1 Declare myCursor Cursor For Select T.Table_Name, C.Column_Name, T.Table_Schema From INFORMATION_SCHEMA.TABLES T Inner Join INFORMATION_SCHEMA.COLUMNS C On T.Table_Schema = C.Table_Schema And T.Table_Name = C.Table_Name Where T.Table_Name 'dtproperties' And Table_Type = 'Base Table' And C.Data_Type In ('varchar','char','nvarchar','nchar','sql_variant') --And C.Data_Type In ('text','ntext...