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: 2020-05-18)
731 reads
James Serra's Blog
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: 2020-05-04)
445 reads
Accessing Managed Instance via SSMS
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)
535 reads
Azure Synapse Analytics confusion
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
453 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
92 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: 2020-03-10)
625 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: 2020-03-02)
892 reads
Power BI Real-time Streaming
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)
3,010 reads
Azure Storage tips
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)
433 reads
DevOps for databases: “DataOps”
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)
1,179 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers