Blog Post

My Favourites Of Paul Randal

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

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating