Row Compression Implementation

This topic summarizes how the Database Engine implements row compression. This summary provides basic information to help you plan the storage space that you need for your data. Enabling compression only changes the physical storage format of the data that is associated with a data type but not its syntax or semantics. Application changes are not…

Read More

Page Compression Implementation

This topic summarizes how the Database Engine implements page compression. This summary provides basic information to help you plan the storage space that you need for your data. Note The details of data compression are subject to change without notice in service packs or subsequent releases. Page compression is similar for tables, table partitions, indexes, and index…

Read More

Setting Server Configuration Options

You can manage and optimize SQL Server resources through configuration options by using SQL Server Management Studio or the sp_configure system stored procedure. The most commonly used server configuration options are available through SQL Server Management Studio; all configuration options are accessible through sp_configure. Consider the effects on your system carefully before setting these options….

Read More

RESTORING ACTIVE DIRECTORY USING WBADMIN AND NTDSUTIL

You can use wbadmin, which is the command-line component of the WindowsServer Backup snap-in, to perform a nonauthoritative restore of Active Directory, which restores a single Active Directory domain controller to its state before the backupwbadmin start sysstaterecovery -version:MM/DD/YYYY-HH:MM-backuptarget:targetDrive:-machine: BackupComputerName-quiet Rebooted your domain controller intoDirectory Services Restore Mode, and that you have already performed a nonauthoritativerestore using wbadmin.1….

Read More

Windows 2008 backup with wbadmin & ntdsutil

Open the command prompt: C: ntdsutilntdsutil: help -> to access the help filesntdsutil: IFMntdsutil: Activate Instance NTDSntdsutil: IFMifm: help -> to access the help filesifm: Create Full %s(the backup folder name) C: wbadmin start systemstatebackup -backupTarget:d(the backup drive): wbadmin restoreC: wbadmin get versionsC: wbadmin start systemstaterecovery version: (location)C: ntdsutil ntdsutil: activate instance ntdsntdsutil: authoritative restoreauthoritative restore:…

Read More

Windows Server 2008 R1 Edition Comparison

Windows Server 2008 comes in several major editions derived from the same code base. The most important differences among editions are in the number of processors, amount of physical memory, and high-availability features supported. The edition specifically targeted at servers with Itanium CPUs, Windows Server 2008 for Itanium-Based Systems (IA64), is not listed in the…

Read More

Force Replication Between Domain Controllers

Applies To: Windows Server 2008, Windows Server 2008 R2 You can use this procedure to force Active Directory replication to occur between two domain controllers on a one-time basis when you want changes to be replicated from the server that received the changes to a server in another site sooner than the site link schedule allows….

Read More

GUI for Windows Server 2008 Core Installation

You have likely heard about the “Core” installation role in Windows Server 2008 which does not have a GUI, but is all command line based. This is a great role to use for branch offices, for Hyper-V servers and some other roles that are typically managed remotely. If you want to install the server core…

Read More

How the Global Catalog Works

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2, Windows Server 2008, Windows Server 2008 R2 In a multidomain Active Directory® Domain Services (AD DS) forest, the global catalog provides a central repository of domain information for the forest by storing partial replicas of all domain…

Read More

Virtualization Smackdown 2: Oracle VM VirtualBox 3.2 vs. VMware Workstation 7.1

Summary: Two titans battle for desktop virtualization supremacy. Who will reign supreme? Two titans battle for desktop virtualization supremacy. Who will reign supreme? Welcome, True Believers. Two years ago, we visited the subject of free desktop virtualization hypervisors. At the time, the two preferred free solutions were Sun’s xVM VirtualBox and and VMware Server 2.0. Things have…

Read More