New editions of SQL Server 2008 R2 announced

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

Processing Excel files in SSIS 2008 – Lessons Learned

I have recently been working on a project where we need to load and transform data held in Excel 2007 into a SQL Server database.  The Excel sheets were fairly complex and had different structures.  Fortunately, SSIS 2008 provides some good tools to handle this situation.  Lessons learned 1. It is possible to read the…


Changing the LISTENER_IP address in a database mirroring configuration

This question came up today: how can I change the IP address between the principal and mirror in database mirroring? Not a common operation but this procedure worked in an isolated lab environment where we had full control over the application and transaction activity.  We wanted to introduce a WAN latency injector so needed to…

New HP Resources on SQL Server 2008 Data Warehousing / Business Intelligence

I haven’t had a chance to look through these yet so I can’t comment on the content but I thought I would post here to share these new resources. HP Business Intelligence Sizer for Microsoft SQL Server 2005/2008 HP Whitepapers on SQL Server 2008 Data Warehousing / Business Intelligence

Troubleshooting SQL Server Transactional Replication

I often see questions about transactional replication performance problems, especially around latency/delays between the publisher and subscriber(s) so I’ve put a few pointers below on what to investigate.  Latency between the publisher, distributor and subscriber(s) is, more often than not, the symptom of other causes for example, poor I/O capacity on subscribers, blocking/locking, hotspots on…

Fusion IO 640GB SSD PCI-Express Cards

We recently had the opportunity to test a couple of the Fusion IO PCI-Express 640GB SSD cards in a Dell R900 server, unfortunately time was against us and we were unable to do this. The Fusion IO SSD cards would dramatically increase the IOPS capacity and personally, I think they would be suited to…

SQL Server 2008 Books Online (July 2009) Update

Only just noticed that a new revision of the SQL Server 2008 Books Online documentation has been published, the download is here

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

I find it frustrating that the SQL Server 2005/2008 default trace is continually overwritten and there is no way to store x number of files or x MBs of data.  As a workaround, I developed an SSIS package to monitor the \LOG folder and automatically archive the default trace file whenever a new file is…


SQL Server 2008 R2 Master Data Services

In case you missed the Tech-Ed 2009 announcement, you can find the info here “On initial scoping, it was determined that ‘Bulldog’ would ship as part of Microsoft Office SharePoint in the O14 wave.  At TechEd 2009, we announced a change in packaging for the new MDM capabilities. Project ‘Bulldog’ will now ship as…


Initializing a Transactional Replication Subscriber from an Array-Based Snapshot

After a few late nights, some coffee and a few review cycles, a new article has just been published on the SQLCAT site which provides an overview of the subscriber initialisation techniques for transactional replication and, more specifically using an array-based snapshot