โ Scribed by Vieira, Robert
No coin nor oath required. For personal study only.
Microsoft SQL server 2008 programming.
Introduction. Chapter 1: Being Objective: Re-Examining Objects in SQL Server. Chapter 2: Tool Time. Chapter 3: Asking a Better Question: Advanced Queries. Chapter 4: XML Integration. Chapter 5: Daring to Design. Chapter 6: Core Storage and Index Structure. Chapter 7: More Advanced Index Structures. Chapter 8: Views. Chapter 9: Scripts and Batches. Chapter 10: Advanced Programmability. Chapter 11: Transactions and Locks. Chapter 12: Triggers. Chapter 13: SQL Cursors. Chapter 14: Reporting Services. Chapter 15: Buying in Bulk: The Bulk Copy Program (BCP) and Other BasicBulkOperations. Chapter 16: Getting Integrated. Chapter 17: Replication. Chapter 18: Looking at Things in Full: Full-Text Search. Chapter 19: Feeling Security. Chapter 20: A Grand Performance: Designing a Database That Performs Well. Chapter 21: What Comes After: Forensic Performance Tuning. Chapter 22: Administration. Chapter 23: SMO: SQLManagement Objects. Chapter 24: Data Warehousing. Chapter 25: BeingWell Connected. Appendix A: System Functions. Appendix B: Going Meta: Getting Data About Your Data. Appendix C: The Basics. Index.
Client/server computing;Database management;SQL server
๐ SIMILAR VOLUMES
SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a data
Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutionsUpdated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment sc