Suspend auto-play

Suspend auto-play

To stop Windows from automatically playing a music CD /Flash Drive, hold the SHIFT key down while inserting them in system.

True size of a directory

True size of a directory

One of the quickest ways to find out the size of a directory (or a folder) -- including the size of the files and directories inside it -- is to press ALT+ENTER on it.
For example, to find out how much space your Windows directory is occupying:
Run "Windows Explorer"
Select "C:\Windows" (or whatever your Windows directory is)
Press ALT+ENTER or right click and select "Properties..."

How to shutdown your computer from a distance...

How to shutdown your computer from a distance...

There's a small utility called "SHUTCMD.EXE" included in the Windows NT Resource Kit that you can use to shutdown or restart a local or remote computer.
For example, you can shutdown the local computer by running:
SHUTCMD /L
to shutdown a computer on your network ("SERVER1" being the name of the computer you want to shutdown):
SHUTCMD \\SERVER1 /Y
to shutdown a remote computer connected to the Internet ("205.56.44.24" being the IP address of the computer you want to shutdown):
SHUTCMD \\205.56.44.24 /Y


NOTE: You must first logon to the computer that you're trying to reboot.

Mobile Phone Secrets & Tricks

.:: NOKIA ::.
Nokia Universal Codes
Code Description :These Nokia codes will work on most Nokia Mobile Phones
(1) *3370# Activate Enhanced Full Rate Codec (EFR) - Your phone uses the best sound quality but talk time is reduced my approx. 5%
(2) #3370# Deactivate Enhanced Full Rate Codec (EFR) OR *3370# ( F avourite )
(3) *#4720# Activate Half Rate Codec - Your phone uses a lower quality sound but you should gain approx 30% more Talk Time.
(4) *#4720# Deactivate Half Rate Codec.
(5) *#0000# Displays your phones software version, 1st Line : Software Version, 2nd Line : Software Release Date, 3rd Line : Compression Type. ( Favourite )
(6) *#9999# Phones software version if *#0000# does not work.
(7) *#06# For checking the International Mobile Equipment Identity (IMEI Number). ( Favourite )
(8) #pw+1234567890+1# Provider Lock Status. (use the "*" button to obtain the "p,w"and "+" symbols).
(9) #pw+1234567890+2# Network Lock Status. (use the "*" button to obtain the "p,w"and "+" symbols).
(10) #pw+1234567890+3# Country Lock Status. (use the "*" button to obtain the "p,w"and "+" symbols).
(11) #pw+1234567890+4# SIM Card Lock Status. (use the "*" button to obtain the "p,w" and "+" symbols).
(12) *#147# (vodafone) this lets you know who called you last.
(13) *#1471# Last call (Only vodofone).
(14) *#21# Allows you to check the number that "All Calls" are diverted to
(15) *#2640# Displays security code in use.
(16) *#30# Lets you see the private number.
(17) *#43# Allows you to check the "Call Waiting" status of your phone.
(18) *#61# Allows you to check the number that "On No Reply" calls are diverted to.
(19) *#62# Allows you to check the number that "Divert If Unreachable (no service)" callsare diverted to.
(20) *#67# Allows you to check the number that "On Busy Calls" are diverted to.
(21) *#67705646# Removes operator logo on 3310 & 3330.
(22) *#73# Reset phone timers and game scores.
(23) *#746025625# Displays the SIM Clock status, if your phone supports this power saving feature "SIM Clock Stop Allowed", it means you will get the best standby time possible.
(24) *#7760# Manufactures code.
(25) *#7780# Restore factory settings.
(26) *#8110# Software version for the nokia 8110.
(27) *#92702689# Displays - 1.Serial Number, 2.Date Made, 3.Purchase Date, 4.Date of last repair (0000 for no repairs), 5.Transfer User Data. To exit this mode you need to switch your phone off then on again. ( Favourite )
(28) *#94870345123456789# Deactivate the PWM-Mem.
(29) **21*number# Turn on "All Calls" diverting to the phone number entered.
(30) **61*number# Turn on "No Reply" diverting to the phone number entered.
(31) **67*number# Turn on "On Busy" diverting to the phone number entered.
(32) 12345 This is the default security code.
press and hold # Lets you switch between lines
NOKIA 5110/5120/5130/5190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
Provider lock status: #pw+1234567890+1
Network lock status #pw+1234567890+2
Provider lock status: #pw+1234567890+3
SimCard lock status: #pw+1234567890+4
NOKIA 6110/6120/6130/6150/6190
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
Enhanced Full Rate: * 3 3 7 0 # [ # 3 3 7 0 # off]
Half Rate: * 4 7 2 0 #
NOKIA 3110
IMEI number: * # 0 6 #
Software version: * # 0 0 0 0 # or * # 9 9 9 9 # or * # 3 1 1 0 #
Simlock info: * # 9 2 7 0 2 6 8 9 #
NOKIA 3330
*#06#
This will show your warranty details *#92702689#*3370#
Basically increases the quality of calling sound, but decreases battery length.
#3370#
Deactivates the above
*#0000#
Shows your software version*#746025625#
This shows if your phone will allow sim clock stoppage*4370#Half Rate Codec activation. It will automatically restart#4370#Half Rate Codec deactivation. It will automatically restartRestore Factory SettingsTo do this simply use this code *#7780#Manufacturer InfoDate of Manufacturing *#3283#*3001#12345# (TDMA phones only)
This will put your phone into programming mode, and you'll be presented with the programming menu.2) Select "NAM1"3) Select "PSID/RSID"4) Select "P/RSID 1"Note: Any of the P/RSIDs will work5) Select "System Type" and set it to Private6) Select "PSID/RSID" and set it to 17) Select "Connected System ID"Note: Enter your System ID for Cantel, which is 16401 or 16423. If you don't know yours,ask your local dealer for it.8) Select "Alpha Tag"9) Enter a new tag, then press OK10) Select "Operator Code (SOC)" and set it to 205011) Select "Country Code" and set it to 302 for Canada, and 310 for the US.12) Power down the phone and power it back on againISDN CodeTo check the ISDN number on your Nokia use this code *#92772689#

