Frank A. Banin

About

With a strong foundation in enterprise data analytics and software engineering, I specialize in designing and implementing advanced analytics solutions that empower data-driven decision-making and drive business growth.

My experience spans diverse environments—on-premises, PaaS, SaaS, and hybrid solutions—demonstrating both versatility and adaptability in addressing complex data challenges.

I am recognized for my intellectual curiosity, a proven ability to quickly master new tools and technologies, and a commitment to staying ahead of emerging industry trends.

My professional growth is supported by a portfolio of industry certifications, which underscore both technical expertise and dedication to continuous learning.


I am characterized by my intellectual curiosity and a strong aptitude for rapidly learning new tools, coupled with a commitment to staying at the forefront of industry trends. My professional development is underscored by a series of certifications, including:

Microsoft Certifications:
Generative AI for Business with MSFT Azure OpenAI
Fabric Analytics Engineer Associate
Azure Data Engineer Associate
Certified Professional
Certified IT Professional
Technology Specialist

Merrill Lynch Certification:
Six Sigma Green Belt

All authors

All authors

Blogs

No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger

By

I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

By

One of the first things I review when I inherit a new SQL Server...

AgentDBA vs Critical SQL Server

By

It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...

Read the latest Blogs

Forums

Increment a number in a SQL Query based on a value

By bswhipp

I have an issue where I have a Bill of Material list of items...

Follow Your Hunch

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Follow Your Hunch

What Happens When You Ask a Local AI to Query Your Database?

By Kumar Abhishek

Comments posted to this topic are about the item What Happens When You Ask...

Visit the forum

Question of the Day

Detecting Characters

I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code: 

SELECT CustomerNameID,
       CustomerName
 FROM dbo.CustomerName
 WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with: 
CustomerNameID CustomerName
1              John Smith
2              Sarah Johnson
3              MICHAEL WILLIAMS
4              JENNIFER BROWN
5              david jones
6              emily davis
7              Robert Miller
8              LISA WILSON
9              christopher moore
10             Amanda Taylor
How many rows are returned?

See possible answers