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.

<< Newer    Items 21 to 40 of 70    Older >>
 

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,247 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,357 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,046 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,569 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,659 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,431 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,342 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,834 reads

Time Bomb Coding

Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.  Read more...
By David Poole 2010/02/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 17,372 reads

Database Documentation Using Red Gate's SQLDoc

Longtime author David Poole has written an excellent article about using SQLDoc, from Red Gate Software. Learn how you can document your own databases in this sponsored article.  Read more...
By David Poole 2009/08/10 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 3,014 reads

Intersect, Except, Union, All and Any

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.  Read more...
By David Poole 2011/12/23 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 39,770 reads

My Approach to Writing for SQLServerCentral

Are you looking to raise your profile? Add something to your resume? Consider writing for SQLServerCentral. Longtime author and expert David Poole gives us some hints.  Read more...
By David Poole 2009/06/19 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 2,818 reads

Book Review: The Data Warehousing Toolkit 2nd Edition

Longtime author and SQL Server guru David Poole takes a look at a classic book about Data Warehousing.  Read more...
By David Poole 2009/04/24 | Source: SQLServerCentral.com | Category: book reviews
Rating: |  Discuss |   Briefcase | 2,059 reads

Deploying Scripts with SQLCMD

Deploying changes to your SQL Servers can be a challenge. Longtime SQL Server expert David Poole brings us a new article looking at a solution using SQLCMD.  Read more...
By David Poole 2009/03/24 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 11,799 reads

Moving Tables and Indexes to Filegroups En Masse

Longtime author and SQL Server expert David Poole brings us a method to   Read more...
By David Poole 2009/01/21 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 7,383 reads

Fast Project Rollbacks

When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.  Read more...
By David Poole 2008/10/22 | Source: SQLServerCentral.com | Category: deployment process
Rating: |  Discuss |   Briefcase | 3,929 reads

Excel with Stored Procedures

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 59,043 reads

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2014/11/27 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 9,817 reads

The Lighter Side - Life is like an analogy

Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.  Read more...
By David Poole 2008/05/14 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 6,676 reads

Accidently Agile

Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)  Read more...
By David Poole 2009/09/18 (first published: 2008/02/14) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 12,653 reads
<< Newer    Items 21 to 40 of 70    Older >>