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.

<< Newer    Items 41 to 60 of 62    Older >>
 

SQL Sudoko

The latest puzzle craze seems to be Sudoko with all kinds of online puzzles, books, etc. appearing around the world. Longtime SQL Server guru David Poole decided solving the puzzles was not enough of a challenge and brings us some T-SQL to help solve those difficult ones keeping you from getting back to work.   Read more...
By David Poole 2006/06/22 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 17,530 reads

Generating a Range

What is the most efficient way of generating a range of values? SQL Server guru David Poole takes a look at a few different methods, both procedural and set based, and gives you some performance results.   Read more...
By David Poole 2006/04/12 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 10,324 reads

The Pitfalls of Foreign Keys

What is the cost of DRI and is it something that you should implement? SQL Server expert David Poole takes a look at the impact of adding DRI to a CMS system and provides some real world results on which you can base your decision.   Read more...
By David Poole 2006/03/02 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 16,275 reads

Utility Procedures

Have you ever wanted to create your own utility procedures in SQL Server? Maybe your own information schema view? SQL Server export David Poole brings us an article dicussing these very topcis and offers advice on how to proceed.   Read more...
By David Poole 2006/02/27 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,918 reads

SQLExaminer Review

Have you ever needed to figure out which objects in development need to go to production? Ever wondered about how to get your databases back in synch? SQL Server guru David Poole takes a look at SQL Examiner, a product that he feel works well for him and is looking to purchase. Read about David's impressions and see if this is for you.   Read more...
By David Poole 2005/12/12 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 4,468 reads

Quick Hints for using the RAISERROR Command

SQL Server 2000 error handling isn't the most mature system for dealing with unexpected events. It has been much enhanced in SQL Server 2005, but many people will be using SQL Server 2000 for a long time. RAISERROR is one of those functions that can really aid in troubleshooting, but is often underutilized. David Poole brings us some hints on how this can help you out in your code.   Read more...
By David Poole 2005/11/23 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 18,553 reads

Data Archiving: Problems and Solutions

SQL Server does an exceptional job at managing your data and making it available for your users and applications. However it doesn't know when you are done with data and there is not archival solution built. Author David Poole likens not having a strategy to leaving certain undesirable clothing items on your floor and provides some common problems and potential solutions based on his experiences.   Read more...
By David Poole 2005/02/16 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 11,885 reads

Can You Compute?

Transact-SQL in SQL Server 2000 has some interesting features, many of which most DBAs will never use. While many DBAs are famliar with the basic aggregate functions, there are a few that are advanced and not well understood. The ROLLUP and COMPUTE operators are two of these and David Poole takes a look at how these work and a practical application for them.   Read more...
By David Poole 2005/01/11 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 10,571 reads

A Look at MYSQL

SQL Server is the best RDBMS, at least according to the current thinking at SQLServerCentral.com, and is fully capable of meeting all of your database needs. However that does not mean you should ignore other platforms. A good DBA will be aware of and perhaps skilled in other platforms and tools, including competing database systems. There has been a lot of buzz about the open source MySQL RDBMS this past year and David Poole takes a look at this server, giving you some points of comparison with   Read more...
By David Poole 2005/01/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,368 reads

The Danger of Hiring Stars

Are you looking to change jobs? Is your company looking to hire a new SQL Server DBA that's a star? David Poole looks at some of the pitfalls of hiring a star as well as things you may want to consider when looking for a new job.   Read more...
By David Poole 2004/10/05 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,226 reads

Return of the users from hell!

Another great article from David Poole looking at more user stereo types that the IT world must deal with. Read on for smile and a little fun.   Read more...
By David Poole 2004/09/16 | Source: SQLServerCentral.com | Category: the lighter side
Rating: |  Discuss |   Briefcase | 10,629 reads

An Is Null Gotcha

In T-SQL you should use the IS NULL keywords to test for a null value. But David Poole runs into a strange gotcha in one of his applications where he is testing for a null value. It's an interesting read following Sherlock Poole around on his hunt to find an error.   Read more...
By David Poole 2004/07/14 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 11,676 reads

Reducing Round Trips - Working with HTML Checkboxes

Reducing the amount of round trips between a server and client is something that can give you a great boost in performance. David Poole looks at how he solved a problem with HTML checkboxes and the challenges they solve in a programming environment. Without Dynamic SQL!   Read more...
By David Poole 2004/06/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,209 reads

Users From Hell

A little off topic (or is it?), David needed to vent a little - something we can all appreciate. Meant to be light hearted fun, please don't take too seriously.   Read more...
By David Poole 2004/04/19 | Source: SQLServerCentral.com | Category: rants
Rating: |  Discuss |   Briefcase | 10,824 reads

SQL Server Statistical Functions

I bet most of us count and sum fairly often, but how often do you use the rest of the 'in the box' statistical functions? Learn these now and be ready when you need them.   Read more...
By David Poole 2004/01/12 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 15,202 reads

Using Bits to Store Data

David recently worked on a project where it turned out storing the answers to a survey using bitmapping was a good approach. He was good enough to write some of it down and share. As he notes bitmapping isn't used as often as it used to be, but it can still be a useful technique to have around.   Read more...
By David Poole 2004/01/06 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,364 reads

Dealing with Addresses

David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle!   Read more...
By David Poole 2003/07/01 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,675 reads

SQL and IIS on the same Box?

David takes us through why he believes trying to run SQL and IIS on the same box is a bad idea. It's a common notion that it IS a bad thing to do, but you have real justification? Read this and you will!   Read more...
By David Poole 2003/06/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,907 reads

Lessons from my first Project as a Project Manager

David tries his hand at Project Management and what follows is a list of tips and problems from that experience. As David points out, it's interesting to see things from the other (not developer or DBA) point of view.   Read more...
By David Poole 2003/06/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 5,727 reads

Querying XML files using SQL 2000

One of the many useful features gained by SQL Server 2000 is the ability to handle XML documents. This means that any computer language capable of opening an XML files and calling SQL Server stored procedures can make use of this new ability. This article by David Poole shows you how!   Read more...
By David Poole 2002/10/11 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 11,871 reads
<< Newer    Items 41 to 60 of 62    Older >>