Microsoft Bob
NOTE: The views expressed on this blog are my own and may not reflect the views of Microsoft
Resuming posting
Haven't posted for a while here and have been using https://bobleith.wordpress.com. I've decided to...
Date: 05/08/2014
Now at 5.11 GB/s SQL backup to Null/3.12 GB/s local backup with I/O Accelerators
This will be my last update for a while, but I did some more shuffling of the database files among...
Date: 10/30/2012
More clarifications on 3.05 GB/s SQL backup potential for much higher throughput
A couple of clarifications - including potential for much greater backup throughput beyond 3 GB/s up...
Date: 10/29/2012
A couple of corrections on video
I should have said that 40 Gbe and 100 Gbe are not widely implemented rather than not...
Date: 10/29/2012
1/4 TB SQL Database backup in under 1 Minute!!! (3.05 GBPS transfer rate)
With the addition of another SATA SSD as well as another SLC Duo to serve as the target destination,...
Date: 10/28/2012
Quick update on IO Accelerator (testing)
Follow-up from last post on 2.0 GBPS backup throughput - was able to update the firmware painlessly...
Date: 10/19/2012
Over 2 GBps SQL Server 2012 backup on 12-core server with 7 Fusion-IO Cards!
I managed to squeeze 2 GBps (2192.207 MBps to be exact) out on 12 cores using a HP Server DL370 with...
Date: 10/18/2012
Software Quality - 4 Key facets (From Linked-in)
I have become active in the Linked-in Community, especially regarding predictive analytics, as there...
Date: 04/29/2012
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...
Date: 03/26/2012
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...
Date: 02/24/2012
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,...
Date: 10/30/2011
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...
Date: 09/18/2011
PCIE SSD Update - Optimizing SQL Backup Performance
In my last blog entry...
Date: 11/08/2010
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...
Date: 11/01/2010
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...
Date: 07/24/2010
SSIS – Chunking number of inserts with a For Each container
My main customer utilizes SSIS for some SQL and Oracle integration requirements. One challenge...
Date: 06/24/2010
Using Checksum to create random data sets
Here’s a quick tip if you don’t want to try to use random and figure out seed, etc. If you’ve...
Date: 06/20/2010
Managing Index Fragmentation and Compression
For today, I recycle bits from a couple of excellent authors in the SQL community. The first script...
Date: 06/06/2010
I love SSD
Been working with 2 PCIE Fusion cards testing out performance for my SQL Server simulation database....
Date: 05/12/2010
Now a SQL Master
After a long and painful process, I have finally achieved this. Was it worth it, would I...
Date: 11/21/2009
Trying to catch up
I apologize as I notice there are some inquiries related to code posted. I should probably set...
Date: 10/06/2009
Nested Identity Keys in SQL?
This weekend I played with partitioning. I have a table with about 10 million rows spanning...
Date: 08/24/2009
A Wrapper for Running SQL Server 2008 Reporting Services Reports Anonymously
With SQL Server 2008, Microsoft re-architected SQL Server Reporting Services (SSRS) to no longer...
Date: 08/20/2009
Cautions with Indexed Views
If you’ve been following my blog, you may remember an article I did extolling the virtues of indexed...
Date: 08/15/2009
Some Uses for Query Hints
Some of you are all set to flame me just because of my title. I know because a couple of years back,...
Date: 08/14/2009
Getting the full exception from .NET
While we're on the topic of .NET coding, here's another technique. If you thought my last post...
Date: 08/04/2009
Fun with Enums and a Generic File Date/Time Stamper
Time for a break from SQL stuff for a little .NET. Have you ever wanted to use the integer...
Date: 08/04/2009
Using NTILE with Cross Reference Values to Create Dimensions
I confess lack of depth in SQL Analysis Services (SSAS). I've read quite a bit about the...
Date: 08/03/2009
Using Persisted Computed Columns in SQL Server Indexes
As part of my research work, I generate thousands of simulations on an almost daily basis for...
Date: 07/10/2009
Auto-Generating Pivot Views
Coming back from the Sci-Fi world of AI, etc to some real world scenarios... Earlier I posted...
Date: 07/10/2009
Generating a List of Calendar Dates
For today, here’s a simple trick. Ever need to get a list of all the calendar dates for a...
Date: 07/05/2009
Dumping SQL data in pivoted format
Technorati Tags: SQL Server,Tips If you’re like me and spend a lot of time in SQL Query Analyzer,...
Date: 06/16/2009
SQL Data Warehousing – Tip 2 – Indexed Views
Last time we discussed the use of a period table to consolidate analysis into smaller segments of...
Date: 05/13/2009
SQL Data Warehousing Tips 1 - Building a Period table
Recently, I started a personal project for analyzing stock market trends and calculating the optimal...
Date: 05/05/2009
Windows Home Server and Backups for the Paranoid
I recently discovered to my chagrin that Windows Home Server is not exactly a secure backup...
Date: 01/04/2009
SQL Server Data Model Monitor Series
Place holder for Data Model Monitor
Date: 06/20/2008
SQL Server 2005 High-Availability Options (Distilled)
Have you ever been asked by a high-level architect or CIO what Microsoft's approach is to a given...
Date: 06/20/2008
Creating the Infrastructure for Capturing a Data Model
At this point, all I've given you is a set of tables that can store metadata about database tables...
Date: 06/12/2008
Monitoring Data Model Changes
Have you ever wanted to view how a database model has evolved over time? It's not that hard to setup...
Date: 06/09/2008