"No one is harder on a talented person than the person themselves" - Linda Wilkinson ; "Trust your guts and don't follow the herd" ; "Validate direction not destination" ;
Showing posts with label Learning Resource - Good Reads. Show all posts
Showing posts with label Learning Resource - Good Reads. Show all posts

February 12, 2013

Database Internals [Good Reads]

Please download and read white paper 'OLTP Through the Looking Glass, and What We Found There'

The whitepaper provides more details on current architecture of OLTP RDBMS Systems. I can closely relate it with MSSQL Server. It covers the key architecture details. The Paper evaluates options by eliminating some of the features based on current hardware systems and demonstrates significant performance gains
 
At a beginner level some of architecture keywords / concepts good to learn are
  • WAL (Write Ahead Logging)
  • Log Manager
  • Buffer Manager
  • Two Phase Locking
  • Concurrency 
  • Eventual Consistency
  • Transaction Manager
I am posting some relavant simple explanations of the same based on MSDN documentation. WAL -
 
Write Ahead Logging (Source - Link)
 
 
Buffer Manager - Page is fetched to main memory through Buffer Manager (Source - Link)
  

Two Phase Locking - A detailed note of how transaction is executed from Brent Ozar Post
 
Concurrency Control - Governed by Isolation levels, Earlier discussed in same blog
 
Log Manager - Manages Logging, WAL
 
Eventual Consistency - Over a period of time the data will be consitent across different nodes (databases) distributed over network. Read More @ Consistency models in nonrelational dbs 
 
 
More Reads  
 
Happy Reading!!! 

January 26, 2013

Good Tech Talk - Making Better Software - QA & DEV

Today I checked this tech talk. This is very very good. **MUST VIEW** for passionate DEV / QA / IT Pro. Complete Tech Talk is inspiring, offers a lot of improvement ideas
 

Between 24:31 to 30:52 minutes

Very Good Joel talk on test skills, testing competency and also covers **Agile QA**
 
Summary of QA Talk
  • Benefits of Having QA in a Team
  • Benefits of Rapid Feedback between Dev & QA
  • Tools for testing + Functional testing both are critical
Between 32:34 to 34:37 minutes
  • How Writing code vs Developing a Great product differs?
Between 44:18 to 48:54
  • Intrinsic and Extrinsic motivation
  • Intrinsic Motivation matters!!
 
Hope you enjoyed the tech talk. Happy Listening!!!

October 08, 2012

Interesting Post - Learn to Code (Startup Tips)

This post is to highlight few lines from Post on Learning to Code. If you have plans to do a startup it is useful and advantageous if you know to write code, passion for technology.



Happy Learning!!!

May 29, 2012

Recommendation Engine for Ecommerce Sites


Excellent post on designing Recommendation Engine. Very good approach by Ricky Ho.
 
More Reads
 
 Happy Reading!!!