note

The scope of what SQL can handle is determined not by the data format, but by whether it can be structured

Have you ever thought it would be convenient to be able to run a query like this on a video? SELECT scene_id, timestamp FROM video_scenes WHERE video_id = 'match_2026_07_01' AND scene_label = 'ゴールシーン' ...
Opinion
Database Trends and ApplicationsOpinion

MotherDuck Previews Flights, an Agent-Native Ingest Tool Inside Python

MotherDuck is launching Flights, an agent-native data pipeline that enables users to choose the MCP server and AI agent of their choice to build and deploy data pipelines in minutes using a flexible, ...
Microsoft

Microsoft Excel

Make data more insightful with free, online, collaborative spreadsheets. See plans and pricing Try for free See plans and pricing Try for free Microsoft 365 Copilot in Excel unlocks the latest AI ...
GitHub

sql-data-warehouse-develop-ctas.md

The CREATE TABLE AS SELECT (CTAS) statement is one of the most important T-SQL features available. CTAS is a parallel operation that creates a new table based on the output of a SELECT statement. CTAS ...
GitHub

columnstore-indexes-data-warehouse.md

To improve efficiency of table seeks in a data warehouse, you can create a nonclustered index designed to run queries that perform best with table seeks. For example, queries that look for matching ...