SQL Clone
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 78    Older >>
 

Our Greatest Strength, Our Greatest Weakness

Our greatest strength is our greatest weakness  Read more...
By David Poole 2018/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 73 reads

GDPR - A guide for the perplexed

If a picture paints a thousand words then can GDPR regulation be represented in diagram form? Could doing so make it easier to comply with the regulation by making it easier to understand?  Read more...
By David Poole 2018/01/11 | Source: SQLServerCentral.com | Category: gdpr
Rating: |  Discuss |   Briefcase | 2,068 reads

Vagrant and SQL Server 2017 on Linux

Vagrant provides a mechanism to build and configure a virtual Linux box running SQL Server 2017  Read more...
By David Poole 2017/11/14 | Source: SQLServerCentral.com | Category: virtualization
Rating: |  Discuss |   Briefcase | 650 reads

Some of my greatest mistakes

You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.  Read more...
By David Poole 2017/05/18 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,003 reads

The Power of the Data Model

A data model is far more powerful than simply a set of build instructions for DBAs. It can be used to shape business thought and actions for the benefit of all.  Read more...
By David Poole 2017/02/14 | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 1,800 reads

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,155 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,226 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 | 86 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...
Rating: |  Discuss |   Briefcase | 2,168 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 | 155 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 2018/07/06 (first published: 2016/01/26) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,531 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,264 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 | 112 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 | 309 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,749 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,245 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 | 103 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 | 356 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 | 216 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,558 reads
   Items 1 to 20 of 78    Older >>