SQL Srvr2K BOL Favorites

Back Home Up Next


Favorites (in my opinion) to bookmark in SQL Books Online
(on the Search TAB use the "Search titles only" option):

Did you know you could transfer your BOL bookmarks (Favorites) from one computer to another? Thanks to student, Jeffrey Bible, here's the tip.

After you've bookmarked some favorites look for the file ""hh.dat" found typically under c:\documents and settings\user X\Application Data\Microsoft\HTML Help". You must expose hidden and system files in Windows Explorer to find the file. Then, transfer the file to the appropriate location on the target computer.

Accessing SQL Server Using HTTP
          [See also "Creating the nwind
                 Virtual Directory", and "URL Access"]

Additional SQL Server Resources
          (Under "Getting Started")
Assigning an sa Password

Autocommit Transactions

Backing Up and Restoring Databases
BACKUP
CAST and CONVERT
Color Coding in SQL Query Analyzer
Configuring Linked Servers
Copying Databases
Creating the nwind Virtual Directory
            (for accessing the Northwind database
                 through a web page)
Cursors
            (underneath "Accessing and Changing
                  Relational Data")
Data Placement Using Filegroups
Data Types (and "Using Data Types")
Database Backups
Database Object Owner
Database Owner (dbo)
DBCC
Designing a Backup and Restore Strategy
Designing an Index
Deterministic and Non-Deterministic functions
Encrypting Views
Glossary
Guest User [see also "public Role"]
Graphically Displaying the Execution Plan Using SQL Query Analyzer
Managing Events
Multiserver Administration
Normalization
Northwind Sample Database
OLE DB Providers Tested with SQL Server
Pages and Extents
Performing an Unattended Installation
Physical Database Files and Filegroups
public Role [see also "Guest User"]
Remote Setup Information
Renaming a Database
RESTORE
Retrieving and Writing XML Data
Roles
SELECT statement (Transact-SQL Reference)
Shrinking a Database
Specifiying Batches
SQL-DMO API (for scripting purposes)
SQL-DMO Object Tree
SQL Query Analyzer
Keyboard Shortcuts
SQL Server Architecture Overview
Starting SQL Server Manually
System Administrator (sa) Login
System Databases and Data
System Stored Procedures
Transactions
Transact-SQL Syntax Conventions
URL Access
Using @@ERROR
Using Data Types (see also "Data Types")
Using Encryption Methods

Using Identifiers as Object Names
Partial example...


Here's a head start...