Power BI Security

• by James-Serra

• James Serra's Blog

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: 2020-03-10)

451 reads

Power BI Sharing

• by James-Serra

• James Serra's Blog

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

13 reads

SQL Database MI benefits

• by James-Serra

• James Serra's Blog

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: 2020-03-02)

377 reads

Power BI Real-time Streaming

• by James-Serra

• James Serra's Blog

With Power BI real-time streaming, you can stream data and update dashboards in real-time. Any visual or dashboard that can be created in Power BI can also be created...

2020-02-19 (first published: 2020-02-11)

834 reads

Azure Storage tips

• by James-Serra

• James Serra's Blog

As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...

2020-01-24 (first published: 2020-01-16)

334 reads

DevOps for databases: “DataOps”

• by James-Serra

• James Serra's Blog

DevOps, a set of practices that combines software development (Dev) and information-technology operations (Ops), has become a very popular way to shorten the systems development life cycle and provide continuous delivery of...

2020-01-16 (first published: 2020-01-07)

892 reads

Azure Synapse Analytics & Power BI concurrency

• by James-Serra

• James Serra's Blog

As a follow-up to my last blog, Azure Synapse Analytics & Power BI performance, I wanted to focus on concurrency when using these two products. A common question I...

2020-01-07 (first published: 2019-12-27)

391 reads

Azure Synapse Analytics & Power BI performance

• by James-Serra

• James Serra's Blog

With two new relational database features (Result-set caching and Materialized Views) just GA’d in Azure Synapse Analytics (formally called Azure SQL Data Warehouse), it makes for some very compelling reporting...

2019-12-26 (first published: 2019-12-12)

1,952 reads

My latest presentations

• by James-Serra

• James Serra's Blog

Just wanted to make everyone aware of my latest presentations that I recently uploaded. Details below. I also have a list of all my presentations with slide decks here.   Azure...

2019-12-04

25 reads

Azure Synapse Analytics new features

• by James-Serra

• James Serra's Blog

Almost lost in all the announcements from Ignite was a bunch of amazing new features that were added to the Provisioned Resources/SQL Pool section (read SQLDW functionalities) side of...

2019-11-19 (first published: 2019-11-11)

444 reads