Items related to 100 SQL Server Mistakes and How to Avoid Them
Synopsis
All 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.
Purchase of the print book includes a free eBook in PDF and ePub formats from Manning Publications.
About the technology
Perfecting a SQL Server system can be a complex balancing act. Why is T-SQL running so slowly? Are the right data available? Are we protected against data theft? What about that new server instance I need to administer? Even the most skilled SQL Server experts make mistakes that cost time and performance. This book can help you get it right the first time.
About the book
100 SQL Server Mistakes and How to Avoid Them focuses exclusively on the errors that you might—and probably will—make as a SQL Server admin or developer. Real-world examples, code samples, and helpful diagrams make it easy to understand each issue and its solution. You’ll learn how to write performant code, design efficient database schemas, implement error handling, work with complex data types, and much more, all in a friendly, common-sense problem/solution format.
What's inside
• T-SQL development
• Installation, administration, and optimization
• High availability and security
About the reader
Readers need to understand basic SQL Server concepts and SQL queries. Perfect for junior database admins, full-stack developers, and “accidental” DBAs.
About the author
Peter A. Carter is a SQL Server expert with experience developing, administering, and architecting data-tier applications and SQL Server platforms.
Table of Contents
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
"synopsis" may belong to another edition of this title.
About the Author
Peter Carter is a SQL Server expert with nearly two decades of experience in developing, administering, and architecting data-tier applications and SQL Server platforms. He also has many years of experience as a SQL Server trainer and author.
From the Back Cover
From the back cover:
There's no "happy path" in 100 SQL Server Mistakes and How To Avoid Them. The book focuses exclusively on the errors and screw-ups that you might (and probably will) make as an unprepared SQL Server admin or developer. Real-world issues taken from author Peter Carter's two decade long career in SQL Server fill each chapter. Peter's seasoned advice helps dispel myths, debunk misconceptions and set you on the right path with examples, expert guidance, useful code samples, and helpful diagrams. You'll learn how to write performant code, set coding standards, design database schemas, add error handling, and work with complex data types. Plus, learn how to select the right OS for your installation, optimize your SQL Server instances and databases, and avoid pitfalls relating to high availability, disaster recovery, and security.
About the reader:
For junior database admins, full-stack developers, and "accidental" DBAs who understand basic SQL Server concepts and can write simple SQL queries."About this title" may belong to another edition of this title.
Search results for 100 SQL Server Mistakes and How to Avoid Them
Stock Image
100 SQL Server Mistakes and Ho
Seller: SecondSale, Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00090872954
Quantity: 1 available
Stock Image
100 SQL Server Mistakes and How to Avoid Them
Seller: HPB-Red, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Good. Connecting readers with great books since 1972! Used textbooks may not include companion materials such as access codes, etc. May have some wear or writing/highlighting. We ship orders daily and Customer Service is our top priority! Seller Inventory # S_422760348
Quantity: 1 available
Stock Image
100 SQL Server Mistakes and How to Avoid Them Format: Paperback
Seller: INDOO, Avenel, NJ, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 9781633437401
Quantity: Over 20 available
Seller Image
100 SQL Server Mistakes and How to Avoid Them
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # 48410491-n
Quantity: 18 available
Seller Image
100 SQL Server Mistakes and How to Avoid Them
Seller: GreatBookPrices, Columbia, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread book in perfect condition. Seller Inventory # 48410491
Quantity: 18 available
Stock Image
100 SQL Server Mistakes and How to Avoid Them Format: Paperback
Seller: INDOO, Avenel, NJ, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Unread copy in mint condition. Seller Inventory # SS9781633437401
Quantity: Over 20 available
Seller Image
100 SQL Server Mistakes and How to Avoid Them
Published by
Manning Publications, US, 2025
ISBN 10: 163343740X
ISBN 13: 9781633437401
New
Hardcover
Seller: Rarewaves.com USA, London, LONDO, United Kingdom
Seller rating 5 out of 5 stars
Hardback. Condition: New. All the mistakes you might make with SQL Server-and how to avoid them!100 SQL Server Mistakes and How To Avoid Them primes you on the pitfalls database professionals often fall into-from administration to development, availability, and security. You'll dodge common mistakes that slow down your T-SQL code, and ensure your SQL server is installed and configured in a way that can 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-SQLInstallation and administration mistakesOptimization mistakesCommon mistakes relating to HA/DRSecurity missteps that can endanger your data Are your T-SQL queries running slowly? Are you worried about your server's availability or bad actors trying to steal your data? Have you just been handed a new SQL Server Instance to administer and aren't quite sure what to do? Never fear! 100 SQL Server Mistakes and How To Avoid Them will make you into a SQL Server veteran without needing to make dozens of mistakes yourself. Seller Inventory # LU-9781633437401
Quantity: 1 available
Stock Image
100 SQL Server Mistakes and How to Avoid Them
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
HRD. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # PB-9781633437401
Quantity: 15 available
Seller Image
100 SQL Server Mistakes and How to Avoid Them (Paperback or Softback)
Published by
Manning Publications 12/31/2024, 2024
ISBN 10: 163343740X
ISBN 13: 9781633437401
New
Paperback or Softback
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Seller rating 5 out of 5 stars
Paperback or Softback. Condition: New. 100 SQL Server Mistakes and How to Avoid Them 1.7. Book. Seller Inventory # BBS-9781633437401
Quantity: 5 available
Stock Image
100 SQL Server Mistakes and How to Avoid Them
Seller: California Books, Miami, FL, U.S.A.
Seller rating 5 out of 5 stars
Condition: New. Seller Inventory # I-9781633437401
Quantity: Over 20 available