I previously posted about a SQL Server CheatSheet from DotNet4All that I thought was useful and comprehensive. If you already know what you need to do, but just forgot the syntax because you haven’t done it in eons, then  a well organized, concise, complete cheat sheet can save the day.

Here are a few other ones:

General SQL Server
DotNet4All

SQLAuthority
Scribd T-SQL

SQL Server Shortcuts
SQLArticles (really good, exhaustive list!)
SQLAuthority SSMS Shortcuts

Connection Strings
ConnectionStrings.com

Regex (especially when you’re working with SQLCLR/Regex)
.NET Regex Cheat Sheet
AddedBytes
(AddedBytes used to be known as ILoveJackDaniels, but that name has changed. Dave has a *lot* of useful cheat sheets in his site.)

SQL Injection
Ferruh Mavituna
ha.ckers

PowerShell
MSDN Blogs (PDF)
MSDN Blogs (MS Word)

SQL Server 2008
SQLAuthority

SQL Server DBA Interview Questions
SQLAuthority Interview Questions – Complete List

Just came across this SQL Server Developer Fact Sheet made by Xander Zelders of DotNet4All. It’s a handy cheat sheet, with all the common stuff you need as a dev:

• Data types, common string/system/date and time/math/cursor functions
• Basic SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER syntax
• SARGability
• Concise checklist for creating indexes and fast queries
• Execution plan icons (aptly color coded – red means no-no!)
• … even connection strings!

Pretty handy and organized reference. Thanks Xander!