AI Is Improving Security

AI LLMs can help find bugs, especially security vulnerabilities, in code. That appears to be happening with SQL Server.

Experimenting with CHOOSE: #SQLNewBlogger

I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included....

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

SQL Server 2025 Server-level Roles

A Fun Prize at the PASS Data Community Summit

I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...

Making an Impression

The job market is tough and Steve has some advice today on how you approach your career.

Monday Monitor Tips: Query Recommendations

We keep adding stuff to Redgate Monitor, and it’s easy to miss some of the improvements. Here’s one that’s been around quite awhile, but while discussing the product with...

SQL Server Vector Support I

Advice I Like: Time and Focus

“You don’t need more time because you already have all the time that you will ever get; you need more focus.” – from Excellent Advice for Living Boy, I...

Choose the Second One

Steve talks software design and architecture today with an interesting idea: design it twice.