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,092 reads
Koen Verbeeck
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,851 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
289 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
529 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,901 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
335 reads
T-SQL Tuesday #99 – Door #2
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
325 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
Session Materials – Biml DataMinds
All of the materials for my Biml session for DataMinds.be can be downloaded from Github:
the slidedeck (it’s only 12MB :))a...
2018-01-25
340 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers