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

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.

4.67 (3)

You rated this post out of 5. Change rating

2024-02-03 (first published: )

3,516 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.

5 (3)

You rated this post out of 5. Change rating

2023-12-11

4,299 reads

SQLServerCentral Article

5 (4)

You rated this post out of 5. Change rating

2023-11-20 (first published: )

2,831 reads

Blogs

A New Word: the Wends

By

the wends– n. the frustration that you’re not enjoying an experience as much as...

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Read the latest Blogs

Forums

upgrading SQL Server 2019 Reporting Services: Standard to Enterprise Edition

By inHouseDBA

Hello, I have a standalone box with only SSRS Standard Edition on it as...

Express In-Memory OLTP

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Express In-Memory OLTP

Disaster Recovery and High Availability Solutions in SQL Server

By Smit Dagli

Comments posted to this topic are about the item Disaster Recovery and High Availability...

Visit the forum

Question of the Day

Express In-Memory OLTP

Can I create In-Memory OLTP tables in SQL Server Express?

See possible answers