Servers

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.

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.

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.

DML and DDL Triggers in in Microsoft SQL Server 2008

• Nov 12, 2008
• Learn how to create DML triggers that execute when you add, modify, or remove rows in a table, in this lesson from Microsoft SQL Server 2008 Step by Step. You will also learn how to create DDL triggers that execute when DDL commands are executed or users log in to an instance.

Data Warehousing in Microsoft SQL Server 2008

• Oct 29, 2008
• This chapter from Programming Microsoft SQL Server 2008 explains what data warehousing is and why you should care about it, and then shows how to take advantage of specific Microsoft SQL Server 2008 data warehousing features.

Table Expressions in Microsoft SQL Server 2008 T-SQL

• Oct 22, 2008
• The focus of this chapter from Microsoft SQL Server 2008 T-SQL Fundamentals is SELECT queries against table expressions. This chapter also introduces the APPLY table operator used in conjunction with a table expression.

Remote Management in Windows Server 2008 Server Core

• Sep 17, 2008
• This chapter from Windows Server 2008 Server Core Administrator's Pocket Consultant examines each of these remote administration methods and demonstrates how to set them up and use them to manage Server Core.

Implementing Disk Management in Windows Server 2008

• Apr 16, 2008
• In this chapter from Windows Server 2008 Administrator's Companion, learn about the physical aspects of storage: the disk subsystem and how you manage and administer it. This includes disks, partitions, and volumes, along with logical drives. Also covered are the special features of the NTFS file system, including encryption and quotas. Throughout this chapter, the authors cover both the graphical way to do things and the command-line way.

Architecture of Windows Group Policy for Windows Server 2008 and Windows Vista

• Mar 5, 2008
• There have been some radical changes to the underlying implementation of Group Policy with Windows Vista and Windows Server 2008. Although the core dependencies have not changed, the core engine of Group Policy has changed for the better, as Derek Melber explains in this chapter from Windows Group Policy Resource Kit: Windows Server 2008 and Windows Vista.

Delegating the Administration of Windows Server 2008 Active Directory Domain Services

• Mar 5, 2008
• This chapter from Windows Server 2008 Active Directory Resource Kit describes administrative delegation, starting with a discussion of the various types of tasks that might be delegated within an enterprise. Then it describes object access, the types of permissions that can be assigned to objects residing within the directory, and how to use these permissions for delegation of administration. Finally, the chapter provides information about auditing changes to objects residing within AD DS.

Managing TCP/IP Networking in Windows Server 2008

• Feb 27, 2008
• This chapter from Windows Server 2008 Inside Out covers installing and configuring TCP/IP networking, managing network connections, and troubleshooting and testing network settings.

Extracting and Loading Data in Microsoft SQL Server 2005 Integration Services

• Jun 20, 2007
• Learn how to set up a new Microsoft SQL Server Integration Services (SSIS) project, add a data flow task to extract data from a source, and load the results into a destination in this chapter from Microsoft SQL Server 2005 Integration Services Step by Step.