When you develop generative AI applications, you typically introduce three additional components to your infrastructure: an embedder, an LLM, and a vector database. However, if you are using MariaDB, ...

See Configuring Claude Desktop / Claude Code for examples. A comprehensive Microsoft SQL Server client implementing the Model Context Protocol (MCP). This server provides extensive SQL Server ...

Recently I’ve been asked by colleagues with various different types of performance problems why Power BI is generating SQL in a particular way, and the answer has been the presence of nullable columns ...

Here’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres ...

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

What a great last few days for PowerApps! I hope you have been enjoying the announcements in the Spring Update Blog bundle. Have you seen Satya’s video? This blog doesn’t quite rise to the level of ...

Last year, residents in the villages of Sleepy Hollow and Tarrytown passed two bonds, totaling $9.7 million, to install two new turf fields, one at the high school, the other at Washington Irving ...

One of the most interesting trends in the computer world during the past few years has been the rapid growth of NoSQL databases. The term may be accurate, in that NoSQL databases don't use SQL in ...