Mastering Microsoft SQL Server 2008
Paperback Engels 2009 1e druk 9780470289044Samenvatting
Whether you're a database administrator or application developer, this in-depth guide is your key to delivering improved data collection, storage, reporting, and security with SQL Server 2008. 'Mastering Microsoft SQL Server 2008'brings you up to speed on architecture, installation, and configuring essentials, before moving to the step by step instruction you need for more advanced topics such as procedural programming, query optimization, how to use spatial data, SQL Server in the .NET world, and more.
You'll master the extensive toolset, explore useful thrid-party tools, and most important, find out how to choose and use the right SQL Server features for the specific tasks you have.
Coverage includes:
- Installing and configuring
- SQL server 2008
- Understanding SQL Server's place within the Microsoft architecture
- Making data reliable and efficiently available to your consumers
- Securing your data with SQL Server 2008's new transparant data encryption feature
- Integrating XML technology into SQL Server
- Creating index architectures for maximum benefits and minimum cost
- Exploring new geometry and geography data types for today's business
- Maximizing data warehousing and business intelligence tools
Specificaties
Lezersrecensies
Inhoudsopgave
U kunt van deze inhoudsopgave een PDF downloaden
1. Overview of Microsoft SQL Server 2008.
2. Understanding SQL Server Architecture.
3. Databases, Files, and Resource Management.
4. Tables and CRUD Operations.
5. Procedural programming.
6. Managing Data Integrity.
7. SQL Server and XML.
8. Managing User Security.
9. Data Recovery.
10. Monitoring SQL Server Activity.
11. Using the SQL Server Agent Service.
12. Data Availability and Distribution.
13. SQL Server Data Security.
14. Indexing Strategies for Query Optimization.
15. Transactions and Locking Strategies.
16. Using Resource Governor and Policy-Based Management.
17. SQL Server and the .NET Client.
18. Leveraging the SQL Server .NET CLR.
19. Using Spatial Data.
20. Service Oriented Architecture and the Service Broker.
21. Full Text Search Services.
Appendices:
A: The Bottom Line
B: SQL Server Analysis Services Overview
C: SQL Server 2008 Reporting Services
Index
Vaak samen gekocht
Anderen die dit boek kochten, kochten ook
-
Anton Greve€ 12,95 -
Liang, Y.€ 88,24
-
Marian van Olst€ 24,95
-
E. Lockhart€ 11,00
-
Bert Koene€ 14,99
-
Bratko, Ivan€ 93,69
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan
