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

Power BI FAQ

Power BI has become hugely popular and I find common questions about functionality and features, so I thought I would put in this blog some of those questions with...

2020-06-23 (first published: )

597 reads

Blog Post

Monitoring Power BI

There are a number of options for monitoring Power BI that I wanted to mention: Performance analyzer: Find out how each of your report elements, such as visuals and...

2020-06-02 (first published: )

648 reads

Blog Post

Query Acceleration for ADLS

Just announced is Query Acceleration for Azure Data Lake Storage Gen2 (ADLS) as well as Blob Storage. This is a new capability for ADLS that enables applications and analytics...

2020-05-20 (first published: )

380 reads

Blog Post

Power BI Security

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the...

2020-03-19 (first published: )

594 reads

Blog Post

Power BI Sharing

There are many ways to share the dashboards, reports, and datasets that you create in Power BI. Below I’ll compare all such options (there are twelve!). First make sure...

2020-03-16

52 reads

Blogs

T-SQL Tuesday #155 –The Dynamic Code Invitation

By

Apologies for the late invitation. A minor snafu has me hosting again. This is...

Daily Coping 6 Oct 2022

By

Today’s coping tip is to remind yourself that you are enough just as you...

What you can do is based on more than your direct permissions.

By

What you have access to is not just what you have direct permissions to....

Read the latest Blogs

Forums

What's the CEIP?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the CEIP?

Assembling Your Own Toolbox

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Assembling Your Own Toolbox

Data Masking: Static vs Dynamic

By maxtardiveau

Comments posted to this topic are about the item Data Masking: Static vs Dynamic

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers