James Serra

James works at Microsoft as a big data and data warehousing solution architect where he has been for most of the last eight 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 “Reporting with Microsoft SQL Server 2012”. He has numerous Microsoft certifications, and has a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Blog Post

Modern Data Warehouse explained

I created a short YouTube video (20 minutes) that is a whiteboarding session that describes the five stages (ingest, store, transform, model, visualize) that make up a modern data...

2021-05-12 (first published: )

987 reads

Blog Post

Power BI and a Star Schema

I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer...

2021-03-05 (first published: )

730 reads

Blogs

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs

Forums

The NULL Connection Setting

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The NULL Connection Setting

Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL

By rohind

Comments posted to this topic are about the item Nullable vs Non-Nullable Columns and...

The Senior Advantage

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Senior Advantage

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers