Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
Follow the authors
OK
SQL Server 2022 Administration Inside Out
Purchase options and add-ons
Conquer SQL Server 2022 and Azure SQL administration from the inside out!
Dive into SQL Server 2022 administration and grow your Microsoft SQL Server data platform skillset. This well-organized reference packs in timesaving solutions, tips, and workarounds, all you need to plan, implement, deploy, provision, manage, and secure SQL Server 2022 in any environment: on-premises, cloud, or hybrid, including detailed, dedicated chapters on Azure SQL Database and Azure SQL Managed Instance. Nine experts thoroughly tour DBA capabilities available in the SQL Server 2022 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and much more. You'll find extensive new coverage of Azure SQL Database and Azure SQL Managed Instance, both as a cloud platform of SQL Server and in their new integrations with SQL Server 2022, information available in no other book. Discover how experts tackle today's essential tasks and challenge yourself to new levels of mastery.
- Identify low-hanging fruit and practical, easy wins for improving SQL Server administration
- Get started with modern SQL Server tools, including SQL Server Management Studio, and Azure Data Studio
- Upgrade your SQL Server administration skillset to new features of SQL Server 2022, Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Linux
- Design and implement modern on-premises database infrastructure, including Kubernetes
- Leverage data virtualization of third-party or non-relational data sources
- Monitor SQL instances for corruption, index activity, fragmentation, and extended events
- Automate maintenance plans, database mail, jobs, alerts, proxies, and event forwarding
- Protect data through encryption, privacy, and auditing
- Provision, manage, scale and secure, and bidirectionally synchronize Microsoft's powerful Azure SQL Managed Instance
- Understand and enable new Intelligent Query Processing features to increase query concurrency
- Prepare a best-practice runbook for disaster recovery
- Use SQL Server 2022 features to span infrastructure across hybrid environments
- ISBN-100137899882
- ISBN-13978-0137899883
- Edition1st
- PublisherMicrosoft Press
- Publication dateApril 15, 2023
- LanguageEnglish
- Dimensions7.78 x 1.86 x 9.13 inches
- Print length992 pages
Frequently bought together

Customers who viewed this item also viewed
- Pro SQL Server 2022 Administration: A Guide for the Modern DBAPaperbackFREE Shipping by AmazonGet it as soon as Saturday, Oct 17Only 8 left in stock (more on the way).
- T-SQL Fundamentals (Developer Reference)PaperbackFREE Shipping by AmazonGet it as soon as Saturday, Oct 17
- SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric IntegrationPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Saturday, Oct 17
- SQL Server Database Administration: The Grumpy Old IT Guy's Beginner's Guide (SQL Server Programming & Administration Books)PaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Saturday, Oct 17
- Windows Server 2025 Administration Fundamentals: A beginner's guide to managing and administering Windows Server environmentsPaperbackFREE Shipping on orders over $35 shipped by AmazonGet it as soon as Saturday, Oct 17
- Mastering Windows Server 2025: Accelerate your journey from IT Pro to System Administrator using the world's most powerful server platformPaperbackFREE Shipping by AmazonGet it as soon as Saturday, Oct 17
Customers also bought or read
- Pro SQL Server 2022 Administration: A Guide for the Modern DBA
Paperback$46.02$46.02FREE delivery Sat, Oct 17 - Mastering Windows Server 2022: Comprehensive administration of your Windows Server environment
Paperback$51.99$51.99FREE delivery Sat, Oct 17 - SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Paperback$38.34$38.34FREE delivery Sat, Oct 17 - Pro SQL Server Relational Database Design and Implementation: Best Practices for Scalability and Performance
Paperback$54.06$54.06FREE delivery Tue, Oct 20 - SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Paperback$27.88$27.88Delivery Sat, Oct 17 - SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
Paperback$35.62$35.62$3.99 delivery Sat, Oct 24 - SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Paperback$54.05$54.05FREE delivery Sat, Oct 17 - Windows Internals: System architecture, processes, threads, memory management, and more, Part 1 (Developer Reference)
Paperback$40.92$40.92FREE delivery Sat, Oct 17 - SQL Server Query Tuning and Optimization: Optimize Microsoft SQL Server 2022 queries and applications
Paperback$54.99$54.99FREE delivery Sat, Oct 17 - SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
Paperback$51.99$51.99FREE delivery Sat, Oct 17 - Practical Database Auditing for Microsoft SQL Server and Azure SQL: Troubleshooting, Regulatory Compliance, and Governance
Paperback$45.29$45.29FREE delivery Sat, Oct 17 - The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition (Business Skills)
Paperback$50.31$50.31FREE delivery Mon, Oct 19 - Python Crash Course, 3rd Edition: A Hands-On, Project-Based Introduction to Programming#1 Best SellerFunctional Software Programming
Paperback$20.91$20.91Delivery Sat, Oct 17 - Pro Encryption in SQL Server 2022: Provide the Highest Level of Protection for Your Data
Paperback$29.32$29.32Delivery Sat, Oct 17 - Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric
Paperback$24.80$24.80Delivery Sat, Oct 17 - Real-World Web Development with .NET 10: Build websites and services using mature and proven ASP.NET Core MVC, Web API, and Umbraco CMS
Paperback$54.99$54.99FREE delivery Sat, Oct 17 - Data Visualization with Microsoft Power BI: How to Design Savvy Dashboards
Paperback$41.33$41.33FREE delivery Sat, Oct 17 - Windows Server 2025 Administration Fundamentals: A beginner's guide to managing and administering Windows Server environments
Paperback$28.00$28.00Delivery Sat, Oct 17 - DAMA-DMBOK: Data Management Body of Knowledge: 2nd Edition#1 Best SellerNetwork Storage & Retrieval Administration
Paperback$49.44$49.44FREE delivery Sat, Oct 17
From the Publisher
Who is this book for?
Data platform administration was never the narrow niche skillset that employers or recruiters might have suspected. The job description continues to broaden, with support for new operating systems and platforms: cloud-based and serverless in addition to on-premises, hybrid environments, even on-premises to cloud failover. We wrote this book for data professionals who are unafraid to add these new skillsets and features to their utility belt, and to give courage and confidence to those who are still hesitant. Data platform administrators should read this book to become more prepared and so they are aware of features when talking to their colleagues in application development, data analytics, and system administration.
Editorial Reviews
About the Author
Randolph West (they/them) lives in Calgary, Alberta, Canada, with a husband and two dogs. After being a consultant for millennia, Randolph now writes full-time at Microsoft Docs, still yelling at the screen. Occasional voice actor. Occasional blogger at bornsql.ca. Not to be trusted around chocolate. Yes, this is a short bio.
William Assaf (he/him) is a senior content developer for Microsoft, writing Learn content for SQL Server, Azure SQL Database, Azure Synapse Analytics, and more. A long-time Baton Rougean, William and his adventure buddy Christine moved to Seattle during the pandemic. They love their new home but are still New Orleans Saints fans. Before joining Microsoft, William was a Data Platform MVP, SQL Saturday and SQL community organizer, and a long-time DBA and data consultant. As a consultant for 13 years, he worked with clients across the U.S. on SQL Server and Azure SQL platform optimization, management, data integration, disaster recovery, and high availability, and led a multi-city team of senior consulting SQL DBAs. William has written for Microsoft SQL certification exams since 2011 and was the team lead author of the 2017 and 2019 editions of SQL Server Administration Inside Out by Microsoft Press.
Elizabeth Noble is a Director of Database Development, the author of Pro T-SQL 2019, and a Microsoft Data Platform MVP. Ze has spoken at several SQL Saturdays across the United States and at PASS Summit. Most of zir topics focus on DevOps, collaboration with other IT departments, and automated database deployments. Zir passion is to help others improve the quality and speed of deploying database changes through automation. When ze is not trying to automate all things, ze can be found spending time with zir dogs, playing disc golf, or paddleboarding (if the weather is right).
Meagan Longoria is a Microsoft Data Platform MVP living in Denver, Colorado. She is an experienced consultant and trainer who has worked with the Microsoft Data Platform for over 15 years. She enjoys creating solutions in Azure, SQL Server, and Power BI that make data useful for decision makers and make the lives of information workers a little bit easier. Meagan enjoys sharing her knowledge with the technical community by speaking at conferences, blogging (DataSavvy.me), and sharing tips and helpful links on Twitter (@mmarie).
Joseph D'Antoni is a Principal Consultant at Denny Cherry & Associates Consulting. He is recognized as a VMWare Expert and a Microsoft Data Platform MVP and has over 20 years of experience working in both Fortune 500 and smaller firms. He has worked extensively on database platforms and cloud technologies and has specific expertise in performance tuning, infrastructure, and disaster recovery.
Louis Davidson has over 20 years as a data architect and technical writer. Recently he joined Redgate as the editor of the Simple Talk website after 20-plus years working for a nonprofit, where he was the lead SQL Server architect and programmer. Louis has been the principal author on many technical books about SQL Server, including six editions of a book on database design. Louis' blog, located at simple-talk.com for many years, provides information about technical issues and upcoming presentations, including previewing the thought process that goes into writing presentations, books, and blogs.
Product details
- Publisher : Microsoft Press
- Publication date : April 15, 2023
- Edition : 1st
- Language : English
- Print length : 992 pages
- ISBN-10 : 0137899882
- ISBN-13 : 978-0137899883
- Item Weight : 3.55 pounds
- Dimensions : 7.78 x 1.86 x 9.13 inches
- Part of series : Inside Out
- Best Sellers Rank: #941,076 in Books (See Top 100 in Books)
- #8 in Client-Server Networking Systems
- #127 in Databases & Big Data
- #561 in Database Storage & Design
- Customer Reviews:
About the authors

I have been in the IT industry for over 14 years as a corporate database developer and architect. The majority of my experience has been with Microsoft SQL Server in every version that has been released since 4.21a. Currently I am a Senior Data Architect for Compass Technology Management, supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, Tennessee.
I have a bachelor's degree in computer science from the University of Tennessee at Chattanooga with a minor in mathematics. I have been a volunteer with the Professional Association for SQL Server (PASS) for over five years. In October 2004 I was awarded the Most Valuable Professional (MVP) award for SQL Server by Microsoft, an honor I am proud to have been given. In my 'free' time you can often find my writing for my blog http://spaces.msn.com/drsql or on the Microsoft SQL Server newsgroups and forums.

Randolph West solves technology problems with a focus on SQL Server and C#.
A former Microsoft Data Platform MVP, now working on the Docs team at Microsoft, Randolph has worked with SQL Server since the late 1990s.
When not writing technical content, you can see them acting on the stage and screen, or doing voices for independent video games.
Also available for mentoring, talks on SQL Server and technology in general, Randolph offers training for junior DBAs.

Discover more of the author’s books, see similar authors, read book recommendations and more.

Joseph D'Antoni is a Principal Consultant at Denny Cherry and Associates Consulting, and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He lives in Malvern, PA and holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016"

Discover more of the author’s books, see similar authors, read book recommendations and more.

I work and play in data analytics and engineering, trying to make data useful and interesting to people. I'm a Microsoft Data Platform MVP, consultant, and blogger. I'm navigating life one data point at a time.





















