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

Blogs

SQL Aggregate Functions: Your Essential Guide & Cheat Sheet

By

SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....

T-SQL Tuesday #174 – My Favorite Interview Question

By

This month is a great topic to me. I think growing and improving your...

T-SQL Tuesday #174: Job Interview Questions

By

Once upon a time, I used to think of difficult technical questions to ask...

Read the latest Blogs

Forums

SQL JOB add/modified

By Shelley Allen

Is there a trigger to notify when a new SQL Agent job is created/modified?

View generating different plan

By DamianC

Hello   I have a view based upon a number of tables I'm selecting...

Alert For Blocking in Azure SQL Managed Instance

By PearlJammer1

In an Azure SQL Managed Instance there is no option to create what we...

Visit the forum

Question of the Day

Full Text Editions

In which editions can I use Full-Text and semantic search?

See possible answers