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

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Power BI: Refreshable Excel Files in PBI Service

By

Ever since Excel made its debut in the 1980’s, it has been used as...

Read the latest Blogs

Forums

Help on grouping to sets of rows in my sql data

By Mond

Hello I need help on writing this query. This is what i need. I...

SSIS Connecting to Azure SQL Managed Instance w/ MFA

By tjcavins

We've been testing out Azure SQL Managed Instance and created SSIS packages to run...

Summarizing Raw Sales Data with Group Summaries and Final Summary

By Paul Stasny

Greetings, I need to transform data returned in a query from several tables as...

Visit the forum

Question of the Day

The Query Traceflag

If I want to enable a trace flag for a specific query, how do I do it?

See possible answers