Free online sql Server  dba learning​​ 


microsoft sql training online free

Licensing for multicore processors is the same as for single-core processors: only a single license is required for each multicore processor. Another way of saying this is licensing is per CPU socket, not per processor core.

The following is space requirements for SQL Server installing

Installing SQL Server 


Installation Walkthrough
The following sections walk you through a typical installation scenario step by step. We bring up important points of information along the way, providing a real-world perspective on the process. No past experience with SQL Server is required to understand these sectionsNetwork Protocol Support

The following network protocols are supported for all editions (where applicable):

  • Shared memory (but not for failover clusters)
  • Named pipes
  • TCP/IP (required for SQL Server endpoint communications)
  • Virtual Interface Adapter (VIA)

To explain the few terms

Shared Memory
This is the simplest protocol of all the other protocols available in SQL Server. The limitation is that the client applications must reside on the same machine where the SQL Server is installed.

Named Pipes
This protocol can be used when your application and SQL Server resides on a local area network. A part of memory is used by one process to pass information to another process, so that the output of one is the input of the other. The second process can be local (on the same computer as the first) or remote (on a networked computer).

This is the most popular and common protocol widely used throughout the industry today. It communicates across interconnected networks and is a standard for routing network traffics and offers advanced security features.

Virtual Interface Adapter (VIA) protocol works with VIA hardware. This protocol has been deprecated and will no longer be available in the future versions of SQL Server.

Running Multiple Simultaneous Editions

You can install multiple editions of SQL Server 2008 on the same machine and run them simultaneously. This capability comes in handy when you need to test code or other feature functionality on one edition versus another, such as when your development and deployment environments differ. In fact, you can even install and run SQL Server 2008 Enterprise Evaluation Edition on XP SP2 (not supported for the non–Evaluation Enterprise Edition) if you need to test an Enterprise Edition feature on a non–Windows Server system.

You can quickly ascertain the SQL Server edition you’re running by executing this T-SQL query:

select serverproperty(‘edition’)

Installation Walkthrough
The following sections walk you through a typical installation scenario step by step. We bring up important points of information along the way, providing a real-world perspective on the process. No past experience with SQL Server is required to understand these sections.

SQL Server 2008 is actually version 10 of the product, just as SQL Server 2005 is version 9, and SQL Server 2000 was version 8, which succeeded SQL Server 7. SQL Server 2008 R2 is considered version 10.5. Although versioning by year seems straightforward, it may obfuscate the reasoning behind the naming convention used for many installed items, such as shared folder names (for example, Microsoft SQL Server\100), SQL Server instance folder names (for example, \MSSQL10_50.MSSQLSERVER), and so on. In addition, SQL Server 2000 servers appear as version 8 when registered in SSMS (and elsewhere). You can still administer many aspects of SQL Server 2000 instances via the 2008 and 2008 R2 management tools.

NEXT PAGE >>>>>>>>>>

Software Requirements

The following software prerequisites must be installed on any server running any SQL Server edition:

  • Microsoft Internet Explorer 6.0 Service Pack 1 (SP1) or later (required because it is a dependency of SMSS, Books Online, Business Intelligence Development Studio [for Analysis Services], and the ReportDesigner)
  • Windows Installer 4.5 or later (sometimes distributed by Microsoft Windows Update services; also will be installed by the SQL Server Installation Center) .
  • .NET Framework 3.5 SP1, SQL Server Native Client and SQL Server Setup support files (if not installed already, these are also installed by SQL Server Installation Center)

 The following is the software and operating system requirements for SQL Server 2008, by edition.

 Installing SQL Server is the first and one of the easiest tasks you’ll accomplish as an administrator. And even though it may take as little as 15 minutes to get SQL Server 2008 up and running by clicking through the install screens and accepting the defaults (Next, Next, Next...), it is crucial to first understand the meaning of each install option and its ramifications for your environment.

What’s New in Installing SQL Server 2008
The installation process has been completely revamped for SQL Server 2008, introducing enhancements to simplify the installation compared to SQL Server 2005. The new installation features for SQL Server 2008 include the following:

  • A new SQL Server 2008 Installation Center landing page, which includes a number of options for planning, installing, and maintaining a SQL Server implementation, as well as links to SQL Server documentation for planning and reviewing before starting the install.
  • New maintenance tasks available in the installation process, allowing DBAs to either repair a corrupt SQL Server 2008 installation or conduct a feature upgrade. The Feature Upgrade Wizard allows DBAs to upgrade or change their installed edition of SQL Server 2008 (for example, upgrading from Standard Edition to Enterprise Edition without having to perform a complete reinstall).
  • A discovery report that provides details on all SQL Server components, features, and settings associated with an installation. . The potential to automate SQL Server installations by using an existing configuration file.
  • An Advanced Cluster Preparation tool, which streamlines and prepares a SQL Server 2008 failover cluster installation. 

With the release of Service Pack 1, SQL Server 2008 also now supports Slipstream installation. Slipstreaming is a method of integrating a SQL Server 2008 update (such as a service pack or cumulative update) with the original installation media so that the original media and update are installed at the same time. This capability can be a huge timesaver over having to manually apply service packs or cumulative updates after performing a full installation.

Installation Requirements
Before you install SQL Server 2008 on your server, it’s a good idea (even if you own the latest-and-greatest system) to review the hardware and software requirements. The next two sections gather all the fine print into a few conveniently organized tables.

The SQL Server 2008 installer helps determine whether your system meets the minimum requirements by running the new System Configuration Checker (SCC) early in the install. SCC conveniently provides a savable (via a button click) textual report on its results (and displays them onscreen). SCC is covered in detail later in this page.

Hardware Requirements

To install SQL Server 2008, you must ensure your system possesses a few basic components:

  • A pointing device
  • A display device with resolution of at least 1024×768 (required by SQL Server Management Studio [SMSS])
  • A DVD-ROM or CD-ROM drive (for installation from disc)

The below lists server environment hardware requirements, by SQL Server edition, with reference to processor type and/or word length. This table lists the base minimum hardware requirements. In most installations, you want to have at least 2GB of memory and a 2GHz or faster processor. In addition, installation using a redundant array of disks (RAID) on production systems is highly recommended.

Of course, faster editions of processors, increased RAM, and more disk space don’t negatively impact any installation either. One final (and perhaps obvious) note: The more SQL Server components you install, the more disk space you need. Analysis Services, for example, requires an additional 90MB of disk space for the install.The hard disk space requirements for SQL Server are dependent on which SQL Server components are installed.

The following is Hardware requirements for installing SQL Server