Weekend Reading Notes

Note #1 - SQL Server Database Engine Performance Tuning Basics - Must read for every TSQL Developer
Key Learning's

• Perf counter values analysis
• Temp Db configuration
• Enable Lock pages in memory
• Interpreting Avg. Disk Sec/Read values

Note #2 - Microsoft SQL Server Versions and Editions

Key Query  - SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Note #3 - One more NOSQL DB that supports ACID transactions - FoundationDB

Note #4 - SQL Server 2014 In-Memory OLTP: Memory Management for Memory-Optimized Tables

Key Learning's

• Memory optimized Tables(MOT) reside in memory not in disks
• Steps to estimate memory for MOT
• Garbage collection of older version of records (similar to snapshot / read committed isolation levels)

Happy Learning!!!