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.

SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
SQLAuthority News – Wireless Router Security and Attached Devices – Complex Password
SQL SERVER – DATE and TIME in SQL Server 2008

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.

SQL SERVER – Get Latest SQL Query for Sessions – DMV
SQL SERVER – Find Most Expensive Queries Using DMV
SQL SERVER – List All the DMV and DMF on Server

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.

SQL SERVER – Disable Clustered Index and Data Insert
SQL SERVER – Understanding ALTER INDEX ALL REBUILD with Disabled Clustered Index
SQL SERVER – Disabled Index and Update Statistics

Two special post which I found very interesting to write are as following.

SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
SQL SERVER – Simple Example of Snapshot Isolation – Reduce the Blocking Transactions

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)

Filed under: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology