Description
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.
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.
Book Information
ISBN 9781633437401
Author Peter Carter
Format Hardback
Page Count 408
Imprint Manning Publications
Publisher Manning Publications