Tag Archives: Powershell

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

Scripting SharePoint installation and configuration

Introduction This is the first post in a series of posts related to Mark Broadbent (B|T) and my preconference at SQL Saturday Cambridge on September 12th 2015. These posts are extracts of what you might expect from our whole day of preconference. Please have a look at Implementing Business Intelligence & SharePoint High Availability Solutions for more […]

speaking at SQL Saturday Porto

This weekend (18 October 2014) I was extremely lucky to have the opportunity to speak at SQL Saturday in Porto : https://www.sqlsaturday.com/341/eventhome.aspx I had also the amazing opportunity to do a whole day of pre-conference about the basics of SQL Server Analysis Services. This pre-con day was hold at the HQ of one of the […]

Installing Sharepoint 2013 without a domain account

I’m sure that at one point every person that is working with Sharepoint has cursed upon the impossibility to install SharePoint without a Domain Controler. Of course I’m not speaking of prod environment here. But on your virtual machines of any kind to try new functionality or to install new features. Lately – today actually […]

How to list the sharepoint 2010 databases that are in use – eventually to a file ?

It happens to me all the time when I develop and test or after migrations attempts ! Well, I hope I’m not the only one who has ended with a lots of used and unused Sharepoint databases after numerous farm installs and reconfigs… When time is in for a clean up of you SQL server […]