T-SQL

SQLServerCentral Article

T-SQL Trigonometric Functions in SQL Server

  • Article

Introduction SQL Server includes several built-in mathematical functions that allow developers to perform complex calculations directly within queries. Among these are trigonometric functions such as SIN(), COS(), and TAN(), which are useful in scenarios involving engineering calculations, geographic data processing, simulations, and analytics. Although these functions are straightforward to use, developers occasionally encounter unexpected results […]

(1)

You rated this post out of 5. Change rating

2026-04-29

1,848 reads

SQLServerCentral Article

Creating a Simple and Flexible Random Password Generator in SQL Server

  • Article

Generating temporary passwords is a common requirement in many applications. Users may need to reset a forgotten password, new accounts may require an initial password, or developers may generate test credentials. While password generation is often implemented in application code, doing it directly in SQL Server provides clear advantages. It centralizes the logic, ensures consistency […]

(2)

You rated this post out of 5. Change rating

2026-04-10

1,673 reads

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

SWAG Saves the Day

By

PASS Summit East is in one week. I was on the road last week...

Upgrading SQL Server Containers on the Laptop

By

I don’t have SQL Server installed on my laptop. In an effort to keep...

Read the latest Blogs

Forums

BCA KCP Lodan Center Tlpn/Wa 0853.7373.7551

By thammyvienula

LODAN CENTER, Ruko Jl No.6-7 Blok O, Ancol, Kec. Pademangan, Jkt Utara, Daerah Khusus...

BCA KCP Summitmas Telpon/WA:08137887595

By tanehome

BCA KCP Summitmas Telpon/WA:08137887595.Summitmas I, Jl. Jend. Sudirman kav 52-53 No.61-62 Lt. Dasar, Senayan,...

BCA KCP ITC Permata Hijau Telpon/WA:08137887595

By tanehome

BCA KCP ITC Permata Hijau Telpon/WA:08137887595.Grand Permata Hijau Type Emerald No. 12 & 14,...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers