David Poole

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)


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


4,502 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)


18,714 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)


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


10,598 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

4 (2)


11,393 reads


Running Express Edition in a Container–#SQLNewBlogger


Another post for me that is simple and hopefully serves as an example for...

How SQL Server stores data types: sql_variant


This post looks at a curious data type that isn’t really a data type....

Microsoft Ignite Announcements 2020


Microsoft Ignite has always announced many new products and new product features, and this year...

Read the latest Blogs


DBA progress/career development/ path

By anoop.mig29

Hi I am an post-grad and mssql server dba with around 5/6 years of...

Why is the topic I'm trying to start not posting?

By DHL-John.Parker

I have a very challenging issue with integrating a CLR on a new MSSQL17...

sql server laptops using AMD processor

By anoop.mig29

Hi I have current dell laptop with intel processor .I has become old and...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers