SQL on-demand in Azure Synapse Analytics

• by James-Serra

• James Serra's Blog

The new SQL on-demand (to be renamed SQL serverless) offering within Azure Synapse Analytics opens up a whole new world of getting insights into data immediately, at low-cost, using...

2020-08-10

32 reads

Business Continuity in SQL Database

• by James-Serra

• James Serra's Blog

I have wrote a number of blogs on the topic of business continuity in SQL Database before (HA/DR for Azure SQL Database, Azure SQL Database high availability, Azure SQL...

2020-08-03 (first published: 2020-07-20)

266 reads

More ADLS Gen2 enhancements

• by James-Serra

• James Serra's Blog

On the heels of More Azure Blob Storage enhancements come more enhancements for Azure Data Lake Store Gen2 (ADLS Gen2): Archive tier is now GA: The archive tier provides...

2020-07-14 (first published: 2020-07-06)

224 reads

Upload files to ADLS Gen2

• by James-Serra

• James Serra's Blog

I discover a small new feature the other day, but a very useful one. Previously, there was no way to upload files to an ADLS Gen2 storage account via...

2020-07-07 (first published: 2020-06-22)

165 reads

Power BI FAQ

• by James-Serra

• James Serra's Blog

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: 2020-06-08)

512 reads

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-06-11 (first published: 2020-05-25)

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

562 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

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

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

324 reads