Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

LivingForSqlServer

I am Ramkumar, 34 years old Consultant, trainer, blogger and speaker at SQL Server user group in India. I have more than 10 years of experience as a developer and SQL Server DBA. I love reading, teaching and blogging about SQL Server internals and performance tuning. My Facebook page: https://www.facebook.com/LivingForSqlServer

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

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.