I use these cheatsheets related  to TSQL and/or SQL server from time to time.

 

I can not count on my memory, but, it would be nice to have a photographic one.

 

Enough of my rambling, here is the list:

TSQL Cheatsheet found at Scribd - http://www.scribd.com/doc/399147/TSQL-Cheat-Sheet

SQL Server Cheatsheet found at Scribd - http://www.scribd.com/doc/15235350/SQL-Server-TSQL-Cheatsheet

Dave Pinal or SQL Authority's Cheatsheet - http://www.pinaldave.com/sql-download/SQLServerCheatSheet.pdf 

 

Did I miss any good ones? I'll update this 

This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

Hello, Friends,

This post deviates from my usual postings on SQL and various geeky topics...

After volunteering my time for various IT interest groups... I also volunteer my time at KFAI radio whenever time permits. KFAI radio recently asked me to create multiple videos for their fund raising effort.

I had a lot of fun building them as a humble volunteer.

Here is the link to the 1st video which is about what KFAI symbolizes.

http://www.youtube.com/watch?v=vZrpQ8QfZDc


The 2nd video falls under comedy category and will be released some time friday.



Please visit KFAI radio http://www.kfai.org or http://www.youtube.com/kfairadio and add them as your friend and/or subscribe if you like the content.

Regards,
Rajib Bahar


This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I noticed an interesting blog entry by Kevin Kline. He is talking about code of ethics for DBA professionals. I thought some of us may find it relevant.

 Enjoy the dialogue and debate at [http://sqlblog.com/blogs/kevin_kline/archive/2009/04/21/is-it-time-for-a-professional-code-of-ethics-for-dbas.aspx]

This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I thought the article below was interesting. It talks about the 1st robot capable of generating hypothesis and run experiments to prove it. I could have used one during my undergrad years.

http://www.informationweek.com/news/showArticle.jhtml?articleID=216402727

 

This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

Here are couple of blog/forum entries I find useful and fun to read outside of the great Books Online resource:

1. http://www.bennadel.com/blog/938-Using-A-SQL-JOIN-In-A-SQL-UPDATE-Statement-Thanks-John-Eric-.htm

2. http://www.sqlservercentral.com/Forums/Topic493913-338-1.aspx

3. http://www.bennadel.com/blog/938-Using-A-SQL-JOIN-In-A-SQL-UPDATE-Statement-Thanks-John-Eric-.htm

4. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=100415

This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I will appreciate if my colleagues and peers would consider looking at this thread I opened at SQL Server Central [http://www.sqlservercentral.com/Forums/Topic661376-1063-1.aspx]. Thanks and have a good day!

 

Update [10/01/2009]:

Thanks to Luke at [SQLServerCentral.com] forum I was able to find the answer. He pointed me to a MSDN article, which in turn pointed to this article [http://msdn.microsoft.com/en-us/library/ms156281.aspx]. That helped me figure out how to do it. If I have time then I'll produce steps on how to reproduce it later.

 

 

This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I was reading some article and landed on this news item. Bill Gates released a bug in some tech event... See http://www.pcworld.com/article/158979/bill_gates_releases_bugs_into_the_wild.html. I am relieved by the fact that I wasn't there. I am sure this may give a new meaning to releasing software bugs... :)


This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I get a lot of questions from my peers about finding a good place to get SQL server interview questions. I have had the privilege of being both the interviewor and interviewee. So, I thought I'd put together a collection on my blog. I look forward to hearing your comments. Please post your favorite or most challenging questions on SQL server.

Here is the list of links to blogs and/or websites that I found useful:

• Comprehensive list of SQL Server Interview questions from Pinal Dave. He is the founder of sqlauthority.com. It's also published at the Code Project website. - http://blog.sqlauthority.com/2007/04/21/sql-server-interview-questions-and-answers- complete-list-download/
• Phone interview tips for DBAs - http://www.mssqltips.com/tip.asp? tip=1472
• Nishant's 9 part series on SQL interview questions - http://www.careerride.com/SQLServer-Interview-Questions.aspx
• Vyas's collection of SQL Server questions - http://vyaskn.tripod.com/iq.htm
• SQL Developer Interview questions from Tech Republic - http://mssqlinterview.blogspot.com/

This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I am asking this question to all of my SQL Server colleagues. There is no right or wrong answer to this. I am interested in learning the experience others have with VLDB systems. Please share your stories. I will compile the responses and make a newer blog entry. That new entry will have your story and link back to your blog if you have any. Feel free to send your responses via facebook, twitter, plaxo, linkedin, livespace, and email. Thanks


This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.

I like the new debugging capabilities of SQL Server 2008. It brings in features such as stepping in, stepping out, and stepping over. This can come handy when we are trying to track the actual issue. I found this feature interesting because it empowers developers to track issues at the most granular level. Now, we can step inside system functions, and stored procedures to figure out the values of internal variables and sets. See the video below for a quick guide on how to debug in SQL Server 2008 management studio.



This posting is provided "AS IS" with no warranties, and confers no rights. It does not reflect any one's opinion other than the author.