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

Pearls in the Ocean – Part 1

 

In our day to day life with SQL Server, We refer web for many reasons.

This includes understanding new SQL Server features or Recollecting syntax of rarely used commands or to check solutions for unfamiliar errors.

While searching what we need on Web, We may have to come across lots of irrelevant and incomplete pages before finding the right one for us.

But In some instances, quite few pages gain our attention. Those pages not only answer our questions but take our knowledge to the next level.  I see them as pearls in the Ocean.

In this post, I would like to share some of the pearls with our SQL Server Community.

Below links might be familiar for experts. But I feel proud to continue sharing this list with SQL Server Community at regular interval.

1.       13 Things You Should Know About Statistics and the Query Optimizer

http://www.simple-talk.com/sql/t-sql-programming/13-things-you-should-know-about-statistics-and-the-query-optimizer/

2.       Debunking myth about T-Logs in full backups

http://www.sqlskills.com/BLOGS/PAUL/post/Debunking-a-couple-of-myths-around-full-database-backups.aspx

3.       Lock Escalation by Sunil Agarwal

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx

4.       Important checklist collection by Brad Mcgehee

 

http://www.bradmcgehee.com/2010/06/sql-server-operating-system-checklist/

http://www.bradmcgehee.com/2010/06/sql-server-hardware-checklist/

http://www.bradmcgehee.com/2010/08/sql-server-monitoring-checklist-2/

http://www.bradmcgehee.com/2010/10/sql-server-database-maintenance-checklist/

http://www.bradmcgehee.com/2010/06/sql-server-instance-checklist/

 

5.       Great SQL Server Debates: Lock Pages in Memory

http://www.simple-talk.com/sql/database-administration/great-sql-server-debates-lock-pages-in-memory/

 

6.       SQL Server 2008 - Summary of Training Sessions By Jose Barreto

http://blogs.technet.com/b/josebda/archive/2009/04/12/sql-server-2008-summary-of-training-sessions.aspx

 

Have a nice day !!!

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.