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
David Poole
- Interests: Badminton, Cycling and Music. Keen piano player.
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,178 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
13,425 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
7,734 reads
Fast Project Rollbacks
When a project is completed, one of the next steps is to roll this project out to the production environment. However a good rollback process is important to ensure that you can remove those changes if there are problems. Longtime author David Poole talks about how he handles this.
2008-10-22
3,940 reads
The Lighter Side - Life is like an analogy
Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.
2008-05-14
6,779 reads
How to Break Replication
David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.
2008-03-06
11,247 reads
Storing IPs in SQL Server
An IP address is something we all recognize and is a piece of data that is quite prevalent in many systems. However it is a piece of
data tha presents some challenges in its storage and retrieval. SQL Server guru David Poole presents us with a look at how you can
work with this strange formatting.
2008-02-19 (first published: 2007-04-02)
15,879 reads
Tracking Illicit Users
Longtime SQL Server guru David Poole brings us a look at one of the thorny problems a DBA faces: tracking down illicit users.
2008-01-15
7,876 reads
Automated Monitoring Database Size Using sp_spaceused
Keeping track of the amount of space in a database is something every DBA needs to do or face the dreaded "out of space" errors appearing on every client's desktop. SQL Server guru David Poole brings us an automated way of doing just that.
2007-12-25 (first published: 2006-12-28)
20,150 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers