SQL SERVER – DECLARE Multiple Variables in One Statement
SQLAuthority News – TOP Downloads – Bookmark
Recently I have gotten many, many requests for SQL Server Interview Questions and Answers as well as related articles. It seems many people are looking for Job or appearing for an interview at this time of the year. I have included lists of the my top downloads in the sidebar of the blog, still I receive many curious questions as side bar does not show up in the RSS feed.
SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2
SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh
It has been a long time since I wrote about SQL Humor. Following is the cartoon sent to me by many (more than 10 times) so far by many users. I did not publish it till now as it has been quite popular and I believed many people had already seen it. However, recently by one of the quite big personality asked me why I have not included this in my blog, so I have finally decided to include that in my blog. Let us read humor about SQL Injection.
SQL Server – 2008 – Cheat Sheet – One Page PDF Download
Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and for novice developers it is good to keep all the important SQL Script and SQL Statements handy.
I have attempted to create cheat sheet for SQL Server 2008 most important commands. User can print this in one A4 size page and keep along with them. This can be used in interviews where T-SQL scripts are being asked.