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

In-Person CISA Training – April 13-16, 2026

By

I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...

EightKB 2026

By

EightKB is back again for 2026! The biggest online SQL Server internals conference is...

The FinOps Lifecycle: From Budgeting to Reporting

By

Working in DevOps long enough teaches you two universal truths: That’s exactly why I...

Read the latest Blogs

Forums

VS Code, Unresolved References.

By mjdemaris

Hi all, I just started using VS Code to work with DB projects.  I...

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

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