How can I change the color of the DOS screen?

I am bored of the black color, how can I change it?

It's rather easy. You can configure the DOS window and change some of the things around. Color for one is easy to change.

Open a DOS Window from Start | Run

Right click the top of  DOS window inside the title bar. From the drop-down click on Defaults. This opens the following window.

Now click on the Colors tab in the above window. I have changed both the Screen Background as well as the Screen Text. You can immediately see the changes you are making.

The next time you open the DOS window you will see the changes provided you clicked OK to the above screen after the changes.

What is Upsert?

Upsert provides the following SQL functionality:

If something does not exist in a table then insert it. If it exists then update it.

This is something like what happens when you move a file to a folder, if the file exists it will ask you whether you want to replace it with a new version or not. If the file does not exist it is inserted, no questions asked.

This is implemented by MERGE in SQL Server 2008

What is JSON?

 JSON stands for Javascript Object Notation. It is a special object notational construct and is a subset of JavaScript. It can be used wherever JavaScript can be used and you do not need to download anything. There is no need to worry about the version of JavaScript, It works with all JavaScript versions.



RFC 4627 describes all aspects of JSON. JSON was designed to be brief (small), textual, and portable. The MIME Media Type is now registered as application/json. JSON can handle exchanging data in applications written in different programming languages such as C, C#, ColdFusion, Perl, Python, Ruby, and so forth.



On getting JSON data from SQL Server read this interesting artilce by William Brewer.

How do I display the currency rates of four countries on my site?

First of all you need to get hold of a web service that provides this information daily.

Then you need to write a client application to access the service.
You can do write the client application in Java, .NET, VB etc.

How can I turn folder pictures into a slide show?

I have many folders with pictures and only in some of them I can show pictures in a slide show( in Windows XP), how can I turn folder pictures into a slide show?




There is a default behavior that you can turn on for all folders. However for a single folder, the best way is to access the folder properties by right clicking the folder.
This opens the Properties window as shown. In here the folder name is SQLDeveloper. Presently I cannot bring up the slide show.

Click on the Customize tab of this window. Then click on the drop-down handle as shown and choose Picture Album.

Now when you open the folder you have Picture Tasks navigation on the left where you find the "View as a slide show".
















Now you are ready to show off.

How do I copy the text from a DOS screen?

You need to highlight the text in DOS screen, copy the text and paste it
into Notepad or Word.
Let us say you want to copy the text on this screen.

Step 1: Highlight the text as follows:
Right click anywhere on the title (blue strip at the top) and from the drop-down
menu choose Edit | Mark.

Step 2: Highlight the text now.
Mark the text by sweeping your mouse (held down) over the text you want to
mark as shown.












Step3: Go back to the title, right click and choose Edit| Copy. This copies the text
and now open Notepad from Start | Accessories |Notepad. With the Notepad open click on
Edit | Paste. The copied text is now pasted to the open Notepad as shown.

What are Smart Tasks?

This is yet another design aid from Microsfot to make life easier for the
developer and to increase his/her productivity. There are property windows and Property pages for customizing the controls at design time. Smart Tasks makes it even easier by listing the tasks a designer has to configure for a given control  on a web page or a windows form.

Here is an example. This is a SQLDataSource control on a web page.

To see what tasks need to be completed for this control, click on the right  pointing arrow. This changes the control as shown in this figure. There is just one task- Configure Data Source...

When you click on Configure Data Source link the wizard wakes up and will take you through the process of the configuration.