Subscribe: Benjamin Wright-Jones
http://blogs.msdn.com/benjones/rss.aspx
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
archive  aspx  contention sql  contention  data  diagnosing resolving  file  microsoft  server  service applications  service  sql server  sql  ssis 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: Benjamin Wright-Jones

Benjamin Wright-Jones



Exploring Information, Infrastructure and Solution Architecture



Last Build Date: Tue, 21 Jul 2015 22:01:27 +0000

 



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

Thu, 21 Mar 2013 13:44:30 +0000

Author: Benjamin Wright-Jones (Microsoft) Contributors: Karthika Raman (Microsoft) Technical Reviewers: Guy Bowerman (Microsoft), Sanjay Nagamangalam (Microsoft) I have recently been exploring the use IaaS (Infrastructure as a Service) to provide cloud-based virtual machines (VM’s) as opposed to laptop-based VM’s and also PaaS (Platform as a Service) for SQL databases.  I like the idea of carrying...



Building a data mart to analyse web log traffic

Thu, 19 Jul 2012 12:47:12 +0000

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...



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

Wed, 04 Jul 2012 22:58:58 +0000

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.  ...



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

Mon, 02 Jul 2012 14:11:25 +0000

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...



Are you interested in Data Science?

Mon, 02 Jul 2012 07:52:19 +0000

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



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

Thu, 21 Jun 2012 09:22:24 +0000

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....



Transposing Columns onto Rows

Thu, 07 Jun 2012 10:38:50 +0000

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...



BI Service Applications in SharePoint 2010

Tue, 29 Nov 2011 01:29:14 +0000

One of my colleagues, Chris Bailiss, has written a number of great articles describing how BI service applications authenticate in SharePoint 2010.  If you are interested then head over here to part 1 (link below) now: http://blogs.msdn.com/b/mcsukbi/archive/2011/11/26/bi-service-applications-in-sharepoint-2010-authentication-classic-vs-claims-and-identity-delegation-kerberos-part-1.aspx



Two new SQLCAT papers available, Spinlock and Latch Contention

Wed, 06 Jul 2011 01:21:41 +0000

Diagnosing and Resolving Spinlock Contention on SQL Server http://sqlcat.com/whitepapers/archive/2011/07/05/diagnosing-and-resolving-spinlock-contention-on-sql-server.aspx Diagnosing and Resolving Latch Contention on SQL Server http://sqlcat.com/whitepapers/archive/2011/07/05/diagnosing-and-resolving-latch-contention-on-sql-server.aspx



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

Fri, 06 May 2011 05:49:55 +0000

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