Mastering SQL server 2008 /
Lee, Michael, 1966-
Mastering SQL server 2008 / Michael Lee, Gentry Bieker. - Indianapolis, Ind. : Wiley Pub., 2009. - xxvi, 766 p : ill, ; 25 cm.
Includes index.
Overview of Microsoft SQL Server 2008 -- Understanding SQL Server Architecture. -- Databases, Files, and Resource Management. -- Tables and CRUD Operations. -- Procedural programming. -- Managing Data Integrity. -- SQL Server and XML. -- Managing User Security. -- Data Recovery. -- Monitoring SQL Server Activity. -- Using the SQL Server Agent Service. -- Data Availability and Distribution. -- SQL Server Data Security. -- Indexing Strategies for Query Optimization. -- Transactions and Locking Strategies. -- Using Resource Governor and Policy-Based Management. -- SQL Server and the .NET Client. -- Leveraging the SQL Server .NET CLR. -- Using Spatial Data. -- Service Oriented Architecture and the Service Broker. -- Full Text Search Services.
Mastering SQL Server 2008continues the approach of the previous editions by providing complete, accurate, and expert coverage of the product. The material is aimed at IT professionals who need coverage of the basics with a quick ramp up to intermediate and advanced database topics. Mastering SQL Server 2008addresses a host of critical topics.
9780470289044
2008042924
SQL server.
Client/server computing.
Relational databases.
005.7585
Mastering SQL server 2008 / Michael Lee, Gentry Bieker. - Indianapolis, Ind. : Wiley Pub., 2009. - xxvi, 766 p : ill, ; 25 cm.
Includes index.
Overview of Microsoft SQL Server 2008 -- Understanding SQL Server Architecture. -- Databases, Files, and Resource Management. -- Tables and CRUD Operations. -- Procedural programming. -- Managing Data Integrity. -- SQL Server and XML. -- Managing User Security. -- Data Recovery. -- Monitoring SQL Server Activity. -- Using the SQL Server Agent Service. -- Data Availability and Distribution. -- SQL Server Data Security. -- Indexing Strategies for Query Optimization. -- Transactions and Locking Strategies. -- Using Resource Governor and Policy-Based Management. -- SQL Server and the .NET Client. -- Leveraging the SQL Server .NET CLR. -- Using Spatial Data. -- Service Oriented Architecture and the Service Broker. -- Full Text Search Services.
Mastering SQL Server 2008continues the approach of the previous editions by providing complete, accurate, and expert coverage of the product. The material is aimed at IT professionals who need coverage of the basics with a quick ramp up to intermediate and advanced database topics. Mastering SQL Server 2008addresses a host of critical topics.
9780470289044
2008042924
SQL server.
Client/server computing.
Relational databases.
005.7585