James Serra

James works at Microsoft as a big data and data warehousing solution architect where he has been for most of the last eight 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 “Reporting with Microsoft SQL Server 2012”. He has numerous Microsoft certifications, and has a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Blog Post

Serving layers with a data lake

Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is...

2023-08-28 (first published: )

325 reads

Blog Post

Data Marketplace

I question I have been getting from customers lately is about a data marketplace. What is it, and what products can I use to build it? A data marketplace,...

2023-04-24 (first published: )

143 reads

Blogs

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

SQL Prompt Quick Access to Helper Code

By

We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available

By

As I have mentioned in prior blog posts, I have been writing a data...

Read the latest Blogs

Forums

I can query one by one. Need help how to become Single Query

By Adelia

Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...

Baking up and restores VLDBs

By ericwenger1

Some of our databases are getting be close to 2 terabytes. We are backing...

Data Analysis with Python: Calculating Mean and Median

By Piyushbhatt

I'm working on a data analysis project in Python and need to calculate both...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers