Introducing Microsoft SQL Server 2019: Reliability, scalability, and security both on premises and in the cloud

Kellyn Gorman

Allan Hirt

Dave Noderer

Mitchell Pearson

James Rowland-Jones

Dustin Ryan

Arun Sirpal

Buck Woody +4 more

S$37.99 ~~S$42.99~~

eBook Apr 2020 488 pages 1st Edition

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Key benefits

Gain insights into what’s new in SQL Server 2019

Understand use cases and customer scenarios that can be implemented with SQL Server 2019

Discover new cross-platform tools that simplify management and analysis

Description

Microsoft SQL Server comes equipped with industry-leading features and the best online transaction processing capabilities. If you are looking to work with data processing and management, getting up to speed with Microsoft Server 2019 is key. Introducing SQL Server 2019 takes you through the latest features in SQL Server 2019 and their importance. You will learn to unlock faster querying speeds and understand how to leverage the new and improved security features to build robust data management solutions. Further chapters will assist you with integrating, managing, and analyzing all data, including relational, NoSQL, and unstructured big data using SQL Server 2019. Dedicated sections in the book will also demonstrate how you can use SQL Server 2019 to leverage data processing platforms, such as Apache Hadoop and Spark, and containerization technologies like Docker and Kubernetes to control your data and efficiently monitor it. By the end of this book, you'll be well versed with all the features of Microsoft SQL Server 2019 and understand how to use them confidently to build robust data management solutions.

What you will learn

Build a custom container image with a Dockerfile

Deploy and run the SQL Server 2019 container image

Understand how to use SQL server on Linux

Migrate existing paginated reports to Power BI Report Server

Learn to query Hadoop Distributed File System (HDFS) data using Azure Data Studio

Understand the benefits of In-Memory OLTP

What do you get with eBook?

Instant access to your Digital eBook purchase

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

AI Assistant (beta) to help accelerate your learning

Frequently bought together

S$52.99

S$66.99

Hands-On SQL Server 2019 Analysis Services

S$74.99

Total S$ 194.97

About the 8 authors

Kellyn Gorman

Kellyn Gorman is a Customer Success Engineer at Microsoft specializing on Oracle and data platforms on Azure. An alumnus of both Microsoft's Idera ACE and Oracle ACE Director programs, a Friend of Redgate, she has been recognized with numerous awards over the years for her technical contributions and community volunteerism. She is one of only six women part of the Oak Table, a network for the Oracle scientist. She has extensive experience in environment migrations, optimization, automation and architecture. Kellyn is well known for her technical content and thought leadership through her presentations, keynotes, webinars, publications and engaging with her on social media presence as DBAKevlar or her blog.

See other products by Kellyn Gorman

Allan Hirt

SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product as well as clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers no matter if they are on premises or in the public cloud and delivers training and speaks at events over the world.

See other products by Allan Hirt

Dave Noderer

Dave Noderer is a software developer and the CEO / President and founder of Computer Ways, Inc., a software development company since 1994. He is the leader of FlaDotNet holding monthly developer meetup, was a Microsoft MVP for 16 years, and is a co-founder of the Microsoft Cloud South Florida User Group. In 2005 he held the first South Florida Code Camp. This annual, free event now called the South Florida Software Developer Conference attracts over 1000 developers.

See other products by Dave Noderer

Mitchell Pearson

Mitchell Pearson has worked as a Data Platform Consultant and Trainer for the last 8 years. Mitchell has authored books on SQL Server, Power BI and the Power Platform. Data Platform experience includes designing and implementing enterprise level Business Intelligence solutions with the Microsoft SQL Server stack (T-SQL, SSIS, SSAS, SSRS), the Power Platform and Microsoft Azure. Mitchell is very active in the community: Running the local Power BI User Group, presenting at user groups locally and virtually, and creating YouTube videos for MitchellSQL

See other products by Mitchell Pearson

James Rowland-Jones

James Rowland-Jones is a principal consultant for The Big Bang Data Company. His focus and passion is to architect and deliver highly scalable analytical platforms that are creative, simple, and elegant in their design. James specializes in big data warehouse solutions that leverage both SQL Server PDW and Hadoop ecosystems. James is a keen advocate for the SQL Server community, both internationally and in the United Kingdom. He currently serves on the board of directors for PASS and sits on the organizing committee for SQLBits (Europe's largest event for the Microsoft Data Platform). James has been awarded Microsoft's MVP accreditation since 2008 for his services to the community.

See other products by James Rowland-Jones

Dustin Ryan

Dustin Ryan is a Senior Cloud Solution Architect at Microsoft. He has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience designing and building data solutions using SQL Server and Azure. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant and trainer for Pragmatic Works. He is also an author, contributor and technical editor of books. Dustin resides outside Jacksonville, Florida with his wife, three children, and three-legged cat and enjoys spending time with his family and serving at his local church.

See other products by Dustin Ryan

Arun Sirpal

Arun Sirpal is a Microsoft MVP specialized within the Microsoft Data Platform which includes SQL Server 2008 R2-2019 (performance tuning, HA/DR, T-SQL, security, backups and general DBA tasks) and Microsoft Azure based technologies such as SQL Server within Azure virtual machines (IaaS), Azure SQL Database (PaaS), SQL database elastic pools, managed instances, Azure SQL DW, Azure Synapse, ADFv2, Cosmos DB (NoSQL), and Azure Cloud Shell. He is a frequent writer, blogger, speaker and technical reviewer for subjects based on SQL Server and Microsoft Azure - Data Platform. He is also known as BlobEater.

See other products by Arun Sirpal

Buck Woody

Buck Woody works on the Azure Data Services team at Microsoft and uses data and technology to solve business and science problems. With over 35 years of professional and practical experience in computer technology, he is also a popular speaker at conferences around the world; author of over 700 articles and eight books on databases, machine learning, and R, he also sits on various Data Science Boards at two US Universities, and specializes in advanced data analysis techniques.

See other products by Buck Woody

Introducing Microsoft SQL Server 2019: Reliability, scalability, and security both on premises and in the cloud

What do you get with eBook?