smalldatetime

Blogs

Moving to Rancher Desktop

By

I’ve been very happy with Docker Desktop for years, running it on both laptop...

Logging in Azure Data Factory data flows

By

(2025-June-15) Long gone are the days when a data engineer could simply focus on building...

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Read the latest Blogs

Forums

Validate SQL Scripts Before Deployment – Offline & Audit-Friendly Tool

By SQL Change Guard

Hi everyone 👋 We recently built a lightweight Windows tool for validating SQL Server...

Secure and Auditable SQL Deployment with SQL Change Guard

By SQL Change Guard

We’ve been struggling with risky SQL scripts making it to production — things like:...

disable remote access

By goodtimecharlie

If I configure remote access to 0 on my servers, am I right in...

Visit the forum

Question of the Day

How Many Can Be the Greatest

I am trying to analyze a number of columns in a large table to determine the highest value for each row. In SQL Server 2022, we have the GREATEST function, which will return the greatest value from those columns passed in. How many columns can I include in an expression like this: 

select GREATEST( col1, col2, col3, ...)

See possible answers