Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

Licensing and Scaling up SQL Server BI

Both Standard and Enterprise editions of SQL Server come with a lot more than just a database engine, there’s also a suite of BI tools: Integration Services (SSIS) Reporting Services (SSRS) Analysis Services (SSAS) which you are also licensed to use on the same server as the database engine.  That might be OK for a… Read more

SQL Server Advent Calendar 15 – Integration Services Profiling

Day 15 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If there were no issues with data quality in data warehouses I would have completed many of my BI projects in a third of the time.  The client would always insist they had good data, after all it would often… Read more

SQL Server Advent Calendar 14 – Integration Services Lookups

Day 14 of my virtual advent calendar, about stuff I like in SQL Server 2008.. If it aint broke don’t fix it, is probably best aimed at Integration Services in SQL Server 2008. So what was ‘fixed’?  The most important thing was the performance of lookups, both in terms of speed and memory usage.  To… Read more

High Availability Integration Services in SQL server

I see a lot of people asking about how to make integration services highly available and there isn’t an easy answer, so let me explain why. Integration services (SSIS) is designed to bulk move a set of data from a source to a target while performing some sort of translation on the way.  The most… Read more

SQL Server 2008 Merge and Integration Services

The new Merge T-SQL command has great potential in a data warehouse scenario and Integration Services is the tool in SQL Server to load the data warehouse so how do they fit together in SQL Server 2008? The answer is not really and I am not sure they should, so let me explain why. Integration… Read more

Deprecated Features in SQL Server 2008

My first ever post was about the features in SQL Server 2000 that were deprecated in SQL Server 2005 i.e. they wouldn’t be available in the next release (SQL Server 2008). In the same way there are SQL Server 2005 features that will be deprecated in SQL Server 2008, they will still work and be… Read more

SQL Server 2008 Performance

It is already possible to get an indication of how well SQL Server 2008 will perform before it is released as there already some TPC benchmarks published for it.  The performance of Integration Services has been separately tested, as have a number of applications such as Microsoft Dynamics and SAP.  The links to all of… Read more

Upgrading SQL Server Business Intelligence

Continuing my series of posts on upgrade, I thought it might be good to have a look at the business intelligence components of SQL Server, so here’s a simple grid that I have adapted from Scalability Experts for use in the upgrade workshops and presentations I give: Along the top is the upgrade path e.g…. Read more

Upgrading Data Transformation Services (DTS)

One of the biggest headaches in migrating away from SQL Server 2000 is Data Transformation Services (DTS).  The tool is very widely used and its initial simplicity no doubt contributed to that. A good example is of several Oracle sites where SQL Server was sat in a corner simply to move data between Oracle databases… Read more