Random thoughts and links on Storage
If there was ever a post true to the part of the tagline of my blog that mentions random thoughts, this is it. :-)
This post is a compilation of my tweets from today, which cover several different topics related to Storage.
- Microsoft Research: Dryad Project: Writing parallel and distributed programs to scale from a small cluster to a large data-center https://bit.ly/cbFrJw
- Microsoft Research: SCOPE: Easy and Efficient Parallel Processing of Massive Data Sets https://bit.ly/16tivz
- Windows Azure Storage presentation (video recording) by Brad Calder delivered during the MIX conference. https://bit.ly/JPJM3
- Understanding Block Blobs and Page Blobs - https://msdn.microsoft.com/en-us/library/ee691964.aspx
- Beta Release of Windows Azure Drive (announced as XDrive at PDC 2009) - https://bit.ly/b1kUy0
- Windows Azure drive acts as a local NTFS volume that is mounted and cached on the local file system - https://bit.ly/aKWsix
- Exchange Server Protocol Documents - https://msdn.microsoft.com/en-us/library/cc425499(EXCHG.80).aspx
- Exchange Server 2010 Database and Log I/O Performance Factors - https://technet.microsoft.com/en-us/library/ee832791.aspx
- Uncovering Exchange 2010 Database Availability Groups (DAGs) - Three-part article - https://bit.ly/7K6IlH
- SMART dealing with HDD unreliability (Self-Monitoring, Analysis, and Reporting Technology) https://en.wikipedia.org/wiki/S.M.A.R.T.
- Migrating server storage to SSDs: analysis of tradeoffs - https://academic.research.microsoft.com/Paper/5872181.aspx
- Adaptec MaxIQ - SSD Cache Performance Solution with hybrid arrays - https://bit.ly/dd4iJY
- The following lists identify, characterize and link to more thorough information on computer file systems - https://bit.ly/auaM6y
- In computer systems, a snapshot is a copy of the state of a system at a particular point in the past. https://bit.ly/bSVuEr)
- How NTFS works - Details on NTFS Architecture https://technet.microsoft.com/en-us/library/cc781134(WS.10).aspx
- Basic Disks vs. Dynamic Disks - MBR vs. GPT - https://msdn.microsoft.com/en-us/library/aa363785(VS.85).aspx
- File Systems in Windows: FAT16, FAT32 and NTFS - https://bit.ly/dvSvS6 (old article, but still nice to understand NTFS basics)
- Checklist: Create a Clustered File Server in Windows Server 2008 R2 - https://technet.microsoft.com/en-us/library/cc753969.aspx
- Failover Cluster Step-by-Step Guide: Configuring a Two-Node File Server Failover Cluster - https://bit.ly/bFNSMO
- 1998: SQL Server 7.0 releases, supporting 1TB of storage. Terraserver was the poster-child DB back then https://bit.ly/apigSi
- Details on how SQL Server stores the actual data (pages) in its files - https://bit.ly/9amObf
- Column stores: databases that store content by column rather than by row. https://bit.ly/2nh4TC
- SQL Server 2008 R2 Parallel Data Warehouse (aka "Madison"): DW performance at low cost via MPP https://bit.ly/1aWTox
- Fusion-io and SQL Server 2008 - https://bit.ly/8ZhF1V
- Deploying SQL Server 2008 with PS6000S array with SSD - https://bit.ly/aozwOV
- A Case for Flash Memory SSD in Enterprise Database Applications - https://portal.acm.org/citation.cfm?id=1376616.1376723
- Unbundling Transaction Services in the Cloud - https://research.microsoft.com/apps/pubs/default.aspx?id=81294
- H-Store: A Next Generation OLTP DBMS - https://db.cs.yale.edu/hstore/
- Microsoft Sync Framework enables collaboration and offline access for applications, services and devices. https://bit.ly/cFP4s8
- SQL Azure - A SQL relational database in the cloud, which you use just like an on-premise SQL Server. https://bit.ly/COx8T
- SQL Azure offers - prices and sizes (up to 10GB per DB you can have multiple DBs) - https://bit.ly/cWLpvb
- SQL Azure Database became generally available this month: https://bit.ly/bxXZmc - SLAs in effect: https://bit.ly/bFFFfp
If you have some free time to read white papers or review presentations (new and old) on Storage, have fun with them...