James is a big data and data warehousing technology specialist at Microsoft. 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.

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: )

544 reads

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: )

578 reads

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: )

329 reads

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: )

524 reads

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

31 reads

SQL Database MI benefits

As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an...

2020-03-10 (first published: )

599 reads

Blogs

Solve SQL Server Resource Database Crash

By

Based on Microsoft Documentation <The Resource database is a read-only database that contains all...

Daily Coping 20 Oct 2020

By

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

My 800th post!

By

It took me a little bit longer to get here than I expected but...

Read the latest Blogs

Forums

Poor peformance

By ramyours2003

I ran the update stats on a  table by creating the indexes, when i...

SQL Server data file distribution

By soumyarani0317

I am a newbie to SQL Server administration and config. Apologies if I appear...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct section to post my question. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers