Category sql server 2016

Installing Power BI reports in SQL Server Reporting Services – On-premises

We tried it on an Azure VM, we’ve seen it at PASS Summit and in some private previews by the Reporting Services Team. But now it is officially available to download for an on-premises installation as a 180 days preview. What is really interesting, besides the fact that we get Power BI reports on-premises, is […]

Method not found Microsoft.SqlServer.Management.IntegrationServices.EnableSsisSupportAlwaysOnSqmHelper.Initialize()

Today, working with SSIS on a SQL Server 2016 RTM I wasn’t able to create the SSIS Catalog. The error I got was : Method not found: ‘Void Microsoft.SqlServer.Management.IntegrationServices.EnableSsisSupportAlwaysOnSqmHelper.Initialize()’. (Microsoft.SqlServer.IntegrationServices.UITasks) Looking at the documentation for the namespace Microsoft.SqlServer.Management.IntegrationServices I quickly figured out that I would be able to create the SSIS Catalog manually using PowerShell. […]

Changing SSRS 2016 user display language

Working in a Swiss company where German is the language of predilection for formatting numbers, dates and currency I was having a hard time understanding what SSRS 2016 was trying to tell me on the displays of it’s menus and options. Words like Paginierter Bericht don’t really mean much to me and trying to understand […]

Connecting SQL Server Mobile Report Publisher

This post is meant as a mental note for not having to struggle with the problem again another time…. Some weeks ago I downloaded and Installed SQL Server 2016 CTP 3.2 and now I want to try the new Reporting Services Experience – with the Datazen part now almost fully integrated to Reporting Services. For […]

SharePoint 2016 – Office Online Server – Error : This product requires Microsoft .Net framework 4.5

I am installing SharePoint 2016 together with PowerPivot and Power View for SQL Server 2016 and I have a 3 servers Hyper-V environment running locally: A domain controller (with a tabular instance of SSAS 2014) A SharePoint 2016 single server farm A SQL Server 2016 CTP 3.1 running the database engine and the tabular instance […]

Speaking at SQL Saturday Slovenia #460

This Saturday, I will be back in wonderful Ljubljana to present a session about a new feature from SQL Server 2016 and Azure SQL Database : Always encrypted. It is the first time I am doing this session and I plan on doing mostly demos, which I am quite excited about. I’ve been benchmarking the […]

SQL Nexus Call for speakers is live

Nexus noun – “That which unites or binds”         After several months of work with a team of great people and companies: -Kenneth M. Nielsen (b|t) -Mark Broadbent (b|t) –ASAP design –Funky.biz –Microsoft –bloodyuseful We have the honour to launch the call for speakers for the next generation data platform conference in Copenhagen. The […]