Change to a drive and expand its sub directories

Change to a drive and expand its sub directories
As you know, you can still run the good old Windows File Manager by running winfile.exe. In the File Manager, you can press CTRL and a letter to change to a particular drive. For example, to change to drive d, press CTRL+D. You'll notice that only the root directories on the selected drive is initially displayed making it somewhat harder to hunt for an unknown file or sub directory. Here's how to change to a drive and then expand all sub directories at the same time:
Press CTRL+SHIFT and the drive letter.For example, to change to drive C:CTRL+SHIFT+C

How to disable shutdown button on the Log-in screen

How to disable shutdown button on the Log-in screen

Unlike in Windows NT Server, Windows NT Workstation's log-in screen has a "Shutdown" button which you can use to shutdown the system without ever logging in. Here's how to disable Windows NT Workstation's "Shutdown" button on the initial log-in screen:

*Run "Registry Editor" (run "RegEdit.exe" or "RegEdt32.exe")
*Select the following key:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\Current Version\Winlogon
*Add a value named "ShutdownWithoutLogon" of type "REG_SZ" and set it to "0".
*Restart Windows

Too lazy to type the full directory name?

Too lazy to type the full directory name?

Did you know that you can avoid typing full directory names when changing directories from the Command Prompt?

Let's say you have a directory named
MyNewYorkOfficeFilesFolder that you want to changed to. Instead of typing:

CD MyNewYorkOfficeFilesFolder

next time try:

CD myn*

If you have multiple directories starting with the letters "myn" then you'd have to use more characters before the *, until the name can be distinguished from the rest of the directory names in the current directory.

If you have multiple directories to change to such as:

MyNewYorkOfficeFilesFolder\AGroup\Outbox

you can use:

CD myn*\a*\o*

Upgrading and Repairing Microsoft Windows

Upgrading and Repairing Microsoft Windows




Upgrading and Repairing Microsoft WindowsAuthor: Scott Mueller, Brian Knittel Que 2005 English 720 pages CHM 9,55 MBFans of Upgrading and Repairing PCs, your call has been answered. Scott Mueller, author of the best-selling Upgrading and Repairing PCs, is now bringing you an equally in-depth guide to Windows troubleshooting. Upgrading and Repairing Microsoft Windows explains how Windows works and how to fix it when things go wrong.This comprehensive resource includes information on:* Installation* Managing security* Optimizing performance* Recovering data* Configuring settings and the registry* Protecting Windows from viruses and spywareScott also includes references to helpful tools and scripting commands for maximum system controls. A DVD is included that provides you with additional resources and unique how-to video that brings Scott right to you. Find out how to make Windows work with you and not against you with Upgrading and Repairing Microsoft Windows.

DownloaD:
http://w14.easy-share.com/1702420355.html

Reviewing SQL Server Permissions

Reviewing SQL Server Permissions

Permissions on data are one of the most critical aspects of database administration. If you’re too strict as a database administrator then your users will not be able to do their jobs. If you’re not lenient, then data can be compromised or even leaked. It is a very fine balance to control. The ability to determine these permissions on your database systems is absolutely paramount.

Who has access to my SQL Server?
First things first, you need to know which users are able to login into your SQL Server instance. Logins come in two flavors; Windows authentication and SQL Server Logins. Windows logins are tied to Windows accounts while SQL Server logins are housed in SQL Server internally. Whether the login is Windows based or is an internal SQL account, you can access login information by querying internal SQL Server views. To find the login information, the sys.server_principals system view can be used. The following script queries this view and returns login information along with the type of associated login.

SELECT name, type_desc, is_disabledFROM sys.server_principalsTo test this query, run the following script followed by the script above. The new login TestLogin should appear in the result-set.

CREATE LOGIN TestLogin WITH Password = 'asdevex33', CHECK_POLICY = OFFWho has access to my Databases?

Once a login is able to gain entry into the server, they then need access to databases. Before a login is able to access a database, a user must be mapped to that login inside the database. The following script queries the sys.database_principals system view, which holds user related information for the current database. Note that this information will likely differ for each database you run it in. Users are database-level, so different users will have different access in different databases.

SELECTUserName = dp.name, UserType = dp.type_desc, LoginName = sp.name, LoginType = sp.type_descFROM sys.database_principals dpJOIN sys.server_principals sp ON dp.principal_id = sp.principal_idTo test the above view, run the following script followed by the script immediately above. The new user TestUser (which is now mapped to the login TestLogin) should appear in the result-set.

CREATE USER TestUser FOR LOGIN TestLogin

Server Roles
Now that I have covered server logins and database users, I need to cover the different server and database roles on the system. A login can be a member of a server role, which gives the login elevated permissions for the SQL Server instance. The following query can be used to view which logins are tied to which server roles.

select p.name, p.type_desc, pp.name, pp.type_descfrom sys.server_role_members rolesjoin sys.server_principals p on roles.member_principal_id = p.principal_idjoin sys.server_principals pp on roles.role_principal_id = pp.principal_idThe following script adds the TestLogin I created above to the dbcreator server role. Once this script is ran, rerun the immediate script above. The new login role will be included in the result-set.

EXECUTE sp_addsrvrolemember@loginame = 'TestLogin',@rolename = 'dbcreator'Database Roles
The previous query illustrated which users had specific permissions inside of your database. However, when you’re a member of a database role, you’re given permissions that are not contained in the sys.database_permissions view, but are absolutely vital for knowing which users have permissions inside your database. You can use the following query to determine which users are assigned to database roles.

SELECTp.name, p.type_desc, pp.name, pp.type_desc, pp.is_fixed_roleFROM sys.database_role_members rolesJOIN sys.database_principals p ON roles.member_principal_id = p.principal_idJOIN sys.database_principals pp ON roles.role_principal_id = pp.principal_idThe following script adds the TestUser to the db_datareader database role. Once this script has been executed, run the previous script to see the new entry in the sys.database_role_members system view.

EXECUTE sp_addrolemember@rolename = 'db_datareader',@membername = 'TestUser'

