David Poole

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 now works as Data Solutions Architect at Moneysupermarket
  • Interests: Badminton, Cycling and Music. Keen piano player.

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.

2 (1)

2006-06-22

17,577 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.

2005-12-12

4,513 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.

4.6 (5)

2005-11-23

18,846 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.

4.75 (4)

2005-02-16

12,674 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.

2005-01-11

10,608 reads

Blogs

Azure Function Drain mode

By

(2021-Jun-16) Recently, Google started to notify me that my blog website (http://datanrg.blogspot.com/) had been experiencing some...

By

New blog post - Monitor deadlocks in Amazon RDS for SQL Server and set notifications...

Let’s Celebrate Pride by Supporting Nonprofits

By

For Pride this year, we’re highlighting queer nonprofits and charities. It’s more important than...

Read the latest Blogs

Forums

Mirror Database without Domain

By stefgrifon

Hello, I tried to make a mirror for my Demo database My Principal server...

PowerShell script help

By rocky_498

Hi Guys, I am executing a PowerShell script from SSIS (Execute Process Task). Simple...

Performance Counters Missing in SQL 2016 SP2

By ReamerXXVI

Hi, I'm looking for a fix to an issue where performance counters are missing...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers