Servers

Administering Microsoft SQL Server 2012 Databases: Clustering and AlwaysOn

• Jul 15, 2012
• In this chapter from Training Kit (Exam 70-462): Administering Microsoft SQL Server 2012 Databases, you learn about how to deploy both failover clustering and AlwaysOn Availability 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.

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.

Creating Your First Table in Microsoft SQL Server

• Feb 15, 2013
• In this chapter from Microsoft SQL Server 2012 Step by Step, you will first learn the importance of implementing and enforcing a naming standard. From there, you will be introduced to the various data types that are supported by SQL Server. Then you will create your first table using Microsoft SQL Server Management Studio (SSMS) and Transact-SQL (T-SQL). Finally, you will use the same methods to add constraints and keys to your tables.

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.

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.

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.

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.

Foundations of Querying Microsoft SQL Server 2012

• Dec 15, 2012
• Transact-SQL (T-SQL) is the main language used to manage and manipulate data in Microsoft SQL Server. This chapter lays the foundations for querying data by using T-SQL. The chapter describes the roots of this language, terminology, and the mindset you need to adopt when writing T-SQL code. It then moves on to describe one of the most important concepts you need to know about the language—logical query processing.

Implementing a Data Warehouse with Microsoft SQL Server 2012: Dynamic Packages

• Dec 15, 2012
• When you are developing Microsoft SQL Server Integration Services (SSIS) packages, it is a good practice to make each task or transformation as dynamic as possible. To do this, you can use the new features in SQL Server 2012, such as parameters and project-level connection managers, or you can use the package configurations that were first made available in the package deployment model in earlier versions of SQL Server. This chapter discusses both possibilities.

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.

Implementing Policy-Based Management in Microsoft SQL Server

• Feb 15, 2012
• Policy-Based Management is an extensible and scalable configuration framework that you can use to manage servers, databases, and other objects in your data environments. As an administrator, you need to be very familiar with how Policy-Based Management technology works, and that’s exactly what this chapter is about.

Introducing SQL Server Data Tools

• Jul 15, 2012
• In this chapter from Programming Microsoft SQL Server 2012, you’ll learn how to use SSDT inside Visual Studio to significantly enhance your productivity as a SQL Server developer. It begins with an overview of key SSDT concepts and features, and then goes through demonstrations of various connected and disconnected scenarios.

Managing File Systems and Drives in Windows Server 2008

• Dec 28, 2009
• Wherever disk resources are located, your job as a system administrator is to manage them. The tools and techniques you use to manage file systems and drives are discussed in this chapter from Windows Server 2008 Administrator's Pocket Consultant, 2nd Edition.

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.

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.

Managing User Data in a Windows Server 2008 R2 Remote Desktop Services Deployment

• Dec 8, 2010
• This chapter from Windows Server 2008 R2 Remote Desktop Services Resource Kit shows you how best to configure profiles and Folder Redirection using the tools that come with Windows.

Managing Your SQL Servers

• Feb 15, 2012
• In this chapter from Microsoft SQL Server 2012 Pocket Consultant, you will learn how to use SQL Server Management Studio.

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.