Database.Guide

SQL Server FORMAT() vs CONVERT(): Which One Should You Use?

July 27, 2026 by Ian SQL Server gives you two functions for formatting values: FORMAT() and CONVERT(). They overlap enough that it’s not always obvious which one to reach for. This article skips the feature-by-feature breakdown and focuses on answering the question of which one you should use for a given scenario.

How to Filter by Today’s Date in SQL Server (And the Mistake Most Beginners Make)?

July 7, 2026 by Ian Filtering records by today’s date sounds simple enough, but there’s a gotcha that’s easy to miss if you’re not careful. This article starts with the correct approach, then explains why the obvious method fails. So you’ll know what to do and why. Read more Categories SQL Server Tags create query, dates, how to, mssql, t-sql

What Is AI Data Observability?

June 15, 2026 by Ian Data pipelines break in boring ways. A field goes null, a schema changes, a job fails to run. You fix it and move on. But AI systems introduce a different kind of failure. One where everything appears to be working, the pipeline is green, the model is running, and the outputs are still wrong. That’s the problem AI data observability is built for.

JSON vs NDJSON: What’s the Difference and When Should You Use Each?

May 28, 2026 by Ian If you’ve spent any time working with APIs or data files, you’ve probably run into JSON. It’s everywhere.

What Is an AI Knowledge Base?

April 29, 2026 by Ian An AI knowledge base is a smarter way to store and retrieve information. Instead of relying on keyword search to dig through articles and documents, it lets people ask questions in plain language and get direct, relevant answers. That’s the short version. Here’s the longer one.