Paul S. Randal

Paul S. Randal is the CEO of SQLskills.com, which he runs with his wife Kimberly L. Tripp. Both Paul and Kimberly are widely-known and respected experts in the SQL Server world, and both are long-time SQL Server MVPs. Paul was a Contributing Editor for TechNet Magazine, where he wrote the bi-monthly SQL Q&A column and feature articles. He also had #1 top-rated workshops and sessions at the PASS Summit and TechEd. Paul is active in the SQL Server community, from user groups to online forums to helping out on Twitter (@PaulRandal – check out the #sqlhelp tag). His popular and widely-referenced blog can be found at https://www.sqlskills.com/blogs/paul/ and he can be reached at paul@sqlskills.com.

Articles by Paul S. Randal

As a follow-up to my introduction to SQL Server joins, in this T-SQL tutorial, I’m going to take a closer look at the most used type of joins in SQL Server – the INNER JOIN.
September 20, 2022 | Paul S. Randal | T-SQL, SQL Sentry, Best Practices 0
Using APPLY, you can significantly expand database code functionality from what a simple join statement allows you.
September 13, 2022 | Paul S. Randal | Best Practices, SQLskills 0
Learn about PostgreSQL PaaS deployment options for Azure Cloud-Single Server, Flexible Server, and Hyperscale-including pricing, benefits, pros and cons.
August 17, 2022 | Paul S. Randal | Best Practices, PostgreSQL 0
As PostgreSQL databases continue to grow in size and complexity, so does the need to keep track of all that’s going on in these environments.
August 3, 2022 | Paul S. Randal | Best Practices, PostgreSQL 0
This article explores the PostgreSQL implementation of the B-Tree and hash index data structures.
July 28, 2022 | Paul S. Randal | Indexes, PostgreSQL 0
The DATEADD function adds (or subtracts) a whole-number increment to a specified date value.
July 26, 2022 | Paul S. Randal | T-SQL 0
Learn how SQL JOIN is used to specify how to return data from different tables and the different SQL JOIN types in this comprehensive guide with examples.
Learn about the ORDER BY clause used to order query results set by one or more columns, including common use cases and performance considerations.
SQL Server expert explains the T-SQL DISTINCT clause, including use cases, common performance considerations, tips, and tricks.
Learn about T-SQL UNION operator best practices from a respected SQL Server expert with examples and answers to questions like UNION vs. UNION ALL.
Introductory and how-to guide explaining what transactions are, why they're necessary, and how they work in SQL Server.
January 19, 2022 | Paul S. Randal | SQL Server 0
In this tutorial, I’ll show you how to use backups to perform point-in-time recovery and a more advanced way to determine an exact point to restore to.
Learn some general recommendations for how to approach SQL Server performance tuning to maximize effort and minimize distractions.
October 6, 2021 | Paul S. Randal | Best Practices, SQL Server 0
Learn what indexes are, why they’re so important, and a bit of both the art and science of various indexing strategies.
August 31, 2021 | Paul S. Randal | Indexes 0

Top Categories

See all

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More