Calculate a semi-additive average in DAX
A semi-additive average? What exactly are you trying to calculate? Let me explain first. A semi-additive measure is a measure...
2016-11-24
1,742 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Book Review – Power Pivot and Power BI
Since Power BI is all the rage right now, I was in need of some material to spice up my...
2016-11-21 (first published: 2016-11-15)
2,126 reads
Master Data Services – Database Error has Occured when Publishing Business Rule
I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016....
2016-11-04 (first published: 2016-10-31)
3,232 reads
First thoughts on Power BI on premises
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises...
2016-11-01 (first published: 2016-10-27)
3,452 reads
Master Data Services error – Cannot read configuration file due to insufficient permissions
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,319 reads
What’s new in SSRS 2016 – Session Contents
The 2016 edition of the Belgian SQL Server Days is over. It was a blast – as usual – and it was...
2016-10-14
517 reads
My thoughts on Recertifying your MCSE through Microsoft Virtual Academy
A couple of years back I achieved the Microsoft certification MCSE – Business Intelligence. You can read all about that process in...
2016-10-13
774 reads
Power BI Desktop hosted on premises with SSRS 2016
UPDATE 2016-10-27: the preview is available as a VM in the Azure Marketplace. More information can be found on the...
2016-10-12 (first published: 2016-09-28)
3,880 reads
Overview of Published Articles – 2016Q3
Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...
2016-10-05
518 reads
Upcoming Webinars: What’s New in SSRS and MDS 2016
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...
2016-10-04
582 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