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

All authors

All authors

Blogs

Friday Flyway Tips: Chaining Commands for State-based Deployments

By

One of the cool things I’ve seen with the new Flyway CLI is that...

A New Word: Querinous

By

querinous – adj. longing for a sense of certainty in a relationship; wishing there...

How to clear the SSMS cache?

By

How to clear the SSMS cache? If you are reading this,...

Read the latest Blogs

Forums

I need help accessing my local SQLExpress

By Rod at work

My PC has been causing me problems for months. I've told my desktop support...

MDX SSAS Calculated measure for last totals + turnovers

By IvanMarkevich

I have a measure with totals for specific dates with the LastNonEmpty aggregation, and...

display bytea image

By Bruin

I moved a table from MsSql to Postgresql that had a field defined as...

Visit the forum

Question of the Day

SQL in an Azure VM Backup

If I use the Azure Backup service for automated backups of my SQL Servers in Azure VMs, how often can I configure log backups? (as of Dec 2024)

See possible answers