James Serra

James works at Microsoft as a big data and data warehousing solution architect where he has been for most of the last nine years. He is a thought leader in the use and application of Big Data and advanced analytics, including data architectures such as the modern data warehouse, data lakehouse, data fabric, and data mesh. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. He is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of major events including SQLBits, PASS Summit, Data Summit and the Enterprise Data World conference. He is the author of the book “Deciphering Data Architectures: Choosing Between a Modern Data Warehouse, Data Fabric, Data Lakehouse, and Data Mesh”.

Blog Post

Levels in IT consultancy

The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...

2013-06-13

1,039 reads

Blog Post

SQL Server 2014!

Just when you thought you got a handle on SQL Server 2012, here comes the next version!  SQL Server 2014 was announced...

2013-06-07 (first published: )

6,957 reads

Blogs

A Broken Copilot Query

By

I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...

SQL Server Alerts

By

Don’t Let Trouble Sneak Up on You   Most SQL Servers run quietly. Until...

Prompt AI helping with Auditing

By

I had a conversation with a customer asking this question: how can I tell...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Building a RESTful API with FastAPI and PostgreSQL

By sabyda

Comments posted to this topic are about the item Building a RESTful API with...

The Journey to PostgreSQL (or anything)

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Journey to PostgreSQL (or...

Visit the forum

Question of the Day

A Common Split

What happens when I run this code:

DECLARE @s VARCHAR(1000) = 'apple, pear, peach'
SELECT *
FROM STRING_SPLIT(@s, ', ')

See possible answers