Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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