MCTS Fix

Ace up your sleeve with MCTS

Category Archives: Education

How to tune a database in MS SQL server 2005

Take the following steps to tune a database: 1. Run SQL Server Profiler from Start -programs – Microsoft SQL Server 2005 – Performance Tools – SQL Server Profiler.
2. In the SQL Server Profiler window, go to File – New Trace option.
3. In the Connect to Server window, select server name from the Server name drop-down list and click the Connect button.
4. In the TraceProperties dialog box, mention the Trace name. Click the Run button.
5. The trace will be created. In order to save the trace, go to File – Save As -Trace File option.
6. In the Save As dialog box, specify the path and name of the trace file. Click the Save button.
7. In the SQL Server Profiler window, go to Tools – Database Engine Tuning Advisor option. Note: You can also open Database Engine Tuning Advisor from Start – Programs – Microsoft SQL Server 2005 – Performance Tools – Database Engine Tuning Advisor.
8. In the Connect to Server window, select server name from the Server name drop-down list and click the Connect button.
9. In the Database Engine Tuning Advisor window, select the database for which you want to create a workload.
10. In order to select the trace file for creating a workload, select the Browse button. In the Select Workload File dialog box, select the trace file.
11. The location and name of the file is displayed in the text box. Click the Start Analysis button in the toolbar.
12. Click the Progress tab to view the tuning progress.
13. Click the Recommendations tab to view recommendations for index and partitions.
14. Click the Reports tab to view the report of the tuning.See the following video for more details:

Share

How to Make Computers Work Fast in 2 Simple Steps

Hello Friends !!

Below are the two simple steps you can use to make your computer work fast right-now.

The First step is to use the Disk Defragmenter tool to defrag your disk drives. To find this tool in your computer just navigate to the following path:

Start > All Program > Accessories > System Tools > Disk Defragmenter.

Play the following video to see how you to use the Disk Defragmenter tool:

The Second step is to use Disk Cleanup to delete unnecessary file from your computer.The path is as follows:

Start > All Program > Accessories > System Tools > Disk Cleanup

Use the following video to see the working of the Disk Cleanup tool:

After using both these tools you will see your computer is working fast.

Good Luck !!

Share

Error code: 0xC004F061

The error “0xC004F061″ is related to activation of Windows 7. Reason for this error is using a product key for an upgrade version of Windows 7 and a previous version of Windows wasn’t on your computer when Windows 7 was installed. Windows Vista or Windows XP must be installed on the computer before you install an upgrade version of Windows 7.

Do not format the drive before starting the installation process before upgrading the product key to activate Windows 7.

For more info visit:  Windows 7 activation error: invalid product key.

Share

How to create a relationship between two tables in Microsoft SQL Server 2005

Take the following steps to create a relationship:

   1. Run SQL Server Management Studio from Start – Programs – Microsoft SQL Server 2005 – SQL Server Management Studio.
   2. In the Connect to Server dialog box, click the Connect button.
   3. In the Microsoft SQL Server Management Studio window, double-click the Databases folder.
   4. In the Microsoft SQL Server Management Studio window, double-click the database.
   5. In the Microsoft SQL Server Management Studio window, double-click the Tables folder.
   6. Right-click the table and click Modify.
   7. The table will open in edit mode. Select the column for which a foreign key is to be assigned.
   8. Go to Table Designer – Relationships.
   9. The Foreign Key Relationships dialog box will open.
  10. In the Foreign Key Relationships dialog box, click the Add button to create the foreign key. Click the Browse button in the Tables and Columns Specification property.
  11. The Tables and Columns dialog box will open.
  12. Select the primary key table from the Primary key table dropdown list.
  13. Select the primary key column from the Primary key table dropdown list.
  14. Select the foreign key column from the Foreign key table dropdown list. Click the OK button.
  15. In the Foreign Key Relationships dialog box, click the Close button.
  16. In the Microsoft SQL Server Management Studio window, go to File – Save Customer (Customer is the name of the table.) to save the changes.

Share

Folders Become Shortcut: how to solve it

Hello friends !!

If your hard disk or pen drive is showing shortcut instead of folders, you can try the following solution:

  • Do not format your drive,
  • Check whether the files are not in hidden mode.
  • Click on “Start” –>Run–>type cmd and click on OK.
  • Enter this command:

attrib -h -r -s /s /d drive letter:\*.*

Note : Replace the drive letter with your drive letter

  • Now check for your files.

It works !!

Good Luck.

Share

Differences between function of Windows Server Backup and that of NTBACKUP

Windows Server 2008 includes a backup utility named Windows Server Backup which significantly differs from its predecessor application NTBACKUP. Some of the key differences are as follows:

  • Windows Server Backup does not support writing backup files to tape drives, NTBACKUP does.

  • The smallest object that can be backed up through Windows Server Backup is a volume instead of a file as in NTBACKUP.
  • With Windows Server Backup, backup files cannot be written to network locations or optical media during scheduled backup.
  • Windows Server Backup supports only NTFS-formatted volumes, whereas NTBACKUP supports FAT volumes, too.
  • Windows Server Backup writes output files as Virtual Hard Disk (VHD) files, whereas NTBACKUP writes output as .bkf files.
Share

MySQL Deployment

MySQL can be built and installed manually from source code, but this can be tedious so it is more commonly installed from a binary package unless special customizations are required. On most Linux distributions the package management system can download and install MySQL with minimal effort, though further configuration is often required to adjust security and optimization settings.

Though MySQL began as a low-end alternative to more powerful proprietary databases, it has gradually evolved to support higher-scale needs as well.

It is still most commonly used in small to medium scale single-server deployments, either as a component in a LAMP based web application or as a standalone database server. Much of MySQL’s appeal originates in its relative simplicity and ease of use, which is enabled by an ecosystem of open source tools such as phpMyAdmin.

In the medium range, MySQL can be scaled by deploying it on more powerful hardware, such as a multi-processor server with gigabytes of memory.

Share