Paul S. Randal
SQLskills.com
Paul S. Randal is the Managing Director of SQLskills.com, which he runs with his wife
Kimberly L. Tripp. Paul is a SQL Server MVP and writes for TechNet Magazine. He holds
a patent (with Microsoft) on consistency checking technology.
Paul started in the industry in 1994 working for DEC on the VMS file system and its check/repair tools (the equivalent of chkdsk for NTFS.
In 1999 he moved to Microsoft to work on SQL Server, specifically on DBCC. For SQL Server 2000, he concentrated on index fragmentation - well, removing it! - writing both
DBCC INDEXDEFRAG and DBCC SHOWCONTIG, plus various algorithms in DBCC CHECKDB to support it being able to run online.
Paul then spent the first 3 years of SQL Server 2005 development rewriting the DBCC CHECKDB and repair code-base, gaining extensive insight
into disaster recovery scenarios and problems through close partnership with the SQL Server PSS (Product Support) group. Paul spent the remaining two years
of SQL Server 2005 development leading/managing a 9-person development team in the Core Storage Engine. His team was responsible for data access and storage
(DBCC, space allocation, indexes & heaps, pages & records, text/LOB storage, snapshot isolation, bulk load etc).
For SQL Server 2008, Paul decided to put his customer passion to better use and switch to a Program Management role within the Storage Engine team - first with responsibility
for the entire Storage Engine for a year, and then with a narrower, more hands-on focus on the Core Storage Engine. This involved both feature set definition
plus customer and partner engagements. It was during this phase of Paul's career that he first started public speaking, with his first session being on DBCC Internals at
TechEd US 2006. This was also where he met Kimberly, and they were subsequently married July 29th 2007.
In 2007, after almost 9 years on the SQL Server team, Paul left Microsoft to join Kimberly running SQLskills.com and pursuing his new-found passion for writing, teaching, and consulting.
Paul is a regular, top-rated presenter at conferences and user groups around the world on high-availability, disaster recovery, database maintenance, and Storage Engine internals.
Paul also teaches classes on Database Maintenance and High-Availability at Microsoft, and is a course author/instructor for the
Microsoft Certified Architect - Database qualification.
His popular blog
is at
http://www.sqlskills.com/blogs/paul/ and he can be reached at
paul@sqlskills.com.
Interviews and Recorded Sessions
Interviews
- Paul: RunAs Radio
-
August 2008 interview with Richard Campbell and Greg Hughes discussing the FILESTREAM feature of SQL Server 2008.
- Paul: RunAs Radio
-
August 2008 interview with Richard Campbell and Greg Hughes discussing what it is to be an "invountary DBA".
- Paul & Kimberly: TechNet Radio Part 2
-
March 2008 interview discussing troubleshooting and manageability in SQL Server 2008. See the March 11th show.
- Paul & Kimberly: TechNet Radio Part 1
-
March 2008 interview discussing security and availability in SQL Server 2008. See the March 4th show.
- Paul & Kimberly: RunAs Radio
-
December 2007 interview with Richard Campbell and Greg Hughes at TechEd ITPro in Barcelona discussing new features in SQL Server 2008.
- Paul & Kimberly: SSWUG TV
-
November 2007 video interview from SQL Connections Fall discussing new features in SQL Server 2008. Paul struggles to break away from calling the SQL team 'we'...
- Paul & Kimberly: TechEd TV
- Paul: SQL Down Under
-
October 2007 interview with Greg Low discussing CHECKDB differences between 2000 and 2005, new features in SQL Server 2008, plus Lego. See show #24.
- Paul: .Net Rocks!
- Paul & Kimberly: SSWUG TV
- Paul & Kimberly: UK Next Generation User Group
Recorded Sessions
- Microsoft TechEd US 2007, Orlando
Awards and Conference Highlights
Patents
Paul worked on two inventions while responsible for DBCC CHECKDB, including a method for running DBCC CHECKDB on a database within a backup, but without
needing to restore the backup. The first of these has been issued a patent in the US (see
here), and the second is patent pending.
Conference Highlights
Paul is the Co-Chair of the SQL Connections conference with Kimberly.
Paul has presented at the following conferences:
- 2008: Microsoft TechEd US, ITPro, Orlando
- Top-rated session in the DAT track and #6 rated session overall
- 1 full-day workshop and 3 sessions
- 2008: SQL Connections Spring, Orlando
- 3 full-day workshops and 3 sessions
- 2007: SQL Connections Fall, Las Vegas
- 3 full-day workshops and 5 sessions
- 2007: Microsoft TechEd IT Forum, Barcelona
- Speaker prize for the top-rated demo session
- 12 sessions, chalk-talks, and instructor-led labs
- 2007: Microsoft TechEd US, Orlando
- 'Secrets of Fast Detection and Recovery From Database Corruption' videoed as one of Best of TechEd
- #2 rated chalk-talk/cabana session
- 2 sessions and 2 chalk-talks
- 2007: SQL Connections Spring, Orlando
- 2 full-day workshops and 3 sessions
- 2006: Microsoft TechEd IT Forum, Barcelona
- #2 rated chalk-talk/cabana session
- 3 sessions and chalk-talks
- 2006: Microsoft TechEd Developers, Barcelona
- 3 sessions and chalk-talks
- 2006: Microsoft TechEd Hong Kong
- 2006: Microsoft TechEd China (Beijing)
- #10 rated speaker overall
- 4 sessions
- 2006: Microsoft TechEd China (Guangzhou)
- 2006: Microsoft TechEd China (Shanghai)
- #4 rated speaker overall
- 4 sessions
- 2006:Microsoft TechEd US, Boston
- First conference session - chalk-talk on DBCC CHECKDB