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

Data Mesh Topologies

As a follow up to my blog Common Data Mesh exceptions, I wanted to discuss various types of data mesh topologies I am seeing being built. I put them...

2024-02-19 (first published: )

436 reads

Blog Post

Common Data Mesh exceptions

When it comes to data meshes that have been constructed or are currently under development, I have not observed any instances where the four core data mesh principles have...

2024-01-22 (first published: )

211 reads

Blogs

SQL Server Wait Stats

By

Everything in SQL Server is waiting for something…this is by design. And most people...

FabCon 2025 Recap

By

Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...

Privacy Policy

By

We value your privacy. This policy explains what personal data we collect and why. What...

Read the latest Blogs

Forums

Why would using a variable vs Hard Value impact a Query's Performance

By YSLGuru

Why would using variables in place of hard coded numbers impact a query's performance? ...

XML data import with poor stored procedure performance (needs optimization)

By Lord Slaagh

Hello SSC! I have been tasked with optimizing a stored procedure the imports data...

Trouble accessing hidden XML download link on Blazor-based government site

By Jobs90312

Hey everyone, I'm trying to access an XML file download from a government website...

Visit the forum

Question of the Day

Importing Flat Files

What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?

See possible answers