Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available Key Features Explore new features of SQL Server 2019 to set up, administer, and maintain your database solution successfully Develop a dynamic SQL Server environment and streamline big data pipelines Discover best practices for fixing performance issues, database access management, replication, and security Book DescriptionSQL Server is one of the most popular relational database management systems developed by Microsoft. This second edition of the SQL Server Administrator's Guide will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable. You'll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. The book then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. You'll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the book covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Once you've got to grips with integration with Azure and streamlining big data pipelines, you'll learn best practices from industry experts for maintaining a highly reliable database solution. Whether you are an administrator or are looking to get started with database administration, this SQL Server book will help you develop the skills you need to successfully create, design, and deploy database solutions. What you will learn Discover SQL Server 2019's new features and how to implement them Fix performance issues by optimizing queries and making use of indexes Design and use an optimal database management strategy Combine SQL Server 2019 with Azure and manage your solution using various automation techniques Implement efficient backup and recovery techniques in line with security policies Get to grips with migrating, upgrading, and consolidating with SQL Server Set up an AlwaysOn-enabled stable and fast SQL Server 2019 environment Understand how to work with Big Data on SQL Server environments Who this book is forThis book is for database administrators, database developers, and anyone who wants to administer large and multiple databases single-handedly using Microsoft's SQL Server 2019. Basic awareness of database concepts and experience with previous SQL Server versions is required.

Find, explore, and extract big data to transform into actionable insights Key Features Perform end-to-end data analysis-from exploration to visualization Real-world examples, tasks, and interview queries to be a proficient data scientist Understand how SQL is used for big data processing using HiveQL and SparkSQL Book DescriptionSQL Server is a relational database management system that enables you to cover end-to-end data science processes using various inbuilt services and features. Hands-On Data Science with SQL Server 2017 starts with an overview of data science with SQL to understand the core tasks in data science. You will learn intermediate-to-advanced level concepts to perform analytical tasks on data using SQL Server. The book has a unique approach, covering best practices, tasks, and challenges to test your abilities at the end of each chapter. You will explore the ins and outs of performing various key tasks such as data collection, cleaning, manipulation, aggregations, and filtering techniques. As you make your way through the chapters, you will turn raw data into actionable insights by wrangling and extracting data from databases using T-SQL. You will get to grips with preparing and presenting data in a meaningful way, using Power BI to reveal hidden patterns. In the concluding chapters, you will work with SQL Server integration services to transform data into a useful format and delve into advanced examples covering machine learning concepts such as predictive analytics using real-world examples. By the end of this book, you will be in a position to handle the growing amounts of data and perform everyday activities that a data science professional performs. What you will learn Understand what data science is and how SQL Server is used for big data processing Analyze incoming data with SQL queries and visualizations Create, train, and evaluate predictive models Make predictions using trained models and establish regular retraining courses Incorporate data source querying into SQL Server Enhance built-in T-SQL capabilities using SQLCLR Visualize data with Reporting Services, Power View, and Power BI Transform data with R, Python, and Azure Who this book is forHands-On Data Science with SQL Server 2017 is intended for data scientists, data analysts, and big data professionals who want to master their skills learning SQL and its applications. This book will be helpful even for beginners who want to build their career as data science professionals using the power of SQL Server 2017. Basic familiarity with SQL language will aid with understanding the concepts covered in this book.

Implement and administer successful database solution with SQL Server 2017 About This Book * 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 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 In Detail 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. Style and approach A comprehensive guide for database professionals, covering a wide range of topics from installation, maintenance, and configuration to managing systems for operational efficiency and high availability; best practices for maintaining a highly reliable database solution are also supplied from industry experts.