Fabric Mirroring

How Important Are Real Time Decisions?

There has been a push to build real time analytics and decision support systems. Steve discusses whether this is a good idea for many organizations.

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of what our Customers Say about us. However, this is what our employees said about the...

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.