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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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,...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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,...

Author: MSFT Bob 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...

Author: MSFT Bob Date: 09/18/2011

PCIE SSD Update - Optimizing SQL Backup Performance

In my last blog entry...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob Date: 06/06/2010

I love SSD

Been working with 2 PCIE Fusion cards testing out performance for my SQL Server simulation database....

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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,...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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,...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob Date: 01/04/2009

SQL Server Data Model Monitor Series

Place holder for Data Model Monitor

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob 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...

Author: MSFT Bob Date: 06/09/2008