James Serra's Blog

More Azure Blob Storage enhancements

• by James-Serra

• James Serra's Blog

I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob storage. Now there are more new features for blog storage that I will talk about....

2020-05-25

21 reads

Build announcements: Azure Synapse Analytics in public preview and more

• by James-Serra

• James Serra's Blog

A few data platform announcements yesterday at Microsoft Build that I wanted to blog about. The biggest one is Azure Synapse Analytics is now available in public preview! You...

2020-05-20

219 reads

Monitoring Power BI

• by James-Serra

• James Serra's Blog

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: 2020-05-18)

441 reads

Query Acceleration for ADLS

• by James-Serra

• James Serra's Blog

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: 2020-05-04)

302 reads

Accessing Managed Instance via SSMS

• by James-Serra

• James Serra's Blog

It used to be that the only way to use SQL Server Management Studio (SSMS) against Azure SQL Database Managed Instance (SQLMI) was to create a VM on the...

2020-05-11 (first published: 2020-04-27)

289 reads

Azure Synapse Analytics confusion

• by James-Serra

• James Serra's Blog

I see a lot of confusion among many people on what features are available today in Azure Synapse Analytics (formally called Azure SQL Data Warehouse) and what features are...

2020-04-13

72 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

17 reads

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)

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

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

1,332 reads