컴퓨터/IT 개발/프로그래밍 , 컴퓨터/IT IT 해외원서
[체험판] SQL Server 2017 Administrator's Guide
판매가 | 무료 |
- 출간 정보
- 2018.02.09. 전자책 출간
- 파일 정보
- 12.3MB
- 31쪽
- ISBN
- 9781786467324
- ECN
- -
리디 접속이 원활하지 않습니다.
강제 새로 고침(Ctrl + F5)이나 브라우저 캐시 삭제를 진행해주세요.
계속해서 문제가 발생한다면 리디 접속 테스트를 통해 원인을 파악하고 대응 방법을 안내드리겠습니다.
테스트 페이지로 이동하기
컴퓨터/IT 개발/프로그래밍 , 컴퓨터/IT IT 해외원서
판매가 | 무료 |
* 이 책은 본권의 일부를 무료로 제공하는 체험판입니다.
* 본권 구입을 원하실 경우, [이 책의 시리즈]→[책 선택] 후 구매해주시기 바랍니다.
<[체험판] SQL Server 2017 Administrator's Guide> ▶Book Description
Take advantage of the real power of SQL Server 2017 with all its new features, in addition to covering core database administration tasks. This book will give you a competitive advantage by helping you quickly learn how to design, manage, and secure your database solution.
You will learn how to set up your SQL Server and configure new (and existing) environments for optimal use. After covering the designing aspect, the book delves into performance-tuning aspects by teaching you how to effectively use indexes. The book will also teach you about certain choices that need to be made about backups and how to implement a rock-solid security policy and keep your environment healthy. Finally, you will learn about the techniques you should use when things go wrong, and other important topics - such as migration, upgrading, and consolidation - are covered in detail. Integration with Azure is also covered in depth.
Whether you are an administrator or thinking about entering the field, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2017.
▶What You Will Learn
⦁ Learn about the new features of SQL Server 2017 and how to implement them
⦁ Build a stable and fast SQL Server environment
⦁ Fix performance issues by optimizing queries and making use of indexes
⦁ Perform a health check of an existing troublesome database environment
⦁ Design and use an optimal database management strategy
⦁ Implement efficient backup and recovery techniques in-line with security policies
⦁ Combine SQL Server 2017 and Azure and manage your solution by various automation techniques Perform data migration, cluster upgradation and server consolidation
▶Key Features
⦁ Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution
⦁ Design and configure, manage, and secure a rock-solid SQL server
⦁ Comprehensive guide in keeping your SQL server disaster proof and all-time availability
▶Who This Book Is For
This book targets database administrators with an interest in SQL Server 2017 administration. Readers are expected to have some experience with previous SQL Server versions.
▶What this book covers
⦁ Chapter 1, Setting Up SQL Server 2017, is a reader's guide through the SQL Server installation process. This chapter also covers all the prerequisites needed for a successful installation of SQL Server. Overview of the SQL Server technology set is also provided in order to show the reader which services and features are used for particular tasks.
⦁ Chapter 2, Keep Your SQL Server Environment Healthy, is about maintaining a healthy database environment on SQL Server 2017. This can be used as a complete guide on what to check when you need to manage a new database server, find the root cause of an issue, or start at a new DBA job. You'll immediately get a good feeling and view of what's going on.
⦁ Chapter 3, Backup and Recovery, provides comprehensive information about all the backup and disaster recovery options offered by SQL Server 2017. Many complex examples are shown and explained throughout this chapter.
⦁ Chapter 4, Securing Your SQL Server, is about securing SQL server 2017. This is a very important chapter on the basics, on how to secure your data with different factors.
⦁ Chapter 5, Disaster Recovery Options, is where the available disaster recovery options are discussed in detail. Replication will be discussed in detail, with different options. Log shipping and mirroring are the options available options for disaster recovery. Also, database snapshot is discussed. Later in the chapter, which option should be selected is also discussed.
⦁ Chapter 6, Indexing and Performance, introduces a wide set of tools and techniques for performance monitoring in its first section alongside with some usage scenarios. The second section describes types of indexes and their internal structures.
⦁ Chapter 7, Troubleshooting SQL Server Environment and Internals, covers troubleshooting, a wide and diverse subject. In this book, this chapter will mainly focus on troubleshooting Windows Server and the SQL Server database engine. Troubleshooting queries/indexes is taken care of by Chapter 6, Indexing and Performance.
⦁ Chapter 8, Migration and Upgrade, explains migration, upgrading, and consolidation, a very important part of working with SQL Server.
⦁ Chapter 9, Automation –. Using Tools to Manage and Monitor SQL Server 2017, shows how SQL Server 2017 helps to automate a routine and regularly repeated administrator tasks.
⦁ Chapter 10, Always On High Availability Features, covers the free tools available to monitor and manage a SQL Server installation. This will include health reviews, performance monitoring, backup, and so on.
⦁ Chapter 11, In-Memory OLTP –. Why and How to Use it, In-Memory OLTP is quite new approach of data handling when the data contention is huge. This chapter goes through several use cases for In-Memory OLTP, with detailed descriptions of each feature used.
⦁ Chapter 12, Combining SQL Server 2017 with Azure, explains that using a cloud environment fully or partially is very advantageous and SQL Server does not stay aside. The last chapter goes through many scenarios of cooperation between SQL Server and Azure. Every scenario is shown as a working example.
▶Editorial Review
SQL Server is a very complicated set of end-to-end data processing technologies, and its correct functioning is crucial for every business. This book leads the reader through all the substantial topics a good administrator has to know in a professional job of provisioning, securing, maintaining, and monitoring SQL Server.
⦁ Marek Chmel
Marek Chmel is an IT consultant and trainer with more than 10 years of experience. He's a frequent speaker who specializes on Microsoft SQL Server, Azure, and security topics. Marek writes for Microsoft's TechnetCZSK blog, and since 2012 he's been an MVP: Data Platform. Marek is also recognized as a Microsoft Certified Trainer: Regional Lead for Czech Republic for few years in a row, he holds many MCSE certifications, and on the top of that he's a ECCouncil Certified Ethical Hacker and holder of several eLearnSecurity certifications.
He earned his MSc (business and informatics) degree from Nottingham Trent University. He started his career as a trainer for Microsoft server courses. Later, he joined AT&T as a senior database administrator with a specialization in MSSQL Server, data platforms, and machine learning.
⦁ Vladimír Mužný
Vladimír Mužný has been a freelance developer and consultant since 1997. His first steps with SQL Server were done on version 6.5 and from that times the working with all next versions of SQL Server has been never stopped.
Now Vladimir teaches Microsoft database courses and also participates on SQL Server adoption in companies and also on projects for production tracking and migrations.
SQL Server 2017 Administrator's Guide is his first attempt to share his knowledge and experience with people around the world, but writing is a strong drug and if possible, Vladimir is interested to share other namely his development experiences with others.
▶TABLE of CONTENTS
1: SETTING UP SQL SERVER 2017
2: KEEPING YOUR SQL SERVER ENVIRONMENT HEALTHY
3: BACKUP AND RECOVERY
4: SECURING YOUR SQL SERVER
5: DISASTER RECOVERY OPTIONS
6: INDEXING AND PERFORMANCE
7: TROUBLESHOOTING SQL SERVER ENVIRONMENT AND INTERNALS
8: MIGRATION AND UPGRADE
9: AUTOMATION - USING TOOLS TO MANAGE AND MONITOR SQL SERVER 2017
10: ALWAYS ON HIGH AVAILABILITY FEATURES
11: IN-MEMORY OLTP - WHY AND HOW TO USE IT
12: COMBINING SQL SERVER 2017 WITH AZURE
0.0 점
0명이 평가함
내가 남긴 별점 0.0
별로예요
그저 그래요
보통이에요
좋아요
최고예요
'구매자' 표시는 리디에서 유료도서 결제 후 다운로드 하시거나 리디셀렉트 도서를 다운로드하신 경우에만 표시됩니다.
성인 인증 안내
성인 재인증 안내
청소년보호법에 따라 성인 인증은 1년간
유효하며, 기간이 만료되어 재인증이 필요합니다.
성인 인증 후에 이용해 주세요.
해당 작품은 성인 인증 후 보실 수 있습니다.
성인 인증 후에 이용해 주세요.
청소년보호법에 따라 성인 인증은 1년간
유효하며, 기간이 만료되어 재인증이 필요합니다.
성인 인증 후에 이용해 주세요.
해당 작품은 성인 인증 후 선물하실 수 있습니다.
성인 인증 후에 이용해 주세요.
본문 끝 최상단으로 돌아가기
무료이용권을 사용하시겠습니까?
사용 가능 : 장
<>부터 총 화
무료이용권으로 대여합니다.
무료이용권으로
총 화 대여 완료했습니다.
남은 작품 : 총 화 (원)
[체험판] SQL Server 2017 Administrator's Guide
작품 제목
대여 기간 : 일
작품 제목
결제 금액 : 원
결제 가능한 리디캐시, 포인트가 없습니다.
리디캐시를 충전하시면 자동으로 결제됩니다.
최대 5% 리디포인트 적립 혜택도 놓치지 마세요!
이미 구매한 작품입니다.
작품 제목
원하는 결제 방법을 선택해주세요.
작품 제목
대여 기간이 만료되었습니다.
다음화를 보시겠습니까?