Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: David Poole

SQLServerCentral.com profile

David Poole has been developing business applications since the days of the Commodore Pet. Those were the days when 8K was called RAM not KEYBOARD BUFFER. He specialised in databases at an early stage of his career. He started developing marketing applications using Ashton-Tate dBase II/Clipper, progressing through a variety of PC database applications before working on HP Image/3000 systems. He has spent 5 years as DBA within the Manchester (UK) office of the worlds No 1 advertising agency, where he focussed on data warehousing and systems integration. At present he is working within the web development department of a company specialising in information delivery.

   Items 1 to 20 of 73    Older >>
 

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.  Read more...
By David Poole 2016/07/28 | Source: SQLServerCentral.com | Category: data quality
Rating: |  Discuss |   Briefcase | 1,070 reads

RANDom traps for the unwary

The Books Online description of the RAND() function is only true from certain perspectives.  Read more...
By David Poole 2016/05/09 | Source: SQLServerCentral.com | Category: rand()
Rating: |  Discuss |   Briefcase | 2,197 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.  Read more...
By David Poole 2016/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 77 reads

Bash for ETL pre-processing

People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today  Read more...
By David Poole 2016/08/15 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 2,071 reads

Too much information can be counter-productive

If you want to be an effective communicator focus on what your audience need to hear rather than what you want to say  Read more...
By David Poole 2016/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 149 reads

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.  Read more...
By David Poole 2016/01/26 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 2,796 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.  Read more...
By David Poole 2015/11/23 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 6,227 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.  Read more...
By David Poole 2015/10/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

NOSQL and RDBMSs

NOSQL and RDBMS are evolving and absorbing ideas from each other. Is this necessarily a good thing? Perhaps we should think again  Read more...
By David Poole 2015/08/27 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 296 reads

Soundex - Experiments with SQLCLR Part 3

Acknowledging fundamental design flaws lead to a more flexible, maintainable phonetic framework  Read more...
By David Poole 2015/08/27 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 2,726 reads

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms  Read more...
By David Poole 2015/07/06 | Source: SQLServerCentral.com | Category: soundex
Rating: |  Discuss |   Briefcase | 3,236 reads

Mudita: Joy in the success of others

It is only when you start to take genuine pleasure in other people's successes that you experience the true rewards of being in a leadership position.  Read more...
By David Poole 2014/07/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 101 reads

Big Data - Cost of acquiring skills

If your companies first foray into Big Data project starts with a big cheque then you are doing it wrong!  Read more...
By David Poole 2014/04/14 | Source: SQLServerCentral.com | Category: big data
Rating: (not yet rated) |  Discuss |   Briefcase | 342 reads

IT and the Older Generation

David Poole looks at the interactions of technology across generations in this guest editorial.  Read more...
By David Poole 2014/06/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 209 reads

Soundex - Experiments with SQL CLR

Using test driven development to turbocharge Soundex  Read more...
By David Poole 2013/09/12 | Source: SQLServerCentral.com | Category: programming
Rating: |  Discuss |   Briefcase | 5,547 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.  Read more...
By David Poole 2015/01/01 (first published: 2013/06/05) | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 23,181 reads

Antipathy for Entity Attribute Value data models

EAV models have their uses but the costs are often hidden and if not hidden, more than anticipated.   Read more...
By David Poole 2013/01/21 | Source: SQLServerCentral.com | Category: data model
Rating: |  Discuss |   Briefcase | 5,588 reads

Eleven Challenges in Unifying Reference Data

Unifying the reference data across an enterprise can be a bigger job than expected. This article describes one approach to doing so.  Read more...
By David Poole 2012/12/20 | Source: SQLServerCentral.com | Category: reference data
Rating: |  Discuss |   Briefcase | 3,453 reads

Storage - A meeting of minds

Even if you are not an infrastructure guy a good grasp of storage basics will stand you in good stead  Read more...
By David Poole 2012/07/16 | Source: SQLServerCentral.com | Category: storage
Rating: |  Discuss |   Briefcase | 5,190 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  Read more...
By David Poole 2014/09/05 (first published: 2012/05/08) | Source: SQLServerCentral.com | Category: regex
Rating: |  Discuss |   Briefcase | 19,019 reads
   Items 1 to 20 of 73    Older >>