Insufficient data from Andrew Fryer

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

SQL Server Advent Calendar 21 – Consolidation

Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Consolidation has become synonymous with virtualization, but even hardcore VMWare addicts and VMWare themselves advise that databases are one of the last targets of a virtualisation strategy.  Nonetheless SQL Server 2008 is being increasingly virtualised and for those interested in… Read more

SQL Server Advent Calendar 20 – Accidental DBA’s

Day 20 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The accidental DBA is a DBA who ends up looking after SQL Server as part of a number of other duties e.g. Exchange admin, developer etc. This often occurs because SQL Server can survive pretty well despite long periods of… Read more

SQL Server Advent Calendar 19 – Data Collection

Day 19 of my virtual advent calendar, about stuff I like in SQL Server 2008.. I often get asked how much faster is SQL Server 2008 than SQL Server 2000, what impact will virtualisation have on my performance, and my answer in fine Microsoft tradition is it depends.  So how can we begin to answer… Read more

SQL Server Advent Calendar 18 – Audit

Day 18 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Rounding out ways of keeping an eye on what’s happening to your data in SQL Server 2008 is the new auditing feature in Enterprise edition.  As the name suggest it’s there for a specific purpose, to make your compliance work… Read more

SQL Server Advent Calendar 17 – Change Tracking

Day 17 of my virtual advent calendar, about stuff I like in SQL Server 2008.. Today’s topic is the confusingly named change tracking i.e. nothing to do with Change Data Capture (CDC) I mentioned in my last post. CDC is only in enterprise edition only and is there to primarily support population of data warehouses… Read more

SQL Server Advent Calendar 16 – Change Data Capture

Day 16 of my virtual advent calendar, about stuff I like in SQL Server 2008.. One of the main hurdles in refreshing a data warehouse is to work out what’s changed since the last refresh.  If you’re lucky the source will have a last modified date and if you’re really lucky this is actually populated… 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

SQL Server Advent Calendar 13 – Grouping Sets

Day 13 of my virtual advent calendar, about stuff I like in SQL Server 2008.. The SQL Group by clause has been around since I can remember, but in SQL Server 2008 we know have grouping sets.  Imagine you wanted to sum sales amount from the adventure works reseller sales table by year, by Product… Read more