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

The Microsoft Power Platform

The Microsoft Power Platform consists of three products: Power BI, PowerApps, and Microsoft Flow. I find customers are confused on the use cases of these products and how they...

2019-07-08 (first published: )

307 reads

Blog Post

Common Data Model

The Common Data Model (CDM) is a shared data model that is a place to keep all common data to be shared between applications and data sources.  Another way...

2019-06-20 (first published: )

1,628 reads

Blog Post

Azure Data Explorer

Azure Data Explorer (ADX) was announced as generally available on Feb 7th.  In short, ADX is a fully managed data analytics service for near real-time analysis on large volumes...

2019-03-14

275 reads

Blogs

Monday Monitor Tips: Lots of Postgres Options

By

Redgate Monitor is growing to include more than just Microsoft SQL Server monitoring. We...

Advice I Like: Experience and Aptitude

By

Experience is overrated. Most breakthrough accomplishments were done by people doing them for the...

Plan Time for Self-Development

By

As you begin the new year, if you don't already have time set aside...

Read the latest Blogs

Forums

Issues with SQL Server 2022 Server

By alisonwheeler

Hello, At my work place I recently migrated our test environment to SQL Server...

Remote query is taking 99% cost of local sp execution

By anoop.mig29

So we have local sp in which remote table is udpated.this remote query part...

Remote query is taking 99% cost of local sp execution

By anoop.mig29

So we have local sp in which remote table is udpated.this remote query part...

Visit the forum

Question of the Day

Data API Builder APIs

What formats of API endpoints can the Data API Builder present to clients when exposing the database?

See possible answers