Microsoft Outlook - Friendly Keyboard Short cuts

Here are a list of shortcuts to help you move faster in Microsoft Outlook:
Alt + . (period) Open the Address Book with the To field selected

Alt + A Open the Action drop-down menu

Alt + B Open the Address Book with the BCC field selected

Alt + C Select message recipients for CC field

Alt + D Switch to Daily calendar view

Alt + E Open the Edit drop-down menu
Alt + F Open the File drop-down menu

Alt + G Open the Go drop-down menu

Alt + H Open the Help drop-down menu

Alt + I Open the Find tool bar / Open the Insert drop-down menu

Alt + J Move to the Subject field

Alt + K Check names in the To, CC, or BCC field against the Address Book
(cursor must be in the corresponding message header field)

Alt + L Reply All

Alt + M Switch to Monthly calendar view

Alt + N Open the Accounts drop-down menu

Alt + O Open the Format drop-down menu / Switch to Today calendar view

Alt + P Open the Message Options dialog box

Alt + R Reply / Switch to Work Week Calendar view

Alt + S Send

Alt + T Open the Tools drop-down menu
Alt + V Open the View drop-down menu

Alt + W Forward an item / Switch to Weekly calendar view

Alt + Y Switch to Daily calendar view

Ctrl + 1 Go to Mail

Ctrl + 2 Go to Calendar

Ctrl + 3 Go to Contacts

Ctrl + 4 Go to Tasks

Ctrl + 5 Go to Notes

Ctrl + 6 Go to Folder List

Ctrl + 7 Go to Shortcuts

Ctrl + 8 Go to Journal

Ctrl + A Select all

Ctrl + B Bold when editing a rich text message

Ctrl + C Copy

Ctrl + D Delete an item (message, task, contact, etc.)

Ctrl + E Activate the Find drop-down menu / Center Align when editing a rich
text message

Ctrl + F Forward

Ctrl + J Open a new Journal Entry from the selected item (message, task,
contact, etc.)

Ctrl + K Check names in the To, CC, or BCC field against the Address Book
(cursor must be in the corresponding message header field)

Ctrl + M Send/Receive all

Ctrl + O Open

Ctrl + P Print

Ctrl + Q Mark the selected message Read

Ctrl + R Reply

Ctrl + S Save a draft message

Ctrl + T Tab

Ctrl + U Mark the selected message Unread

Ctrl + V Paste

Ctrl + X Cut

Ctrl + Y Go to Folder

Ctrl + Z Undo

Ctrl + Backspace Delete the previous word

Ctrl + End Move to the end

Ctrl + Home Move to the beginning

Ctrl + Shift + A Open a new Appointment

Ctrl + Shift + B Open the Address Book

Ctrl + Shift + C Create a new Contact

Ctrl + Shift + E Open a new folder

Ctrl + Shift + F Open the Advanced Find window

Ctrl + Shift + G Flag message for follow up

Ctrl + Shift + J Open a new Journal Entry

Ctrl + Shift + K Open a new Task

Ctrl + Shift + L Open a new Distribution List

Ctrl + Shift + M Open a new Message

Ctrl + Shift + N Open a new Note

Ctrl + Shift + O Switch to the Outbox

Ctrl + Shift + P Open the New Search Folder window

Ctrl + Shift + Q Open a new Meeting Request

Ctrl + Shift + R Reply All

Ctrl + Shift + S Open a new Discussion

Ctrl + Shift + U Open a new Task Request

Ctrl + Shift + Y Copy a Folder

Shift + Tab Select the previous message header button or field

F1 Open Outlook Help

F3 Activate the Find toolbar

F4 Open the Find window

F7 Spellcheck

F9 Send and receive all

F10 Select File from the Outlook toolbar button

F11 Activate the "Find a contact" dialog box

F12 Save As

Alt + F4 Close the active window

A Friend.... A to Z about a friend

A Friend....
Accepts you as you are
Believes in "you"
Calls you just to say "HI"
Doesn't give up on you
Envisions the whole of you even the unfinished parts
Forgives your mistakes
Gives unconditionally
Helps you
Invites you over
Just "be" with you
Keeps you close at heart
Loves you for who you are
Makes a difference in your life
Never Judges
Offers support
Picks you up
Quiets your fears
Raises your spirits
Says nice things about you
Tells you the truth when you need to hear it
Understands you
Values you
Walks beside you
X-plains things you don't understand
Yells when you won't listen and
Zaps you back to reality

Windows Se7en - Free Guide

Do you want to get Free guide for Windows 7?

Please follow the links below.

What’s New in Windows 7?
DirectAccess
BranchCache and other networking technologies,
VHD boot and other deployment technologies,
AppLocker,
Biometrics,
security technologies

http://download.microsoft.com/download/1/0/1/1017E8C2-3117-4C82-9E6D-3B7C8E3AE256/Windows7_WhatsNew.doc

http://download.microsoft.com/download/1/0/1/1017E8C2-3117-4C82-9E6D-3B7C8E3AE256/Windows7_Manageability.doc

Hidden Treasure in VLC Media Player


While playing media in VLC Player, just try to press Ctrl + Up Arrow in your keyboard. You can get maximum...maximum..maximum... sound.

Keep Playing Media..

Windows 7 Taskbar with Jump lists




Windows Se7en has a new Jump List facility to find and connect all the last instances of applications in Taskbar.

Google Voice - Forwarding phones

Google Voice - Conference calling

Google Sites Tour




Google Sites, a new offering from Google Apps, makes creating a team site as easy as editing a document. Use Google Sites to centralize all types of information -- from videos to presentations -- and share your site with just a few people, your entire organization, or the world.

Today is a beautiful day

A blind boy sat on the steps of a building with a hat by his feet. He held up a sign which said: "I am blind, please help." There were only a few coins in the hat.

A man was walking by. He took a few coins from his pocket and dropped them into the hat. He then took the sign, turned it around, and wrote some words. He put the sign back so that everyone who walked by would see the new words.

Soon the hat began to fill up. A lot more people were giving money to the blind boy. That afternoon the man who had changed the sign came to see how things were. The boy recognized his footsteps and asked, "Were you the one who changed my sign this morning? What did you write?"

The man said, "I only wrote the truth. I said what you said but in a different way."

What he had written was: "Today is a beautiful day and I cannot see it."

Do you think the first sign and the second sign were saying the same thing? Of course both signs told people the boy was blind.

But the first sign simply told people to help by putting some money in the hat.

The second sign told people that they were able to enjoy the beauty of the day, but the boy could not enjoy it because he was blind.

The first sign simply said the boy was blind. The second sign told people they were so lucky that they were not blind. Should we be surprised that the second sign was more effective?


Moral of the Story:

1. Be thankful for what you have.

2. Be creative. Be innovative.Think differently and positively.

3. Invite the people towards good with wisdom.

What's the Best HDTV to Buy?

Windows 7 Beta Thoughts - Better than Vista or XP?

How to Get Free Microsoft Software

Life is a do-it-yourself project.

An elderly carpenter was ready to retire. He told his employer-contractor of his plans to leave the house-building business to live a more leisurely life with his wife and enjoy his extended family. He would miss the paycheck each week, but he wanted to retire. They could get by.

The contractor was sorry to see his good worker go & asked if he could build just one more house as a personal favor. The carpenter said yes, but over time it was easy to see that his heart was not in his work. He resorted to shoddy workmanship and used inferior materials. It was an unfortunate way to end a dedicated career.

When the carpenter finished his work, his employer came to inspect the house. Then he handed the front-door key to the carpenter and said, "This is your house... my gift to you."

The carpenter was shocked!

What a shame! If he had only known he was building his own house, he would have done it all so differently.

So it is with us. We build our lives, a day at a time, often putting less than our best into the building. Then, with a shock, we realize we have to live in the house we have built. If we could do it over, we would do it much differently.

But, you cannot go back. You are the carpenter, and every day you hammer a nail, place a board, or erect a wall. Someone once said, "Life is a do-it-yourself project." Your attitude, and the choices you make today, help build the "house" you will live in tomorrow. Therefore, Build wisely!

Funny Game from BBC

How fast are your reactions?

Click the tranquilizer button whenever you see a sheep leaving the flock and running the freedom.

There are five sheep to stop. But be warned, there's a 3 second penalty if you shoot a dart when no sheep are running.

Click here to Play

A Kid's Intelligence

A young boy enters a barber shop and the barber whispers to his Customer,

"This is the dumbest kid in the world. Watch while I prove it to you."

The barber puts a five rupee coin in one hand and two one rupee coins(1+1=2) in the other, then calls the boy over and asks,

"Which do you want, son?"

The boy takes the two one rupee coins and leaves.

"What did I tell you?" said the barber.

"That kid never learns!"

Later, when the customer leaves, he sees the same young boy coming out of the ice cream store.

"Hey, son! May I ask you a question?

Why did you take two one rupee coins instead of five rupee coin?"

The boy licked his cone and replied,

"Because THE DAY I TAKE THE FIVE RUPEE COIN, THE GAME IS OVER

|
|
|
|
|
|
|
|
|
|
|
|
|
|


Moral:


When you think the other person is dumb, you are making a fool of yourself.

Never Gift To Impress But The Need

Four brothers left home for college, and they became successful doctors and lawyers and prospered. Some years later, they chatted after having dinner together. They discussed the gifts they were able to give their elderly mother who lived far away in another city.

The first said, "I had a big house built for Mama."
The second said, "I had a hundred thousand dollar theater built in the house."
The third said "I had my Mercedes dealer deliver an SL600 to her."

The fourth said, "You know how Mama loved reading the Bible and you know she can't read anymore because she can't see very well. I met this preacher who told me about a parrot that can recite the entire Bible. It took twenty preachers 12 years to teach him. I had to pledge to contribute $100,000 a year for twenty years to the church, but it was worth it. Mama just has to name the chapter and verse and the parrot will recite it."

The other brothers were impressed. After the holidays Mom sent out her thank you notes. "She wrote: "Milton, the house you built is so huge. I live in only one room, but I have to clean the whole house. Thanks anyway."

"Marvin, I am too old to travel. I stay home, I have my groceries delivered, so I never use the Mercedes. The thought was good. Thanks."

"Michael, you gave me an expensive theater with Dolby sound, it could hold 50 people, but all my friends are dead, I've lost my hearing and I'm nearly blind. I'll never use it. Thank you for the gesture just the same."

"Dearest Melvin, you were the only son to have the good sense to give little thought to your gift. The chicken was delicious. Thank you."

Three different Thougts

Thought 1

The average man's life consists of
Twenty years of having his mother ask him where he is going,
Forty years of having his wife ask the same question;
And at the end, the mourners wondering too.

Thought 2
A Man was walking down a street when he heard a voice from behind, 'If you take one more step, a brick will fall down on your head and kill you.' The man stopped and a big brick fell right in front of him. The man was astonished.

He went on, and after a while he was going to cross the road. Once again the voice shouted, 'Stop! Stand still! If you take one more step a car will run over you, and you will die.' The man did as he was instructed, just as a car came careening around the corner, barely missing him.

The man asked. 'Who are you?' 'I am your guardian angel,' the voice answered. 'Oh, yeah?' the man asked 'And where the hell were you when I got married?'

Thought 3
Everyone in the wedding ceremony was watching the radiant bride as her father escorted her down the aisle to give away to the groom. They reached the altar and the waiting groom; the bride kissed her father and placed something in his hand. Everyone in the room was wondering what was given to the father by the bride.

The father could feel the suspense in the air and all eyes were on him to divulge the secret and say something. So he announced 'Ladies and Gentlemen today is the luckiest day of my life..' Then he raised his hands with what his daughter gave him and continued, 'My daughter finally, finally returned my credit card to me.'

The whole audience including priest started laughing..........But not the poor groom!!!!

Neither Legal Nor Logical - Real Fun

A Student secures lower grade in the externals and after looking at the mark sheet he asks his Professor.

Student: "Can you answer any question? “
Professor: "Surely I must. Otherwise I would not be a professor!"

Student: "Great, well then I would like to ask you a question. If you can give me the correct answer, I will accept my mark as it is. If you however do not know the answer, I want you give me an "A" for the exam. "

Professor: "Okay, it's a deal. So what is the question?"

Student: "What is legal, but not logical, logical, but not legal, and neither logical, nor legal?"

Even after some long and hard consideration, the professor cannot give the student an answer, and therefore changes his Student’s exam mark into an "A", as agreed.

Afterwards, the Professor calls on the Student and asks him the same question.

He immediately answers:

"Sir, you are 60 years old and married to a 30 year old woman, which is legal, but not logical.

Your wife has a 25-year-old lover, which is logical, but not legal.

The fact that you have given your wife's lover an "A", although he really should have failed, is neither legal, nor logical.

Microsoft's Future Vision on Health Care

Windows Home Concept: Microsoft's Home of the Future

Opera - Short Cut Keys

Find text [Ctrl] + [F]

Find next instance of text [F3]

Find previous instance of text [Shift] + [F3]

Display context (right-click) menu [Ctrl] + [M]


Close all pages and exit Opera [Ctrl] + [Q]

Enter a Web address [F2]

Paste and go [Ctrl] + [D]

Enter nickname for fast bookmark access [Shift] + [F2]

Go to parent directory [Ctrl] + [Backspace]

Go to next page in history (or Fast Forward) [X]


File a page as new bookmark [Ctrl] + [T]

Save selected link as new bookmark [Ctrl] + [Shift] + [T]

Manage bookmarks [Ctrl] + [Alt] + [B]

Show transfers [Ctrl] + [Alt] + [T]

Set your preferences [Alt] + [P]

Set focus to address field [F8]

Set focus to search field [Shift] + [F8]

Check e-mail [Ctrl] + [K]

Write new e-mail [Ctrl] + [E]

Go to next unread e-mail [Shift] + [J]

Go to previous unread e-mail [Shift] + [U]

Reply to all recipients of e-mail [Shift] + [R]

Do you want to download free games?


All of us playing games in computers. We like to play it always.

Where can we download free games on internet?

Here are 5 websites providing free download service.

  1. GameTop.Com
  2. FreeGamePick.Com
  3. FunPcGame.Com
  4. Share-Games.Com
  5. GrandMatrix.Com

How to recover corrupted images from digital camera?


Many of our friends are having digital cameras for their entertaining purpose.

They are shooting good photos using it. All photos are stored in a memory chip of a camera.

We can't easily recover the photos,videos from the memory card when it is having problems. If we want to do recover, what should we do?

Just we can download Artplus software and using it to recover accidentally formatted memory devices, corrupted files.

Enjoy Shooting...

http://www.artplus.hr/adapps/eng/dpr.htm

Enjoy Playing...

How to speed up our internet connection?


Top internet accelerator (according to PC Magazine), a network settings optimizer to speed up your existing Dial-Up Modem, DSL, Cable, Wireless, LAN, High-speed internet connections.

SpeedConnect Internet Accelerator is a powerful Windows application designed to optimize your network connection and speed up all your internet activities. This translates into a faster internet connection, faster browsing and email, faster downloads, faster online gaming, improved Skype connection.

Easy, safe and fast optimization of your existing internet connection.

Run Commands for Windows Vista

>>> Color Management — colorcpl
>>> Computer Management Launcher — CompMgmtLauncher
>>> Control Panel — control
>>> Credential Backup and Restore Wizard — credwiz
>>> Defragment User Interface — dfrgui
>>> Driver Package Installer — dpinst
>>> Display Adapter Troubleshooter — AdapterTroubleshooter
>>> Encryption File System — rekeywiz
>>> Event Viewer — eventvwr
>>> Firewall Settings — FirewallSettings
>>> Firewall Control Panel — FirewallControlPanel
>>> Help Pane — helppane
>>> iSCSI Initiator — iscsicpl
>>> Iexpress — iexpress
>>> Logoff from Vista — logoff
>>> Language Pack Installer — lpksetup
>>> Microsoft Sync Center — mobsync
>>> Microsoft Support Diagnostic Tool — msdt
>>> Optional Features Manager — optionalfeatures
>>> Performance Monitor — perfmon
>>> Presentation Settings — presentationsettings
>>> Printer Migration — PrintBrmUi
>>> Snipping Tool — snippingtool
>>> Software Licensing/Windows Activation — slui
>>> Sound Volume — sndvol
>>> Sound Recorder — soundrecorder
>>> Sticky Note — StikyNot
>>> System Properties — SystemPropertiesAdvanced
>>> User Accounts — Netplwiz
>>> Windows Fax and Scan — wfs
>>> Windows Mobility Center — mblctr
>>> Windows Backup Utility — sdclt

Run Commands for Windows XP

We can simply run these commands using Start ==> Run ==> Command.

1. Accessibility Controls - access.cpl
2. Accessibility Wizard - accwiz
3. Add Hardware Wizard - hdwwiz.cpl
4. Add/Remove Programs - appwiz.cpl
5. Administrative Tools - control admintools
6. Automatic Updates - wuaucpl.cpl
7. Bluetooth Transfer Wizard - fsquirt
8. Calculator - calc
9. Certificate Manager - certmgr.msc
10. Character Map - charmap
11. Check Disk Utility - chkdsk
12. Clipboard Viewer - clipbrd
13. Command Prompt - cmd
14. Component Services - dcomcnfg
15. Computer Management - compmgmt.msc
16. Control Panel - control
17. Date and Time Properties - timedate.cpl
18. DDE Shares - ddeshare
19. Device Manager - devmgmt.msc
20. Direct X Troubleshooter - dxdiag
21. Disk Cleanup Utility - cleanmgr
22. Disk Defragment - dfrg.msc
23. Disk Management - diskmgmt.msc
24. Disk Partition Manager - diskpart
25. Display Properties - control desktop
26. Display Properties - desk.cpl
27. Dr. Watson System Troubleshooting Utility - drwtsn32
28. Driver Verifier Utility - verifier
29. Event Viewer - eventvwr.msc
30. Files and Settings Transfer Tool - migwiz
31. File Signature Verification Tool - sigverif
32. Findfast - findfast.cpl
33. Firefox - firefox
34. Folders Properties - control folders
35. Fonts - control fonts
36. Fonts Folder - fonts
37. Free Cell Card Game - freecell
38. Game Controllers - joy.cpl
39. Group Policy Editor (for xp professional) - gpedit.msc
40. Hearts Card Game - mshearts
41. Help and Support - helpctr
42. HyperTerminal - hypertrm
43. Iexpress Wizard - iexpress
44. Indexing Service - ciadv.msc
45. Internet Connection Wizard - icwconn1
46. Internet Explorer - iexplore
47. Internet Properties - inetcpl.cpl
48. Keyboard Properties - control keyboard
49. Local Security Settings - secpol.msc
50. Local Users and Groups - lusrmgr.msc
51. Logs You Out Of Windows - logoff
52. Malicious Software Removal Tool - mrt
53. Microsoft Chat - winchat
54. Microsoft Movie Maker - moviemk
55. Microsoft Paint - mspaint
56. Microsoft Syncronization Tool - mobsync
57. Minesweeper Game - winmine
58. Mouse Properties - control mouse
59. Mouse Properties - main.cpl
60. Netmeeting - conf
61. Network Connections - control netconnections
62. Network Connections - ncpa.cpl
63. Network Setup Wizard - netsetup.cpl
64. Notepad - notepad
65. Object Packager - packager
66. ODBC Data Source Administrator - odbccp32.cpl
67. On Screen Keyboard - osk
68. Outlook Express - msimn
69. Paint - pbrush
70. Password Properties - password.cpl
71. Performance Monitor - perfmon.msc
72. Performance Monitor - perfmon
73. Phone and Modem Options - telephon.cpl
74. Phone Dialer - dialer
75. Pinball Game - pinball
76. Power Configuration - powercfg.cpl
77. Printers and Faxes - control printers
78. Printers Folder - printers
79. Regional Settings - intl.cpl
80. Registry Editor - regedit
81. Registry Editor - regedit32
82. Remote Access Phonebook - rasphone
83. Remote Desktop - mstsc
84. Removable Storage - ntmsmgr.msc
85. Removable Storage Operator Requests - ntmsoprq.msc
86. Resultant Set of Policy (for xp professional) - rsop.msc
87. Scanners and Cameras - sticpl.cpl
88. Scheduled Tasks - control schedtasks
89. Security Center - wscui.cpl
90. Services - services.msc
91. Shared Folders - fsmgmt.msc
92. Shuts Down Windows - shutdown
93. Sounds and Audio - mmsys.cpl
94. Spider Solitare Card Game - spider
95. SQL Client Configuration - cliconfg
96. System Configuration Editor - sysedit
97. System Configuration Utility - msconfig
98. System Information - msinfo32
99. System Properties - sysdm.cpl
100. Task Manager - taskmgr
101. TCP Tester - tcptest
102. Telnet Client - telnet
103. User Account Management - nusrmgr.cpl
104. Utility Manager - utilman
105. Windows Address Book - wab
106. Windows Address Book Import Utility - wabmig
107. Windows Explorer - explorer
108. Windows Firewall - firewall.cpl
109. Windows Magnifier - magnify
110. Windows Management Infrastructure - wmimgmt.msc
111. Windows Media Player - wmplayer
112. Windows Messenger - msmsgs
113. Windows System Security Tool - syskey
114. Windows Update Launches - wupdmgr
115. Windows Version - winver
116. Windows XP Tour Wizard - tourstart
117. Wordpad - write

Do you want to create PDF for Free?

http://www.pdfforge.org/

http://www.gicomsrl.it/pdf4free-en.html

http://www.dopdf.com/

http://www.primopdf.com/


The above sites are giving software applications to do create PDF for entirely free.

Feel free to download the applications from those sites and install it on your PC.

Enjoy Downloading..

Do you want to send Free SMS to abroad?

We people are using
http://www.160by2.com
http://www.way2sms.com sites to send free SMS throughout India.

We can send Free SMS to abroad country using the following sites.

http://www.sendsmsnow.com/register.php

http://smsdaak.com/Registration.aspx

http://gizmosms.com/

http://www.cherple.com/

http://www.txtdrop.com/

Keep Messaging.. (:-

Microsoft SQL Questions for Freshers : (1 to 10 parts included)

Part - 1

If I want to see what fields a table is made of, and what the sizes of the fields are, what option do I have to look for?

What is a query?

A SQL query is typed in the _________ .

What is the purpose of the model database?

What is the purpose of the master database?

What is the purpose of the tempdb database?

What is the purpose of the USE command?

If you delete a table in the database, will the data in the table be deleted too?

What is the Parse Query button used for? How does this help you?

Tables are created in a ____________________ in SQL Server 2005.

Part - 2

  1. What is usually the first word in a SQL query?

  2. Does a SQL Server 2005 SELECT statement require a FROM?

  3. Can a SELECT statement in SQL Server 2005 be used to make an assignment? Explain with examples.

  4. What is the ORDER BY used for?

  5. Does ORDER BY actually change the order of the data in the tables or does it just change the output?

  6. What is the default order of an ORDER BY clause?

  7. What kind of comparison operators can be used in a WHERE clause?

  8. What are four major operators that can be used to combine conditions on a WHERE clause? Explain the operators with examples.

  9. What are the logical operators?

  10. In a WHERE clause, do you need to enclose a text column in quotes? Do you need to enclose a numeric column in quotes?

  11. Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

  12. Will COUNT(column) include columns with null values in its count?

  13. What are column aliases? Why would you want to use column aliases? How can you embed blanks in column aliases?

  14. What are table aliases?

  15. What are table qualifiers? When should table qualifiers be used?

  16. Are semicolons required at the end of SQL statements in SQL Server 2005?

  17. Do comments need to go in a special place in SQL Server 2005?

  18. When would you use the ROWCOUNT function versus using the WHERE clause?

  19. Is SQL case-sensitive? Is SQL Server 2005 case-sensitive?

  20. What is a synonym? Why would you want to create a synonym?

  21. Can a synonym name of a table be used instead of a table name in a SELECT statement?

  22. Can a synonym of a table be used when you are trying to alter the definition of a table?

  23. Can you type more than one query in the query editor screen at the same time?

Part -3

  1. The INSERT INTO .. VALUES option will insert rows into the _________ of a table.

  2. While you are inserting values into a table with the INSERT INTO .. VALUES option, does the order of the columns in the INSERT statement have to be the same as the order of the columns in the table?

  3. While you are inserting values into a table with the INSERT INTO .. SELECT option, does the order of the columns in the INSERT statement have to be the same as the order of the columns in the table?

  4. When would you use an INSERT INTO .. SELECT option versus an INSERT INTO .. VALUES option? Give an example of each.

  5. What does the UPDATE command do?

  6. Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

  7. Will SQL Server 2005 allow you to reduce the size of a column?

  8. What integer data types are available in SQL Server 2005?

  9. What is the default value of an integer data type in SQL Server 2005?

  10. What decimal data types are available in SQL Server 2005?

  11. What is the difference between a CHAR and a VARCHAR datatype?

  12. Does Server SQL treat CHAR as a variable-length or fixed-length column? Do other SQL implementations treat it in the same way?

  13. If you are going to have too many nulls in a column, what would be the best data type to use?

  14. When columns are added to existing tables, what do they initially contain?

  15. What command would you use to add a column to a table in SQL Server?

  16. In SQL Server, which data type is used to store large object data types?

  17. If I do not need to store decimal places, what would be a good numeric data type to use?

  18. If I need to store decimal places, but am not worried about rounding errors, what would be a good data type to use?

  19. Should a column be defined as a FLOAT if it is going to be used as a primary key?

Part - 4
  1. What is a join? Why do you need a join?

  2. What is an INNER JOIN?

  3. Which clause[s] can be used in place of the JOIN in Server SQL?

  4. What is the Cartesian product?

  5. What would be the Cartesian product of a table with 15 rows and another table with 23 rows?

  6. List some uses of the Cartesian product.

  7. What is an equi-join?

  8. What is a non-equi-join? Give an example of an non-equi-join.

  9. What is a self join? Give an example of a self join.

  10. What is a LEFT OUTER JOIN?

  11. What is a RIGHT OUTER JOIN?

  12. What is a CROSS JOIN?

  13. What is a FULL OUTER JOIN?

  14. Does Server SQL allow the use of *= to perform outer joins?

  15. What is the maximum number of rows that a self join can produce?

  16. For what kinds of joins will the associative property hold?

  17. What would be the Cartesian product of the two sets {a,b,c} and {c,d,e}?

Part - 5
  1. What are functions?

  2. What are aggregate functions? Give examples of aggregate functions. What is another term for an aggregate function?

  3. What are row-level functions? Give examples of row-level functions.

  4. Is COUNT an aggregate function or a row-level function? Explain why. Give at least one example of when the COUNT function may come in handy. Does the COUNT function take nulls into account?

  5. Is AVG an aggregate function or a row-level function?

  6. What is the NULLIF function? Explain.

  7. How are ties handled in SQL Server?

  8. How does the DISTINCT function work?

  9. Are string functions (for example, SUBSTRING, RIGHT, LTRIM) aggregate functions or row-level functions?

  10. What is the SUBSTRING function used for?

  11. What is the CHARINDEX function used for?

  12. What function would you use to find the leftmost characters in a string?

  13. What are the LTRIM/RTRIM functions used for?

  14. What function would produce the output in all lowercase?

  15. What function would you use to find the length of a string?

  16. What characters or symbols are most commonly used as wildcard characters in SQL Server 2005?

  17. What is the concatenation operator in Server SQL 2005?

  18. What does the YEAR function do?

  19. What does the MONTH function do?

  20. What does the GEtdATE function do?

  21. What will the following query produce in SQL Server 2005?

        SELECT ('.....'+ names) AS [names]
    FROM Employee

  22. Does Server SQL allow an expression like COUNT(DISTINCT column_name)?

  23. How is the ISNULL function different from the NULLIF function?

  24. What function would you use to round a value to three decimal places?

  25. Which functions can the WITH TIES option be used with?

  26. What clause does the WITH TIES option require?

  27. What is the default date format in SQL Server 2005?

  28. How do dates have to be entered in Server SQL 2005?

  29. What function is used to convert between data types?

  30. What function is useful for formatting numbers?

  31. What function is useful for formatting dates?

Part - 6

  1. Which has precedence, AND or OR?

  2. Why do we need derived structures?

  3. What is a view?

  4. List some advantages of using views.

  5. List some advantages of using temporary tables.

  6. Can temporary tables replace views in all cases?

  7. What is the difference between a view and temporary table?

  8. What is the difference between a local temporary table and global temporary table?

  9. If data is changed in a view, is it changed in the original table?

  10. If data is changed in a temporary table, does it automatically change data in the original table?

  11. What happens to local temporary tables after the session has been ended?

  12. What happens to global temporary table after the session has been ended?

  13. Which type of temporary table has a system-generated suffix attached to it? What does this suffix mean?

  14. Why are inline views helpful?

  15. In SQL Server, is the ORDER BY clause allowed during the creation of a view?

  16. Is SELECT INTO allowed in a view? Why or why not?

  17. Where is the data stored in a view?

  18. How do you delete views?

  19. How do you delete a temporary table?

  20. Do you need to delete a local temporary table? Why or why not?

  21. Which operators have the highest/lowest precedence?

  22. In SQL Server, if a column of FLOAT data type were divided by a column of REAL data type, what data type would the resulting column have? (Hint: refer to the section on Data Type Preference.)

  23. Is an ORDER BY clause necessary when you use a DISTINCT? Why or why not?

Part - 7
  1. What are the major differences between the UNION operation and the JOIN operation?

  2. What is the major difference between the UNION and the UNION ALL?

  3. What major set operator does SQL Server 2005 not have? How can these problems be resolved?

  4. What does union compatibility mean?

  5. What data types are union-compatible?

  6. What is the maximum number of rows that can result from a UNION of two tablesone with 5 rows and the other with 6 rows?

  7. What is the maximum number of rows that can result from a JOIN of two tablesone with 5 rows and the other with 6 rows?

  8. How can a UNION be used to implement an outer join? Explain.

  9. Does SQL Server 2005 support the MINUS operation? How can this be resolved? Give examples.

  10. What is a full outer join? Does SQL Server 2005 directly support a full outer join?

  11. Do you need the same number of columns to perform a union?

  12. Do you need the same data types to perform a union?

  13. Do you need the same number of columns to perform a join?

  14. From the examples given in the chapter, what does the UNION JOIN appear to do?

  15. If a VARCHAR column were unioned with a CHAR column, what would the resulting column be? (Hint: refer to the "Data Type Precedence" section in Chapter 6.)

  16. What does set compatibility mean?

  17. What is the maximum number of rows that can result from a INTERSECT of two tablesone with 5 rows and the other with 6 rows?

  18. Do you need the same number of columns to perform an INTERSECT operation?

  19. Do you need the same data types to perform an INTERSECT operation?


Part - 8

  1. What is a subquery?

  2. Which part of the query/subquery is considered the inner query, and which part is considered the outer query?

  3. Can a subquery always be done as a join? Why or why not?

  4. When writing a query that will have a subquery, how do you determine which table/tables will go in the outer query?

  5. Which predicate can usually be reformulated into a join?

  6. When using operators, are many values acceptable from a result of a subquery?

  7. What can you do to insure a working subquery?


Part -9
  1. What do aggregate functions do?

  2. How does the GROUP BY clause work?

  3. What is the difference between a GROUP BY and ORDER BY?

  4. What is the HAVING clause used for?

  5. Can the WHERE clause always be considered a substitute for the HAVING clause? Why or why not?

  6. Do functions of functions have to be handled in a special way in Server SQL 2005?

  7. Will nulls in grouped columns be included in a result set?

  8. How do aggregate functions treat nulls?

  9. Does the sequence of the columns in a GROUP BY clause have an effect on the end result?

  10. When would it not make sense to use the GROUP BY and DISTINCT functions together?

  11. Is GROUP BY affected by nulls?

  12. Which comes first in a SELECT statement, an ORDER BY or GROUP BY? Why?

  13. The GROUP BY and ________________ clauses are used together.


Part -10

  1. What is a noncorrelated subquery?

  2. Which type of subquery can be executed on its own?

  3. Which part of a query is evaluated first, the query or the subquery?

  4. What are correlated subqueries?

  5. What does the EXISTS predicate do?

  6. What are considered universal qualifiers?

  7. Is correlation necessary when we use EXISTS? Why?

  8. Explain how the "for all" type SQL query involves a double-nested correlated subquery using the NOT EXISTS predicate.

Char Vs Varchar Vs NVarchar in SQL

char[(n)] - Fixed-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is n bytes. The SQL-92 synonym for char is character.

varchar[(n)] - Variable-length non-Unicode character data with length of n bytes. n must be a value from 1 through 8,000. Storage size is the actual length in bytes of the data entered, not n bytes. The data entered can be 0 characters in length. The SQL-92 synonyms for varchar are char varying or character varying.

nvarchar(n) - Variable-length Unicode character data of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length. The SQL-92 synonyms for nvarchar are national char varying and national character varying.

Abstract Class Vs Interface in C#

Abstract Class
Only one Abstract class can be inherited into the derived class.
Members of the abstract class can or cannot have implemention

Interface
Interfaces enable multiple inheritance to the object
Interfaces contains only the definitions for the menbers without implementation

Important Commands and Functions in SQL Server 2005

ABS
Row-level function that returns an absolute value.

ALTER COLUMN
Command used to change a column's size or type in a table.

ALTER TABLE
Command used to modify a table's definition.

AND
Logical operator that, when used in a WHEREclause, means that both criteria have to be met for a row to be included in the result set.

ASC
Function used in ORDER BY to put a SQL result set in ascending order.

AVG
Aggregate function used to average a group of row values.

BETWEEN
An operator used to determine whether a value occurs within a given range of values (inclusive); used with a WHERE clause.

BIGINT
Integer data type that can store numbers from -263 to 263 - 1.

BINARY
Data type used to store strings of bits.

BIT
Data type that consumes only a single bit of storage.

CAST
Conversion function used to change a data type of a column within a query.

CEILING
Row-level function that returns the next larger integer.

CHAR(size)
Character data type used when the column length is known and unvarying.

CHARACTER
Data type used to store any combination of letters, numbers, and symbols.

CHARINDEX
String function that returns the starting position of a specified pattern.

CHECK
Integrity constraint used to create bounds for a column value.

CONSTRAINTS
Restrictions that can be placed on values when creating database objects such as tables and views.

CONVERT
Conversion function used to explicitly convert to a given data type within in a query.

COUNT(*)
Function used to count the total number of rows in a result set.

COUNT(attribute)
Group function that counts the number of rows where attribute is not NULL.

CREATE INDEX
Command used to create an index.

CREATE DATABASE
Command used to create a database.

CREATE SYNONYM
Command used to create a synonym.

CREATE TABLE
Command used to create a table.

CREATE VIEW
Command used to create a view.

CROSS JOIN
A query option used to generate a Cartesian product.

DATE
Oracle equivalent of DATETIME .

DATEADD
Date function that adds to a specified part of a date.

DATEDIFF
Date function that returns the difference between two dates.

DATEFORMAT
Date function that controls how SQL Server interprets date constants that are entered for dates.

DATEPART
Date function that returns the specified part of the date requested.

DATETIME
Data type that can be used for dates.

DAY
Date function that extracts a day from a date.

DEC
Data type; synonym for DECIMAL data type.

DECIMAL
Numeric data type whose storage type varies based on a specified precision.

DECLARE
Command used to create variables on the fly within a script.

DELETE FROM
Command that deletes rows in a table that may satisfy a given condition.

DESC
Function used in ORDER BY to put a SQL result set into descending order.

DISTINCT
Result set function that omits rows that contain duplicate data.

DROP COLUMN
Command used to delete a column in a table.

DROP CONSTRAINT
Command used to delete a named constraint.

DROP INDEX
Command used to delete an index.

DROP SYNONYM
Command used to delete a synonym.

DROP TABLE
Command used to delete a table.

DROP VIEW
Command used to delete a view.

EXISTS
A keyword in a SQL statement that returns true in a WHERE clause if the subquery following it returns at least one row.

FLOAT
Decimal data type that has a precision of 15 digits.

FLOOR
Row-level function which returns the next lower integer value when a number contains decimal places.

GEtdATE
Date function that returns the current system date and time.

GROUP BY
Produces one summary row for the aggregate value of all values for a given column.

GUID
Global unique identifier; UNIQUEIDENTIFIER data type guarantees worldwide uniqueness, even among unconnected computers.

HAVING
Part of a SQL statement that is used to determine which groups of a GROUP BY will be included in the result set.

IMAGE
Large object binary data type; used to store pictures.

IN
Logical operator for a WHERE clause that tests for inclusion in a named set.

INT
Integer data type that can store numbers from -231 to 231 - 1.

INDEX BY
Command used to create an index on a table by a certain column value.

INNER JOIN
Command used to combine two tables in an equi-join operation.

INSERT INTO.. SELECT
A way to insert many rows into a new table at one time.

INSERT INTO..VALUES
A way to insert values into a table one row at a time.

INSERT
Command that allows for the addition of new rows to a table.

INTEGER
Numeric data type that has no digits after the decimal point.

INTERSECT
Set operation that combines two queries such that it returns all rows that are the same in both result sets.

IS NOT NULL
Function that tests for the NOT NULL condition.

ISNULL
Function that returns a true value if a data item contains a null.

JOIN
Command used to join two tables; synonymous with INNER JOIN.

LEFT
String function that returns the left portion of a string up to a given number of characters.

LEFT JOIN
Same as LEFT OUTER JOIN .

LEFT OUTER JOIN
A join where all the rows from the first (left) table are kept in the result set, regardless of whether they have matching rows in the second (right) table.

LEN
String function that returns the length of a string.

LIKE
A WHERE clause option that matches a particular pattern.

LONG
Oracle equivalent of TEXT data type.

LOWER
String function used to convert a string to lowercase.

LTRIM
String function that removes blanks or other named character from the beginning of a string.

MAX
Aggregate function that returns the highest of all values from a column in a set of rows.

MIN
Aggregate function that returns the lowest of all values from a column in a set of rows.

MINUS
Set operation that returns only those rows from the result of the first query that are not in the result of the second query; not available in SQL Server.

MONEY
Data type used with currency data.

MONTH
Date function that extracts the month from a date.

NATIONAL CHARACTER
A data type; synonym for NCHAR data type.

NCHAR
Fixed-length Unicode character data type.

NOT
Operator that reverses the effect of any logical operator such as IN, LIKE, and EXISTS.

NOT BETWEEN
Operator that allows you to determine whether a value does not occur within a given range of values.

NOT EXISTS
Operator that returns true in a WHERE clause if the subquery following it returns no rows.

NOT NULL
Operator that returns true if an attribute has a non-null value.

NOT NULL Constraint
Integrity constraint that denies the creation of a row when an attribute has a null value.

NULL
Value that is unknown.

NULLIF
Function that returns a NULL if a certain condition is met in an expression.

NUMERIC
Synonym for DECIMAL data type.

NVARCHAR
Variable-length Unicode character data type.

OR
Binary logical operator that returns a true value if either one of the expressions is true.

ORDER BY
Clause that sorts the results of a query before they are displayed.

OUTER JOIN
Join where rows from a table are kept in the result set although there is no matching row in the other table used in the join.

PERCENT
Function that is used to return a certain percentage of records that fall at the top of a range specified.

PRIMARY KEY
Constraint used to create a primary key in a table; used in CREATE TABLE and ALTER TABLE commands.

REAL
Decimal data type that has a precision of seven digits.

REFERENCES
Constraint part that defines the table name and key used to reference another table.

RIGHT
String function that returns the right portion of a string.

RIGHT JOIN
Same as RIGHT OUTER JOIN .

RIGHT OUTER JOIN
Join where all the rows from the second (right) relation are kept whether matched or not in a join operation.

ROUND
Function used to round numbers to a specified number of decimal places.

ROWCOUNT(n)
Function that returns the first n rows.

RTRIM
String function that removes blanks from the right end of a string.

SELECT
Command that allows you to retrieve rows from tables (or views) in a database.

SET
Command used to assign values to variables.

SET DATEFORMAT
Date function used to change the format in which SQL Server reads in dates.

SMALLDATETIME
Data type used to store dates.

SMALLINT
Integer data type that can store numbers between -215 to 215 - 1.

SMALLMONEY
Data type that can be used with currency data.

SQUARE
Row-level function that returns the square of a number.

SQL_VARIANT
Data type used to store values of any data type except TEXT or IMAGE.

SQRT
Row-level function that returns the square root of positive numeric values.

STR
Conversion function that always converts from a number to a character data type.

SUBSTRING
String function that returns part of a string.

SUM
Group function that adds up all the values for a column value in a set of rows.

TABLE
A two-dimensional (row by column) arrangement of data.

TEXT
Character large object data type.

TINYINT
Integer data type that can store numbers between 0 and 255.

TOP
Function that returns a specified number of records from the top of a result set.

UNION
Set operation that combines two queries such that it returns all distinct rows for the result sets of both queries. The two queries must have union-compatible result sets.

UNION ALL
Set operation that combines two queries and returns all rows from both the SELECT statements (queries). A UNION ALL also includes duplicate rows. The two queries must have union-compatible result sets.

UNIQUE
Integrity constraint that disallows duplicate entries for an attribute even though the column is not a primary key.

UNIQUEIDENTIFIER
Data type that guarantees uniqueness of the identifier, even among unconnected computers.

UPDATE
Command that changes values in specified columns in specified tables .

UPPER
String function used to display all output in uppercase.

USE
Command used to open a database.

UUID
Universal unique identifier; the UNIQUEIDENTIFIER data type that guarantees uniqueness, even among unconnected computers.


VARBINARY
Data type used to store variable-length binary data.

VARCHAR
Character data type used when the field length is varying.

VARCHAR2
Oracle equivalent of VARCHAR.

WHERE
Row filter part of a SQL statement that allows you to specify criteria on column values for rows that are being selected from a table.

WITH TIES
Clause used with the TOP function to retrieve rows that are ties.

XML
A new SQL Server data type used to model complex data.


YEAR
Date function that extracts the year from a date.

Miscellaneous SQL Server Objects

  • Synonyms

    A synonym is an alternative name for a schema-scoped object. It is a single-part name to reference a base object. A synonym is similar to an alias, but it replaces a two-part, three-part, or four-part name.

  • Database diagrams

    A database diagram is a graphical design of a table or set of tables that can be used to illustrate the tables and relationships within a database.

  • Statistics Stored within a table, statistics are automatically created and optionally supplemented histograms.

  • Assemblies

    An assembly references a managed application module (DLL file) that was created in the .NET Framework common language runtime (CLR).

  • Proxies

    In the msdb context, a proxy defines security context and provides the SQL Server Agent access to credentials for a Windows user.

Installation Procedure for IIS6.0 on Windows 2003

1- Go to Add or Remove Programs

Start =>> Control Panel ==> Add or Remove Programs

2- Go to the Add/Remove Windows Components


3- Select Internet Information Services to install

Double click on Application Server

Double click on Internet Information Services (IIS)

Select File Transfer Protocol (FTP) Service and Internet information Services Manager in the Internet Information Services (IIS) window and then click OK

OK

To Open IIS do in a Dos Command : Start ==> Run ==> INETMGR

How Can I Enable RDC in Windows 2003?

Remote Desktop is a great way to work on your computer from basically anywhere (if you set up your internet connection sharing device properly). The port it runs on is 3389, forward that on your router to be available from anywhere in the world.

Procedure :

1) Click the Start button, and right-click My Computer and click Properties from the pop-up menu

Go to the "Remote" tab and check "Allow users to connect remotely to this machine"

At this point, only Administrators can access the machine. To allow more users, click "Select Remote Users..." and click the "Add" button in the new dialog

In the next dialog, type in the name of a regular user and press OK

And that's all!

To connect to a virtual desktop (2 are allowed in Windows Server 2003) run "MSTSC" from a Windows XP/2003 machine and type the address

For other systems you can download the RD client 5.2 from this address

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=a8255ffc-4b4a-40e7-a706-cde7e9b57e79

To connect to the console session, you must either have logged in locally to the machine, then try accessing it, or be an Administrator.

You run either "mstsc /console" or connect to /console.

Google Chrome (BETA) - Tech Videos





Do you want to download?

How to split large files into set of smaller files?



We can split huge large sized files into set of smaller files. GSplit is a free reliable file splitter that lets you split your large files (like Self-Extracting archives, Zip archives, disk images, multimedia, music, video, backup, image, archive, log, large text, document files...) into a set of smaller files called pieces.

These pieces are easier to:

1) copy to floppy or any removable media disks.

2) distribute over the Internet, networks.
3) send by email (forget attached file size restrictions imposed by
some ISP, pop3, SMTP and other e-mail servers).

4) archive to CD, DVD, USB Flash drive and strick, Zip disk, and any other storage device. .

5) upload to host accounts, file delivery services, online file hosting sites...
that have restrictions on file sizes.

6) share with friends, colleagues or other users through networks and the Internet.

7) exchange using Instant Messaging clients or Instant Messenger programs...

Click Here for More >>>

How to Convert CHM To EXE?

CHM To Exe (or Chm2exe) is a free program that allows you to convert Microsoft HTML Help files (.chm) into executable files. You can open CHM files, explore them, extract all source files and create related HTML Executable projects.

You can then compile your HTML Help source files into single and secure executable files that can also be customized with all of the features provided by HTML Executable.

It wont support Microsoft Help 2.0.

Click here for More...>>>

How Increase the Speed for Acrobat Reader?

1. Go to the installation folder of Acrobat Reader

2. Move all the files and folders from the “plugins” directory to the “Optional” directory.
(Please do not Copy-Paste. Please do Cut-Paste)

Please close Acrobat Reader before doing this

How to Hide 'User Accounts' from others in Windows XP?

Hide 'User Accounts' from users

1.Go to Start/Run, and type: GPEDIT.MSC
2.Open the path
User Config > Admin Templates > Control Panel
3.doubleclick "Hide specified Control Panel applets"
4.put a dot in 'enabled', then click 'Show"
5.click Add button,type "nusrmgt.cpl" into the add box

NTLDR Missing - How to Solve the Problem?



"NTLDR is Missing Press any Key to Restart- this is the first message I got on my computer screen when I turned it on."

Thanks to : http://www.youtube.com/user/mater91

Windows Server 2008 : Run Commands For Administrators

Command Line

Console Name

AdRmsAdmin.msc Active Directory Rights Management Services
Adsiedit.msc ADSI Edit
Azman.msc Authorization Manager
Certmgr.msc Certmgr (Certificates)
Certtmpl.msc Certificates Template Console
CluAdmin.msc Failover Cluster Management
Comexp.msc Component Services
Compmgmt.msc Computer Management
Devmgmt.msc Device Manager
Dfsmgmt.msc DFS Management
Dhcpmgmt.msc DHCP Manager
Diskmgmt.msc Disk Management
Dnsmgmt.msc DNS Manager
Domain.msc Active Directory Domains And Trusts
Dsa.msc Active Directory Users And Computers
Dssite.msc Active Directory Sites And Services
Eventvwr.msc Event Viewer
Fsmgmt.msc Shared Folders
Fsrm.msc File Server Resource Manager
Fxsadmin.msc Microsoft Fax Service Manager
Gpedit.msc Local Group Policy Editor
Lusrmgr.msc Local Users And Groups
Napclcfg.msc NAP Client Configuration
Nfsmgmt.msc Services For Network File System
Nps.msc Network Policy Server
Ocsp.msc Online Responder
Perfmon.msc Reliability And Performance Monitor
Pkiview.msc Enterprise PKI
Printmanagement.msc Print Management
Remoteprograms.msc TS RemoteApp Management
Rsop.msc Resultant Set of Policy
Secpol.msc Local Security Policy
ServerManager.msc Server Manager
StorageMgmt.msc Share And Storage Management
Services.msc Services
StorExpl.msc Storage Explorer
Tapimgmt.msc Telephony
Taskschd.msc Task Scheduler
Tmp.msc Trusted Platform Module (TPM) Management
Tsadmin.msc Terminal Services Management
Tsconfig.msc Terminal Services Configuration
Tsgateway.msc TS Gateway Manager
Tsmmc.msc Remote Desktops
Uddi.msc UDDI Services Console
Wbadmin.msc Windows Server Backup
Wdsmgmt.msc Windows Deployment Services
Winsmgmt.msc WINS Manager
WmiMgmt.msc WMI Control

Verbose Text to Speech Converter

Converts text to voice and can save as mp3

* Reads any text on your computer out loud.
* Listen to text as an mp3 audio file on a portable device.
* Installs and ready to read text in just minutes.

Verbose is a text to speech program which will read aloud any text or save it as mp3.

After you have installed this text reading software you can assign a system wide hot key. Then whenever you want Verbose to read the text on your screen just push that key and the software will read it aloud.

Verbose text to voice software can also save your text documents or emails to mp3 or wav for you to store them on your Pocket PC or MP3 player, such as an iPod, so you can listen to them on your way home.

Please click here for more

VideoPad Video Editor Software

Creating a movie from your digital videos has never been easier. VideoPad is a full featured, professional, video editing application which allows you create movie projects from various video clips or a single video file.

This video editing application allows you to import various file formats including .avi, .wmv, .3gp, .wmv, .divx and many others and then apply effects, cut frames, add captions, voice-overs and soundtracks and more.

VideoPad is completely free.


Download it from here : http://www.nchsoftware.com/videopad/vpsetup.exe

Using Replication in SQL

Using Replication

Replication is the process by which data and database objects are distributed from SQL Server to other database engines that reside across an enterprise; this data can be distributed to other SQL Server databases or even nonSQL Server databases such as Oracle and others. Replication can be explained by using a publisher/subscriber/distributor metaphor. To understand replication, you must understand and become familiar with the basic concept of the publisher/distributor/subscriber metaphor. This metaphor defines the different roles SQL Server can play in the replication process. Each role provides functionality that aids in the replication process:

  • Publisher In replication terminology, the publisher is the server that produces the original data for the use of the replication process. The publisher can produce many publications or sets of data to be distributed to other subscribing machines. One publisher can produce data to be replicated to many subscribers. Also, many publishers can produce data to be distributed to just a single, central subscriber. The former is implemented as a standard central publisher/distributor/subscriber replication model, and the latter is referred to as central subscriber replication.

  • Distributor The distributor is the server that contains the distribution database, data history, and transactions; as its name implies, it sends data to subscribers. The distributor can be implemented on the same physical server as the publisher or subscriber, although it doesn't need to be. It can reside on a separate server somewhere else in the world and be connected via a network. The placement of the distributor and its characteristics depend on the type of replication used.

  • Subscriber A subscriber, in SQL Server terms, is the server that receives replicated data through the distributor. Subscribers can choose from the publications available at the publisher and don't necessarily need to subscribe to them all.

