Servers

Microsoft SQL Server 2012 Internals: Special Storage

• Nov 15, 2013
• This chapter from Microsoft SQL Server 2012 Internals looks at how SQL Server stores data that doesn’t use the typical FixedVar record format and data that doesn’t fit into the usual 8 KB data page.

Planning Your Report Design in Microsoft SQL Server 2012 Reporting Services

• Apr 15, 2013
• The purpose of this chapter from Microsoft SQL Server 2012 Reporting Services is to help you think about how to prepare for the report development process. Knowing who will view reports and how they want or need to interact with reports has an impact on how you should design those reports.

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.

Overview of Microsoft SQL Server 2012

• Feb 15, 2013
• In this chapter from Microsoft SQL Server 2012 Step by Step, you will examine the components and features of Microsoft SQL Server 2012 and determine how they fit into your installation.

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.

Querying Full-Text Data in Microsoft SQL Server 2012

• Dec 15, 2012
• Microsoft SQL Server 2012 enhances the full-text search support that was substantially available in previous editions. This chapter explains how to use full-text search and even semantic search inside a SQL Server database.

Troubleshooting Windows Startup and Shutdown Problems

• Sep 15, 2012
• This chapter, from Windows Internals, Part 2, 6th Edition, describes the steps required to boot Windows and the options that can affect system startup.

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.

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.

Microsoft SQL Server 2012 Analysis Services: DAX Basics

• Jul 15, 2012
• In this chapter from Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model, learn about the syntax of DAX, its data types, and the available operators and functions.

Single-Table Queries in Microsoft SQL Server 2012

• Jul 15, 2012
• This chapter from Microsoft SQL Server 2012 T-SQL Fundamentals introduces you to the SELECT statement, logical query processing, and various other aspects of single-table queries.

SQL Windowing

• Apr 15, 2012
• This chapter from Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions provides the background of window functions, a glimpse of solutions using them, coverage of the elements involved in window specifications, an account of the query elements supporting window functions, and a description of the standard’s solution for reusing window definitions.

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.

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.

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 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.

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.

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.