Chris Kempster

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".
  • Interests: Mt Biking, playing with my young kids, and IT

Technical Article

Generate Restore DB Scripts from prev backups v1.0

Using the the MSDB backup tables, will generate the basic disk RESTORE commands for a database. It will include the Full, differential and all associated log recovery commands for you. Run the stored proc in Query Analyser then copy/alter the output to recover your DB. Great if using EE is not your cup of tea. […]

2002-01-03

372 reads

Technical Article

Email using CDONTS (via smtp)

Here is a very basic example script for sending emails via CDONTS. This comes from the sqlmag web-site forum. Although fine, remember that it will use the local SMTP server to forward emails onto the destination user. If your servers smtp process can not reach an exchange/group-wise/other mail box on your network, then this code […]

2001-08-09

3,528 reads

Blogs

Scary Scalar Functions - Part Two: Performance

By

Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Foreword In the second part of this...

Goal Progress for June 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

Using Sessionize for Your User Group – Part 2

By

Now that your CFS has been setup it’s time to get the word out...

Read the latest Blogs

Forums

The July Fourth Anniversary

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The July Fourth Anniversary

Independence Day 2022

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Independence Day 2022

Employee Hierarchy Recursive CTE Different Top Level Directors Overtime

By SQL_Kills

Hi, I have looked at some examples of Employee > Manager Hierarchy using Recursive...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers