Microsoft Press eBooks Page 3

Expert recommendations, pragmatically applied. Automate system administration using Windows PowerShell best practices-and optimize your operational efficiency. With this practical guide, Windows PowerShell expert and instructor Ed Wilson delivers field-tested tips, real-world examples, and candid advice culled from administrators across a range of business and technical scenarios. If you're an IT professional with Windows PowerShell experience, this book is ideal. Discover how to: Use Windows PowerShell to automate Active Directory tasks Explore available WMI classes and methods with CIM cmdlets Identify and track scripting opportunities to avoid duplication Use functions to encapsulate business logic and reuse code Design your script's best input...

Ace your preparation for the skills measured by MCTS Exam 70-431-and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you';ve learned by applying your knowledge to real-world case scenarios and practices. 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: Install and configure SQL Server Create tables and indexes, define columns, and implement constraints Implement functions, stored procedures, and triggers by using Transact-SQL Work with relational and XML data Monitor, troubleshoot and tune queries Maintain database availability with log shipping, database mirroring, and ...

You';re beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It';s all muscle and no fluff. Discover how the experts tackle Excel 2007-and challenge yourself to new levels of mastery! ul liLearn expert techniques for designing powerful spreadsheets/li liApply built-in functions-or write your own-and carry out complex calculations/li liUse rich charting capabilities and new SmartArt graphics to visually represent data/li liPerform sophisticated data analysis: financial, statistical, and what-if/li liDesign PivotTable reports to dynamically analyze data/li liShare spreadsheets and collaborate with colleague...

Automate everyday administrative tasks-and take greater control of your Windows networks-with this hands-on guide to scripting. Your instructor, a Microsoft Certified Trainer with more than a decade of enterprise consulting experience, expertly builds your scripting expertise with labs and lessons you complete at your own pace. From writing your first scripts from scratch with Microsoft Visual Basic Scripting Edition (VBScript) and Windows Script Host (WSH)-to exploring the programmatic advantages of using Windows Management Instrumentation (WMI) and Active Directory Service Interface (ADSI)-you'll learn timesaving ways to set up, deploy, and manage your Windows-based systems.Teach yourself how to write and run scripts to: Automate folder and file ma...