As a new blogger, It is a little pain for me to blog on a technical topic.
It starts from learning, exprimenting, being comfortable with topic, decide what to write and how to convey, make sure no or minimum technical inaccuracies, preparing relavent demo scripts, formatting and so on.
But while going thru his blog post count, varity, depth and presentation style, I have no words.
Here is some of my favourite drops in an Ocean. Would like to explore and continue sharing my favourites whenever I find time.
Wait Statistics
http://www.sqlskills.com/blogs/paul/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
Understanding Logging and Recovery
http://technet.microsoft.com/en-us/magazine/2009.02.logging.aspx
Database Corruption :
Conference corruption demo scripts and example corrupt databases
http://www.sqlskills.com/blogs/paul/post/Conference-corruption-demo-scripts-and-example-corrupt-databases.aspx
Myths around causing corruption
http://www.sqlskills.com/blogs/paul/post/Search-Engine-QA-26-Myths-around-causing-corruption.aspx
Misconceptions around database repair
http://www.sqlskills.com/blogs/paul/post/Misconceptions-around-database-repair.aspx
Top Tips for Effective Database Maintenance
http://technet.microsoft.com/en-us/magazine/2008.08.database.aspx
Inside the Storage Engine:
Anatomy of a page
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx
Anatomy of a record
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-record.aspx
Anatomy of an extent
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-an-extent.aspx
GAM, SGAM, PFS and other allocation maps
http://www.sqlskills.com/blogs/paul/post/Inside-The-Storage-Engine-GAM-SGAM-PFS-and-other-allocation-maps.aspx
IAM pages, IAM chains, and allocation units
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-IAM-pages-IAM-chains-and-allocation-units.aspx
CHECKDB From Every Angle: Complete description of all CHECKDB stages
http://www.sqlskills.com/blogs/paul/post/CHECKDB-From-Every-Angle-Complete-description-of-all-CHECKDB-stages.aspx
How to tell if the IO subsystem is causing corruptions?
http://www.sqlskills.com/blogs/paul/post/How-to-tell-if-the-IO-subsystem-is-causing-corruptions.aspx
Advanced performance troubleshooting: waits, latches, spinlocks
http://www.sqlskills.com/BLOGS/PAUL/post/Advanced-performance-troubleshooting-waits-latches-spinlocks.aspx
Common SQL Server Myths (60 page collection)
http://www.sqlskills.com/blogs/paul/CommonSQLServerMyths.pdf
Tech net Q & A
http://www.sqlskills.com/blogs/paul/category/TechNet-Magazine.aspx
Suggestion by Paul Randal
SQL Server Best Practices Article
http://technet.microsoft.com/library/Cc966412
Thanks