WavePad Sound File Editor : Professional Audio Editing Software

This sound editing software is a full featured professional audio editor for Windows or Mac.

It lets you make and edit music, voice and other audio recordings.

When editing audio files you can cut, copy and paste parts of recordings and, if required, add effects like echo, amplification and noise reduction.

WavePad works as a wav editor or mp3 editor but it also supports a number of other file formats including vox, gsm, real audio, au, aif, flac, ogg and more.

http://www.nch.com.au/wavepad/index.html

How To Enable Dynamic Updates For DHCP Clients

1.Run DHCP from Start Menu > Programs > Administrative Tools > DHCP.
2.In the DHCP console tree, click the applicable DHCP server.
3.Click the Action menu and then click Properties.
4.In the Properties window, Click the DNS tab.
5.Select the Enable DNS dynamic updates according to the settings below check box, and then click the OK button.

How To Achieve Your Deepest Desires?

6 Simple Steps To Achieve Your Deepest Desires - By Jack Sinclair

It's been a long time since I played soccer. But I have a passion for it. Everyday I would think that I am making the winning goal from every angle of the field. Then I would also imagine that I've won the championship, that I'm also the highest scorer in the game. I would really love to play again, but I'm too busy with my job & other stuffs.

Then the opportunity came when my friends invited me to play. I haven't been practicing, but I'm making better moves than those who have been playing every day.

What made the difference?

Well, that's the power of imagination & visualization. If you want to be a doctor, visualize as one. Act like one. Think of what prognosis you're making, the patient you're seeing, the operation you're handling, and the operating room you're in. Visualize the procedure. Experience the success. Make everything real.

You should also affirm. Believe that you are what you are visualizing. So you want to be a doctor? Tell yourself, "I'm the best doctor in the world." Don't say to yourself, "I will be the best doctor in the world."

Affirm strongly. Say "I am," not "I will," because "I will" suggests something that will occur only in the future. You have to experience it NOW, not in the future.

You must sink into your subconscious your deepest desire. The subconscious mind can do what the conscious mind cannot.
Here's an exercise.

Get a comfortable & quiet place to rest.

Relax your whole body. Command every part of your body to relax starting from your feet up to your head.

Count back slowly from 20 to 1, where in each count you relax deeper & deeper. Upon reaching 1, you are completely relaxed.

Now affirm your deepest desire. If you want to be a doctor, say," I am the greatest doctor in the world." As you're saying that, picture yourself to be the best doctor ever, helping every patient you've ever met. You may say "I am now explaining to the medical community my methods" or anything that will affirm what you're conceiving in your mind as of the moment.

After about 10 to 20 minutes of continuous confirmation and visualization, count slowly from 1 to 20. Upon counting, slowly be aware of your surroundings. Feel refreshed and invigorated after doing this exercise.

Repeat this exercise everyday.

What you have just learned is a very powerful technique to greatly enhance the power of visualization & affirmation by embedding it into the subconscious. What once was nearly impossible to achieve will become easier to reach from now on.




--------------------------------------------------------------------------------
Jack Sinclair is President of Templar Bond, the online wealth generation company

How to Enable ASP in IIS6.0?

IIS 6.0 comes with ASP disabled by default, and this will show you how to enable it.

Method:

Load IIS from the Administrative tools in the Control Panel by clicking

Start -> Administrative Tools -> IIS Manager

(or loading the Control Panel, entering the Administrative Tools folder, and double clicking IIS Manager).

Go to the Web Service Extensions tab, click Active Server Pages, then press the "Allow" button on the left

Great Tips for Windows Vista Users

1. If you hate the look of Aero, click Start/Control Panel/Themes and you can choose a non-Aero theme, such as Windows Classic.

2. Windows Vista's installer can detect serial-ATA (SATA) drives without the need to provide a driver diskette. Don't bother creating a diskette for your SATA drives before you install Vista.

3. If, for some reason, the Vista installation gets interrupted due to an unintentional shutdown or reboot, start the computer without booting the Vista DVD. Windows Vista's installer should pick up where it left off. If it does-n't, then restart the installation over from scratch.

4. When you perform a search with Vista's new, instant search feature, you can save the search in a special folder. This powerful feature allows you to create a virtual folder which, by default, is saved in your \\Searches\ folder. Every time you open such a folder, the search results are updated.

5. In Windows Vista, you can add additional clocks to the system tray. Click the clock, and then click Date and Time Settings. Click the Additional Clocks tab. You can add one or two additional clocks to the tray and select their time zones.

6. You can save your progress in most of the games included with Windows Vista—even the carry-overs from earlier versions of Windows.

7. You can create XML documents, which are more secure than regular text files or even word processor docs. Just create a document in a word processor, print it via the options menu, and select the XPS printer.

8. If you upgrade your graphics card in preparation for Windows Vista, be sure to get a new card with as much local memory as possible. Since Windows Vista renders everything—even the desktop and windows them-selves—as 3D surfaces, local 3D memory greatly improves performance...sometimes even more than a more powerful GPU.

9. Windows Vista games deposit their saves into a special directory, called Saved Games, in your personal folder. In theory, that will make upgrading to a new system much easier for gamers, who like to migrate their game saves.

10. When using the Help system, it's usually advantageous to include Microsoft's online database in your search. The online/offline status of your search is located on the bottom right of the Help window. You can click it to toggle.

11. The Games folder is a powerful repository of all things gaming. From within, you launch games, update games with the latest patches, enable parental controls to protect younger users from harmful content, and more. Invoke it by clicking Start/Games.

12. Several applications are available to help you tweak Windows Vista for maximum performance. They in-clude TweakVI (www.totalidea.com), TweakVista (www.tweakvista.com/tweakvistautility), and VistaBootPRO (www.vistabootpro.org). And don't forget about Windows ReadyBoost, which lets you use a removable flash memory drive to boost system memory.

13. Do you use the icon in the upper left corner of system and application windows? A quick double-click closes the window (instead of a single click on the X at the upper right). Though Microsoft left the icon out in Vista, the function remains.—Sarah Pike

14. In Microsoft Windows Explorer, you can use column headers (Name, Size, and so on) to sort files. Savvy users may right-click on a column head to remove items or add some—say, Dimensions for images. There are around 45 such columns available in Windows XP. Windows Vista has well over 250, covering a multitude of metadata.—Sarah Pike

15. If you've become used to surfing your Program Menu to get to applications, you'll be in for a shock when you first use Microsoft Windows Vista. The new Program Menu shows you only recently used applications and requires extra clicks to navigate to submenus. This can be very frustrating but, thankfully, the Search box Microsoft has added to the Start menu is a great replacement—as long as you're an accurate typist. As quickly as you can type, it returns intelligent results in apps, files, even e-mail messages.—Dave Cardinal, freelance writer

Source: www.pcmag.com