UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade working isn’t supported by Microsoft. However, someone from the SSRS team told me the March 2018 release of Power BI Report Server has fixed some bugs, so you should try to upgrade the normal way. […]
Category: SQL Server
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 to blog about a topic of our choice, either about a passion outside of the SQL Server community, or about a T-SQL bad habit. In this blog post, I’ll tackle the second option, but I […]
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 .sql file with the DDL statements to create objects (schema, tables, views, stored procs, functions) in a database called Biml (which you have to create yourself). Along with some metadata in those tables. […]
DataMinds.be Meetup – Biml
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and otherwise. And what better way to start the new year with a user group session? On Thursday 25th of January 2018 I will be giving an evening session for dataminds.be, formerly known as SQLUG.be aka […]
Connect is dead! Long live feedback.azure.com!
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been found: feedback.azure.com. It’s not all about Azure, the link goes to the relevant portion of SQL Server. I’m glad for this change, as Connect could sometimes be a little … quirky. Especially the […]
Book Review – The Biml Book
After years of waiting, a book about Biml has been published! It’s conveniently titled “The Biml Book” (subtitled Business Intelligence and Data Warehouse Automation) and I can tell you immediately it’s the best Biml book I’ve ever read! (haha, it will take a while until this joke gets old). In all seriousness though, it’s a great […]
SQL Server Data Tools 2017 and TFS Integration
UPDATE 2018-06-20: I was finally able to install the stand-alone version of SSDT for VS 2017 with working TFS integration. Read more about it here. I’ve blogged a while back on how SSIS 2017 was finally here. Not much has changed; there is still no Visual Studio extension for SSIS, so if you want to […]
Installing the MDS add-in for Excel 2016
For some reason I attract all kinds of misery when working with Master Data Services. Today I was trying to install the add-in for SQL Server 2012 on a machine that has Office 2016 64-bit installed. I clicked on the link in the MDS webpage which send me to the download page of the MDS […]
Can’t Connect to Analysis Services – Invalid Connection Information
I have a new installation of SQL Server 2017, along with an instance of Analysis Services Tabular 2017. I tried to connect to the SSAS instance for the first time, and I was greeted with the following error: “Invalid connection information to establish the server connection” I was using SSMS 17.3 to connect to the […]
Error Installing SQL Server 2017
A quick blog post on an error I got when installing SQL Server 2017 RTM. I ran the set-up for the usual features (database engine, SSAS, SSIS, SSRS and MDS), but the installation failed for the database engine and SSIS. During the set-up, I received two pop-ups notifying that something was wrong. A quick look […]