开发资源汇聚– MS SQL Server (持续更新中)
综合[*]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 不错的网站，有不少实用的性能优化practice
[*]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
[*]邹建 @CSDN /
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 最差SQL语句
DBA
Security
[*]SQL Injection Attacks by Example
[*]SQL Injection Cheat Sheet
Performance & TroubleShooting
[*]Improving SQL Server Performance (MSDN)
[*]Top 1000 SQL Performance Tips
[*]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 将符号分隔的字符串转换为表的函数
[*]SQL CODE --- 经典·精彩 @博客园
技巧/具体应用/其它
[*]Educate yourself about .NET SQL Server connection string syntax
[*]How do I find a stored procedure containing ?如何找到依赖
[*]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 格式化时间
[*]Educate yourself about .NET SQL Server connection string syntax 详细讲解SQL链接串各属性含义
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:写一篇上次分页的博客吧！
页:
[1]