Doing Good at SQL Server Central

Steve talks about some of the charitable work at SQL Server Central.

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

Missing the Jaro Winkler Distance

The Book of Redgate: SQL Server Central

It was neat to stumble on this in the book, a piece by me, just a few years after Redgate acquired SQL Server Central. I’ll let the words speak...

Detecting Issues

How do you detect issues in your systems? Testing? Monitoring? Steve Jones has a few thoughts that we should find ways to do so before our customers.

Claude AI Convinced Me Not to Build an iPad App

I coach volleyball and I do a lot of stat stuff on paper. I decided recently to see if I could find a way to more easily automate things....

Creating JSON II

Engineer Lessons

Steve thinks a few lessons on being a software engineer at Google are good items for anyone to think about.

RANK() vs DENSE_RANK(): #SQLNewBlogger

I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way....

Setting FK Constraints in Data Modeler

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