Share via


Benjamin Wright-Jones

Exploring Information, Infrastructure and Solution Architecture

Date: 03/21/2013

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

Date: 07/04/2012

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

Date: 07/02/2012

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

Date: 07/02/2012

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

Date: 06/21/2012

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

Date: 06/07/2012

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

Date: 11/29/2011

Diagnosing and Resolving Spinlock Contention on SQL Server...

Date: 07/06/2011

https://msdn.microsoft.com/en-us/library/hh147624.aspx

Date: 05/06/2011

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

Date: 01/24/2011

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

Date: 10/04/2010

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

Date: 10/04/2010

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

Date: 07/14/2010

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

Date: 07/08/2010

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

Date: 06/24/2010

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

Date: 06/19/2010

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

Date: 06/02/2010

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

Date: 05/25/2010

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

Date: 05/24/2010

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

Date: 05/24/2010

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

Date: 05/06/2010

Here...

Date: 04/24/2010

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

Date: 03/08/2010

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

Date: 02/11/2010

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

Date: 11/04/2009

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

Date: 10/21/2009

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

Date: 09/25/2009

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

Date: 09/16/2009

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

Date: 09/10/2009

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

Date: 09/10/2009

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

Date: 08/29/2009

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

Date: 05/13/2009

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

Date: 05/13/2009

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

Date: 05/07/2009

https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032413070&EventCategory=4&am...

Date: 04/22/2009

Just released https://support.microsoft.com/kb/967909/

Date: 04/21/2009

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

Date: 03/29/2009

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

Date: 03/19/2009

Just published here https://support.microsoft.com/kb/963036

Date: 03/17/2009

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

Date: 02/18/2009

Just published - download from here...

Date: 01/29/2009

Read the publication here...

Date: 12/10/2008

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

Date: 11/24/2008

This is a big announcement made at WinHEC...

Date: 11/07/2008

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

Date: 10/23/2008

In case you haven’t seen this…https://support.microsoft.com/kb/956717

Date: 09/23/2008

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

Date: 09/21/2008

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

Date: 08/27/2008

Just noticed this KB https://support.microsoft.com/kb/956893 which outlines the support policy for...

Date: 08/26/2008

Next>