Microsoft Bob
learn.microsoft.com/en-us/archive/blogs/microsoftbob
NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
DatabasesPerformance / optimizationStorage / filesystemsMicrosoft blogsMSDN archive
- Posts
- 39 from 9 Jun 2008 to 8 May 2014
- Posting
- archived, read-only
- Kind
- personal blog
- Feed
- https://learn.microsoft.com/en-us/archive/blogs/microsoftbob/feed.xml
2014 1
2012 9
- Now at 5.11 GB/s SQL backup to Null/3.12 GB/s local backup with I/O Accelerators
- More clarifications on 3.05 GB/s SQL backup potential for much higher throughput
- A couple of corrections on video
- 1/4 TB SQL Database backup in under 1 Minute!!! (3.05 GBPS transfer rate)
- Quick update on IO Accelerator (testing)
- Over 2 GBps SQL Server 2012 backup on 12-core server with 7 Fusion-IO Cards!
- Software Quality - 4 Key facets (From Linked-in)
- Memory via PCIE-SSD as the authoritative data source
- Boolean KMAP reduction code released after 23 years!
2011 2
2010 7
- PCIE SSD Update - Optimizing SQL Backup Performance
- Back again, Dealing with Storage-aligned Index oddities
- Indexes and SSDs and Random versus Sequential Access
- SSIS – Chunking number of inserts with a For Each container
- Using Checksum to create random data sets
- Managing Index Fragmentation and Compression
- I love SSD
2009 16
- Now a SQL Master
- Trying to catch up
- Nested Identity Keys in SQL?
- A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously
- Cautions with Indexed Views
- Some Uses for Query Hints
- Getting the full exception from .NET
- Fun with Enums and a Generic File Date/Time Stamper
- Using NTILE with Cross Reference Values to Create Dimensions
- Using Persisted Computed Columns in SQL Server Indexes
- Auto-Generating Pivot Views
- Generating a List of Calendar Dates
- Dumping SQL data in pivoted format
- SQL Data Warehousing – Tip 2 – Indexed Views
- SQL Data Warehousing Tips 1 - Building a Period table
- Windows Home Server and Backups for the Paranoid