買這商品的人也買了...
相關主題
商品描述
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.
Purchase of the print book includes a free eBook in PDF and ePub formats from Manning Publications.
About the book
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 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.
商品描述(中文翻譯)
您可能在 SQL Server 上犯的所有錯誤——以及如何避免它們！
100 SQL Server Mistakes and How To Avoid Them 讓您了解資料庫專業人員常常陷入的陷阱——從管理到開發、可用性和安全性。您將避免那些會減慢 T-SQL 代碼的常見錯誤，並確保您的 SQL Server 以能夠應對您組織所面臨的任何挑戰的方式安裝和配置。
在 100 SQL Server Mistakes and How To Avoid Them 中，您將學會避免：
- 撰寫 T-SQL 時的開發錯誤
- 安裝和管理錯誤
- 優化錯誤
- 與高可用性/災難恢復相關的常見錯誤
- 可能危及您數據的安全失誤
您的 T-SQL 查詢運行緩慢嗎？您擔心伺服器的可用性或壞人試圖竊取您的數據嗎？您剛剛接手一個新的 SQL Server 實例進行管理，但不太確定該怎麼做？別擔心！100 SQL Server Mistakes and How To Avoid Them 將讓您成為 SQL Server 的老手，而無需自己犯下數十個錯誤。
購買印刷版書籍包括來自 Manning Publications 的免費 PDF 和 ePub 格式電子書。
關於本書
在 100 SQL Server Mistakes and How To Avoid Them 中沒有「幸福之路」。本書專注於您作為一名未準備好的 SQL Server 管理員或開發人員可能（而且很可能會）犯的錯誤和失誤。每一章都充滿了來自作者 Peter Carter 在 SQL Server 領域近二十年職業生涯中的真實問題。Peter 的經驗豐富的建議有助於消除神話、揭穿誤解，並通過範例、專家指導、有用的代碼範本和幫助性圖表將您引向正確的道路。您將學會如何撰寫高效的代碼、設置編碼標準、設計資料庫架構、添加錯誤處理以及處理複雜數據類型。此外，還將學習如何為您的安裝選擇合適的作業系統，優化您的 SQL Server 實例和資料庫，並避免與高可用性、災難恢復和安全性相關的陷阱。
關於讀者
適合初級資料庫管理員、全棧開發人員和理解基本 SQL Server 概念並能撰寫簡單 SQL 查詢的「意外」DBA。
關於作者
Peter Carter 是一位 SQL Server 專家，擁有近二十年的開發、管理和架構數據層應用程序及 SQL Server 平台的經驗。他還擁有多年作為 SQL Server 培訓師和作者的經驗。
作者簡介
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.
作者簡介(中文翻譯)
彼得·卡特是一位 SQL Server 專家，擁有近二十年的經驗，專注於開發、管理和架構資料層應用程式及 SQL Server 平台。他還擁有多年作為 SQL Server 培訓師和作者的經驗。