What can these users do?

The following query uses the sys.database_permissions system view to indicate which users had specific permissions inside the current database.

SELECT
dp.class_desc, dp.permission_name, dp.state_desc,ObjectName = OBJECT_NAME(major_id), GranteeName = grantee.name, GrantorName = grantor.nameFROM sys.database_permissions dpJOIN sys.database_principals grantee on dp.grantee_principal_id = grantee.principal_idJOIN sys.database_principals grantor on dp.grantor_principal_id = grantor.principal_id

Creating the autorun.inf file for my CDs, DVDs & Flash Drives

Creating the autorun.inf file for my CDs/DVDs/Flash Drives.


Contrary to what you may have heard from the RIAA, burning a CD-R or CD-RW is not an activity restricted only to music pirates. In many business situations, the burned CD is the best way to distribute information to a target audience. For communications involving PowerPoint presentations, HTML, PDF forms, Flash animations, or a number of other applications, the portable and durable CD has become a common delivery method.

The compact disk drive auto play feature, common to most operating systems, is a good way to simplify user experience. Auto play is controlled by a simple text-only file called autorun.inf. While there are dozens of software utilities available that will help you create the file, all you really need is a text editor and some basic knowledge.

Solution 1:
Create autorun.inf
The basic configuration of the autorun.inf states the program to run when the CD is inserted in the drive and the icon to display when the disk is viewed by Windows Explorer or other directory listing software. The text-only file, which resides in the root directory of the CD, should follow this pattern:

[autorun]
open=myprogram.exe
icon=myicon.ico

The icon file should also reside in the root directory of the CD.

Variations
Often the program you want to run will not be located in the root directory of the CD. If that is the case you must include the path:

[autorun]
open=folder1\folder1A\myfile.exe
icon=myicon.ico

Sometimes you may need to pass an argument to the program to be auto played:

[autorun]
open=myprogram.exe /argument
icon=myicon.ico

It's Not a program
Sending customers, salespeople, investors, and employees presentations, PDF files, and HTML documents requires a slight variation to the basic autorun.inf file and the addition of a DOS batch file to the CD root directory. The autorun.inf file opens a batch file, which then opens the file using the default program designated for that file type. For example:

[autorun]
open=autorun.bat index.htm
icon=myicon.ico

And the autorun.bat file reads:

echo off
@start %1 %2 %3 %4 %5 %6 %7 %8 %9
@exit

There is a variation on this idea that takes advantage of the ShellExecute command:

[autorun]
ShellExecute=index.htm
icon=training.ico

Using the autorun.inf file to auto play your burned CDs will prevent another headache for your users and increase the likelihood of reaching your target audience. And because it is a simple text file, it can be created with a text editor and your normal disk-burning software.

Solution 2:
Create autorun.inf
While creating your autorun.inf file according to Solution One will work for most of your users, it will fail for a small percentage who have issues with the autorun function in their particular installation of Windows. The batch file in the first solution makes no allowances for errors and will merely fail when an error is encountered.

This is where a shell utility can save the day, because these third-party applications contain routines for handling common errors and will complete the autorun process even if an error is encountered. For this example, we’ll use autorun.exe, which can be downloaded from Tarma Software Research. Tarma has made autorun.exe freely available for both personal and commercial use, and there are no requirements for copyright notices, etc.

To use autorun.exe, you make a simple modification to the autorun.inf file by replacing autorun.bat with the .exe file. The basic autorun.inf under this scenario would look like this:

[autorun]
open=autorun.exe index.htm
icon=myicon.ico

The only other requirement is that a copy of the 8KB autorun.exe file be included in the root directory of each burned CD. This application also contains several options and supports an extended autorun.inf structure that provides more flexibility in how you design your CD package.

Structured Computer Organization

Structured Computer Organization



Structured Computer Organization by Tanenbaum is a popular book to learn computer hardware and architecture. The book presents a layered approach that will guide us through the fundamental concepts of computer hardware.
DOWNLOAD LINK:
http://rapidshare.com/files/161443916/Structured_Computer_Organization--Tanenbaum_4th.rar