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”.

Blogs

The Data API Builder Start and Add Extensions in VS Code

By

One of the things that I like about the Data API Builder (DAB) is...

Using OneLake for Excel Files in Microsoft Fabric

By

Hey data friends! This blog is to discuss an edge case I’ve run into...

Another AI Faux Pax

By

I was experimenting with a local model (article) and as a part of this,...

Read the latest Blogs

Forums

AD, powershell and ssis

By stan

Hi, i have a requirement that involves visiting multiple folders in AD for active,...

File date from Extended Event .xel files

By Michael L John

I know this, but I do not remember it. I have scoured by saved...

SSMS gets very messy

By oRBIT

At work we have quite a few databases that I'm frequently browsing. This is...

Visit the forum

Question of the Day

Sparse Column Defaults

What are the restrictions for defaults on columns declared as sparse?

See possible answers