Category Archives: Uncategorized

Software Quality – 4 Key facets (From Linked-in)

I have become active in the Linked-in Community, especially regarding predictive analytics, as there are many very good discussion groups. So, to save effort and still get a couple of hours of sleep, a lot of my posting here will … Continue reading

Posted in Uncategorized | Leave a comment

Memory via PCIE-SSD as the authoritative data source

i’ve blogged a few times about Fusion-IO devices and my experiences with SSD. I’ve been thinking about the implications of large in-memory databases that retain persistence and transactional capabilities. Turns out the game may be changing long-term to an in-memory … Continue reading

Posted in Uncategorized | Leave a comment

Boolean KMAP reduction code released after 23 years!

Yes, I know its been a while since I have posted anything and way past due to post my update on my fusion-io card testing (I now have 6 memory devices in my R710 – 2 cards are duo). I … Continue reading

Posted in Uncategorized | Leave a comment

Update on PCIE-SSD (Fusion-IO) Performance

I’ve been working on this and wanted to achieve max throughput before posting, but since I am stuck, thought I would post what I have to this point. I have 4 Fusion-IO cards including a duo in a 12 core … Continue reading

Posted in Uncategorized | Leave a comment

SSD Updates and Status of Blog

I’m sorry it’s been so long since I’ve posted.  Been very busy with a DoD project.  I plan to add a post soon on how my SSD experience is going.  I have now accumulated 7 PCIE Fusion SSD cards (3 … Continue reading

Posted in Uncategorized | Leave a comment

PCIE SSD Update – Optimizing SQL Backup Performance

In my last blog entry (http://blogs.msdn.com/b/microsoftbob/archive/2010/11/06/the-potential-of-ssd-for-millions-of-iops-on-increasingly-larger-databases.aspx), I shared the throughput numbers backing up from 2 Fusion-IO devices to a 4-spindle 15K SAS Raid-10 device.  I also shared the numbers of backing up to NUL device, and was surprised they weren’t … Continue reading

Posted in Uncategorized | Leave a comment

The potential of SSD for millions of IOPS on increasingly larger databases

NOTE: There is an update to this article at http://blogs.msdn.com/b/microsoftbob/archive/2010/11/08/pcie-ssd-update-optimizing-sql-backup-performance.aspx regarding the throughput I was able to achieve on my own configuration with the Fusion-io backup process.  Through some parameter changes on the backup command, was able to double the … Continue reading

Posted in Uncategorized | Leave a comment

Back again, Dealing with Storage-aligned Index oddities

I’m back after being on leave for past several weeks in case you wonder why I haven’t posted.  To quote Joy Gresham from the move ShadowLands “I wasn’t dead, I was just in America (fill-in-the-blank)” This was one of my … Continue reading

Posted in Uncategorized | Leave a comment

Indexes and SSDs and Random versus Sequential Access

If you’re one of the dozen or so people who follow my blog, you’re aware that I’m using SSDs for my doctoral research project involving simulations to find solutions to complex data correlation problems.  I finally have started to get … Continue reading

Posted in Uncategorized | Leave a comment

SSIS – Chunking number of inserts with a For Each container

My main customer utilizes SSIS for some SQL and Oracle integration requirements.  One challenge they’ve had is timeouts from the Oracle side.  We’ve tried everything to eliminate the issue in terms of extending timeout values within SSIS, but the problem … Continue reading

Posted in Uncategorized | Leave a comment