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
95 reads
James Serra's Blog
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)
894 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,011 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)
435 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,181 reads
Azure Synapse Analytics & Power BI concurrency
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)
786 reads
Azure Synapse Analytics & Power BI performance
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)
3,365 reads
My latest presentations
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
42 reads
Azure Synapse Analytics new features
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)
529 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kas Gayungsari Telpon. 083135766741
WhatsApp 083135766741 Jl. Gayungsari Timur MGH No. 7C, Menanggal, Kec. Gayungan, Surabaya, Jawa Timur...
BCA KCU KEDIRI NO.TELPON 087781685647
WHATSAPP 087781685647 Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
BCA KCU MESJID LAMA No tlpon:083138717148
Whatsapp:083138717148.Jl. Mesjid Lama No.27-31, 17 Ilir, Kec. Ilir Tim. I, Kota Palembang, Sumatera Selatan...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers