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

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

260 reads

Blogs

T-SQL Tuesday #174: Your Favorite Job Interview Question

By

My blog has been quiet lately. I recently wrapped up a master’s program (more...

I like KQL and I like managing my test data – are they mates?

By

Test Data Management (TDM) is essential in software development to ensure your application runs...

T-SQL Tuesday 174 - Your Favorite Job Interview Questions

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Read the latest Blogs

Forums

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

Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c

By rpalani65sql

Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...

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