Inside the book with Bob Beauchemin: Video Podcast
In this interview Bob Beauchemin describes who should read his book and what the developer will find inside. Listen to highlights of the most useful features of SQL Server 2005!
"I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or XML background and suddenly had an urgent need to learn it. SQL Server 2005 is too big of a release to learn from the books online. Fortunately, now there is a book for developers who need to go from SQL Server 2000 to SQL Server 2005 and to do it as painlessly as possible. Basically, it's one-stop shopping for serious developers who have to get up to speed quickly. I'll keep this one on my desk--not on my bookshelf. Well done, Bob and Dan!"
--Dr. Tom Moreau
SQL Server MVP and Monthly Columnist
SQL Server Professional, Brockman Moreau Consulting Inc.
"A SQL book truly for developers, from two authorities on the subject. I'll be turning to this book first when I need to understand a component of SQL Server 2005."
"An excellent book for those of us who need to get up to speed on what's new in SQL Server 2005. The authors made sure this book includes the final information for the release version of the product. Most other books out now are based on beta versions. It covers key areas from XML and SQLCLR to Notification Services. Although the wide variety of information is great, my favorite part was the advice given on when to use what, and how performance is affected."
Senior Software Developer
Blue Note Computing, Inc.
"SQL Server 2005 is a massive release with a large number of new features. Many of these features were designed to make SQL Server a great application development platform. This book provides comprehensive information about the SQL Server features of most interest to application developers. The lucid text and wealth of examples will give a developer a clear understanding of how to use SQL Server 2005 to a whole new class of database applications. It should be on every SQL Server developer's bookshelf."
"While there will be a lot of good books on SQL Server 2005 development, when people refer to the 'bible,' they'll be talking about this book."
--Dr. Greg Low
Readify Pty Ltd
"SQL Server 2005 is loaded with new features and getting a good overview is essential to understand how you can benefit from SQL Server 2005's features as a developer. Bob and Dan's book goes beyond enumerating the new SQL Server 2005 features, and will provide you with lots of good examples. They did a good job striking a balance between overview and substance."
Senior Program Manager, SQL Server
Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide--accurate, comprehensive, and packed with examples. A Developer's Guide to SQL Server 2005 starts where Microsoft's documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2
Download the Sample Chapter related to this title.
The .NET Framework and the Microsoft Platform 1
The .NET Framework's Effects on SQL Server 3
The SQL:1999 Standard: Extending the Relational Model 8
User-Defined Types and SQL Server 11
XML: Data and Document Storage 14
Web Services: XML As a Marshaling Format 20
Client Access . . . And Then There Are Clients 22
Extending SQL Server into the Platform: Service Broker and Notification Services 24
Where Are We? 26
Why Care How Hosting Works? 27
What Is a .NET Framework Runtime Host? 29
SQL Server As a Runtime Host 31
Loading the Runtime: Processes and AppDomains 40
Safe Code: How the Runtime Makes It Safer to Run "Foreign" Code 43
Where the Code Lives: Storing .NET Framework Assemblies (CREATE ASSEMBLY) 46
Assembly Dependencies: When Your Assemblies Use Other Assemblies 49
Assemblies and SQL Schemas: Who Owns Assemblies (Information Schema) 51
Maintaining User Assemblies (ALTER ASSEMBLY, DROP ASSEMBLY) 55
Specification Compliance 58
Where Are We? 60
Extending SQL Server 61
CLR Extension Basics 63
CLR Extension Details 74
Parameters and Return Value 93
User-Defined Functions 93
Table-Valued Functions 99
Stored Procedures 106
Where Are We? 110
Programming with SqlClient 111
Context: The SqlContext Class 115
Commands: Making Things Happen 121
Obtaining Results 124
Creating and Sending New Rowsets 137
Using the WindowsIdentity 139
Calling a Web Service from SQLCLR 140
Exception Handling 143
SqlClient Classes That You Can't Use on the Server 150
Where Are We? 151
Why Do We Need User-Defined Types? 153
Overview of User-Defined Types 154
Creating a User-Defined Type 157
Where Are We? 217
New Security Features in SQL Server 2005 219
Optional Features Are Turned Off by Default 221
A Quick Review of SQL Server Security Concepts with Enhancements 224
SQL Server Password Policies and Credentials 235
Encryption Keys and Built-In Encryption Functions 238
Encryption Functions 242
Separation of Users and Schemas 248
Specifying Execution Context for Procedural Code 253
Code Signing 259
SQL Server Permissions and SQLCLR Objects 261
Assembly Permissions: Who Can Catalog and Use an Assembly? 262
What .NET Framework Code Can Do from within SQL Server: Safety Levels 268
Where Are We? 275
Improvements to the SQL Engine 277
SNAPSHOT Isolation 278
Data Definition Language Triggers 289
Event Notifications 294
Large Value Data Types 298
Loading Data with the New BULK Provider 301
Statement-Level Recompilation 301
Query Hints, Plan Guides, and Plan Forcing 303
Where Are We? 309
Improvements to Transact-SQL 311
Error Handling 312
INTERSECT and EXCEPT 326
ON DELETE and ON UPDATE 333
Download the Foreword related to this title.
Download the Index file related to this title.