Category Tips & Tricks

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

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

SSMS Tip Of The Day – Show Row Count

Today, when clicking around SSMS, I discovered this little helpful trick, that you probably already knew but here it comes anyway. If you want to see the number of rows in a table you can always use Select count(*) from TableName but it has quite a nasty performance. Another way to do it with much […]

Extending SSIS With .NET scripting

Earlier this year I got embarked on a book project together with Joost Van Rossum (B|T) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. Namely how to extend the capacity of SSIS with […]