I had a gala time at TechEd India 2009 event! Meeting with great people is an experience of a lifetime. My session was well attended and well appreciated, which also gives me another reason to feel happy. Moreover, my SQL Server Cheat Sheet gained unpredicted popularity at the event. Let me share with you all a little story behind this cheat sheet.
For my personal use, I created one handy SQL Cheat Sheet, which I hang on my desk always. Even though I have a sound knowledge of SQL Syntax there are many occasions when I need to quickly refer to syntax. This cheat sheet helped me quite a bit and saved my time. Besides, it saved me from getting annoyed of looking up for same syntax again and again. This experience gave me the idea of creating a proper SQL Server Cheat Sheet, which was until now in a simple excel document.
I often received numerous requests from my friends, UG members and blog readers to covert the SQL Server Cheat Sheet into a more presentable one. Well, my designing skills are limited and also I never undertook this creative task. I was inspired by Rushabh Mehta of SolidQ as well the directors of Digicorp to create PDF printable version of this cheat sheet. Designers at Digicorp created this professional looking cheat sheet and then it was printed on a high quality glossy paper. When I had the first glimpse of the final SQL Server Cheat Sheet, I realized that I should do something for my community and share this useful cheat sheet with more and more SQL developers. TechEd India 2009 was one such opportunity where I was able to achieve my goal; I distributed several SQL Server Cheat Sheets among the participants.
SQL Server Cheat Sheet acquired so much popularity at TechEd that I ran out of all the copies around noon on the third day of the event. I had promised many attendees that I will put this online and also I will send it to them using physical email.
Now, you can download SQL Server Cheat Sheet and print it on a glossy paper yourself. I request you all to spread the words and pass this cheat sheet to your friends. Bookmark it, reprint it, and distribute it! Due to copyright issues you are not allowed to host it online anywhere other than its original location listed below.
Download SQL Server Cheat Sheet
Reference: Pinal Dave (https://blog.sqlauthority.com)
12 Comments. Leave new
Thanks Pinal for the cheat sheet….
Thanx for the PDF. I printed it up and hung it at my desk.
Hi, Pinal.
Thanks, it’s very useful. I think you should add COALESCE, ISNULL, NULLIF, @@ROWCOUNT, @@ERROR and @@IDENTITY.
Fundooo, Just great and very helpful.
Thank pip this is one the very useful things, I pinned it on ma wall……tanx again
hi sir..
is it necessary to install sql server 2005 than before visula studio 2008??
Hi Pinal,
Thanks a lot!
Regards
Siva
Pinal Sir,
Nice Cheat sheet.Thank you so much.
Regards
Dharmendra
I am not able to access the sheet, can you please update the link / let me know the modified link?
Thanks the Cheat sheet.
FYI original I tried to download the sheet in IE7 (I know 8 & 9 are out) and the download didn’t work. But it did on FireFox 8.
Regards
Mark
thank u sir, I really need it :D