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.
2006-06-22
17,697 reads
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.
2006-04-12
10,546 reads
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.
2006-03-02
16,866 reads
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.
2006-02-27
12,394 reads
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,655 reads
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.
2005-11-23
19,685 reads
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.
2005-02-16
13,874 reads
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,728 reads
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
2005-01-04
11,426 reads
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.
2004-10-05
11,555 reads
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
By Steve Jones
This month I want to look at a few of the things I’ve seen...
By SQLPals
SQL Server 2016 Has Reached End of Support. Now What? On...
Comments posted to this topic are about the item PostgreSQL 19 Is Late
Comments posted to this topic are about the item Hyperscale Replicas V
Comments posted to this topic are about the item A Heavy Heart
I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?
See possible answers