PowerPivot/PowerView/PowerQuery/PowerBI

Technical Article

Performance Design Tip for Power BI: Be Careful of Dates

  • DatabaseWeekly

I have written about Date Dimension in Power BI in many posts, and it makes sense now to explain one of the most common performance challenges that I see in some of the models. Sometimes, your model size grows significantly big, and you have no idea...

You rated this post out of 5. Change rating

2019-03-30

Technical Article

Power BI, Caching, Parallelism And Power Query Refresh Performance

  • DatabaseWeekly

Some time ago a customer of mine (thank you, Robert Lochner) showed me a very interesting scenario where a set of Power Query queries in Power BI Desktop refreshed a lot faster with the “Enable Parallel Loading Of Tables” option turned off.

You rated this post out of 5. Change rating

2019-03-30

Blogs

Monday Monitor Tips: VLF Alerts

By

A recent change made to Redgate Monitor to add a new alert for VLF...

Using T-SQL Snapshot Backup - Seeding Availability Groups

By

In this post, the fifth in our series, I want to illustrate an example...

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Read the latest Blogs

Forums

Keeping QUERIES for Using Again and Adding DB to Git/Github and VS Code

By Ahr Aitch

While I know that it will speed my learning to type queries as I...

Found a Tool Very Helpful for Beginner

By Ahr Aitch

I struggled with remembering the conventions I'd chosen when creating column names and data...

Is anybody using Windows 2022 clustered SQL Failover cluster ( 2019 CU30 )

By Johan Bijnens

How do you configure the cluster resources to be able to use Distributed Transactions...

Visit the forum

Question of the Day

Partial Backups I

What is a partial backup for a read-only database?

See possible answers