-
Recent Posts
Recent Comments
Bob L on Moving Databases from One Inst… Bob L on History may not repeat, b… Michael Abrams on History may not repeat, b… Mark Polczynski on Moving Databases from One Inst… emilie parker on Now at 5.11 GB/s SQL backup to… Archives
- August 2016
- June 2016
- October 2015
- September 2015
- August 2015
- July 2015
- February 2015
- December 2014
- July 2014
- May 2014
- March 2014
- February 2014
- November 2013
- September 2013
- August 2013
- July 2013
- March 2013
- October 2012
- April 2012
- March 2012
- February 2012
- October 2011
- September 2011
- November 2010
- July 2010
- June 2010
- May 2010
- November 2009
- October 2009
- August 2009
- July 2009
- June 2009
- May 2009
- January 2009
- June 2008
Categories
- 2FA
- Artificial Intelligence
- Azure
- Cloud
- data security
- Fusion-io
- Hyper-v
- Machine learning
- Mulifactor Authentication
- Problem Solving
- Security
- SQL Server
- SQL Tips and Techniques
- Stock Market
- Technical Analysis
- Uncategorized
- Virtualization
- Windows Server
- Windows Server 2008 R2
- Windows Server 2012
- Windows Server 2012 R2
Meta
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