An Eventual Consistency Scam

Steve uncovers a scam that relies on data not being consistent between two systems.

Architecting Power BI Solutions in Microsoft Fabric

Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios.

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

BIT_COUNT() V

The Book of Redgate: Evidence

We aren’t the only company that does this, but Redgate Software does try to be data driven. Across my 18 years, I’ve had plenty of people use evidence from...

TRY_PARSE Limitations: #SQLNewBlogger

I got a notification from a question I’d posted at SQL Server Central: Getting the Average. A user had posted their repro didn’t work, with no real comment. As...

Never is Not the Policy

Are there things you should never change or configure? Steve notes that is probably not the best policy.

Rebuilding All Indexes

Database Mail Configuration

Going Big with SSDs

Solid State Drives are becoming more commonplace in database systems. eBay and Facebook have implemented large SSD systems in their environments. Steve Jones thinks DBAs should be learning more about how SSDs affect SQL Server.

A Worse Computer; A Better Car

Steve gets a new EV, which brings with it a new software experience.