Time Bomb Design - A Longer Fuse
In a sequel to his first article on Time Bomb Design, David Poole examines the issues we find between development environments and production ones.
2010-05-26
10,618 reads
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
Scaling Out the Distribution Database
Replication is a great technology for moving data from one server to another, and it has a great many configuration options. David Poole brings us a technique for scaling out with multiple distribution databases.
2010-03-30
11,273 reads
Time Bomb Coding
Do your system contain a time bomb in the code? David Poole looks at some potential situations where you might be experiencing performance issues and delves into why.
2010-02-10
18,126 reads
Accidently Agile
Longtime SQL Server expert David Poole brings us a look at Agile Development and how he's been converted. (From Feb 2008)
2009-09-18 (first published: 2008-02-14)
12,711 reads
Database Documentation Using Red Gate's SQLDoc
Longtime author David Poole has written an excellent article about using SQLDoc, from Red Gate Software. Learn how you can document your own databases in this sponsored article.
2009-08-10
3,592 reads
My Approach to Writing for SQLServerCentral
Are you looking to raise your profile? Add something to your resume? Consider writing for SQLServerCentral. Longtime author and expert David Poole gives us some hints.
2009-06-19
3,153 reads
If databases were 100x as fast
Kognitio WX2 I went to a presentation by a company called Kognitio which has a super-fast in-memory database engine targeted at the data warehouse market. They have put the Powerpoint...
2009-06-03
1,673 reads
Book Review: The Data Warehousing Toolkit 2nd Edition
Longtime author and SQL Server guru David Poole takes a look at a classic book about Data Warehousing.
2009-04-24
2,369 reads
Deploying Scripts with SQLCMD
Deploying changes to your SQL Servers can be a challenge. Longtime SQL Server expert David Poole brings us a new article looking at a solution using SQLCMD.
2009-03-24
14,708 reads
Moving Tables and Indexes to Filegroups En Masse
Longtime author and SQL Server expert David Poole brings us a method to
2009-01-21
8,063 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Alamat BCA KCP Sudirman Mansion Telp:0821-8200-233
Telp/WA 62 8218200233 Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G No....
Alamat BCA KCP Tebet Barat 2 Telp:0821-8200-203
Telp/WA 62 8218200203 Jl. Tebet Raya No.25 B Blok CI, RT.1/RW.2, Tebet Tim., Kec....
Alamat BCA KCP Setiabudi Atrium Telp:0821-8200-174
Telp/WA 62 8218200174 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62...
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers