SQL Server 2017 Administration Inside Out: Your Ultimate Guide

Are you ready to delve into the world of SQL Server 2017 administration? Look no further! In this comprehensive guide, we will take you through every aspect of SQL Server 2017 administration, providing you with all the knowledge and tools you need to become an expert in managing and optimizing your databases.

Why SQL Server 2017?

SQL Server 2017 is the latest version of Microsoft's popular relational database management system. It comes packed with several new features and enhancements, making it a must-have for any organization relying on SQL Server for their data storage and analysis needs.

SQL Server 2017 Administration Inside Out

by William Assaf(1st Edition, Kindle Edition)

4.3 out of 5

Language	:	English
File size	:	19318 KB
Text-to-Speech	:	Enabled
Screen Reader	:	Supported
Enhanced typesetting	:	Enabled
Print length	:	704 pages

FREE

The new features introduced in SQL Server 2017 include:

• Support for Linux-based operating systems: SQL Server 2017 can now run on both Windows and Linux platforms, expanding its reach and providing more flexibility.
• Enhanced security capabilities: With the of features like Always Encrypted and Row-Level Security, SQL Server 2017 offers improved protection for your sensitive data.
• Adaptive Query Processing: This innovative feature automatically adjusts query plans to provide optimal performance, saving you time and resources.
• Graph database support: SQL Server 2017 includes built-in support for graph databases, allowing you to model and analyze complex relationships more efficiently.

Getting Started with SQL Server 2017 Administration

Before diving into the intricacies of SQL Server 2017 administration, it is important to have a solid understanding of the basics.

If you are new to SQL Server, don't worry! We will guide you through the installation process, highlighting the key considerations and best practices to ensure a smooth setup.

Once you have SQL Server 2017 up and running, we will explore the various administrative tools at your disposal. From SQL Server Management Studio to the command-line utilities, you will learn how to effectively navigate and utilize these tools to manage your databases and perform routine tasks.

Database Management and Optimization

Keeping your databases well-managed and optimized is crucial for maintaining performance and minimizing downtime. In this section, we will cover various topics such as:

• Database backup and restoration: Learn how to create reliable backup strategies and perform seamless restores in case of emergencies.
• Index and query optimization: Discover techniques to improve query performance by properly indexing your tables and optimizing your query plans.
• Data partitioning and compression: Explore strategies for partitioning and compressing your data to enhance storage efficiency and query performance.
• Monitoring and troubleshooting: Acquire knowledge on how to effectively monitor and troubleshoot your SQL Server instance to identify and resolve performance issues.
• High availability and disaster recovery: Get insights into implementing high availability and disaster recovery solutions to ensure business continuity.

Security and Compliance

Security is of utmost importance when it comes to managing databases. In this section, we will explore SQL Server 2017's security features and discuss best practices for securing your data.

Topics covered include:

• User and login management: Learn how to create and manage user accounts, assign permissions, and implement security policies.
• Encryption and data protection: Discover how to safeguard your data using encryption techniques and built-in security features like Always Encrypted.
• Auditing and compliance: Understand the importance of auditing and compliance in database management, and learn how to implement auditing and meet regulatory requirements.

Scaling and Performance Optimization

As your database grows, it becomes crucial to scale and optimize its performance to meet the ever-increasing demands. In this section, we will explore techniques for:

• Horizontal and vertical scaling: Understand the differences between horizontal and vertical scaling, and learn the best practices for scaling your SQL Server databases.
• Performance tuning: Discover how to identify and resolve performance bottlenecks by monitoring and optimizing key areas like CPU, memory, and disk usage.
• Query execution plans: Dig deeper into query execution plans and learn how to interpret and optimize them for better performance.

Migrating to SQL Server 2017

If you are already using a previous version of SQL Server and considering upgrading to SQL Server 2017, this section is for you. We will guide you through the migration process, covering areas such as:

• Assessing the compatibility of your existing databases and applications with SQL Server 2017
• Creating a migration plan and minimizing downtime during the upgrade
• Testing and troubleshooting the migrated databases and applications

SQL Server 2017 Administration Inside Out is your ultimate guide to becoming a proficient SQL Server administrator. By mastering the topics covered in this guide, you will be able to manage and optimize your SQL Server 2017 databases with confidence, ensuring smooth operations and improved performance.

So, are you ready to dive into the fascinating world of SQL Server 2017 administration? Get started now and unlock the full potential of SQL Server!

SQL Server 2017 Administration Inside Out

by William Assaf(1st Edition, Kindle Edition)

4.3 out of 5

Language	:	English
File size	:	19318 KB
Text-to-Speech	:	Enabled
Screen Reader	:	Supported
Enhanced typesetting	:	Enabled
Print length	:	704 pages

FREE

Conquer SQL Server 2017 administration—from the inside out

Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery.

• Install, customize, and use SQL Server 2017’s key administration and development tools

• Manage memory, storage, clustering, virtualization, and other components

• Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations

• Provision SQL Server and Azure SQL databases

• Secure SQL Server via encryption, row-level security, and data masking

• Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing

• Establish SQL Server IaaS network security groups and user-defined routes

• Administer SQL Server user security and permissions

• Efficiently design tables using keys, data types, columns, partitioning, and views

• Utilize BLOBs and external, temporal, and memory-optimized tables

• Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans

• Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments

For Experienced SQL Server Administrators and Other Database Professionals

• Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert

• Prerequisites: Basic understanding of database administration procedures