SQL Server 2005 for Developers

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. 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 Annotation 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