开发资源汇聚– MS SQL Server (持续更新中)
2011-02-24 by 嘉瑜, Category: 码农日记, Tags: SQL, 开发资源 No Comments 10次浏览
综合
- 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
DBA
Security
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语句及算法
- 比如：行列转换，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 <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 格式化时间
- 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
图书推荐
My task: 写一篇上次分页的博客吧！
