Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

The ZLAG and ZDIF functions are like the LAG and DIF functions, but they are not counted in the determination of the program lag length, and they replace missing values with 0s. The ZLAG function ...

With Pulsar Functions, you can apply Python functions to pub/sub messages in Apache Pulsar to make machine learning predictions in real time. Here’s how.

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...

We delve into the Excel Date & Time functions EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INT. All are handy for going back and forth in time on retirement dates, expiration dates and more.

InfluxData Inc. is the developer of InfluxDB, an open-source platform designed to retrieve and store time series data for monitoring, analysis, metrics and more. Recently, the company announced ...

SQL Server 2012 was released last April, making it the 11th major release of the product. Every new version has delivered new functionality that should excite developers, and this release is no ...