SQL Server CONVERT() Date Style Codes Explained (With Examples)

by

In SQL Server, dates are stored in one format but often need to be displayed in another. That’s where the CONVERT() function can help. It lets you take a date value and turn it into a string in whatever format you need, whether that’s MM/DD/YYYY for an American audience or DD-MM-YYYY for a universally recognized date format.

The tricky part when using this function is the style code. This a number you pass into CONVERT() that tells it which format to use. There are dozens of style codes, and they’re not exactly intuitive to memorise. This article breaks down the most useful ones with real examples so you can find what you need and move on.

Read more

Cross-Modal Retrieval Explained

by

Cross-modal retrieval is an AI search technique that lets you search for data in one modality using a query from an entirely different modality. You type a description, and a search engine hands you back a matching image. Or you upload a photo, and it finds related audio clips. That’s cross-modal retrieval doing its thing.

The word “modal” just refers to a type of data, like text, images, audio, or video. “Cross-modal” means you’re working across two or more of those types. So cross-modal retrieval is when you use one type of data to search for another.

Read more

What Is AI Data Observability?

by

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. It gives your team the visibility to catch data issues before they quietly corrupt model behavior, and not after someone notices the outputs are off.

Read more

What is Approximate Nearest Neighbor (ANN) Search?

by

When you search for something using AI-powered tools, whether that’s a similar image, a related document, or a product recommendation, the system needs to find the closest matches to your query from a potentially massive dataset. Approximate Nearest Neighbor search, usually called ANN search, is the technique that makes that fast enough to be practical.

Read more

Feature Engineering Pipelines Explained

by

Raw data is rarely in a form that machine learning models can use well. Feature engineering is the process of transforming that raw data into inputs that actually help a model learn. A feature engineering pipeline is the automated system that runs those transformations consistently, from the moment data comes in to the moment it reaches the model.

Read more

How to Convert a Date to a String in SQL Server

by

There are a few reasons you might need to convert a date to a string in SQL Server. Maybe you need a date in a specific format for a report. Maybe you’re concatenating it with other text. Maybe an external system expects dates as strings. Whatever the reason, SQL Server gives you several ways to do it, and the right one depends on what you’re trying to achieve.

This article covers four functions: FORMAT(), CONVERT(), CAST(), and STR().

Read more