Anshumali Ambasht

Anshumali Ambasht is a seasoned Data Engineering and Analytics Manager with a wealth of experience in implementing innovative data and analytics technology solutions.
Currently affiliated with Deloitte Consulting, Ambasht has amassed over 16 years of exceptional expertise in the fields of data engineering, business intelligence, analytics, data integration, and data warehousing.
His interdisciplinary background, coupled with his master’s degree in Financial Analytics from the esteemed Stevens Institute of Technology, provides him with a unique perspective on data challenges.
Ambasht’s impressive track record includes successfully spearheading numerous large-scale projects and showcasing his leadership skills in managing geographically dispersed development teams.
With a keen focus on data engineering best practices and a commitment to driving business transformation, Ambasht remains at the forefront of revolutionizing data management.

All authors

All authors

Blogs

Goodbye, Microsoft

By

A few years ago I took a new job at Microsoft, working as a...

The SUM of Nothing: #SQLNewBlogger

By

I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...

How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections

By

I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...

Read the latest Blogs

Forums

Building a SQL Server Fleet Audit That Leadership Actually Reads

By Mayank Sethi

Comments posted to this topic are about the item Building a SQL Server Fleet...

Smart AI Agents and Data Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Smart AI Agents and Data...

RegEx Functions IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item RegEx Functions IV

Visit the forum

Question of the Day

RegEx Functions IV

I have this data in a table in a SQL Server 2025 database: 

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM
If I run this query, which row(s) are returned? 
SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^D', 'i')
 AND BusinessEntityID IN (7,8)

See possible answers