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