SQL Server 2000 and 2005
(SQL Server 2008 coming soon)

Microsoft SQL Server 2005 provides a new Management Studio, integration with Visual Studio 2005, and the Microsoft .NET common language runtime - all of which help you build, debug, and operate applications faster and more efficiently.
SQL Server 2005 provides a comprehensive business intelligence platform for data integration, analysis, and reporting that helps you turn insight into action and make better decisions, faster.
SQL Server 2005 supports the highest performance, availability and security to run your most demanding applications with native data encryption, secure default settings, and password policy enforcement.

Top

This Script is used to create a Backup for a Filegroup

BACKUP DATABASE [TestDB] -- backup the database in the [ ]
FILEGROUP = N'PRIMARY' -- backup just the primary file group
TO  DISK = N'F:\Backup\TestDB.bak'-- the backup file to create
WITH NOFORMAT, NOINIT, -- Format the tape, NoInit = append to existing file
NAME = N'AW_IT_assets-Full Filegroup Backup', -- name of the tape
SKIP, NOREWIND, NOUNLOAD -- skip errors, don't rewind when done, eject tape when done.
GO

Top

This Script is used to create a Database

use master
go
create database TestDB -- database name of new database
on (name = 'transacttestdb', -- logical name of the file (used by SQL Server)
   filename = 'C:\TestDB\TestDB.mdf', -- primary file of the database
size = 20 mb, -- default size is 20mb
filegrowth = 0) -- default filegrowth as specified by SQL Server (usually 10% of starting size a.k.a. 2mb)
log on (name ='transacttestdb_log', -- log file for the database
   filename = 'D:\TestDB\TestDB_log.ldf', -- should be on a seperate disk for better performance.
size = 5 mb, -- default size should be 1/4th of the data file size
filegrowth = 0) -- default filegrowth as specified by SQL Server (usually 10% of starting size a.k.a. 500KB)

Top

SQL Server 2005 Books

Inside Microsoft SQL Server 2005: The Storage Engine This practical, hands-on book offers deep, thorough coverage of the internals of architecture and resource management in SQL Server 2005, focusing on the Storage Engine. The book features extensive code samples and table examples.

Programming Microsoft SQL Server 2005 Get the straightforward information you need to learn the core programmability features in SQL Server 2005. This guide offers hands-on programming instruction, practical examples, and code samples to help you design and develop robust database applications and business intelligence solutions.

Microsoft SQL Server 2005: Database Essentials Step by Step The popular, learn-by-doing tutorial—updated for SQL Server 2005. Teach yourself the fundamental techniques for designing, building, testing, and deploying SQL Server databases—one step at a time.

Microsoft SQL Server 2005: Applied Techniques Step by Step A skill-building, learn-by-doing tutorial to help developers and database administrators with basic product knowledge begin to master SQL Server 2005.

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft SQL Server 2005 Announcing an all-new Microsoft Certified IT Professional (MCITP) Training Kit designed to help maximize your performance on Exam 70-443, an exam for the new MCITP: Database Administrator certification. This kit packs the tools and features exam candidates want most—including in-depth, self-paced training based on final exam content; rigorous, objective-by-objective review; exam tips from expert, exam-certified authors; and a robust testing suite. It also provides real-world scenarios, case study examples, and troubleshooting labs for skills and expertise that you can apply to the job. Top

SQL Server 2000 Books

Microsoft SQL Server 2000 Reporting Services Step by Step Teach yourself how to author, deploy, and manage reports over the Web with SQL Server Reporting Services—one step at a time! Learn how to exploit the range of reporting capabilities at your own pace through hands-on exercises and practical examples.

Microsoft SQL Server 2000 DTS Step by Step Teach yourself how to develop a data movement application with SQL Server 2000 Data Transformation Services (DTS)—one step at a time! Discover the full range of DTS capabilities at your own pace through dozens of hands-on exercises and code examples.

Microsoft SQL Server 2000 High Availability Ensuring 24/7 database availability is crucial to your company’s success. Discover the best ways to help keep your critical, Microsoft SQL Server 2000–based systems up and running—and secure—with this in-depth guide, straight from the source.

MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, Exam 70-228, Second Edition Learn how to install, configure, and administer SQL Server 2000—as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.

MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition—as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks. Top