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.

All authors

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (2)

2005-01-04

11,393 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.75 (4)

2004-07-14

11,691 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

2004-01-06

6,397 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!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (3)

2003-07-01

10,235 reads

All authors

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

Question of the Day

A Mixed Matrix in R

See possible answers