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.

Blogs

Azure chaos STUDIO

By

Chaos engineering is fun but especially important when building solutions in the cloud. It...

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

By

Script to identify the most expensive queries on your database server using the Query...

Read the latest Blogs

Forums

Help with BCP in SQL 2022

By tommiwan

We have a stored procedure that calls xp_cmdshell in order to use the BCP...

PREEMPTIVE_COM_GETDATA when using DISTINCT in remote query.

By toolman21

Replacing an old server with a newer one.  A job that runs fine on...

Job schedules

By bobrooney.81

Hi All, Assume that I have SQL Server Agent Job name:"TestJob". I am on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers