Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 62    Older >>
 

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 | 93 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 | 278 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 | 193 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 | 4,898 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 2013/06/05 | Source: SQLServerCentral.com | Category: hadoop
Rating: |  Discuss |   Briefcase | 15,604 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,440 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,434 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,165 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 | 18,042 reads

Fun with sp_executeSQL

Switching from 32 BIT SQL Server to a 64 BIT edition illustrates how removing a bottleneck from a system can have a detrimental affect overall  Read more...
By David Poole 2012/01/31 | Source: SQLServerCentral.com | Category: nhibernate
Rating: |  Discuss |   Briefcase | 15,903 reads

Mind mapping software - How it can help the DBA

Mind mapping software allows the rapid capture of thoughts and ideas. It is a killer app that can easily help a busy DBA capture their thoughts  Read more...
By David Poole 2011/12/01 | Source: SQLServerCentral.com | Category: mind map
Rating: |  Discuss |   Briefcase | 7,322 reads

sp_prepexec and nHibernate

SQL Server architect David Poole sets about exploring sp_prepexec when called from nHibernate.  Read more...
By David Poole 2011/12/08 | Source: SQLServerCentral.com | Category: sp_prepexec
Rating: |  Discuss |   Briefcase | 8,223 reads

Pascals Triangle, Home Work and Root Cause Analysis

A lively comparison of Pascal's triangle to root cause analysis from David Poole.  Read more...
By David Poole 2011/10/19 | Source: SQLServerCentral.com | Category: troubleshooting
Rating: |  Discuss |   Briefcase | 4,235 reads

An alternative to GUIDs

GUIDs are often regarded as a necessary evil but how necessary are they?  Read more...
By David Poole 2011/09/15 | Source: SQLServerCentral.com | Category: guids
Rating: |  Discuss |   Briefcase | 10,295 reads

An nHibernate Head Scratcher

An interesting mystery on why some nHibernate performance issues might exist on your systems. Read this piece from SQL Server expert David Poole and look to see if this is a problem you can easily solve in your environment.  Read more...
By David Poole 2011/04/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,029 reads

Oiling the gears for the data dictionary

Documenting the database is always a challenge, and there are many techniques you can use to help all the people on your team understand what all your tables are used for. David Poole brings us an easy way to implement a framework for documentation.  Read more...
By David Poole 2014/04/25 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: documentation
Rating: |  Discuss |   Briefcase | 13,404 reads

A genuine use for a SQL CLR Aggregate

When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.  Read more...
By David Poole 2014/02/05 (first published: 2010/12/29) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 14,355 reads

A Quick Look at the MPP World

David Poole takes a look at the Massively Parallel Processing world for database servers.  Read more...
By David Poole 2010/08/11 | Source: SQLServerCentral.com | Category: mpp
Rating: |  Discuss |   Briefcase | 4,418 reads

Time Bomb Design - A Longer Fuse

In a sequel to his first article on Time Bomb Design, David Poole examines the issues we find between development environments and production ones.  Read more...
By David Poole 2010/05/26 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 10,324 reads

Scaling Out the Distribution Database

Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.   Read more...
By David Poole 2010/03/30 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 6,087 reads
   Items 1 to 20 of 62    Older >>