Every Database Has Problems

The magic way to get better performance from your system is to write better code from the start.

Changing the Cardinality of a FK in Redgate Data Modeler

One of the things a customer asked recently about Redgate Data Modeler was how to adjust a FK constraint between two tables. The tool seemed to makes this  easy,...

The New OS Wars

A few countries are looking to reduce their reliance on US technology. While they might leave Windows, Steve thinks they will continue to run SQL Server.

The Vector Data Type

Identities and Sequences V

Microsoft Power BI Performance Best Practices: Learn practical techniques for building high-speed Power BI solutions Microsoft Power BI Performance Best Practices

In a world dominated by data, organizations heavily rely on business intelligence tools like Power BI for deriving insights and informed decision-making. Yet, as data volumes grow and user demands increase, achieving optimal performance becomes challenging.

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

Working Better Under Pressure

DBAs can see the future.

Creating a JSON Document I

Finding the Next Sequence Value: #SQLNewBlogger

I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I...

Who is Irresponsible?

It can be irresponsible to use AI, but is it in many cases? Steve has a few thoughts.