Lesson 1 - Getting Started on SQL Server 2008

SQL Server 2008 comes in many different editions. The edition you choose will depend on your requirements. If you are looking for a free database management system, you will need to choose one of the Express editions or the Compact edition. You could also try the Evaluation edition, which allows you to trial SQL Server 2008 for 180 days.

Enterprise Edition

• Data management and business intelligence platform providing enterprise class scalability, high availability, and security for running business-critical applications
• Standard Edition
  Data management and business intelligence platform providing ease of use and manageability for running departmental applications
• Workgroup Edition
  Data management and reporting platform providing secure, remote synchronization, and management capabilities for running branch applications
• Developer Edition
  May be installed and used by one user to design, develop, test, and demonstrate your programs on as many systems as needed
• Web Edition
  A low-TCO, scalable, and manageable database option for web hosters and end customers looking to deploy publicly facing web applications and services
• Express Edition
  A free edition of SQL Server ideal for learning and building desktop and small server applications and for redistribution by ISVs
• Compact Edition
  A free, SQL Server embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and web clients
• Evaluation Edition
  This edition may be installed for demonstration and evaluation purposes until an expiration period of 180 days.

SQL Server 2008 Requirements

Hardware Component	Requirement
Processor	Pentium III 2-Ghz processor (32-bit or 64-bit)
Memory	2GB
Hard disk	280 MB - Minimal Install 1700 MB - Full Install Installation process requires 2 GB of free space on system drive

 

Software Component	Requirement
Operating system	Windows XP (SP2) Windows Server 2003 SP2 Windows Vista,windows 7,windows 8 Windows Server 2008,2012
.Net Framework	.Net Framework 3.5
Windows Installer	Windows Installer 4.5 or later
Microsoft Data Access Components (MDAC)	MDAC 2.8 SP1 or later
Microsoft Internet Explorer	Internet Explorer 6 SP1

Launching SQL Server 2008 Management Studio


Hope you got it understood well :-)

Thanks & Regards

Srikanth Goud- Virtualization Administrator

SQL Server 2008 R2 database administration learning course

As I am fallowing and learning Sql server administration From Trainsignal and other web information sites.  as per my guidance and knowledge iam posting few topics.  

                       SQL Server 2008 R2 database administration

Lesson :-1 
 
Getting Started on SQL Server 2008
  SQL Server Version History
  SQL Server 2008 Editions
  What's New in SQL Server 2008?

  Install SQL Server 2008
  SQL Server 2008 Requirements
  Downloading SQL Software
  SQL Server Security
  Installing SQL Server 2008
  SQL Server Installation Center Overview
  New SQL Server Stand-Alone Installation
  Launching SQL Server 2008 Management Studio

Lesson :- 2
  SQL Server 2008 Manageability
  Central Management Servers
  Policy-Based Managements

Lesson :-3 
 SQL Server 2008 Performance
  Resource Governor
  Data Collector

Lesson :-4
  SQL Server 2008 Security Enhancement
  Encrypting Databases
  SQL Server Audit

Lesson :-5
  SQL Server Database Development Enhancements
  Transact-SQL Enhancement
  SQL Server Management Studio Enhancement

Lesson :-6
    Backup Compression

Hack windows 8 user and password

Forgetting your password is never any fun, but luckily there’s a really easy way to reset the password. All you need is a copy of the Windows installation disk and one simple command line trick.
Boot off the Windows disk and select the “Repair your computer” option from the lower left-hand corner.



Follow through until you get to the option to open the Command Prompt, which you’ll want to select.


Next enter these command one by one (make sure to replace C in the first command to the appropriate drive letter for your Windows partition, if it’s different in your case)

C:
cd windows
cd system32
copy cmd.exe cmd.exe.original
copy Utilman.exe Utilman.exe.original
del Utilman.exe
ren cmd.exe Utilman.exe

Once you get to the login screen, click the Ease of Access button at the bottom left corner. Based on the commands that we used in the previous step, this will open a Command Prompt window instead of the Ease of Access menu.
net user Srikanth password
That’s all there is to it. Now you can login.
After successfully unlocking  your account and resetting the account password now you need to roll back the changes you
made to Utilman.exe and cmd.exe, so go ahead and boot your pc with the System Recovery CD
c: and hit Enter key(your Windows drive maybe different so change it accordingly to the drive letter you have)

cd windows 
c:\windows
 
cd system32
c:\windows\system32


del  Utilman.exe 
c:\windows\system32\ del Utilman.exe

 ren  Utilman.exe.original Utilman.exe
c:\windows\system32\ ren Utilman.exe.original Utilman.exe

 ren cmd.exe.original cmd.exe 
c:\windows\system32\ren cmd.exe.original cmd.exe
hen the PCc reboots and reaches the logon screen, check to see if the Utilman is fixed and returned back to place by
clicking on its icon on the bottom left side of the screen,

Thanks & Regards

Srikanth Goud- Virtualization Administrator

Hack windows 7 user

Forgetting your password is never any fun, but luckily there’s a really easy way to reset the password. All you need is a copy of the Windows installation disk and one simple command line trick.
Boot off the Windows disk and select the “Repair your computer” option from the lower left-hand corner.

Follow through until you get to the option to open the Command Prompt, which you’ll want to select.

Next enter these command one by one (make sure to replace C in the first command to the appropriate drive letter for your Windows partition, if it’s different in your case)

C:
cd windows
cd system32
copy cmd.exe cmd.exe.original
copy Utilman.exe Utilman.exe.original
del Utilman.exe
ren cmd.exe Utilman.exe

Once you get to the login screen, click the Ease of Access button at the bottom left corner. Based on the commands that we used in the previous step, this will open a Command Prompt window instead of the Ease of Access menu.
net user Srikanth password
That’s all there is to it. Now you can login. 

Thanks & Regards

Srikanth Goud- Virtualization Administrator