Note: Synchronize updates in your blog
Comprehensive
- SQL Server Skills-Immerse yourself in SQL server (a collection)
- Featured Database Articles (itself an aggregation) SQL Server @ DatabaseJournal
- SQL Server Central
- SQL Tips | Tutorials
- Microsoft: SQL Sever Magazine
- Microsoft: SQL Server MSDN Homepage
- Microsoft: SQL Server Reference (MSDN)
- Microsoft: 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 full strategy (Chinese)
- SQL Server @ blog Garden (Chinese)
- SQL Server @ ITPUB (Chinese)
Forums
- ITPub Forum (ms SQL) (Chinese)
- 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)
Teaching
- SQL Server 2005
- SQL Server lessions
Classic SQL statements and Algorithms
- For example, row and column conversion, For XML Path, SQL paging, and batch usage
- Search for "classic SQL" @ blog
- Split a delimited list into a table converts string separated by symbols into table functions.
Tips
- Educate yourself about. net SQL Server connection string syntax
- How do I find a stored procedure containing <text>?
- Grouping SQL Server table metadata with SSMS and TSQL
- SQL Server Programming Hacks (SQL Server section, sorted by Ratings, you can see some useful posts)
- How to format datetime & date in SQL Server 2005
Other Skills
- Deadlock Dead lock
- Exception Handling Exception handler
- Transaction and nested Transaction (nested)
- Index
- Best Practice
- Performance Optimization
- Classic SQL statements
- SQL Server Profile monitoring performance
- Execution Plan (reference)
- Usage of XML in SQL Server
- Full-text search
- Database Management and System commands/functions
LINQ To SQL
- Using LINQ to SQL (Part 1)
Book recommendation
My task: write a blog post on the last page!
Note: Synchronize updates in your blog
Comprehensive
- SQL Server Skills-Immerse yourself in SQL server (a collection)
- Featured Database Articles (itself an aggregation) SQL Server @ DatabaseJournal
- SQL Server Central
- SQL Tips | Tutorials
- Microsoft: SQL Sever Magazine
- Microsoft: SQL Server MSDN Homepage
- Microsoft: SQL Server Reference (MSDN)
- Microsoft: 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 full strategy (Chinese)
- SQL Server @ blog Garden (Chinese)
- SQL Server @ ITPUB (Chinese)
Forums
- ITPub Forum (ms SQL) (Chinese)
- 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)
Teaching
- SQL Server 2005
- SQL Server Lessions
Classic SQL statements and Algorithms
- For example, row and column conversion, For XML Path, SQL paging, and batch usage
- Search for "classic SQL" @ blog
- Split a delimited list into a table converts string separated by symbols into table functions.
Tips
- Educate yourself about. net SQL Server connection string syntax
- How do I find a stored procedure containing <text>?
- Grouping SQL Server table metadata with SSMS and TSQL
- SQL Server Programming Hacks (SQL Server section, sorted by Ratings, you can see some useful posts)
- How to format datetime & date in SQL Server 2005
Other Skills
- Deadlock Dead lock
- Exception Handling Exception handler
- Transaction and nested Transaction (nested)
- Index
- Best Practice
- Performance Optimization
- Classic SQL statements
- SQL Server Profile monitoring performance
- Execution Plan (reference)
- Usage of XML in SQL Server
- Full-text search
- Database Management and System commands/functions
LINQ To SQL
- Using LINQ to SQL (Part 1)
Book recommendation
My task: write a blog post on the last page!
