Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Regular Columnist: David Poole

SQLServerCentral.com profile

David Poole has been developing business applications since the days of the Commodore Pet. Those were the days when 8K was called RAM not KEYBOARD BUFFER. He specialised in databases at an early stage of his career. He started developing marketing applications using Ashton-Tate dBase II/Clipper, progressing through a variety of PC database applications before working on HP Image/3000 systems. He has spent 5 years as DBA within the Manchester (UK) office of the worlds No 1 advertising agency, where he focussed on data warehousing and systems integration. At present he is working within the web development department of a company specialising in information delivery.

<< Newer    Items 21 to 40 of 62    Older >>
 

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.  Read more...
By David Poole 2010/02/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 17,349 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.  Read more...
By David Poole 2009/08/10 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 2,949 reads

Intersect, Except, Union, All and Any

Longtime author and expert DBA David Poole examines a few T-SQL commands that he has never used. Learn how some of these little used T-SQL items function and see if they work for you.  Read more...
By David Poole 2011/12/23 (first published: 2009/07/20) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 39,689 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.  Read more...
By David Poole 2009/06/19 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 2,814 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.  Read more...
By David Poole 2009/04/24 | Source: SQLServerCentral.com | Category: book reviews
Rating: |  Discuss |   Briefcase | 2,055 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.  Read more...
By David Poole 2009/03/24 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 11,680 reads

Moving Tables and Indexes to Filegroups En Masse

Longtime author and SQL Server expert David Poole brings us a method to   Read more...
By David Poole 2009/01/21 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 7,266 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.  Read more...
By David Poole 2008/10/22 | Source: SQLServerCentral.com | Category: deployment process
Rating: |  Discuss |   Briefcase | 3,907 reads

Excel with Stored Procedures

Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.  Read more...
By David Poole 2010/08/13 (first published: 2008/08/13) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 58,923 reads

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio.  Read more...
By David Poole 2013/01/31 (first published: 2008/05/20) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 8,231 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.  Read more...
By David Poole 2008/05/14 | Source: SQLServerCentral.com | Category: career
Rating: |  Discuss |   Briefcase | 6,674 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)  Read more...
By David Poole 2009/09/18 (first published: 2008/02/14) | Source: SQLServerCentral.com | Category: system development life cycle
Rating: |  Discuss |   Briefcase | 12,647 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.  Read more...
By David Poole 2008/03/06 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 9,997 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.  Read more...
By David Poole 2008/01/15 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 7,830 reads

A Love Hate Affair with User Defined Types

Many new DBAs think that User-defined types are a very cool feature in SQL Server when they first encounter them. However many experienced DBAs soon realize that UDTs can be a pain to work with and longtime SQL Server guru David Poole discusses his experiences   Read more...
By David Poole 2007/07/23 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 6,403 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.   Read more...
By David Poole 2007/04/02 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 13,961 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.   Read more...
By David Poole 2006/12/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,063 reads

TinyInt, SmallInt, Int and BigInt

SQL Server guru David Poole takes a look at the different integer data types and the impact of each of those on your database.   Read more...
By David Poole 2006/12/18 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 19,904 reads

Performance Effects of NOCOUNT

Most SQL Server programmers know to use the SET NOCOUNT command to prevent the number of rows message from being returned to the client. But how does this affect performance? Does it make sense to qualify the owner on your objects? SQL Server guru David Poole brings us some performance analysis of how your stored procedures perform.   Read more...
By David Poole 2006/12/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 21,943 reads

The Enterprise Library for .NET Framework 2.0

What does a SQL Server developer care about the Enterprise Library? SQL Server guru David Poole is starting to work with .NET and brings us his perspective on what this library is and how it benefits those who develop against SQL Server.   Read more...
By David Poole 2006/08/21 | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 14,668 reads
<< Newer    Items 21 to 40 of 62    Older >>