Nikhil Bangad

Data engineering leader known for spearheading impactful solutions and managing high-performing teams. With a decade under my belt, I specialize in complex data model design and scalable practices. Passionate about sharing my expertise and giving back to the community
  • Interests: Data Engineering
  • Skills: SQL, Python, Data Modeling, Data Visualization, Data Leadership, Influence, Communication

All authors

SQLServerCentral Article

SQL Window Functions Series: NTILE()

Unlock the power of SQL's NTILE function with our latest deep-dive article. Learn to segment your data effectively into quantiles for more nuanced analysis, discover common pitfalls and their solutions, and optimize your queries for peak performance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2024-02-03 (first published: )

5,266 reads

SQLServerCentral Article

SQL Window Functions Series: LAG() and LEAD()

Dive deep into the powerful SQL window functions, LAG() and LEAD(). Explore their intricacies, discover real-world examples, and avoid common pitfalls.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2023-12-11

10,984 reads

SQLServerCentral Article

SQL Window Functions Series: RANK() and DENSE_RANK()

Welcome to the fascinating world of SQL window functions! Today, we'll explore in detail: RANK() and DENSE_RANK().

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

16,177 reads

All authors

Blogs

Restore SQL Server Database to an OrbStack Container

By

In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...

Day of Data Baton Rouge Slides and Code

By

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

Read the latest Blogs

Forums

ALAMAT BCA KCU SCBD Telp:08218154392

By m4l4mt194

WA CS:08218154392 Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl....

Alamat Kontak BCA KCU BEKASI WA CS:08218154392

By Halo_BCA

WA CS:08218154392 Jl. Ahmad Yani No.9, RT.01/RW.05, Marga Jaya, Kec. Bekasi Sel., Kota Bks,...

ALAMAT BANK BCA KCU GUNSA 45 TLP/WA 08218154374

By m4rt1n4

Hub Cs: 08218154374 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...

Visit the forum

Question of the Day

SQL Server Certificates

Which of these is not true for certificates used for SQL Server connections?

See possible answers