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

Guest Columnist: Chris Kempster

SQLServerCentral.com profile

Chris has been working in the computer industry for around 8 years as an Application Development DBA. He began his career as an Oracle AP then moved into a DBA role using Oracle. From there he has specialised in DBA technical consulting with a focus to both Oracle and SQL Server. Chris has been actively involved with SQL Server since 1999 for a variety of clients and is currently working with a range of large scale internet based development projects. Visit www.chriskempster.com for further information and his ebook titled "SQL Server 2k for the Oracle DBA".

   Items 1 to 18 of 18   
 

Debugging MSDTC Issues

For the most part the DTC (Distributed Transaction Coordinator) just works. What happens when it doesn't? Chris had to resolve an issue with it recently and documented some of the steps he used.   Read more...
By Chris Kempster 2004/01/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,482 reads

Sending Alerts Via a Custom SMTP procedure

SQL Mail comes with SQL, but you have to load Outlook to use it. The alternative is to send email directly via SMTP. Combine that idea with alerts and you've got a new article!   Read more...
By Chris Kempster 2004/01/13 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,312 reads

Full Text Indexing - Text Parsing Routine

Full text indexing is interesting, but not always easy for the user to apply well. Chris has some ideas about to make that   Read more...
By Chris Kempster 2003/12/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,022 reads

What is Denormalization?

Chris Kempster brings us a basic look at the database design topic of denormalization.  Read more...
By Chris Kempster 2003/12/01 | Source: SQLServerCentral.com | Category: advanced
Rating: |  Discuss |   Briefcase | 16,769 reads

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.   Read more...
By Chris Kempster 2003/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,246 reads

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.   Read more...
By Chris Kempster 2003/11/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,399 reads

Mapping Database File Objects and Fragmentation

Chris proposes a tool that would allow you to graphically see the space utilized by objects in a SQL database. Good idea?   Read more...
By Chris Kempster 2003/10/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,398 reads

Upgrading to Windows 2003

Chris has been working through the process of upgrading to Win2003 and has the start of a great checklist along with few lessons learned - stuff that will come in handy it's time for you to do your own upgrade.   Read more...
By Chris Kempster 2003/09/11 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 10,873 reads

Example VSS Framework - Source Code Management - Part 1

We asked Chris to put together some information on how he uses VSS, a subject that comes up a lot as we have articles and discussions that involve change management. Change management isn't easy, you definitely need a pattern to work from. This two part article gives you a pattern you can start with and customize to your needs.   Read more...
By Chris Kempster 2003/07/07 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,485 reads

Example VSS Framework - Source Code Management - Part 2

In part two of this article Chris explains how to handle some common issues you'll run into while using version control and how to manage the process. Defintely read part one first if you haven't already.   Read more...
By Chris Kempster 2003/07/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,756 reads

IIS 6 Map

Chris does a lot of work with IIS and based on that he put together this nice map showing how all the bits and pieces go together. No SQL here, but most of us deal with IIS so we thought it might be of interest.   Read more...
By Chris Kempster 2003/07/02 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 5,755 reads

Change Management

This article looks at change management from the perspective of the DBA, including how to use source control to your advantage and planning for 'self-healing' apps.  Read more...
By Chris Kempster 2003/03/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,889 reads

Utilizing fn_virtualfilestats

In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.   Read more...
By Chris Kempster 2002/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,947 reads

Quickly Moving Databases

This article by Chris Kempster shows you how to quickly move a database by detaching or taking a database offline.   Read more...
By Chris Kempster 2008/02/08 (first published: 2004/05/18) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 147,325 reads

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.   Read more...
By Chris Kempster 2005/11/25 (first published: 2004/03/24) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 47,710 reads

SQL Server Security Part 3

In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.   Read more...
By Chris Kempster 2002/02/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,604 reads

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,069 reads

SQL Server Security Part 1

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...
By Chris Kempster 2005/02/11 (first published: 2002/01/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 49,987 reads
   Items 1 to 18 of 18