Author Archives: regbac

Speaking at SQL Saturday Lisbon #583

In a few days, I will be heading towards Lisbon to speak at the annual SQL Saturday which takes place on Saturday March 11th. On March 9th and 10th, there are 3 preconference workshops held by some of the very knowledgeable people in the industry, so if you are near you don’t want to miss Friday […]

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 […]

Speaking at MS Cloud Summit 2017

No one is prophet in its own land says the adage. But when it comes to Microsoft Cloud technologies that doesn’t seem to apply. Next week, Monday 23rd, marks the start of the first edition of the MSCloudSummit in Paris, France. This will be my very first public speaking in my country of birth and although […]

Power BI reports in SQL Server Reporting Services available very soon

The long awaited news of Power BI reports on-prem that we’ve all been waiting for is now official. Power BI reports, that works together with SSRS 2016 and that has been available as a Technical Preview in Azure will be available in an on-prem preview version mid-januar 2017. A production ready version of the product […]

Allowing non-domain admins to configure Kerberos Constrained Delegation.

As you are probably aware of, configuring constrained delegation requires some steps that involve domain admin permissions. In many larger organizations where there is a clear separation of duties this is can be problem since the engineers and developers need to specify what type of delegation need to be configured, and domain admins need to […]

Speaking at SQL Saturdays – busy times ahead

This fall, starting September 17th, I have the honor and the privilege to be presenting at few SQL Saturdays: SQL Saturday Copenhagen #541 Besides co-organizing it for the fourth time I will also be speaking (selection process was may be a bit biaised) about one of my favorite topics. Automated deployment and integration : Continuous Integration […]

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. […]