Script Data in MS SQL Server 2008

Something I found, it's unbelievable, that existed in MySQL since I know it.

http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx

About SQL Update and Insert: Updating data in a Table in another Database

I was confronted with a common problem when working with several staging environments, how to sync the data in the different databases.
I came up with a quite sleak solution, well at least is what I want to believe:

/****** INSERT NOT EXISTING ROWS  ******/

INSERT INTO dbo.myFirstTable
SELECT KeyColumn1, KeyColumn2, KeyColumn3,Column1
FROM  (

SELECT KeyColumn1, KeyColumn2, KeyColumn3,Column1

FROM mySecondDataBase.dbo.myFirstTable

WHERE (KeyColumn1 = 1) 
AND (KeyColumn2 IN (1, 3, 35, 36, 29, 12, 38))
AND (KeyColumn3 = 'A')
) as myTempSubQuery

WHERE (

SELECT  COUNT(*)
FROM dbo.myFirstTable
WHERE (KeyColumn1 = myTempSubQuery.KeyColumn1) 
AND (KeyColumn2 = myTempSubQuery.KeyColumn2) 
AND (KeyColumn3 = myTempSubQuery.KeyColumn3)

) = 0


/****** UPDATE EXISTING ROWS  ******/

UPDATE dbo.myFirstTable
SET Column1 = myTempSubQuery.Column1
FROM  (
SELECT KeyColumn1, KeyColumn2, KeyColumn3,Column1
FROM  mySecondDataBase.dbo.myFirstTable
WHERE (KeyColumn1 = 1) 
AND (KeyColumn2 IN (1, 3, 35, 36, 29, 12, 38))
AND (KeyColumn3 = 'A')
) as myTempSubQuery, dbo.myFirstTable targetTableInFirstDataBase
WHERE  (targetTableInFirstDataBase.KeyColumn1  = myTempSubQuery.KeyColumn1) 
AND (targetTableInFirstDataBase.KeyColumn2 = myTempSubQuery.KeyColumn2) 
AND (targetTableInFirstDataBase.KeyColumn3 = myTempSubQuery.KeyColumn3)

Some inspiration coming from:

http://www.sqlrecipes.com/sql_questions_answers/insert_update_record_if_already_exists-6/

Code Markup from:

http://lukabloga.blogspot.com/2008/10/to-test-new-highlighting.html

Task Scheduler for .NET

I was looking for this a while ago, seems to be a perfect solution.
Now I'm going to test it more on this in some weeks!

http://quartznet.sourceforge.net/index.html

Fatal Execution Engine Error (79FFEE24) (80131506)

A problem occurs after installing .NET Framework 3.5.

The Solution:

https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=16827&wa=wsignin1.0

Sources:

http://stackoverflow.com/questions/334706/fatal-execution-engine-error-79ffee24-80131506/1342522#1342522

http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.dotnet.framework.clr&tid=f84d09ec-7d84-4d82-817f-6f6e5fa18bdb&cat=&lang=&cr=&sloc=&p=1

http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/21e1b2b2-21d1-40f1-9aa7-bcb3f0ba6b8d

http://social.msdn.microsoft.com/Forums/en-US/vssetup/thread/0376db8f-4761-4ae5-9af2-98c53216318a#VS_IDE_unexpected_problems


http://support.microsoft.com/kb/916900

Nasty Hibernation Problem when 1gb+ present

The solution:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=9d20f96a-a8d6-4627-89f7-787cd9b3852c

Other sources of information:

http://www.codinghorror.com/blog/archives/000555.html

Cambiar el Navegador por Defecto en Windows XP

Go to the following >> start >> control panel >>> add and remove
programs >>> select "set program access and defaults" have the dot on custom
and click on it which should bring a drop down menu , place a dot on
internet explorer , click ok

Como cambiar el Navegador por Defecto en Visual Studio / How to change the default Browser in VS 2005/2008

http://www.cambiaresearch.com/c4/83b1ee3e-e1b9-40ef-9505-7276007635d4/Change-the-Default-Browser-in-Visual-Studio-2005-and-Visual-Web-Developer.aspx