註：在自己的部落格中同步更新
綜合
- SQL Server Skills – Immerse yourself in sql server (一篇匯聚)
- Featured Database Articles (本身就是篇匯聚) SQL Server @DatabaseJournal
- SQL Server Central
- SQL Tips | Tutorials
- 微軟：SQL Sever Magazine
- 微軟：SQL Server MSDN首頁
- 微軟：SQL Server Reference (MSDN)
- 微軟：SQL Sever 2008 R2 Books online
- MS SQL CITY
- SQL Server Performance
- SQL @Small Talks
- SQL Server @CodeProject
- SQL Server @Ask
- SQL Connection Strings
- SQL Blogs
- SQL Server DBA全攻略 （中文）
- SQL Server @部落格園 （中文）
- SQL Server @ITPUB （中文）
Forums
- ITPub論壇 (MS SQL) （中文）
- MS SQL @dbforums
部落格 Blog
Index
- SQL Server Index Basics
- General Tips on Optimizing SQL Server Indexes
- Index Selection and the Query Optimizer
Misc
- Visual Representation of SQL Joins
- Microsoft Reporting Services in Action
- Free SQL Server tools that might make your life a little easier
- SQL Server Date Formats
- SQL Server Web Tools
Best Practice
- SQL SERVER – 15 Best Practices for Better Database Performance
- SQL Server Worst Practices
DBA
Security
- SQL Injection Attacks by Example
- SQL Injection Cheat Sheet
Performance & TroubleShooting
- Improving SQL Server Performance (MSDN)
- Did You Know? Free SQL Server Troubleshooting Tools
- SQL Server TroubleShooting FAQ
- Troubleshooting Performance Problems in SQL Server 2005 (MSDN)
- See SQL Server graphical execution plans in action
- SQL Tuning Tutorial - Understanding a Database Execution Plan (1)
教學
- SQL Server 2005
- SQL Server Lessions
經典SQL語句及演算法
- 比如：行列轉換，For XML Path，SQL分頁，pivot用法等
- 搜尋“經典SQL” @部落格園
- Split a delimited list into a table 將符號分隔的字串轉換為表的函數
技巧
- Educate yourself about .NET SQL Server connection string syntax
- How do I find a stored procedure containing <text>?
- Exploring SQL Server table metadata with SSMS and TSQL
- SQL Server Programming Hacks (SQL Server版塊，按Ratings排序後可以看到一些有用的貼子)
- How to format datetime & date in Sql Server 2005
Other Skills
- 死結 Dead lock
- 異常處理 Exception handler
- 事務及嵌套事務 Transaction (nested)
- 索引
- Best Practice
- Performance 效能最佳化
- 經典SQL語句
- SQL Server Profile監視效能
- Execution Plan (參考)
- XML在SQL Server中的用途
- 全文檢索索引
- 資料庫管理，及系統命令/函數等
LINQ To SQL
- Using LINQ to SQL (Part 1)
圖書推薦
My task: 寫一篇上次分頁的部落格吧！
註：在自己的部落格中同步更新
綜合
- SQL Server Skills – Immerse yourself in sql server (一篇匯聚)
- Featured Database Articles (本身就是篇匯聚) SQL Server @DatabaseJournal
- SQL Server Central
- SQL Tips | Tutorials
- 微軟：SQL Sever Magazine
- 微軟：SQL Server MSDN首頁
- 微軟：SQL Server Reference (MSDN)
- 微軟：SQL Sever 2008 R2 Books online
- MS SQL CITY
- SQL Server Performance
- SQL @Small Talks
- SQL Server @CodeProject
- SQL Server @Ask
- SQL Connection Strings
- SQL Blogs
- SQL Server DBA全攻略 （中文）
- SQL Server @部落格園 （中文）
- SQL Server @ITPUB （中文）
Forums
- ITPub論壇 (MS SQL) （中文）
- MS SQL @dbforums
部落格 Blog
Index
- SQL Server Index Basics
- General Tips on Optimizing SQL Server Indexes
- Index Selection and the Query Optimizer
Misc
- Visual Representation of SQL Joins
- Microsoft Reporting Services in Action
- Free SQL Server tools that might make your life a little easier
- SQL Server Date Formats
- SQL Server Web Tools
Best Practice
- SQL SERVER – 15 Best Practices for Better Database Performance
- SQL Server Worst Practices
DBA
Security
- SQL Injection Attacks by Example
- SQL Injection Cheat Sheet
Performance & TroubleShooting
- Improving SQL Server Performance (MSDN)
- Did You Know? Free SQL Server Troubleshooting Tools
- SQL Server TroubleShooting FAQ
- Troubleshooting Performance Problems in SQL Server 2005 (MSDN)
- See SQL Server graphical execution plans in action
- SQL Tuning Tutorial - Understanding a Database Execution Plan (1)
教學
- SQL Server 2005
- SQL Server Lessions
經典SQL語句及演算法
- 比如：行列轉換，For XML Path，SQL分頁，pivot用法等
- 搜尋“經典SQL” @部落格園
- Split a delimited list into a table 將符號分隔的字串轉換為表的函數
技巧
- Educate yourself about .NET SQL Server connection string syntax
- How do I find a stored procedure containing <text>?
- Exploring SQL Server table metadata with SSMS and TSQL
- SQL Server Programming Hacks (SQL Server版塊，按Ratings排序後可以看到一些有用的貼子)
- How to format datetime & date in Sql Server 2005
Other Skills
- 死結 Dead lock
- 異常處理 Exception handler
- 事務及嵌套事務 Transaction (nested)
- 索引
- Best Practice
- Performance 效能最佳化
- 經典SQL語句
- SQL Server Profile監視效能
- Execution Plan (參考)
- XML在SQL Server中的用途
- 全文檢索索引
- 資料庫管理，及系統命令/函數等
LINQ To SQL
- Using LINQ to SQL (Part 1)
圖書推薦
My task: 寫一篇上次分頁的部落格吧！
