James Serra

James is a Data Platform Architecture Lead at EY, and previously was a big data and data warehousing solution architect at Microsoft for seven years. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. 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 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Blog Post

Data Mesh defined

The two latest trends in emerging data platform architectures are the Data Lakehouse (the subject of my last blog Data Lakehouse defined), and the Data Mesh, the subject of...

2021-02-16

Blog Post

Data Lakehouse defined

As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...

2021-02-02 (first published: )

545 reads

Blog Post

Syncing SQL databases

There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use...

2021-01-05 (first published: )

649 reads

Blog Post

Syncing SQL databases

There are various ways to keep SQL Server databases and SQL Database/SQL Managed Instance (SQL MI) databases in-sync asynchronously that I will discuss in this blog. The main use...

2021-01-04

8 reads

Blogs

Generating Unicode Characters in Power Query

By

You may have used the UNICHAR() function in DAX to return Unicode characters in...

Daily Coping 29 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Create Multiple XML Files using SSIS

By Jobs90312

Hi community, I have a table in my database which consists of 100,000 rows....

Performance problem

By Jonas Jisendal

Hi I have one server running SQL server 2017 and one running SQL server...

AOAG Listener Error:Kerberos Status is showing: Incorrect username and Password

By Shashihemanth

Hi, I am having error in creating AG Group Listener. We finally try to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers