SQL Cookbook: Query Solutions and Techniques for All SQL Users

You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in several flavors of SQL, including Oracle, DB2, SQL Server, MySQL, and PostgreSQL.

• Printed book:
  • US
• Kindle book:
  • US

SQL Server Licensing is Simple

Over the years I've had no shortage of licensing questions for SQL Server. At times it's felt a little crazy. Look at the licensing guide. Choose EE or SE and the number of cores. Then check if you're using VMs. Oh, and consider the cloud, and which cloud you're running a workload on. It's simple […]

A New Operator

Don't Let Corner Cases Drive Your Design

When we design a database or system, we often do so with corner cases in mind. We don't have to do this.

Monday Monitor Tips: ServiceNow Integration

Earlier this year I visited a customer that was using the Redgate Monitor webhook to integrate with ServiceNow. However, they were also trying to integrate in a richer way...

Reverse Engineering a Physical Model Diagram

I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting, but creating all the objects is a pain. I decided to try creating a physical...

Advice I Like: Failure

If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...

T-SQL in SQL Server 2025: The PRODUCT Function

Earlier this year at SQL Saturday Austin 2025, Conor Cunningham gave a keynote that discussed the engineering efforts in the Austin office around SQL Server. One of the things he mentioned was PRODUCT(), which was written there and added to SQL Server 2025 to help with the GDP calculation for the US government. Yep, that's […]

What's Your Theme Music?

Steve asks what theme music you would pick for your next presentation.

Which Object Definitions Are Available?