After receiving lots of requests from different readers for long time I have decided to write first monthly round up. If all of you like it I will continue writing the same every month. In fact, I really like the idea as I was able to go back and read all of my posts written in this month.
This month was started with answering one of the most common question asked me to about What is Adventureworks? Many of you know the answer but to the surprise more number of the reader did not know the answer. There were few extra blog post which were in the same line as following.
DMVs are also one of the most handy tools available in SQL Server, I have written following blog post where I have used DMV in scripts.
I was able to write two follow-up of my earlier series where I was finding the size of the indexes using different SQL Scripts. And in fact one of the article Powershell is used as well. This was my very first attempt to use Powershell.
SQL SERVER – Size of Index Table for Each Index – Solution 2
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell
SQL SERVER – Four Posts on Removing the Bookmark Lookup – Key Lookup
Without realizing I wrote series of the blog post on disabled index here is its complete list. I plan to write one more follow-up list on the same.
Two special post which I found very interesting to write are as following.
In personal adventures, I won the Community Impact Award for Last Year from Microsoft. Please leave your comment about how can I improve this round up or what more details I should include in the same.
Reference: Pinal Dave (http://blog.SQLAuthority.com)