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,601 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,249 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,117 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,707 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,577 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,147 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,362 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,676 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,051 reads
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Concurrency and Baseline Control: Level 5 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Spending Time in the Office
Comments posted to this topic are about the item Spending Time in the Office
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers