Servers

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.