100 SQL Server Mistakes and How to Avoid Them
Год издания: 2025
Автор: Carter P.A.
Издательство: Manning
ISBN: 978-1633437401
Язык: Английский
Формат: EPUB
Качество: Издательский макет или текст (eBook)
Интерактивное оглавление: Да
Количество страниц: 754
Описание: ll the mistakes you might make with SQL Server—and how to avoid them!
100 SQL Server Mistakes and How to Avoid Them prepares you for the pitfalls database professionals often encounter—from administration to development, availability, and security. You'll learn to sidestep common errors that slow down your T-SQL code and ensure your SQL Server is installed and configured to handle anything your organization throws at it.
- Inside 100 SQL Server Mistakes and How to Avoid Them you'll learn to avoid
- Development errors when writing T-SQL
- Installation and administration mistakes
- Optimization missteps
- Common pitfalls relating to high availability and disaster recovery (HA/DR)
- Security oversights that can endanger your data
100 SQL Server Mistakes and How to Avoid Them doesn't focus on the "happy path"—instead, it covers all the errors and problems you might face as a SQL Server developer or administrator. Each chapter is filled with real-world issues drawn from author Peter A. Carter’s two-decade-long career in SQL Server. Peter's seasoned advice helps dispel myths, debunk misconceptions, and set you on the right road.
Примеры страниц (скриншоты)
Оглавление
preface
acknowledgments
about this book
about the author
about the cover illustration
1 Introducing SQL Server
2 Development standards
3 Data types
4 Database design
5 T-SQL development
6 SSIS development
7 Error handling, testing, source control, and deployment
8 SQL Server installation
9 Instance and database management
10 Optimization
11 Indexes
12 Backups
13 Availability
14 Security
index
