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

Guest Columnist: Don Peterson

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

Thoughts on the PASS Summit

The 2007 PASS Summit is coming up in September and you can register early and save now, but is it worth going? Longtime author and successful DBA Don Peterson brings us a few thoughts on last year's Summit and the benefits of attending.   Read more...
By Don Peterson 2007/02/19 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 1,863 reads

Beware of Search Argument (SARG) Data Types

Performance tuning often seems like it can be more of an art than a science. However there are a number of fundamentals that can help you tune most of the queries that you will write or have issues with their performance. Don Peterson brings us a look at how he tuned a query in the real world to avoid a conversion that can cause a query to run slower.   Read more...
By Don Peterson 2006/07/13 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 11,175 reads

All About Transactions - Part 3

Transactions in SQL Server are probably no more complicated than those in other RDBMS products, which is to say they are fairly complex. Don Peterson continues with part 3 of his series and takes a look at transaction isolation levels and how they interact with multiple connections and their impact on locking.   Read more...
By Don Peterson 2004/12/02 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 14,678 reads

All About Transactions - Part 2

Transactions in SQL Server can be very complicated, and are often misunderstood. Don Peterson brings us part 2 of his series on transactions. This part deals with XACT_ABORT, compilation errors and error handling in transactions.   Read more...
By Don Peterson 2004/11/24 | Source: SQLServerCentral.com | Category: sql puzzles
Rating: |  Discuss |   Briefcase | 18,386 reads

All About Transactions - Part 1

The heart of an RDBMS is the transaction system that it employs. SQL Server has a great one that can easily be misunderstood or misused by those that haven't spent time delving into the details of how it works. Don Peterson has done that and brings us the start of a new series on the details of how transactions work in SQL Server.   Read more...
By Don Peterson 2004/11/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 22,672 reads

Lookup Table Madness

Are you mad? Not angry, more like crazy when it comes to designing databases in SQL Server? Don Peterson has met a few people he thinks are just that when it comes to building lookup tables. Does it stem from poor understanding of database design? Or do you disagree? Read Don's case against this particular design practice.   Read more...
By Don Peterson 2006/03/24 (first published: 2004/09/08) | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 46,176 reads

Is XML the Answer?

New Author! Don Peterson writes his first article for us and explores why he considers XML to be...bad! There are some interesting points made here and if you've haven't thought about what XML means to you as a DBA, it's a subject worth spending some time on.   Read more...
By Don Peterson 2008/05/02 (first published: 2003/10/07) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 64,215 reads
   Items 1 to 7 of 7