Bash for ETL pre-processing
People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today
2016-08-15
5,958 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
Data Quality - Addressing non-stated requirements
Producing a crib sheet for data quality drives a shared understanding of the data used to power the business.
2016-07-28
1,310 reads
RANDom traps for the unwary
The Books Online description of the RAND() function is only true from certain perspectives.
2016-05-09
2,693 reads
What’s in a name?
When a business does not have an agreed set of definitions for their every day terms slow burning chaos ensues.
2016-05-04
92 reads
Getting ready for Hadoop
Before adopting Hadoop into your organisation there are a number of factors to consider. This article highlights some of the key points.
2015-11-23
6,358 reads
Deploying tech to the cloud
There is a world of difference between technology originating in or designed for the cloud and technology that predates but can run in the cloud.
2015-10-12
118 reads
Soundex - Experiments with SQLCLR Part 2
Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms
2015-07-06
3,765 reads
A Beginners Look at Hadoop
Hadoop has been making a lot of noise in the Big Data world. Despite my lack of Linux experience I decided to take the plunge and this is what I found.
2015-01-01 (first published: 2013-06-05)
24,117 reads
Templates and teamwork
SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.
2014-11-27 (first published: 2008-05-20)
10,203 reads
RegEx for DBAs
RegEx functions are incredibly powerful text handling functions which should be at the top of a data warehouse DBAs list when writing CLR functions
2014-09-05 (first published: 2012-05-08)
20,482 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...