So here we are it's Thursday and since I skipped last week's blog of the week I am giving it to you a day early. The blog of the week is Adam Machanic by Adam Machanic. Who is Adam Machanic?
Adam Machanic is an independent database software consultant, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server solutions for a variety of high-availability OLTP and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Machanic has written for SQL Server Professional magazine, serves as SQL Server 2005 Expert for SearchSQLServer.com, and is co-author of "Pro SQL Server 2005". In addition, he regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP). Machanic's latest book, "Expert SQL Server 2005," is due out in early 2007.
What do I like about this blog?
I like the fact that Adam likes to speak his mind, if you post something and Adam thinks he can do it better he will post a solution and leave you a comment (this reminds you to be careful what kind of stuff you post ;-) ). The postings usually are very detailed and give a nice explanation why something works or doesn't work
What are some at the posts I like the most?
Swinging From Tree to Tree Using CTEs, Part 1: Adjacency to Nested Sets
Swinging From Tree to Tree Using CTEs, Part 2: Adjacency to Nested Intervals
Running sums, redux
Running sums yet again: SQLCLR saves the day!
T-SQL Variables: Multiple Value Assignment
Where can I see/read/hear more about the author?
Check the microsoft.public.sqlserver.programming forum and the Transact-SQL msdn forum
Adam also did a podcast for SQL Down Under, scroll down to number 8 to listen to it
So there you have it; the SQL Server blog of the week