HackerNoon

Your Database Can Time-Travel and Still Get the Past Wrong

Late corrections can make historical replays use data that was not known at the time. Learn how business time and system time ...
blog.csdn

SQL Server DATEADD()深度解析：时间位移原理与8大生产场景

本内容遵循CC 4.0 BY-SA版权协议 本文深入解析SQL Server DATEADD()函数的本质——非算术加减，而是日历感知的时间坐标位移。重点剖析秒至年的8种时间单位行为差异，揭示精度陷阱、月末回滚、时区 ...
Microsoft

SQL Server on Azure Local is now generally available

Some of the world’s most critical databases run in places where cloud connectivity cannot be assumed. A remote industrial site, for example, may need production systems to continue operating when ...
learn

MEDIAN (Transact-SQL)

The MEDIAN function returns the exact median, or 50th percentile, of non-NULL numeric values. You can use it as both an aggregate function and a window (analytic) function: Aggregate usage: Returns ...
Microsoft

SQL Server 2016 end of support is here: Plan your next steps

As of today, July 14, 2026, SQL Server 2016 has reached end of support. For the past decade, SQL Server 2016 has helped organizations run mission-critical applications and support the data needs of ...
Computerworld

How to use Excel formulas and functions

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas (with or without help from the Copilot AI assistant) and ...
InfoQ

Azure Functions Ships Serverless Agents Runtime at Build 2026

Microsoft announced the Azure Functions serverless agents runtime in public preview at Build 2026, turning the event-driven compute service into a platform for building and hosting AI agents. The ...
devblogs

Generate Embeddings Function and External Model Object Support Are Now Generally Available in Azure SQL

We are excited to announce the General Availability (GA) of AI_GENERATE_EMBEDDINGS and CREATE EXTERNAL MODEL in Azure SQL Database and Azure SQL Managed Instance. These two T-SQL features — CREATE ...
letsdatascience

SQL Window Functions Interview Questions: The Complete Guide

Master every SQL window function pattern tested in data science interviews. 14 worked problems covering ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, running totals, NTILE, and complex multi-window queries ...
habr

Правила DATEADD в DAX

Важной задачей при смещении периодов времени (месяцы, годы) является необходимость учесть разное количество дней в разных месяцах и годах ...
InfoQ

AWS Enables Lambda Function Triggers from RDS for SQL Server Database Events

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Lily Mara explains how to avoid high-risk ...
GitHub

dateadd-transact-sql.md

- "add interval to date or time [SQL Server]" - "subtract interval from date or time [SQL Server]" This function adds a *number* (a signed integer) to a *datepart* of an input *date*, and returns a ...