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
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
Related posts:
- SQL Server 2005 Cheat Sheet ...
- MySQL EXPLAIN Cheat Sheet ...
- Resolving “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” ...
- SQLXML : How To Save XML Query Results to a File Using BCP ...
- VANPASS Presentation and Demo Files on SQL Server and PowerShell ...
- SQL Server PowerShell : How to List SQL Server Services using PowerShell ...











[...] SQL Server Cheat Sheets – Donabel Santos links to several cheat sheets to help DBAs with basic syntax. Whenever Quest gives away posters with syntax for stuff like DMVs and system stored procs, DBAs go crazy asking for them, so I bet you guys will go crazy for these too. [...]