Benjamin Wright-Jones

Exploring Information, Infrastructure and Solution Architecture

Using PowerShell to deploy Windows Azure Virtual Machines and Windows Azure SQL Databases

Author: Benjamin Wright-Jones (Microsoft) Contributors: Karthika Raman (Microsoft) Technical...

Author: superlatch Date: 03/21/2013

Redux: Using an SSIS package to monitor and archive the default trace file

I’ve recently been asked for details regarding the SSIS package I wrote to copy and archive the...

Author: superlatch Date: 07/04/2012

Redux: Using a C# script task in SSIS to download a file over http

A few people have asked for further information about the C# script task which I blogged about...

Author: superlatch Date: 07/02/2012

Are you interested in Data Science?

The University of Dundee is now gauging interest in a number of data science focused courses (see...

Author: superlatch Date: 07/02/2012

Testing SQL Server HA using Hyper-V in Windows 8 Release Preview

I often find the need to build and test SQL Server clusters to support native two-node or N+1...

Author: superlatch Date: 06/21/2012

Transposing Columns onto Rows

After a long period of absence, I have returned to posting some blog articles.  This one popped...

Author: superlatch Date: 06/07/2012

BI Service Applications in SharePoint 2010

One of my colleagues, Chris Bailiss, has written a number of great articles describing how BI...

Author: superlatch Date: 11/29/2011

Two new SQLCAT papers available, Spinlock and Latch Contention

Diagnosing and Resolving Spinlock Contention on SQL Server...

Author: superlatch Date: 07/06/2011

Whitepaper Alert: Microsoft EDW Architecture, Guidance and Deployment Best Practices

Author: superlatch Date: 05/06/2011

Creating custom reports against the System Center Operations Manager 2007 R2 data warehouse

It is possible to create custom reports, using SQL Server 2008 Reporting Services, against the...

Author: superlatch Date: 01/24/2011

Using SQL Server 2008 R2 Best Practice Analyzer against Analysis Services

SQL Server 2008 R2 BPA is an excellent and often under-used, tool.   The title is a little...

Author: superlatch Date: 10/04/2010

Debugging Parameters in the SSIS Data Flow (Script Component)

I had unfortunately picked up the (bad) habit of debugging my SSIS packages by using

Author: superlatch Date: 10/04/2010

Editing XML using PowerShell

I recently had a requirement to edit an XML document using PowerShell  Fortunately, this is a...

Author: superlatch Date: 07/14/2010

SQL Server 2008 Service Pack 2 CTP

Just noticed that we have posted SQL Server 2008 Service Pack 2 CTP on, here is the...

Author: superlatch Date: 07/08/2010

Using Visual Studio Test Tools to troubleshoot and reproduce database performance issues

Visual Studio test suite contains a very useful set of tools to help troubleshoot and reproduce...

Author: superlatch Date: 06/24/2010

Best Practice Analyzer is back

BPA is back for SQL Server 2008 and SQL Server 2008 R2...

Author: superlatch Date: 06/19/2010

Blogs from Microsoft Consultancy Services

Microsoft Consultancy Services (UK) has recently started blogging.  These are team-based blogs...

Author: superlatch Date: 06/02/2010

SQL Azure vs. SQL Server

I’ve just read the SQL Azure vs. SQL Server whitepaper...

Author: superlatch Date: 05/25/2010

Backing up to NUL(L)?

Some of you may be wondering why you would want to do this.  We had a real requirement in a...

Author: superlatch Date: 05/24/2010

SQL Server 2008 R2 Cumulative Update 1

Hot on the heels of the RTM release of SQL Server 2008 R2, we have just announced the first...

Author: superlatch Date: 05/24/2010

Hotfix Alert: Identifying poor I/O

We have just released a hotfix to help identify poor I/O issues on Windows Server 2008 and Windows...

Author: superlatch Date: 05/06/2010

SQL Server 2008 R2 RTM BOL now available


Author: superlatch Date: 04/24/2010

Using SSIS with SQL Azure databases

I’m quite surprised how easy it is to setup an SSIS package to read and write data to a SQL Azure...

Author: superlatch Date: 03/08/2010

Performance monitor, SQL Server and PAGE compression

I tend to automate perfmon collection with logman.exe logging to a SQL Server 2008 database via the...

Author: superlatch Date: 02/11/2010

New editions of SQL Server 2008 R2 announced

SQL Server 2008 R2 Datacenter SQL Server 2008 R2 Parallel Data Warehouse...

Author: superlatch Date: 11/04/2009

Processing Excel files in SSIS 2008 – Lessons Learned

I have recently been working on a project where we need to load and transform data held in Excel...

Author: superlatch Date: 10/21/2009

Changing the LISTENER_IP address in a database mirroring configuration

This question came up today: how can I change the IP address between the principal and mirror in...

Author: superlatch Date: 09/25/2009

New HP Resources on SQL Server 2008 Data Warehousing / Business Intelligence

I haven’t had a chance to look through these yet so I can’t comment on the content but I thought I...

Author: superlatch Date: 09/16/2009

Troubleshooting SQL Server Transactional Replication

I often see questions about transactional replication performance problems, especially around...

Author: superlatch Date: 09/10/2009

Fusion IO 640GB SSD PCI-Express Cards

We recently had the opportunity to test a couple of the Fusion IO PCI-Express 640GB SSD cards...

Author: superlatch Date: 09/10/2009

SQL Server 2008 Books Online (July 2009) Update

Only just noticed that a new revision of the SQL Server 2008 Books Online documentation has been...

Author: superlatch Date: 08/29/2009

Using an SSIS package to monitor and archive the default trace file

I find it frustrating that the SQL Server 2005/2008 default trace is continually overwritten and...

Author: superlatch Date: 05/13/2009

SQL Server 2008 R2 Master Data Services

In case you missed the Tech-Ed 2009 announcement, you can find the info here...

Author: superlatch Date: 05/13/2009

Initializing a Transactional Replication Subscriber from an Array-Based Snapshot

After a few late nights, some coffee and a few review cycles, a new article has just been published...

Author: superlatch Date: 05/07/2009

Technet Webcast: An Early look at SQL Server ‘Kilimanjaro’ and project ‘Madison’

Author: superlatch Date: 04/22/2009

SQL Server 2005 Service Pack 3 Cumulative Update 3

Just released

Author: superlatch Date: 04/21/2009

Using a C# script task in SSIS to download a file over http

I recently had a requirement to automate downloading a file from an website and then perform ETL on...

Author: superlatch Date: 03/29/2009


[Non-SQL related] I’ve just discovered an interesting site called Microspotting which came to my...

Author: superlatch Date: 03/19/2009

SQL Server 2008 CU4 released

Just published here

Author: superlatch Date: 03/17/2009

Why is sp_dbmmonitorresults failing with invalid object?

I recently setup a simple database mirroring config on my latpop (two instances SQL Server 2005 SP3...

Author: superlatch Date: 02/18/2009

SQL Server 2008 System Views Map in PDF or XPS

Just published - download from here...

Author: superlatch Date: 01/29/2009

SQLCAT publish new article on transaction log performance..

Read the publication here...

Author: superlatch Date: 12/10/2008

Readtrace updated

In case you haven’t seen this, readtrace has been updated to also support the SQL Server 2008 trace...

Author: superlatch Date: 11/24/2008

Support for more than 64 logical processors

This is a big announcement made at WinHEC...

Author: superlatch Date: 11/07/2008

New performance monitor counters for SQL Server 2008

I have been looking at some of the new performance counters that are shipped with SQL Server...

Author: superlatch Date: 10/23/2008

SQL Server 2008 CU1 has just been posted

In case you haven’t seen this…

Author: superlatch Date: 09/23/2008

Making a database clone using SMO

I’ve been playing around with SMO a bit more over the past few days as I’m finding it really useful...

Author: superlatch Date: 09/21/2008

How can I generate a T-SQL script for just the indexes?

I was trying to work out the best way to generate a T-SQL script for only the indexes and I thought...

Author: superlatch Date: 08/27/2008

Finally some guidance on SQL Server and Hyper-V

Just noticed this KB which outlines the support policy for...

Author: superlatch Date: 08/26/2008