To maximize your effectiveness as an SQL Server 2008 database administrator, you must keep track of hundreds of Transact-SQL commands, keywords, command arguments, options, and prompts - and Microsoft's MCTS 70-432 and MCITP 70-450 exams test you on many of those. Familiarizing yourself with all these commands is a daunting task. SQL Server 2008 Database Administrator Portable Command Guide: MCITP 70-432 and 70-450 brings them all together in one compact, portable, easy-to-use reference. Packed with configuration examples, real-world scenarios, and expert usage tips, this book covers everything IT professionals need to know about Transact-SQL 2.0 for SQL Server 2008, from basic concepts to advanced techniques. You'll learn how to use Transact-SQL to: * Work with the SQL Server Management Studio * Manipulate database objects and data * Write scripts involving Transactions, SQLCmd, and DAC * Manage backup and restore * Administer and maintain databases * Run system and user-defined stored procedures * Enforce security through database roles, logins, DDL triggers, data encryption, certificates, and keys * And much more It's the perfect take-anywhere guide to administering SQL Server 2008 databases - and passing Microsoft's two key SQL Server 2008 DBA exams.
- ISBN10 0789747391
- ISBN13 9780789747396
- Publish Date 28 September 2012
- Publish Status Out of Print
- Out of Print 15 March 2021
- Publish Country US
- Publisher Pearson Education (US)
- Imprint Pearson IT Certification
- Format Paperback
- Pages 350
- Language English