belle’s sql musings

SQL Server-Related Cheat Sheets That Can Save You Time

Posted in DBA Toolbox / T-SQL Scripts, Powershell by belle on October 17, 2008

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

Tagged with: ,

SQL Server 2005 Cheat Sheet

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!

Tagged with: