客服公告:2025年博客來春節過年各項服務詳情

100 SQL Server Mistakes and How to Avoid Them

100 SQL Server Mistakes and How to Avoid Them

  • 作者: Carter, Peter
  • 原文出版社:Manning Publications
  • 出版日期:2024/12/31
  • 語言:英文
  • 定價:3299

分期價:(除不盡餘數於第一期收取) 分期說明

3期0利率每期10996期0利率每期549
  • 運送方式:
  • 臺灣與離島
  • 海外
  • 可配送點:台灣、蘭嶼、綠島、澎湖、金門、馬祖
  • 可配送點:台灣、蘭嶼、綠島、澎湖、金門、馬祖
  • 無庫存,購買後從海外調貨
  • 分享

買了此商品的人,也買了...

上頁下頁
 

內容簡介

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

 

作者簡介

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.

 

詳細資料

  • ISBN:9781633437401
  • 規格:平裝 / 437頁 / 普通級 / 初版
  • 出版地:美國

最近瀏覽商品

 
"上頁" "下頁"

相關活動

  • 【自然科普、電腦資訊】遠流暢銷電子書展|單本79折、兩本75折
 

購物說明

外文館商品版本:商品之書封,為出版社提供之樣本。實際出貨商品,以出版社所提供之現有版本為主。關於外文書裝訂、版本上的差異,請參考【外文書的小知識】。

調貨時間:無庫存之商品,在您完成訂單程序之後,將以空運的方式為您下單調貨。原則上約14~20個工作天可以取書(若有將延遲另行告知)。為了縮短等待的時間,建議您將外文書與其它商品分開下單,以獲得最快的取貨速度,但若是海外專案進口的外文商品,調貨時間約1~2個月。 

若您具有法人身份為常態性且大量購書者,或有特殊作業需求,建議您可洽詢「企業採購」。 

退換貨說明 

會員所購買的商品均享有到貨十天的猶豫期(含例假日)。退回之商品必須於猶豫期內寄回。 

辦理退換貨時,商品必須是全新狀態與完整包裝(請注意保持商品本體、配件、贈品、保證書、原廠包裝及所有附隨文件或資料的完整性,切勿缺漏任何配件或損毀原廠外盒)。退回商品無法回復原狀者,恐將影響退貨權益或需負擔部分費用。 

訂購本商品前請務必詳閱商品退換貨原則 

  • 小物加碼
  • 國際書展
  • 爸媽英文分級班