SQL Server development resource aggregation (continuously updating)

Source: Internet
Author: User
Tags sql server connection string sql injection cheat sheet

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

  • Zhujian @ 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

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

  • Zhujian @ 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

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!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.