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

Finding and Updating Duplicate IDs: #SQLNewBlogger

By

Finding duplicates was an interview question for me years ago, and I’ve never forgotten...

Optimising Costs: Strategies for Efficient Cloud Resource Management

By

Over time, I’ve realised that one of the hardest parts of cloud management isn’t...

Cost Visibility: Tracking and Analysing Your Cloud Spend

By

One of the biggest challenges I’ve faced in cloud operations is maintaining clear visibility...

Read the latest Blogs

Forums

Fun with JSON II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Fun with JSON II

Changing Data Types

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing Data Types

Answering Questions On Dropped Columns

By Cláudio Silva

Comments posted to this topic are about the item Answering Questions On Dropped Columns

Visit the forum

Question of the Day

Fun with JSON II

I have some data in a table: 

CREATE TABLE #test_data
(
    id INT PRIMARY KEY,
    name VARCHAR(100),
    birth_date DATE
);

-- Step 2: Insert rows  
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned? 
SELECT t1.[key] AS row,
       t2.*
FROM OPENJSON(
     (
         SELECT t.* FROM #test_data AS t FOR JSON PATH
     )
             ) t1
    CROSS APPLY OPENJSON(t1.value) t2;

See possible answers