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 […]
How to fix license error when attempting to add a new instance to an existing SQL Server 2014 CTP2 installation
When installing a new instance on an existing SQL 2014 CTP2 you might get this error: Access to the path ‘C:Program FilesMicrosoft SQL Server120License TermsSQLServer2014CTP_License_EVAL_1033.rtf’ is denied. like the one below If you hit Retry it will popup again and if you hit Cancel your whole installation is cancelled. After clicking Cancel: The workaround is […]
Performance Point Services not showing SSAS databases
Sometimes in this blog I write things that I don’t want to forget. So I’ll be able to find them again some day when I need them. This Monday I was at a customer showing the great things you can achieve with Performance Point Services in SharePoint 2013. I explained them that the greatest analytics […]
Approving group of items in SharePoint 2013
This might be slightly off-topic but what is a blog if you cannot share ahas and tricks…at least so you know where to find it next time it is needed ? When working with documents that require approval in SharePoint 2013 sometimes you want to be able to approve several items at once. it is […]
The Blobfarm 