Sample chapters

Supporting Windows 7 Users with Remote Assistance

• Oct 7, 2009
• This chapter from Windows 7 Resource Kit examines how Remote Assistance works in Windows 7, how to use it to support end users, and how to manage it using Group Policy and scripts.

Adding, Removing, and Managing Programs in Windows 7

• Sep 23, 2009
• In this chapter from Windows 7 Inside Out, learn the hoops and hurdles and everything else having to do with the addition, removal, updating, and management of applications in Windows 7.

Temporary Tables and Table Variables in Microsoft SQL Server 2008 T-SQL Programming

• Sep 23, 2009
• In this chapter from Inside Microsoft SQL Server 2008 T-SQL Programming, get a clear picture of how the different temporary object types behave, in which circumstances you should use each, and whether you should use them at all.

How to Navigate Windows and Folders in Windows 7

• Sep 16, 2009
• In this chapter from Windows 7 Step by Step, you’ll first learn how to size, arrange, hide, and otherwise manage windows on your desktop. You’ll learn about the standard file storage structure Windows 7 uses, and about the types of files you’ll find on your Windows 7 computer. Then you’ll explore the Windows 7 file storage structure. You’ll also experiment with searching for files by using the different search methods that are available.

MCTS Self-Paced Training Kit (Exam 70-653): Managing and Configuring Remote Access in Windows Small Business Server 2008

• Aug 19, 2009
• This chapter from MCTS Self-Paced Training Kit (Exam 70-653): Configuring Windows Small Business Server 2008 discusses secure access to the server using self-issued and third-party certificates, default Remote Web Workplace settings, how to configure Remote Web Workplace, as well as how to enable and configure a virtual private network (VPN) in Windows SBS.

MCTS Self-Paced Training Kit (Exam 70-652): Securing Hosts and Virtual Machines

• Jun 17, 2009
• This chapter from MCTS Self-Paced Training Kit (Exam 70-652): Configuring Windows Server Virtualization introduces you to securing Hyper-V host servers and the virtual machines they run.

Processes, Threads, and Jobs in the Windows Operating System

• Jun 17, 2009
• In this chapter from Windows Internals, 5th Edition, learn the data structures and algorithms that deal with processes, threads, and jobs in the Windows operating system. The first section focuses on the internal structures that make up a process. The second section outlines the steps involved in creating a process (and its initial thread). The internals of threads and thread scheduling are then described. The chapter concludes with a description of the job object.

Customizing Microsoft Dynamics AX 2009

• Jun 10, 2009
• This chapter from Inside Microsoft Dynamics AX 2009 describes how to customize Microsoft Dynamics AX 2009 inventory tables and classes to implement new inventory dimensions, explains how to customize forms in Dynamics AX, describes how to customize reports in Dynamics AX, and explains how to customize the number sequence classes in Dynamics AX to implement a new number sequence.

Moving from Virtual Server 2005 R2 to Hyper-V

• Jun 10, 2009
• Moving from Virtual Server 2005 R2 SP1 to Hyper-V involves migrating both the Virtual Server host and the virtual machines. This chapter from Windows Server 2008 Hyper-V Resource Kit will provide you with guidance about what should be moved, how to move it, when to move it, and other important considerations you need to be aware of during the process.

Managing Partitions and Database Processing in Microsoft SQL Server 2008 Analysis Services

• Apr 15, 2009
• This chapter from Microsoft SQL Server 2008 Analysis Services Step by Step explains how Analysis Services physically processes and stores data. The explanations are simplified, but they encompass some of the most complex topics in this book. If nothing else, this chapter can give you an appreciation for the sophistication and elegance of the Analysis Services server design.

Microsoft SQL Server 2008 Business Intelligence Development and Maintenance: Developing SSRS Reports

• Apr 15, 2009
• In this chapter from MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL Server 2008 Business Intelligence Development and Maintenance, you will first learn how to create SSRS projects and reports in Business Intelligence Development Studio (BIDS). You will also see how to develop report objects by using the Report Designer and how to work with advanced report object properties. You will then see how to use a SQL Server Analysis Services (SSAS) database as the source for your report. And last, after looking at how to create a dataset from a data source, you will learn how to apply dataset filters and groups.

Aggregating and Pivoting Data in Microsoft SQL Server 2008 T-SQL

• Mar 25, 2009
• This chapter from Inside Microsoft SQL Server 2008 T-SQL Querying covers various data-aggregation techniques, including using the OVER clause with aggregate functions, tiebreakers, running aggregates, pivoting, unpivoting, custom aggregations, histograms, grouping factors, and grouping sets.

Microsoft SQL Server 2008 Internals: Transactions and Concurrency

• Mar 11, 2009
• In general, database systems can take two approaches to managing concurrent data access: optimistic or pessimistic. Learn the basic differences between the two models, the five possible isolation levels in SQL Server 2008, and the internals of how SQL Server controls concurrent access using each model. Also learn how to control the isolation level, and understand the metadata that shows you what SQL Server is doing, in this chapter from Microsoft SQL Server 2008 Internals.

Configuring Connections and Connecting to Data in Microsoft .NET Framework 3.5

• Feb 25, 2009
• This chapter from MCTS Self-Paced Training Kit (Exam 70-505): Microsoft .NET Framework 3.5 Windows Forms Application Development describes how to create the various connection objects that are used to connect applications to different data sources and sets the basis for working with data in the following chapters.

Microsoft SQL Server 2008 Reporting Services: Deploying Reports to a Server

• Feb 25, 2009
• This chapter from Microsoft SQL Server 2008 Reporting Services Step by Step shows you how to deploy reports to the report server, organize content on the report server by using folders, create a linked report on a native-mode report server, override report parameter settings, manage authentication in data sources, control report execution, and create and store report snapshots in history.

Working with Time in Microsoft SQL Server 2008 MDX

• Feb 25, 2009
• Analysis Services provides a number of time-based MDX functions. Using these functions, powerful metrics can be assembled. In this chapter from Microsoft SQL Server 2008 MDX Step by Step, you learn how to employ the time-based MDX functions to calculate some of the more frequently requested of these metrics.

Designing Policy Based Management in Microsoft SQL Server 2008

• Feb 18, 2009
• In this chapter from MCTS Self-Paced Training Kit (Exam 70-432): Microsoft SQL Server 2008 Implementation and Maintenance, learn about the new Policy Based Management framework that allows you to check and enforce policy compliance across your entire SQL Server infrastructure.

Managed Memory Model in the .NET Framework

• Feb 18, 2009
• This chapter from Solid Code is a practical discussion of the Garbage Collector and the memory mode of the .NET Framework.

Windows Group Policy: Deploying Group Policy

• Feb 11, 2009
• This chapter from Windows Group Policy Administrator's Pocket Consultant describes the changes Group Policy has seen in each Windows release. It also shows how to keep group policy current, apply and link group policy objects, use default policies, and use policy preferences and settings.

Understanding SSAS in SSMS and SQL Server Profiler

• Feb 4, 2009
• In this chapter from Smart Business Intelligence Solutions with Microsoft SQL Server 2008, learn the ins and outs of some tools you’ll use when working with Microsoft SQL Server Analysis Services (SSAS) objects. After reading this chapter, you’ll be an expert in not only SQL Server Profiler but also SQL Server Management Studio (SSMS) and other tools that will make your work in SSAS very productive.