Posts by author
Ben Gallagher
How to keep your SQL Server data clean – efficiently!
Working with very large datasets (for example when identifying duplicate records using matching software) frequently can throw up performance problems if you are running queries returning large volumes of data. However there are some tips and tricks that you can use to ensure your SQL code works as efficiently as possible. In this blog post, I’m going to…
Where Is Your Bad Data Coming From?
As Kimball documents in The Data Warehouse Lifecycle Toolkit (available in all good book stores), there are five concepts that together, can be considered to define data quality: