Chapter 2: Creating Database Objects

Books

Turley, Paul, and Dan Wood. Beginning Transact-SQL with SQL Server 2000 and 2005 . Wrox.

On the Web

Free SQL Server Help: http://sqlservercentral.com

SQL Server Books Online Help Facility

"SQL Server Database Engine -> Designing and Creating Databases"

"What's New in Microsoft SQL Server 2005"

"Full-Text Search"

"SQL Server Language Reference -> Transact-SQL Reference"

Chapter 3: Implementing Database Objects

Books

Ben-gan, Itzik, Dejan Sarka, and Roger Wolter. Inside Microsoft SQL Server 2005: T-SQL Programming . Microsoft Press.

Vieira, Robert. Beginning SQL Server 2005 Programming . Wrox.

On the Web

Choosing Between the CLR and T-SQL in SQL Server 2005: www.devx.com/dbzone/Article/28412

SQL Server Books Online Help Facility

"SQL Server Language Reference -> Transact-SQL Reference -> System Tables"

"SQL Server Language Reference -> Transact-SQL Reference -> System Views"

"SQL Server Database Engine -> Accessing and Changing Database Data"

"Full-Text Search"

Chapter 4: Supporting the XML Framework

Books

Klein, Scott. Professional SQL Server 2005 XML . Wrox.

On the Web

An Interview with Michael Rys on XQuery, SQL Server 2005, and Microsoft XML Technologies: www.stylusstudio.com/michael_rys.html

The Fundamentals of the SQL Server 2005 XML Datatype: www.developer.com/db/article.php/3531196

SQL Server 2005 Provides True Integration of XML Data: www.windowsitpro.com/Articles/Index.cfm?ArticleID=45131&DisplayTab=Article

SQL Server Books Online Help Facility

"SQL Server Language Reference -> Transact-SQL Reference -> CREATE ENDPOINT"

"What's New in SQL Server 2005 -> Database Engine Enhancements -> Database Engine XML Enhancements"

"SQL Server Database Engine -> Using XML in SQL Server"

Chapter 5: Data Consumption and Throughput

Books

Hamilton, Bill. Programming SQL Server 2005 . O'Reilly.

On the Web

SQL Server 2005 Service Broker: www.securedevelop.net/presentations/HDC2004/HDC2004_SQLServer2005ServiceBroker.pdf#search='SQL%20Server%202005%20service%20broker'

SQL Server Books Online Help Facility

"Tools and Utilities Reference -> Command Prompt Utilities -> bcp Utility"

"SQL Server Database Engine -> Administering the Database Engine -> Importing and Exporting Bulk Data"

"SQL Server Service Broker"

"SQL Server Language Reference -> Transact-SQL Reference -> CREATE ENDPOINT"

Chapter 6: Database Maintenance

Books

Nielson, Paul. SQL Server 2005 Bible . Wiley.

On the Web

SQL-Server-Performance.Com Forum/Database Maintenance Plan: www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9826

SQL Server Reference Guide/Database Maintenance: www.informit.com/guides/content.asp?g=sqlserver&seqNum=32&rl=1

SQL Server Books Online Help Facility

"SQL Server Database Engine -> Designing and Creating Databases -> Database Snapshots"

"SQL Server Database Engine -> Administering the Database Engine -> Backing up and Restoring Databases"

Chapter 7: Monitoring SQL Server Performance

On the Web

Idera Performance Enhancement: www.sql-server-performance.com

SQL Server Books Online Help Facility

"SQL Server Database Engine -> Administering the Database Engine -> Monitoring and Tuning for Performance"

Chapter 8: Troubleshooting and Optimizing SQL Server

On the Web

Inside SQL Server: www.insidesqlserver.com (The material was based on SQL Server 2000, with the 2005 release to come in the future.)

Solid Quality Learning: www.solidqualitylearning.com

SQL Server Books Online Help Facility

"SQL Server Database Engine -> Administering the Database Engine -> Monitoring and Tuning for Performance"

Flylib.com

Category list

Similar pages

Chapter 2: Creating Database Objects