IT Tutorials, Guides, Videos, and More

Web Building

Introduction to the Web	Hosting a Website on Your Own Webserver	How to Make Your Website SEO Friendly
Setting Up a Website	Hosting a Website with a Web Hosting Company	Tips to Make Your Website User Friendly
Getting a Domain Name	Comparing Web Hosting Options	Create an RSS Feed for your Website
Hosting DNS Servers for Your Domain	Creating a Blog Site	Create a Sitemap XML File for your Website
Types of Websites	How to Submit Your Website to Search Engines	Generating Income from your Website

SQL

Introduction to SQL	SQL SELECT INTO	MySQL DATE Function
What is ODBC?	SQL AVG Function	MySQL EXTRACT Function
Install SQL Server	SQL COUNT Function	MySQL DATE_ADD Function
SQL SELECT Statement	SQL MIN Function	MySQL DATE_SUB Function
SQL INSERT INTO Statement	SQL MAX Function	MySQL DATEDIFF Function
SQL DELETE Statement	SQL SUM Function	MySQL DATE_FORMAT Function
SQL UPDATE Statement	SQL UPPER, UCASE Function	SQL DROP Statement
SQL Order By Keyword	SQL LOWER, LCASE Function	SQL TRUNCATE Table Statement
SQL TOP Clause	SQL LEN Function	SQL CREATE DATABASE Statement
SQL Where Clause	SQL ISNULL, NVL, and IFNULL Function	SQL CREATE TABLE Statement
SQL AND/OR Operators	SQL ROUND Function	SQL CREATE VIEW Statement
SQL LIKE Operator and Wildcards	SQL Date Functions Overview	SQL ALTER Statement
SQL IN Operator	Date Formatting	Stored Procedures
SQL Between Operator	SQL GETDATE Function	Stored Procedure Parameters
Assigning an Alias to Columns and Tables	SQL DATEPART Function	SQL IF…ELSE Statement
Joining Tables and Views	SQL DATEADD Function	SQL Cursors
SQL INNER Join	SQL DATEDIFF Function	Sending Email Using CDOSYS
SQL LEFT Join	MySQL NOW Function	Returning Data From a Stored Procedure
SQL RIGHT Join	MySQL CURDATE Function	Querying Active Directory from SQL
SQL FULL Join	MySQL CURTIME Function	Leveraging Temporary and Variable Tables in SQL
SQL UNION Operator

VBScript

Accessing the Local Registry Using VBScript	How to Pass Parameters to VBScript	Send an Email Message Using VBScript
Configure TCP/IP Settings via Script	Mapping Network Drives Using VBScript	How to Delete Files Older than "x" Days Old
Create a Pop-up Message using VBScript

Basic Networking

Ethernet Crossover Cable	What is a VLAN?	Using PING to Test for Network Connectivity
Using NSLOOKUP to Troubleshoot DNS Issues	How IP Packets are Routed on a Local Area Network	Ping and ICMP Error Messages
Installing a Loopback Adapter	Using the Windows Route Command

Virtualization

Why MultiBoot When You Can Virtualize?	Configuring Guests on Virtual PC 2007	Installing a Host Loopback Adapter
How to Install Microsoft Virtual PC 2007	Editing the MAC Address for Guests	Support for Hyper-V?

Windows XP

How to Install Windows XP	Create a Shortcut for Your Network Connections	Creating Local User Accounts
Automatic Private IP Addressing (APIPA)	How to Configure Proxy Settings in Internet Explorer	Installing IPv6 in Windows XP
Disabling Automatic IP Addressing (APIPA)	Enable and Disable Proxy Settings via Shortcut	Tweak: Speed Up the Windows Start Menu
Configuring a TCP/IP Alternate Configuration	How to Enable TCP/IP Forwarding in Windows XP	Windows 2000/XP Automatic Logon

Windows 8

Windows 8 Developer Preview Download

Configure Oracle VirtualBox for Windows 8

How to Install Windows 8 Developer Preview

Windows Server 2008

What is New with Active Directory 2008 R2	Windows Server 2008 R2 DNS Issues (EDNS0)	Restore AD Deleted Objects Without a Recycle Bin
Windows Server 2008 R2 - 32 bit Available?	Do Not Use Recursion vs Disable Recursion	Restoring the Default Domain GPOs
Windows Server 2008 System Requirements	How to be Authoritative for a Single Host Name in DNS	Metadata Cleanup for Active Directory 2000/2003
Windows Server 2008 R2 System Requirements	Delete PTR Records with Uppercase Characters	Metadata Cleanup for Active Directory 2008
Windows Server 2008 R2 Upgrade Paths	What is Split-Brain, Split-Horizon, Split-DNS	Modifying the Behavior of Inter-Site Replication
How to Install Microsoft Windows Server 2008	Preparing Your Active Directory Infrastructure for 2008	Preventing Users from Joining the Domain
Best Practices for Server Management	Implementing a Password Policy	Redirecting Computer Objects to a Specific OU
How to Change a Service Path to Executable	Troubleshooting Password Policy Issues	Active Directory Group Types and Scopes
Enable IP Forwarding on Windows Server 200x	Password Policy FAQs	Locating Inactive Computer Accounts in AD
Share vs NTFS Permissions	Changing the Password Expiry Warning Period	Copying Attributes From a Template User Object
Network Port Requirements for Windows Systems	Object Naming Convention	Change the Display Names of Active Directory Users
Manging the Network Connectivity Status Indicator	Choosing a Domain Name for your Active Directory	How to Enable the AD 2008 R2 Recycle Bin
How to Install RSAT on Windows Server 2008 R2	Validate your Active Directory Schema Version	Active Directory Search Limit
DNS Client Settings for Domain Controllers	Using Single Label DNS Names for Active Directory	Accessing Resources Across AD Forests
TCP/IP NetBIOS and Host Name Resolution	Windows NT 4.0 and 2008 R2 Domain Trusts	Active Directory Trust Relationships
Install the Windows Server 2008 DNS Service	Windows 2008 Read-Only Domain Controllers (RODCs)	Designing Active Directory for a SOHO Network
How to Add a Secondary DNS Server	Selective Authentication Between AD Forests	Active Directory Site Link Costs
Understanding DNS Aging and Scavenging	What is the Active Directory Schema?	AdminCount, AdminSDHolder, and SDProp
Understanding GlobalNames Zone in Windows 2008	The Physical Structure of Active Directory	Common Active Directory User Attributes
What is Root Hints?	The Core of Active Directory	The DHCP Process: Negotiating a Lease
What is an SOA Record in DNS?	What is FSMO?	The DHCP Relay Agent
Configure DNS Forwarding in Windows 2003	The Schema Master	Using Conflict Detection in DHCP
DNS Conditional Forwarding in Server 2003	The Domain Naming Master	Load Balancing DHCP Using Split Scopes
DNS Conditional Forwarding in Server 2008	The Infrastructure Master	Increasing IP Lease Availability in DHCP
Configuring Wildcard DNS Records	The PDC Emulator	DHCP Reservation Limitations in Windows 2008 R2
DNS Records and Security	The RID Master	Moving the DHCP Database
Delegating DNS Rights and Permissions to Users	What are Active Directory Global Catalog Servers?	Unauthorizing DHCP Servers
DNS Resolver Cache and Time-to-Live (TTL)	Service Location (SRV) Resource Records	Best Practices When Running WINS On Your Network
DNS Creates Reverse Lookup Zones by Default	Filtering Administrators From Local Computer Policy	WINS NetBIOS Unique and Group Names
DNS May Fail to Resolve Top-Level Domain