Hyperscale Replicas III

The Book of Redgate:A Prehistory

I’ve covered the values in a number of previous posts on the Book of Redgate. Those values came from our founders, Simon Galbraith and Neil Davidson. I am lucky...

Keeping Track of my ConEmu CLIs

I use ConEmu for my terminal interface. I’m still on Windows 10 at home, and for consistency’s sake, I run this on my Win11 laptop and the home machine....

You Need a DBA Pipeline

Steve notes that DBAs need a privileged pipeline, separate from what they might use to update database schema.

Checking the Error Log II

Designing for Teams

When we build software, or we put together a process, we need to consider how teams use it, not just individuals.

Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger

I was creating a question on sp_readerrorlog and realized that this procedure is different from the one it wraps: xp_readerrorlog. This post digs into a few differences. Another post...

Flyway Tips: Object History

It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the object history for different schema changes, so as you are evaluating how your changes might...

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

Absolute and Relative References

One of the challenges in digital systems involves how we reference other resources. Steve discusses whether absolute or relative references are better.