SQL Server 2008 and 2008 R2

SQL Server 2008 and 2008 R2

end of support is coming

SQL Server 2008 and SQL Server 2008 R2 will no longer be supported by Microsoft

starting in July 2019. Avoid challenges and vulnerabilities caused by end of support.

Why should you upgrade?

Mitigate risks with platform security and compliance

There will be no access to critical security updates, opening the potential for business interruptions and

loss of data.

Upgrade to better cost efficiency

Maintaining legacy servers, firewalls, intrusion systems, and other tools can get expensive quickly.

Modernize to innovate

Grow your environments with data, analytics and the cloud.

More than an upgrade

With SQL Server 2017 you don¡¯t just get an update¡ªyou get inmemory performance across workloads, mission-critical high

availability, and built-in security features to help protect your data

at rest and in motion.

SQL

#1 OLTP performance 1

#1 DW performance on 1TB 2 , 10TB 3 , and 30TB 4

#1 OLTP price/performance 5

Learn more about SQL Server 2017

#1 DW price/performance on 1TB 2 , 10TB 3 , and 30TB 4

End of support options for SQL Server 2008 and 2008 R2

Take advantage of the Azure

Hybrid Benefit

Extended Security Updates for

on-premises environments

Free Extended Security Updates

in Azure

Save when you migrate your SQL Server 2008

or 2008 R2 workloads to Azure SQL Database

with the Azure Hybrid Benefit for SQL Server.

Learn more.

Customers with Software Assurance or subscription

licenses may purchase Extended Security Updates

for three years of security updates for SQL Server

2008 and 2008 R2. Learn more.

Lift and shift your SQL Server 2008 workloads to

Azure with no application code changes. This

gives you more time to plan for end of support.

Learn more.

Learn more about SQL Server 2008 and 2008 R2 end of support

? 2018 Microsoft Corporation. All rights reserved.

All TPC Claims as of 1/19/2018. 1; 2; 3; 4; 5

Keep learning from the inside out¡ªand save!

Save 50% when you purchase the complete eBook edition of

SQL Server 2017 Administration Inside Out by William Assaf, Randolph

West, Sven Aelterman, and Mindy Curnutt.

Visit SQLAdmin to select title and use code

SQLADMIN during checkout to apply discount. The eBook is delivered

in EPUB, PDF, and MOBI to read on your preferred device.

Sign up to receive more special offers from Microsoft Press at

newsletters

Discount code valid on eBook purchase from and cannot be combined with another offer.

Microsoft Press products are published, marketed, and distributed by Pearson.

SQL Server 2017

Administration Inside Out

Second Edition

William Assaf

Randolph West

Sven Aelterman

Mindy Curnutt

Published with the authorization of Microsoft Corporation by:

Pearson Education, Inc.

Copyright ? 2018 by Pearson Education Inc.

All rights reserved. Printed in the United States of America. This publication is protected by copyright, and

permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system,

or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. For

information regarding permissions, request forms, and the appropriate contacts within the Pearson Education

Global Rights & Permissions Department, please visit permissions/. No patent liability is

assumed with respect to the use of the information contained herein. Although every precaution has been taken

in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is

any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-1-5093-0521-6

ISBN-10: 1-5093-0521-1

Library of Congress Control Number: 2017961300

Printed and bound in the United States of America.

1 18

Trademarks

Microsoft and the trademarks listed at on the ¡°Trademarks¡± webpage are trademarks

of the Microsoft group of companies. All other marks are property of their respective owners.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness

is implied. The information provided is on an ¡°as is¡± basis. The authors, the publisher, and Microsoft Corporation

shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising

from the information contained in this book or programs accompanying it.

Special Sales

For information about buying this title in bulk quantities, or for special sales opportunities (which may include

electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or

branding interests), please contact our corporate sales department at corpsales@ or (800) 382-3419.

For government sales inquiries, please contact governmentsales@.

For questions about sales outside the U.S., please contact intlcs@.

Editor-in-Chief: Greg Wiegand

Acquisitions Editor: Trina MacDonald

Development Editor: Mark Renfrow

Technical Editor: Louis Davidson

Managing Editor: Sandra Schroeder

Senior Project Editor: Tracey Croom

Editorial Production: Octal Publishing, Inc.

Copy Editor: Octal Publishing, Inc.

Indexer: Octal Publishing, Inc.

Proofreader: Octal Publishing, Inc.

Cover Designer: Twist Creative, Seattle

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download