Monthly roundups are very refreshing as it gives me a chance to go back and see what did I do last month. The highlight of the last month is my computed column series and its final installment. If you have not followed up on it I suggest you read SQL SERVER – Computed Columns – Index and Performance. I have great fun to investigate the computed column. The second fun thing was to write about views. I am still going to write more article on this subject but at least the series has started in this month. Following are the first two articles in the series.
- SQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1
- SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
Community events are in my blood and I always enjoyed being part of it. I had a few reports as listed below where I did a community event. Salute to the community which is so vibrant.
- SQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success
- SQLAuthority News – Community Tech Days, Ahmedabad – July 24, 2010
- SQLAuthority News – Feedback Received for Virtual Tech Days Sessions on Spatial Database
Career Development or professional development is always burning questions for all. I had great fun to write about when one can take vacation SQL SERVER – Best Practices for DBA Before Taking Vacation. There were lots of curious looks at my article on Shrinking Database SQL SERVER – SHRINKDATABASE For Every Database in the SQL Server. Many people online either refused to see it just based on the title. Many online tried to even call big gurus to start controversy, however, all went well once people start reading the article. I had a really good discussion also on the article SQLAuthority News – Why SQL Server is better than any other RDBMS Applications?. Obviously, SQL Server is the best.
Performance tuning has been my favorite subject always so I have two new announcements this month as well.
There were few more articles but the one which really makes you think was SQL SERVER – Does Order of Column in WHERE clause Matter?. Additionally, there were many other articles I have written during the month, you can check all the articles written by me over here. Tell me which one was your favorite article this month’s roundups.
Reference : Pinal Dave (https://blog.sqlauthority.com)