T-SQL in SQL Server 2025: The UNISTR Function

I am not much for working in languages other than English. That's my native language and I know little about others. However, the last few years I find myself using emojis more and more in quick communications as they seem to add some fun to the interaction. And those interactions need to be stored in […]

PASS Keynote Shots

Rodney Kidd took some great shots of the keynote and published an album here: https://www.flickr.com/photos/127113040@N04/albums/72177720330695911 A few of my favorites: Here’s one of the 8 ball and keynote (and...

Adding a Lot of Seconds

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...