Building a data mart to analyse web log traffic

I recently had the opportunity to build a data mart in order to analyse web logs from IIS servers.  The solution utilised SQL Server 2012 Database Engine, Integration Services, Analysis Services and Excel 2010 (to slice/dice the data).    Loading IIS logs (text files with fixed width spaces) was fairly challenging due as the column definitions…

4

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 default trace file which is generated by SQL Server.  The contents of the file can be quite useful for troubleshooting or diagnosis purposes. I’ve updated the package to work with SQL Server 2008 R2 and SQL Server 2012.  …

2

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 (quite a while ago).  I mistakenly forgot to add the full source code, sorry everyone.  Here is the link to the original blog post:  http://blogs.msdn.com/benjones/archive/2009/03/29/using-a-c-script-task-in-ssis-to-download-a-file-over-http.aspx I have since imported the SSIS package into Visual Studio 2010 (BIDS) and…

0

Are you interested in Data Science?

The University of Dundee is now gauging interest in a number of data science focused courses (see below). You can register interest via this link http://www.dundee.ac.uk/admissions/new_courses/register.php

0

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 (multi-instance) scenarios and also validate SQL Server 2012 Always On configurations.  I was previously running Windows Server 2008 R2 on my laptop but I a few issues using this as a day to day operating system e.g….

1

Transposing Columns onto Rows

After a long period of absence, I have returned to posting some blog articles.  This one popped up last week from an Oracle DBA while I was onsite with a customer.  The conversation went something along the lines of: Oracle DBA: “How can I place columns values on rows? I have a limited page width…

3