SSRS and MDX: Think about Cell Properties
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you...
2016-05-04
557 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Power BI Service error: “This visual has unrecognized fields”
Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power...
2016-05-03 (first published: 2016-04-22)
2,543 reads
Dynamic Security in Power BI
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.
In...
2016-04-28
2,806 reads
Loading Data into Clustered Columnstore Index with SSIS
I’m using a clustered columnstore index (CCI) on one of my fact tables at a client. The row size is...
2016-04-21
1,818 reads
Overview of Published Articles – 2016Q1
Here is an overview of the articles I published in the first quarter of 2016.
R Services series:
SQL Server 2016 R Services:...
2016-04-19
425 reads
SSIS Trick: Adding Multiple Packages to a Project
A little SSIS trick today. Sometimes you start a new Integration Services project and you want to add some existing...
2016-04-06
16,771 reads
SQLSaturday Belgium: slidedeck
The very first SQLSaturday in Belgium is over and it was a great event. I saw some interesting sessions, especially...
2016-03-24
496 reads
Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,103 reads
Reblog: MDS – A Database Error Has Occurred
I recently came across the following error message when I tried to look at the batches in the Integration Management...
2016-03-11
813 reads
Webinar – SQL Server BI Best Practices
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its...
2016-02-24
686 reads
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
Changing the Recovery Time
Comments posted to this topic are about the item Changing the Recovery Time
Getting More Time from AI
Comments posted to this topic are about the item Getting More Time from AI
When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Comments posted to this topic are about the item When Page Prefetching Takes a...
Question of the Day
Changing the Recovery Time
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers