Apr 06, 2012 |
3,503 views |
Book Description
Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Maximize your performance on the exam by learning to:
- Create and manage database objects
- Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity
- Create stored procedures, functions, and triggers
- Manage transactions, error handling, and change tracking
- Tune query performance
- Implement database mail, full-text search, Service Broker, scripts
- Work with XML and SQLCLR
Table of Contents
Chapter 1. Data Retrieval
Chapter 2. Modifying Data—The INSERT, UPDATE, DELETE, and MERGE Statements
Chapter 3. Tables, Data Types, and Declarative Data Integrity
Chapter 4. Using Additional Query Techniques Download Now »
Apr 06, 2012 |
3,151 views |
Book Description
Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Maximize your performance on the exam by learning to:
- Configure, manage, back up, and restore databases
- Create a partitioned table, index, or indexed view
- Configure services and components to manage your environment
- Help prevent unauthorized access at each security infrastructure layer
- Design and deploy high-availability solutions
- Manage SQL Server Agent jobs, alerts, and operators
- Identify service, concurrency, and job execution problems
Table of Contents
Chapter 1. Installing and Configuring SQL Server 2008
Chapter 2. Database Configuration and Maintenance
Chapter 3. Tables
Download Now »
Apr 04, 2012 |
5,585 views |
Book Description
Delve inside Windows architecture and internals—guided by a team of internationally renowned internals experts. Fully updated for Windows 7 and Windows Server 2008 R2, this classic guide delivers key architectural insights on system design, debugging, performance, and support—along with hands-on experiments to experience Windows internal behavior firsthand.
See how Windows components work behind the scenes:
- Understand how the core system and management mechanisms work
- Explore internal system data structures using tools like the kernel debugger
- Go inside the Windows security model to see how it authorizes access to data
- Understand how Windows manages physical and virtual memory
- Tour the Windows networking stack from top to bottom
- Troubleshoot file-system access problems and system boot problems
- Learn how to analyze crashes
Table of Contents
Chapter 1. Concepts and Tools
Chapter 2. System Architecture Download Now »
Apr 04, 2012 |
5,104 views |
Book Description
Introducing Microsoft® SQL Server® 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, application developers, and technical decision makers.
Table of Contents
Part I: Database Administration
Chapter 1. SQL Server 2012 Editions and Engine Enhancements
Chapter 2. High-Availability and Disaster-Recovery Enhancements
Chapter 3. Performance and Scalability
Chapter 4. Security Enhancements
Chapter 5. Programmability and Beyond-Relational Enhancements
Part II: Business Intelligence Development
Chapter 6. Integration Services
Chapter 7. Data Quality Services
Chapter 8. Master Data Services
Chapter 9. Analysis Services and PowerPivot
Chapter 10. Reporting Services Download Now »
Apr 02, 2012 |
3,109 views |
Book Description
Assess your readiness for MCTS Exam 70-680—and quickly identify where you need to focus and practice. This practical, streamlined guide walks you through each exam objective, providing “need to know” checklists, review questions, tips, and links to further study—all designed to help bolster your preparation.
Reinforce your exam prep with a Rapid Review of these objectives:
- Installing, Upgrading, and Migrating to Windows 7
- Deploying Windows 7
- Configuring Hardware and Applications
- Configuring Network Connectivity
- Configuring Access to Resources
- Configuring Mobile Computing
- Monitoring and Maintaining Systems That RunWindows 7
- Configuring Backup and Recovery Options
Table of Contents
Chapter 1. Installing, Upgrading, and Migrating to Windows 7
Chapter 2. Deploying Windows 7
Chapter 3. Configuring Hardware and Applications
Chapter 4. Configuring Network Connectivity
Chapter 5. Configuring Access to Resources Download Now »
Apr 02, 2012 |
2,691 views |
Book Description
Assess your readiness for MCTS Exam 70-662—and quickly identify where you need to focus and practice. This practical, streamlined guide walks you through each exam objective, providing “need to know” checklists, review questions, tips, and links to further study—all designed to help bolster your preparation.
Reinforce your exam prep with a Rapid Review of these objectives:
- Installing and Configuring Exchange Servers
- Configuring Exchange Recipients and Public Folders
- Configuring Client Access
- Configuring Message Transport
- Monitoring and Reporting
- Implementing High Availability and Recovery
- Configuring Message Compliance and Security Features
This book is an ideal complement to the in-depth training of the Microsoft Press® Training Kit and other exam-prep resources for Exam 70-662.
Table of Contents
Chapter 1. Installing and Configuring Exchange Servers
Chapter 2. Configuring Exchange Recipients and Public Folders Download Now »
