Creating JSON III

Identity Columns Can’t Be Updated: #SQLNewBlogger

I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error...

Testing is Becoming More Important

Testing is going to be even more important in the age of AI.

Can You Let Go of Determinism

As Steve uses AI more, it seems determinism isn't something you get out of many LLMs.

Lots of FKs

Rolling Back a Broken Release

We had an interesting discussion about deployments in databases and how you go forward or back from the point when you discover a problem. You can watch the episode...

Advice I Like: In 100 Years

In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...

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