Change SSAS Tabular Data Source using TOM
We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server...
2018-05-15 (first published: 2018-05-08)
1,913 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Issue while using SQLCompare against Azure SQL DB
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate...
2018-05-15
292 reads
Connect to Power BI Report Server with SSMS
Sometimes you want to connect to a report server instance using Management Studio, for example to create a new security...
2018-05-11 (first published: 2018-05-02)
4,051 reads
Stop Previewing the bim.layout File in SSAS Tabular
A quick blog post for future reference, because I know I’ll bump into this again someday.
When you’re working with a...
2018-03-29 (first published: 2018-03-22)
1,844 reads
Migrate SSRS 2017 to Power BI Report Server
UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade...
2018-03-20 (first published: 2018-03-08)
3,892 reads
Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel
As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data...
2018-03-15
283 reads
T-SQL Tuesday #100!
The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the...
2018-03-13
299 reads
Excel Rendering In Power BI Report Server: You Are Not Licensed To Use This Feature
I recently migrated an SSRS 2017 instance to a Power BI Report Server environment, as you can read in the...
2018-03-12
528 reads
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018...
2018-03-02
332 reads
T-SQL Tuesday #99 – Door #1
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice...
2018-02-13
504 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers