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-SQL Installation and administration mistakes Optimization mistakes Common mistakes relating to HA/DR Security 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.
By:
Peter Carter Imprint: Manning Publications Country of Publication: United States Dimensions:
Height: 230mm,
Width: 180mm,
Spine: 18mm
Weight: 734g ISBN:9781633437401 ISBN 10: 163343740X Pages: 408 Publication Date:30 January 2025 Audience:
Professional and scholarly
,
Undergraduate
Format:Hardback Publisher's Status: Active
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.