SQL Server 2005 for Developers

✍ Scribed by Robert Ericsson, Jason Cline

• Year: 2006
• Tongue: English
• Leaves: 416
• Edition: 1
• Category: Library

✦ Synopsis

Capturing and analyzing data about customers, products, and the market is essential to staying competitive. Microsoft SQL Server is a leading database tool, and with its ease of use and low total ownership cost, you can customize it to meet your ever-changing business needs. SQL Server 2005 has many enhanced tools that fall into three main categories: data management, developer tools, and business intelligence. SQL Server 2005 for Developers teaches you how to leverage these new tools by covering the topics relevant to developers. Samples throughout the book illustrate the features of SQL Server 2005 in a realistic manner, and provide insights into the new ways for developers to manipulate servers and databases. Specific discussions of similarities and differences between SQL Server 2005 and past versions allow you to use what you already know and apply it efficiently. After working through the book, you'll be up to speed and ready to integrate SQL Server 2005 into your own projects.

✦ Table of Contents

Contents......Page 8
What is SQL Server?......Page 12
SQL Server History......Page 13
What is in this Book?......Page 14
2 Database Design......Page 18
Informal Rules of Database Design......Page 23
Normalization......Page 30
Design of Example Application......Page 34
Conclusion......Page 39
3 Database Security......Page 40
Access Control......Page 42
Security Analysis......Page 45
SQL Server Security Design Principles......Page 48
SQL Server 2005 Security Model......Page 49
SQL Server 2005 Security Features Authentication Modes......Page 50
Encryption......Page 51
User and Schema Separation......Page 53
Execution Context......Page 56
Signed Modules......Page 57
Password Policy Enforcement......Page 59
Row-Level Security......Page 61
Granular Permissions......Page 62
SQL Server 2005 Security Best Practices......Page 63
Conclusion......Page 65
4 Transact-SQL for Developers......Page 66
Syntax Elements......Page 67
Basic Statements......Page 85
Additional Transact-SQL Language Enhancements......Page 100
Conclusion......Page 107
5 Programmability......Page 110
Assemblies......Page 111
User-Defined Types......Page 114
Stored Procedures......Page 120
User-Defined Functions......Page 125
Triggers......Page 129
Aggregates......Page 134
Conclusion......Page 137
6 ADO.NET 2.0......Page 138
New ADO.NET 2.0 Features......Page 140
Conclusion......Page 160
7 Notification Services......Page 162
Notification Applications......Page 163
Management and Operations......Page 179
Conclusion......Page 182
8 XML in SQL Server 2005......Page 184
XML Basics......Page 185
Native Storage for XML......Page 186
XML Query......Page 192
SQL Server Native Web Services......Page 201
Conclusion......Page 204
9 Service Broker......Page 206
Asynchronous Queuing......Page 208
Programming Model......Page 212
Service Broker Security......Page 224
Conclusion......Page 225
10 Performance Analysis and Tuning......Page 226
A Journey, Not a Destination......Page 227
Performance Factors......Page 228
Tools......Page 237
Conclusion......Page 248
11 Business Intelligence......Page 250
Challenges......Page 251
Providing Value......Page 256
Delivering Value......Page 258
SQL Server 2005 Business Intelligence Features......Page 262
Conclusion......Page 269
12 Data Warehouse......Page 272
Top-Down versus Bottom-Up......Page 274
Data Warehouse versus Transactional Systems......Page 276
Dimensional Modeling......Page 280
Sizing of a Data Warehouse......Page 284
Data Preparation and Cleansing......Page 289
Loading Data......Page 291
Conclusion......Page 293
13 SQL Server Integration Services......Page 294
DTS Packages......Page 296
Containers......Page 297
Workflow......Page 300
Data Flow......Page 305
Logging......Page 307
SQL Server Import/Export Wizard......Page 308
Designer......Page 314
Conclusion......Page 324
Reporting......Page 326
Report Design......Page 328
Reporting Services Architecture......Page 332
Conclusion......Page 336
15 OLAP......Page 338
Introduction to Analysis Services......Page 339
OLAP Basics......Page 340
The Unified Dimensional Model......Page 342
Analysis Services Architecture......Page 344
MDX......Page 348
MDX Scripts......Page 349
Example......Page 354
Conclusion......Page 364
Data Mining Fundamentals......Page 366
References......Page 404
About the CD-ROM......Page 406
A......Page 408
C......Page 409
D......Page 410
F......Page 411
M......Page 412
P......Page 413
S......Page 414
T......Page 415
X......Page 416